10500 Teaching & Training courses delivered Online

This International Practitioners of Holistic Medicine accredited qualification teaches the skills, knowledge and competence required of an individual in order to work with clients on specific breathing techniques in both 1:1 or group sessions. Learners will cover: The anatomy of the lungs; gaseous exchange; the breath-brain connection and the physical and mental benefits of breathwork. How to hold space for breathwork; creating a trauma-informed space and basic facilitation skills. How the breath impacts the vagus nerve and its connection to the parasympathetic nervous system. The structure of a breathwork session and how to build momentum with music and motivational cueing (i.e.what to say and what to play). The content of a breathwork session with an in-depth study of 6 unique breathwork exercises. Advanced Facilitation skills – How to plan for emotional and physical reactions; how to modify for different audiences/special populations.

Embark on a Transformational Journey with Our 5-Week Online Ceremonial Cacao Workshop and Uncover the Mysteries of Cacao. Dive deep into the enchanting world of ceremonial cacao with our immersive course. Explore its rich history, traditional farming techniques, health benefits, and spiritual significance.

This programme has been specifically designed to help experienced trainers, facilitators and coaches use Everything DiSC and the Five Behaviours assessments, and deliver workshops, with their own clients and in-house teams.

Join this one day workshop designed specifically for tutors, trainers and assessors working in post-16 education settings. This course focuses on honing the skills and knowledge necessary for effective planning and feedback, empowering participants to support their learners towards achieving qualifications and progressing their careers. * Explore planning of both long term goals and short term targets * Use a tried and testeed structure for goal and target setting * Explore tried and tested techniques for giving developmental feedback * Practice structuring both writtten and verbal feedback * Explore techniqus to keep learners motivated and engaged in their learning -------------------------------------------------------------------------------- FURTHER INFORMATION This is a face to face workshop that will be held over one day. Participants will also be provided with access to our online Assessor Toolkit to reinforce learning and provide resources after the session. -------------------------------------------------------------------------------- BENEFITS * Gain free access to our online learning Assessor Toolkit * Master the art of giving feedback to motivate learners * Network and explore strategies and solutions with peers from across Wales * Learn from our experienced workshop facilitators who have worked in the sector for over 20 years. * Gain meaningful CPD hours

In this webinar, we will explore the powerful features and benefits of Cademy - the UK's largest education directory, and the all-in-one platform for hosting education services in-person and online.

This qualification recognises the skills, knowledge and competence required of an individual in order to work in an unsupervised capacity, including the values and principles of adult social care and the ability to plan and deliver chair–based exercise to either disabled adults or frailer older adults.

This course will develop knowledge from the FD&FA foundation BS 5839-1 module and/or industry experience and apply this to the design of FD&FA systems.

Duration 2 Days 12 CPD hours This course is intended for This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers. This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics. 1 - INTRODUCTION TO TRANSACT-SQL * Work with schemas * Explore the structure of SQL statements * Examine the SELECT statement * Work with data types * Handle NULLs 2 - SORT AND FILTER RESULTS IN T-SQL * Sort your results * Limit the sorted results * Page results * Remove duplicates * Filter data with predicates 3 - COMBINE MULTIPLE TABLES WITH JOINS IN T-SQL * Understand joins concepts and syntax * Use inner joins * Use outer joins * Use cross joins * Use self joins 4 - WRITE SUBQUERIES IN T-SQL * Understand subqueries * Use scalar or multi-valued subqueries * Use self-contained or correlated subqueries 5 - USE BUILT-IN FUNCTIONS AND GROUP BY IN TRANSACT-SQL * Categorize built-in functions * Use scalar functions * Use ranking and rowset functions * Use aggregate functions * Summarize data with GROUP BY * Filter groups with HAVING 6 - MODIFY DATA WITH T-SQL * Insert data * Generate automatic values * Update data * Delete data * Merge data based on multiple tables ADDITIONAL COURSE DETAILS: Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the DP-080T00 Querying Data with Microsoft Transact-SQL course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

For those who are looking to get top marks in the Maths 11+ exam > Save Your Child’s Spot in the  11+ Advanced Maths Small Group Classes * Tricky Algebra * Confusing word problems * Fractions, Decimals and Percentages * Tricks to answer questions more efficiently (and save time!) * Topics that really stretch your child * Personalised weekly homework  * Exam-style questions PLUS! Bettering Youth's Signature Mindset Coaching + exam stress management tools Our engaging course doesn’t just teach numbers; Our Maths courses build confidence.  This course is perfect for students in Year 5 students who are at "greater depth"  and are preparing for their 11+ Exam in 2024.  Course breakdown: 1. Each week begins with independent completion of a topic pre-learning 2. I use the data from these pre-learning activities to build a personalised and highly intentional in-person weekly lesson  3. We ensure full mastery of the topic through discussions around efficient methods and provide plenty of opportunities for practise 4. At the end of the topic, students will complete a mock exam to measure their progress and understanding.  5. We use spaced repetition and interleaving [https://betteringyouth.co.uk/blog/4-studying-techniques] throughout the course to ensure that students have multiple exposures to each topic.  6. You regularly get feedback and have a parent's portal to view your child's assignments! We transform 11+ Maths exam prep from a challenge to an exciting adventure, helping your child become a resilient and prepared student. Mathematics can be a battleground for many students, especially when faced with word problems. We understand the fear of numbers, the confusion with multiplication tables, and the frustration of not being able to solve real-world math challenges. Key Details: * Duration: Each half term is 5 weeks * Official Lesson Start Date: January 11th at 6pm  * Maths Focus Areas:Algebra, advanced geometry, tricky word problems * Group Size: 4 to 8 students * For Just £127.00 *save 20% with our Small Business Saturday offer!   What our families have to say:  

LOOKING FOR: ADULT FICTION, NON-FICTION Amanda Preston has been a literary agent for over 20 years and co-founded LBA in 2005. She won the RNA Literary Agent of the Year award in 2018.  She represents commercial and reading group fiction, as well as a range of narrative non-fiction and memoir. She loves working with authors, championing them every step of the way, and works with them and their publishing teams to build them into brand names and award winning and bestselling authors in the UK and internationally. Whether commercial or reading-group, she loves innovative and well-written stories that hook her in from the start and whose voice stays with her. She is looking for novels that demand to be talked about and shared, whatever their genre, and that she is still thinking about days after finishing.  She is on the hunt for a high-concept thriller which is character and plot driven, but also has a discussable issue at its heart i.e Elizabeth is Missing by Emma Healey and Girl A by Abigail Dean. She love thrillers where the location is as integral to the plot as the crime i.e The Dry by Jane Harper and The Sanatorium by Sarah Pearse, and would love a good locked-room thriller but is only looking for fresh and unique ideas in this area.  She is also on the hunt for a glorious book club love story that is doing something a bit different and special i.e Lessons in Chemistry by Bonnie Garmus or anything by Taylor Jenkins Reid or Liane Moriarty! Or smart, contemporary, observant romcoms with a very strong emphasis on diverse / own voices.  Finally, she would love a historical that vividly brings that period to life as well as having a stunning plot i.e, The Familiars by Stacey Halls and The Doll Factory by Elizabeth MacNeal. Amanda would like you to submit a covering letter, 1 page synopsis and the opening three chapters (max 5,000 words). (In addition to the paid sessions, Amanda is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk [agent121@iaminprint.co.uk] to apply, outlining your case for this option which is offered at the discretion of I Am In Print).  By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting. The submission deadline is: Tuesday 14 May 2024