683 Practitioner courses delivered Live Online

Person Centred Planning: the act of listening to each other creates relationship and strengthening trust and inclusion within the team. If well facilitated In creating a shared vision, groups of people build a sense of commitment together. They develop images of the future they want to create together, along with the values that will be important in getting there and the goals they want to see achieved along the way. Course Category Person Centred Planning Team Building and Leadership Description How to facilitate Person Centred Planning? How is it different from any other kind of meeting or planning? Person Centred working is great – but how exactly is it facilitated? How does it differ from ‘chairing a meeting” What skills and processes enable the group to work together effectively and avoid going off at tangents or dissolving into an unfocussed ‘discussion’ Person Centred Planning: the act of listening to each other creates relationship and strengthening trust and inclusion within the team. If well facilitated In creating a shared vision, groups of people build a sense of commitment together. They develop images of the future they want to create together, along with the values that will be important in getting there and the goals they want to see achieved along the way. Making inclusive action plans using full participation and graphic facilitation Drawing on the planning tools MAPS and PATH (Pearpoint, Forest and OBrien 1997) and other facilitation sources we use both process and graphic facilitation to enable the group to build their picture of what they would love to see happening within their organisation/community in the future and we encourage this to be a positive naming, not just a list of the things they want to avoid. In this training we make this facilitation explicit and attempt to model, teach and enable practice of key skills and processes. Jack Pearpoint, Marsha Forest and John O’Brien developed these innovative PCP approaches in North America and they are being used successfully in many parts of the UK. The planning can focus on an individual, group or organisation and provides a powerful problem solving opportunity, which is flexible and robust enough for many occasions. Tell the story, find the dream, touch the nightmare, and explore who you are, what are the gifts and strengths of the person or group, what are the needs of those present and what is the action plan for the future? Testimonials Learning Objectives Participants understand group and graphic facilitation processes for Person Centred Planning Participants have skills and confidence to facilitate PATH/MAP processes Participants learn graphic as well as process facilitation skills. Strengthens practitioners inclusive practice Provides additional tools for those involved in inclusive work in schools and the wider community Further develop problem solving and planning skills Who Is It For ? Person Centred Planning Facilitators Multi Agency Teams Social workers CAMHS teams Year Managers Primary and secondary staff teams Early Years and School based Practitioners Heads and Deputies SENCOs Advanced Skills Teachers Primary and secondary teachers Local Authority Support Services Voluntary Organisations Course Content The course answers the questions: Need to find new ways to facilitate Planning? How to facilitate Person Centred Planning? How is it different to any other kind of meeting or planning? Person Centred working is great – but how exactly is it facilitated? What are the skills and processes that will make the group work really well and a wonderful graphic to be created? Bored with annual reviews, transition plans and review meetings? Want to find a way of making meetings and planning feel more real and engaging? Need an approach, which engages a young person respectfully together with his or her family and friends? Want the ultimate visual record of the process of a meeting, which will help everyone, keep track? Want to problem solve and plan for the future of a small or large group, service or organisation up to the size of an LA? Inclusive Solutions offer an introductory day to facilitating person centred planning or a 3 – 10 session course which is practical as well as values based. Participants will receive direct individualised coaching and training. We will cover: Group and Graphic Facilitation processes Use of music and dramatic participation methodology The person being at the centre Family members and friends being full partners Planning reflecting the person’s capacities, what is important to the person and specifying the support they require to make a full contribution to their community Planning building a shared commitment to action that will uphold the person’s rights Planning leading to continual listening, learning and action and helping the person get what they want out of life. Essential Lifestyle Planning, PATH MAPS Personal Futures Planning

Duration 3 Days 18 CPD hours This course is intended for This is an introductory- level course appropriate for those who are developing applications using relational databases, or who are using SQL to extract and analyze data from databases and need to use the full power of SQL queries. Overview This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert practitioner, attendees will learn to: Maximize the potential of SQL to build powerful, complex and robust SQL queries Query multiple tables with inner joins, outer joins and self joins Construct recursive common table expressions Summarize data using aggregation and grouping Execute analytic functions to calculate ranks Build simple and correlated subqueries Thoroughly test SQL queries to avoid common errors Select the most efficient solution to complex SQL problems A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. SQL is the cornerstone of all relational database operations. In this hands-on course, you learn to exploit the full potential of the SELECT statement to write robust queries using the best query method for your application, test your queries, and avoid common errors and pitfalls. It also teaches alternative solutions to given problems, enabling you to choose the most efficient solution in each situation. Introduction: Quick Tools Review Introduction to SQL and its development environments Using SQL*PLUS Using SQL Developer Using the SQL SELECT Statement Capabilities of the SELECT statement Arithmetic expressions and NULL values in the SELECT statement Column aliases Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword Use of the DESCRIBE command Restricting and Sorting Data Limiting the Rows Rules of precedence for operators in an expression Substitution Variables Using the DEFINE and VERIFY command Single-Row Functions Describe the differences between single row and multiple row functions Manipulate strings with character function in the SELECT and WHERE clauses Manipulate numbers with the ROUND, TRUNC and MOD functions Perform arithmetic with date data Manipulate dates with the date functions Conversion Functions and Expressions Describe implicit and explicit data type conversion Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions Nest multiple functions Apply the NVL, NULLIF, and COALESCE functions to data Decode/Case Statements Using the Group Functions and Aggregated Data Group Functions Creating Groups of Data Having Clause Cube/Rollup Clause SQL Joins and Join Types Introduction to JOINS Types of Joins Natural join Self-join Non equijoins OUTER join Using Subqueries Introduction to Subqueries Single Row Subqueries Multiple Row Subqueries Using the SET Operators Set Operators UNION and UNION ALL operator INTERSECT operator MINUS operator Matching the SELECT statements Using Data Manipulation Language (DML) statements Data Manipulation Language Database Transactions Insert Update Delete Merge Using Data Definition Language (DDL) Data Definition Language Create Alter Drop Data Dictionary Views Introduction to Data Dictionary Describe the Data Dictionary Structure Using the Data Dictionary views Querying the Data Dictionary Views Dynamic Performance Views Creating Sequences, Synonyms, Indexes Creating sequences Creating synonyms Creating indexes Index Types Creating Views Creating Views Altering Views Replacing Views Managing Schema Objects Managing constraints Creating and using temporary tables Creating and using external tables Retrieving Data Using Subqueries Retrieving Data by Using a Subquery as Source Working with Multiple-Column subqueries Correlated Subqueries Non-Correlated Subqueries Using Subqueries to Manipulate Data Using the Check Option Subqueries in Updates and Deletes In-line Views Data Control Language (DCL) System privileges Creating a role Object privileges Revoking object privileges Manipulating Data Overview of the Explicit Default Feature Using multitable INSERTs Using the MERGE statement Tracking Changes in Data

Advanced Lip Smile Injectables Package includes: Skin Boosters Lips filler , Russian, French techniques Beauty Threads for lips contour Entry requirements Registered Medical professional Level – Beauty Therapist Dental Nurse Physiotherapist Holds at least 6 months experience with needles (micro-needling, microblading, tattooing, vaccinations, phlebotomy and more) NOTE! After booking we will contact you for scheduling the exact course date! Courses dates are subject to change due to mentors availability. We will inform you via email if a date becomes available! Additional information ATTENDANCE ONLINE (Theory), IN CLINIC (Practice) ADVANCED Skin Boosters Lips filler , Russian, French techniques Beauty Threads for lips contour Choose Online or In-Clinic (30% Discount)

This workshop gives an opportunity to focus on the emotional needs of girls and how to meet these. We lift the lid on a less well explored inclusion issue, meeting the emotional needs of girls. Everyone knows a girl or woman. They may be pupil, daughter, sister, parent or partner. Course Category Meeting emotional needs Behaviour and Relationships Inclusion Early Years Description This workshop gives an opportunity to focus on the emotional needs of girls and how to meet these. We lift the lid on a less well explored inclusion issue, meeting the emotional needs of girls. Everyone knows a girl or woman. They may be pupil, daughter, sister, parent or partner. Girls will often withdraw, attack or even hurt themselves when under emotional stress and this is not always obvious in the way it is with boys. 1 in 4 women experience domestic violence and every week 2 women are killed by a current or ex partner. Whilst the world assumes girls have no problems processing their emotions, we lift the lid on this and question what is really happening for girls this century? Testimonials Learning Objectives Increased understanding of girls’ emotional needs Access to a wider range of practical strategies to impact on meeting emotional and behaviour problems Deeper understanding of core values surrounding inclusion Opportunity to reflect on professional attitudes and behaviour towards girls and their emotional challenges New skills and processes to make girls’ inclusion and achievement more successful Who Is It For ? Early years and school based practitioners Key workers Teaching Assistants with support roles Heads and deputies SENCOs Advanced skills teachers Primary and secondary classroom teachers Parents Local Authority support services Course Content The course explores the questions : Is there an invisible problem with girls? What can we do to meet the emotional needs of girls? What helps? What should our priority be with girls? This workshop will explore: Cultural and historical expectations of girls in our society Shared experiences of teaching and parenting girls Circle of Courage as a way of understanding emotional needs Fathers, mothers and daughters Solution Circle Problem Solving around girls’ needs What girls really need If you you want something similar, but not gender specific try: FRESH APPROACHES TO BEHAVIOUR AND RELATIONSHIPS or you may like: RESTORATIVE INTERVENTIONS

In this practical workshop session we will explore ways of problem solving around complex situations. The session will be practical and will aim to allow the sharing of experiences and good practice as well promoting innovative approaches to problem solving around systemic, organisational as well as individual inclusion issues. Course Category Behaviour and Relationships Visioning and Problem Solving Description ‘The question is not should they be here anymore. Now it’s how can we figure out how best to include them?’ In this practical workshop session we will explore ways of problem solving around complex situations. The session will be practical and will aim to allow the sharing of experiences and good practice as well promoting innovative approaches to problem solving around systemic, organisational as well as individual inclusion issues. Behaviour problems, relationship challenges and personnel dilemmas can all be worked on with these team oriented problem solving processes. We will introduce participants to a range of powerful effective approaches for them to choose from back in their own workplaces. Testimonials A great day – going away buzzing with ideas Excellent! Inspirational! Informative! Learning Objectives Increased confidence regarding problem solving around inclusion in mainstream settings Access to a wider range of practical strategies and techniques to impact on communication, realtionship, learning and behaviour issues Learn new problem solving processes Who Is It For ? Early Years and School based Practitioners Heads and Deputies Guidance staff Learning Support teams SENCOs Primary and secondary teachers Parents Local Authority Support Services Community workers and carers Course Content The course answers the questions : How can we work out how to include this child best? Is there a more structured way to run this meeting? Can we explore the emotional impact the person is having on us and still agree strategies? How can I get unstuck from this problem? The day will cover: Solution Circles Solution Focused approaches Synectics – using analogies and out of the box creativity Circles of Adults Using Imagination to solve problems If you liked this course you may well like: CIRCLES OF ADULTS

A Solution Circle is a 30 minute creative Problem Solving Process for getting unstuck…Ideal for busy people! lt was designed by Marsha Forest & Jack Pearpoint. This is a short and powerful tool. It is effective in getting “unstuck” from a problem in life or work. Solution Circles are tools of “community capacity”. It assumes and demonstrates that nearby people – in any community or work place have the capacity to help – if asked. It requires a person to ASK – not an easy thing in our culture of privacy and “do it alone”. This tool puts all the values we espouse into practice and demonstrates that TOGETHER WE’RE BETTER. Course Category Problem Solving Description A Solution Circle is a 30 minute creative Problem Solving Process for getting unstuck…Ideal for busy people! lt was designed by Marsha Forest & Jack Pearpoint. This is a short and powerful tool. It is effective in getting “unstuck” from a problem in life or work. Solution Circles are tools of “community capacity”. It assumes and demonstrates that nearby people – in any community or work place have the capacity to help – if asked. It requires a person to ASK – not an easy thing in our culture of privacy and “do it alone”. This tool puts all the values we espouse into practice and demonstrates that TOGETHER WE’RE BETTER. In this training you will learn how to set up and facilitate Solution Circles  Learning Objectives For participants to learn how to facilitate a Solution Circle For participants to understand the underlying rationale and ethos of this way of working For participants to learn the power of team work and problem solving when including challenging individuals Who Is It For? Team Around the Child agencies Parents and Professional working together Families Multi Agency Teams Social workers CAMHS teams Year Managers Primary and secondary staff teams Early Years and School based Practitioners Heads and Deputies SENDCOs Advanced Skills Teachers Primary and secondary teachers Local Authority Support Services Course Content This can be introduced in a twilight, half day or even a full day workshop with individualised coaching. We will provide background context for this approach and will directly model the process with real live issues facing participants. So bring your most challenging concerns to this training. The course answers the questions: What to when you are stuck Can we find an alternative to permanent exclusion or special unit or school placement? Struggling with a child for whom praise is ineffective? Feeling isolated in your responses to a child’s needs? Worried about where your instinctive reactions are leading you? Cannot seem to get any consensus view of a young person’s behaviour/needs amongst all the family and professionals involved – is everyone pulling in different directions? We will cover: Setting the tone Background and detailed teaching of process Inclusion values underpinning this work Graphic and process facilitation skills Processes modelled and opportunities to try process out with coaching Practical setting up of insights and solutions circles Lessons learned

This training gives an opportunity to focus on how to embed effective approaches to meeting emotional needs in schools. We explore a range of ways into meeting emotional needs of pupils across a school. We focus on including pupils with extreme emotional needs. Course Category Meeting emotional needs Description This training gives an opportunity to focus on how to embed relevant ideas and materials in schools. We explore how to make these materials really come to life as we explore a range of ways into meeting emotional needs of pupils across a school. We focus on including pupils with extreme emotional needs. There are lots of opportunities for personal and professional reflection on engagement with challenging pupils as we provide processes to support reflection, visioning and problem solving. Testimonials ‘Thank you so much for the work you did with us yesterday – I have since been in 2 schools today and have spoken to an number of other colleagues who were present – all were totally overwhelmed by the session – they loved it.”NOTTINGHAM SEAL COORDINATOR “I was totally blown away, when I realised how passionate people were about SEAL” “So nice to reflect and realise what a long way we have come” “That was so powerful and motivational”.’ Learning Objectives Shared vision of a school that is truly meeting all social and emotional needs Access to a wider range of practical strategies to impact on meeting emotional and behaviour problems Deeper understanding of how to embed positive Mental Health approaches in a school Opportunity to reflect on professional attitudes and behaviour towards children with emotional challenge Who Is It For? All practitioners who are leading on Mental Health work in schools or on behalf of a Local Authority Full range of agencies committed to meeting social and emotional needs in schools Course Content The training explores the questions: What would a school look like when Mental Health was truly part of everything that was happening, a shared vision? How can we truly embed Mental Health approaches and materials in our school? What can we do to meet complex and challenging emotional needs in schools? Can we learn a process to understand at a deeper level highly complex social and emotional needs? This training will cover: Bringing positive Mental Health approaches to life in schools: creating a shared vision and a set of grounded goals together Circle of Adults process for self-reflection and understanding emotional needs of high profile pupils. We will model and teach how this process links in and strengthens PSHE work in schools. If you liked this try: FRESH APPROACHES TO BEHAVIOUR AND RELATIONSHIPS or: RESTORATIVE INTERVENTIONS

This workshop gives an opportunity to focus on the emotional needs of children and young people and how to meet these. We lift the lid on an emerging urgent inclusion issue, meeting the emotional well being of all children. In one year 1300 young men committed suicide in the UK. In the UK the commonest cause of death among those aged 16-35 is suicide. Online Course now available via Teachable Platform – Understanding children’s Emotional Needs Learn at your own pace… lots of text and video support Course Category Behaviour and Relationships Meeting emotional needs Early Years Inclusion Description This workshop gives an opportunity to focus on the emotional needs of children and young people and how to meet these. We lift the lid on an emerging urgent inclusion issue, meeting the emotional well being of all children. In one year 1300 young men committed suicide in the UK. In the UK the commonest cause of death among those aged 16-35 is suicide. 1 in 4 women experience domestic violence and 2 women a week are killed by a current or ex partner. We need to find ways to allow children to unclench their hearts and learn to experience, process, communicate and manage their own emotional lives for their own and for the good of the wider community. Testimonials Be the first…. Learning Objectives Increased understanding of emotional needs Access to a wider range of practical strategies to impact on meeting emotional and behaviour problems Deeper understanding of core values surrounding inclusion Opportunity to reflect on professional attitudes and behaviour towards children and their emotional challenges New skills and processes to make emotionally challenged children’s inclusion and achievement more successful Who Is It For ? Early years and school based practitioners Key workers Teaching Assistants with support roles Heads and deputies SENCOs Advanced skills teachers Primary and secondary classroom teachers Parents Local authority support services Course Content Shared experiences of teaching and parenting around emotional well being Circle of Courage as away of understanding emotional needs Fathers, mothers and sons and daughters Drinking and drugs, filling the emotional void Depression and suicide Anger and violence Solution Circle Problem Solving What children really need

This is our latest lead workshop/training day and is an extremely innovative, participative and practical guide to successfully creating a truly inclusive classroom in mainstream school settings for children and young people of all ages. This engaging day will equip participants with ways of thinking and planning for the inclusion of all pupils within the curriculum. Course Category Teaching and Learning Inclusion Description This is our latest lead workshop/training day and is an extremely innovative, participative and practical guide to successfully creating a truly inclusive classroom in mainstream school settings for children and young people of all ages. This engaging day will equip participants with ways of thinking and planning for the inclusion of all pupils within the curriculum. There’s no better way to get set up, get trained, and get going on your inclusive classroom. The most knowledgeable trainers will teach you all the basics in face-to-face training sessions, and guide you through more advanced concepts and ideas. So whether you’re brand-new to inclusion, a seasoned pro, or somewhere in between, we will help take your skills to the next level. Testimonials ‘Yet again inspiring and opening more doors than I can go through’ ‘This opened a lot of avenues for thought and reflection. It will help me to help colleagues to see where they can improve practice to create a more inclusive environment within the whole school.’ ‘Some great ideas and restored my self belief! Fantastic’ Learning Objectives Increased skills in diversifying/differentiating the curriculum Reflection on attitudes to individual learning and the curriculum Linking learning style research to real classroom inclusion of high profile/need pupils Improved teaching skills for those with severe and complex needs and behaviour Challenge to attitudes and mindsets Who Is It For ? School based Practitioners Heads and Deputies SENCOs Learning Support Advanced Skills Teachers Primary and secondary teachers Parents Local Authority Support Services Course Content The course answers the questions: How do I begin differentiating? How do I include a pupil with very complex learning needs? How do we go about practically including high profile children or young people? Best delivered over the course of 2 days, ‘Inclusive Classroom’ introduces participants to 6 guiding Ideas that increase effective inclusion in mainstream settings. Setting the tone for learning Resourcing schools and classrooms effectively The essential 4 questions! What is the essential learning in this lesson? How do the students learn best? What needs modifying? How will students demonstrate their learning? Building on strengths and talents Beyond the IEP The curriculum content of inclusive classrooms If you liked this course you may well like: CREATING AN INCLUSIVE SPACE WHERE EVERYONE LEARNS

To facilitate a group, family, team or organisation in thinking together around a given challenge or issue here is an opportunity to experience for real the person centred, futures planning tool – MAP (Pearpoint, Forest et. al. 1989). This is a process not a training day. Let us facilitate your planning and refocus your story whilst strengthening you and your group. This tool uses both process and graphic facilitation to help any group develop a shared vision and then to make a start on working out what they will need to do together to move towards that vision. MAPS are great for threshold moments. Is your team stuck? Want to move on, haunted by the past cannot get any useful dialogue about the future? Facing a challenging transition into a new school or setting? Leaving school? Bored with annual reviews, transition plans and review meetings? Want to find a way of making meetings and planning feel more real and engaging? Need an approach, which engages a young person respectfully together with his or her family and friends? Want the ultimate visual record of the process of a meeting, which will help everyone, keep track? Want to problem solve and plan for the future of a small or large group, service or organisation up to the size of an LEA Learning Objectives To create a shared vision To talk through the story so far and reflect upon it To name the worse nightmares that will block progress To strengthen the group by focussing on gifts and capacity To detail needs To specify an Action Plan To create a visual graphic record of the whole event Course Content The MAP process has 6 Steps: The story so far. The group is required to think back over the years to describe their collective experience of changes and events over time within their settings. Stories and events are recorded on the graphic. Building Shared Dreams. The group thinks together about what they would love to see happening for children, families and practitioners in their settings if they could have it all. If there were no constraints on time, money, resources, people or anything else what do they see happening in their imaginations? The various ideas that the group comes up with are then recorded in key words, images and colours on the MAP graphic. The purpose of this Step is to give the group a sense of direction, their North Star, an image of the place they want to work towards. Nightmare. In this Step, the group imagines the worst scenarios. What is the opposite of their dreams? How bad could it get? This is a shorter but powerful process that can give some groups more energy than dreaming together. Gifts and Capacity. In this Step the group is asked to take explicit stock of their capacities and what they already have going for them as they begin working towards the vision. This is a strong reminder for any group of the wealth of knowledge and experience that is already and always in the room. Needs. In this Step the group is invited to begin to name some of the needs they will have if they are to move forward to wards the dream and away from the nightmare. Actions. This is the final Step in the MAP and calls for individuals within the group to name a range of very specific actions (however small) that they will take within a definite time scale. This is not a time for declaring good intentions or suggesting good ideas for someone else to do. The purpose of this Step is to end the MAP process with a range of clearly understood actions that carry this planning process forward into the real world.