553 Trainer courses in Peacehaven delivered Live Online

Duration 2 Days 12 CPD hours This course is intended for This is an intermediate and beyond level SQL course geared for experienced end users, data scientists, business analysts, application developers and database administrators. Students should have recently attended a basic SQL class or have equivalent experience. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment led by our expert practitioner, attendees will learn advanced skills needed to: Advanced Query Techniques Manipulating Table Data Using SQL's Data Manipulation Language (DML) User-Defined Functions Stored Procedures Triggers 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. Next Level SQL explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work in this course is ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, MySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. Advanced Query Techniques Join inner outer (Left, Right, Full) Subqueries Simple Correlated Using the Exists Operator Tips for Developing Complex Queries Performing Set Operations Aggregating Results Using Group by Creating Temporary Tables Manipulating Table Data Using SQL's Data Manipulation Language (DML) Inserting Data into Tables Updating Existing Data Deleting Records Truncating Tables Implementing Data Integrity with Transactions Beginning Explicit Transactions Committing Transactions Rolling Back Transactions User-Defined Functions Definition and Benefits of Use CREATE FUNCTION Syntax RETURN Clause and the RETURNS Statement Scalar vs. Table Functions Comparison with Stored Procedures Returning Scalar Values and Tables ALTER and DROP FUNCTION Stored Procedures Definition and Benefits of Use CREATE PROCEDURE Syntax Variables and Parameters Control of Program Flow ALTER and DROP PROCEDURE Implementation Differences Triggers Definition and Benefits of Use Alternatives (e.g., Constraints) CREATE TRIGGER Syntax Trigger Types 'Inserted' (or 'NEW') and 'Deleted' (or 'OLD') Tables Event Handling and Trigger Execution ALTER and DROP TRIGGER Additional course details: Nexus Humans Advanced SQL Programming (TTSQL005) 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 Advanced SQL Programming (TTSQL005) 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.

THIS LIVE PRESENTATION is suitable for parents and carers of individuals affected by neurodiversity aswell as practitioners providing services for people with autism and associated conditions and gives you a comprehensive opportunity to learn about Autism and associated conditions like you will have never experienced before. Providing you the knowledge and from a unique perspective, this course will assist you to support neurodiverse loved ones, individuals and families. This live presentation includes ADHD, PDA and neurodiversity and the Sensory world uniquely brought to you by autistic trainers. Learn more about sensory dysfunction, autism and anxiety and Masking!. Join us to learn more about Autism, and how to communicate more effectively with individuals on the autistic spectrum! This presentation also covers ‘Challenging Behaviour’ and how to implement Positive Behaviour Support Plans and EXPLAINS why communication, sensory, rigid thinking and social interaction differences lead to CHALLENGING BEHAVIOUR and offers advice and strategies about how to support individuals with differences. Training sessions include question and answer time to offer practitioners and families to gain solutions to relevant challenges/experiences. Autizma are committed to improving lives and enhancing service provision and we look forward to meeting with you soon! Please don’t worry if you can’t attend registration gives you access to the Live Recording, a Certificate and post training resources.

This live virtual presentation gives you a comprehensive opportunity to learn about Autism and associated conditions like you will have never experienced before. Providing you the knowledge from a unique perspective, this course will assist you to support neurodiverse loved ones, and individuals.

Course Overview This practical, one-day course is designed to equip participants with the essential skills, tools and confidence to effectively facilitate discussions, meetings, and workshops. Whether you're guiding a team brainstorming session, leading a stakeholder workshop, or managing a complex meeting, strong facilitation skills can dramatically improve outcomes and engagement. Participants will learn how to plan and structure sessions, manage group dynamics, keep discussions on track, and handle challenging behaviours—all while creating a collaborative and inclusive environment. The course combines theory with hands-on activities, group discussions, and real-world scenarios to build practical, transferable skills. Who Should Attend This course is ideal for: Project managers Team leaders and supervisors Business analysts Community engagement officers Policy officers Trainers and consultants Anyone responsible for leading meetings or workshops No prior facilitation experience is necessary. Learning Outcomes By the end of the course, participants will be able to: Understand the role and mindset of an effective facilitator Plan and design structured facilitation sessions Use a range of facilitation tools and techniques to encourage participation Manage group dynamics, including difficult participants and off-topic conversations Apply active listening, summarising and questioning techniques Create safe, inclusive and engaging environments for diverse groups Maintain neutrality and guide discussions to achieve desired outcomes Course Content 1. Introduction to Facilitation What is facilitation? Key differences between facilitation, presentation and training The mindset of an effective facilitator 2. Planning for Success Clarifying session purpose and outcomes Structuring the session: openings, transitions, closings Selecting the right tools and approaches for your audience 3. Core Facilitation Techniques Questioning strategies (open, probing, clarifying) Active listening and reflection Encouraging balanced participation Visual facilitation basics (whiteboards, templates, sticky notes) 4. Managing Group Dynamics Reading the room and adapting your approach Handling dominant or disengaged participants Dealing with conflict or resistance constructively Techniques for decision-making and consensus-building 5. Practice and Feedback Facilitated role-plays and group exercises Constructive peer and trainer feedback Personal action planning Delivery Method This course is delivered in a highly interactive, face-to-face or virtual format. It includes a blend of short presentations, group work, facilitated discussions and hands-on activities to embed learning. Inclusions Comprehensive participant workbook and toolkit Facilitator guides and templates Certificate of completion Optional post-course coaching (available on request)

Course Overview Outstanding customer service doesn’t happen by accident- it’s the result of clear communication, empathy, consistency, and a strong customer-focused mindset. This practical one-day course helps participants develop the mindset, skills and strategies needed to provide exceptional service and handle difficult situations with confidence and professionalism. Through real-world scenarios, role plays and interactive discussions, participants will learn how to build rapport, respond to customer needs, and create positive experiences that leave a lasting impression—whether communicating face-to-face, by phone, email, or online. Who Should Attend This course is ideal for: Frontline staff in retail, hospitality, healthcare, call centres, or public service Administration or reception staff Technical support or helpdesk officers Any team member who interacts with customers, clients or stakeholders No previous training in customer service is required. Learning Outcomes By the end of the course, participants will be able to: Understand what excellent customer service looks like and why it matters Communicate clearly, professionally and confidently in different situations Build rapport with a wide range of customers Show empathy and listen actively to understand customer needs Handle complaints, concerns and difficult conversations calmly and constructively Maintain a positive attitude, even under pressure Represent their organisation in a consistent and professional way Course Content 1. Foundations of Customer Service Excellence What is excellent customer service? First impressions and the customer journey Attitude, tone and mindset 2. Communicating with Confidence The power of words, tone and body language Active listening and questioning skills Managing expectations and saying "no" professionally 3. Creating Positive Connections Building rapport and trust quickly Adapting your style for different customers Service recovery: turning complaints into opportunities 4. Handling Difficult Situations Staying calm under pressure Responding to frustration, complaints or anger The LEAPS model for difficult conversations (Listen, Empathise, Apologise, Provide solution, Summarise) 5. Service Across Channels Delivering service via phone, email and online Professional email and message tone Tips for consistency across different platforms 6. Practical Application and Action Planning Real-life scenarios and role plays Personal action planning for immediate workplace impact Sharing service tips and best practices Delivery Method The course is delivered in an engaging, interactive format and includes: Short trainer-led discussions Scenario-based activities Role plays with coaching Group discussions and shared insights Available as a face-to-face or live virtual workshop. Inclusions Participant workbook and tools Practical checklists and communication templates Certificate of completion Access to optional post-course coaching support

What is NLP? Join proactivenlp.com on this virtual workshop and find out how NLP can start changing your life by saying goodbye to the negatives and welcoming in all the positives you want.

Python Course, code the Hangman. Basic Python Course covers in one hour the coding of an interesting app. Any one very welcome. Our Style: Hands-on, Practical Location: Online, Instructor-led Download: anaconda.com Duration: 1 Hour Times: arrange a time for your time zone

Diabetes is serious. It can be life-threatening, however, people with diabetes can live long, healthy lives if their condition is kept well-controlled. In this training course, we explain what diabetes is and what to look out for. We cover how it is diagnosed and how to provide care and support to a person living with diabetes.

First Aid for Mental Health | RQF Level 2 First Aid for Mental Health qualification is designed to provide individuals with the knowledge and skills to support individuals experiencing mental health issues. This course aims to increase awareness of mental health, reduce stigma, and promote early intervention and support. The course covers various aspects of mental health, including common mental health conditions, signs and symptoms, and the impact of mental health issues on individuals and society. Participants will learn about different approaches to mental health, including self-help, accessing support, and signposting to appropriate services. The content of the RQF Level 2 First Aid for Mental Health course typically includes: Understanding Mental Health: An overview of mental health, including common mental health conditions such as depression, anxiety disorders, and stress. Participants will learn about the prevalence of mental health issues and their impact on individuals and society. Recognizing Mental Health Conditions: Understanding the signs, symptoms, and potential triggers of various mental health conditions. Participants will learn to identify early warning signs and risk factors for mental health issues. Promoting Positive Mental Health: Strategies and techniques for promoting positive mental health and well-being. This may include stress management techniques, self-care practices, and maintaining good mental health hygiene. Providing Mental Health First Aid: Techniques for providing initial support to individuals experiencing mental health crises or deteriorating mental health. Participants will learn how to offer non-judgmental listening, empathy, and reassurance to individuals in distress. Signposting and Referral: Understanding the importance of signposting individuals to appropriate professional help and support services. Participants will learn about local resources, helplines, and mental health organizations that can provide ongoing assistance. Self-Help and Resilience: Exploring self-help strategies and resilience-building techniques that individuals can use to manage their mental health and well-being. This may include relaxation techniques, mindfulness exercises, and developing healthy coping mechanisms. The course may be delivered through a combination of classroom-based instruction, group discussions, case studies, and practical activities. All our trainers are qualified and experienced in mental health education and support. Upon successful completion of the RQF Level 2 First Aid for Mental Health course, participants will receive a qualification that demonstrates their understanding of mental health issues and their ability to provide initial support to individuals experiencing mental health challenges. It's important to note that this course is not intended to replace professional mental health services or provide participants with the qualifications to diagnose or treat mental health conditions. It aims to equip individuals with the knowledge and skills to provide initial support and signposting to appropriate services. Suitability - Who should attend? First Aid for Mental Health course is suitable for a wide range of individuals who are interested in gaining knowledge and skills to provide initial support to individuals experiencing mental health challenges. Here are some examples of who the course may be suitable for: General Public: The course is open to anyone who wants to increase their understanding of mental health and learn how to support others effectively. It is suitable for individuals who want to develop their knowledge and skills in mental health first aid for personal reasons or to support friends, family members, or colleagues. Workplace Settings: The course is particularly relevant for individuals working in various professional settings, including but not limited to workplaces, schools, colleges, universities, community organizations, and voluntary sectors. It can benefit employees, supervisors, managers, and HR professionals who want to create a mentally healthy and supportive work environment. Healthcare Professionals: Healthcare professionals, such as nurses, doctors, paramedics, and allied health professionals, can benefit from the course to complement their existing medical knowledge and skills. The course equips them with additional tools and strategies to effectively respond to the mental health needs of their patients. Customer Service and Support Roles: Individuals working in customer service, hospitality, retail, or other client-facing roles can benefit from the course to enhance their ability to provide empathetic and supportive interactions with customers or clients who may be experiencing mental health challenges. Community Leaders and Volunteers: Community leaders, volunteers, and individuals involved in community organizations, charities, or support groups can gain valuable knowledge and skills from the course. It enables them to offer informed support and signposting to individuals within their communities who may be in need. It's important to note that the course does not require any previous qualifications or specific professional background in mental health. Participants should have a willingness to learn, an open mind, and a compassionate attitude toward individuals experiencing mental health challenges. However, it's also important to recognize that the course does not provide participants with the qualifications to diagnose or treat mental health conditions. Instead, it focuses on providing initial support, promoting awareness, and signposting individuals to appropriate professional help and services. Before enrolling in the course, individuals should consider their personal interest, commitment to learning about mental health, and their motivation to support others in this area. It is also recommended to check any specific requirements or prerequisites set by the training provider to ensure suitability for participation. Overall, the RQF Level 2 First Aid for Mental Health course is suitable for individuals from various backgrounds who want to develop their understanding of mental health and gain practical skills to provide initial support and signposting to individuals in need. Outcome / Qualification etc. Upon successful completion of the First Aid for Mental Health course, participants can expect to achieve the following outcomes: Increased Awareness and Understanding: Participants will develop a greater awareness and understanding of mental health, including common mental health conditions, their signs and symptoms, and the impact they can have on individuals and society. They will gain knowledge about the prevalence of mental health issues and the importance of promoting positive mental health. Enhanced Ability to Recognize Mental Health Conditions: Participants will acquire the skills to recognize signs and symptoms of various mental health conditions. They will be better equipped to identify early warning signs and risk factors, enabling them to provide timely support and intervention. Improved Mental Health First Aid Skills: Participants will learn techniques and strategies for providing initial support to individuals experiencing mental health crises or deteriorating mental health. They will develop skills in active listening, non-judgmental communication, and empathy, allowing them to offer appropriate assistance and reassurance to individuals in distress. Knowledge of Signposting and Referral: Participants will gain an understanding of the importance of signposting individuals to appropriate professional help and support services. They will learn about local resources, helplines, and mental health organizations, enabling them to provide accurate information and guide individuals to the appropriate sources of assistance. Enhanced Self-Help and Resilience Strategies: Participants will learn self-help strategies and resilience-building techniques that individuals can use to manage their own mental health and well-being. They will acquire practical tools for stress management, relaxation, and developing healthy coping mechanisms. Confidence in Supporting Others: The course aims to enhance participants' confidence in providing support to individuals experiencing mental health challenges. Through knowledge, skills, and practical exercises, participants will feel more prepared to respond appropriately and effectively in a compassionate and understanding manner. Qualification: Upon successful completion of the course, participants will receive an RQF Level 2 qualification in First Aid for Mental Health. This qualification demonstrates their understanding of mental health issues and their ability to provide initial support to individuals in need. It's important to note that the RQF Level 2 First Aid for Mental Health qualification is not intended to replace professional mental health services or provide participants with the qualifications to diagnose or treat mental health conditions. Instead, it aims to equip individuals with the necessary knowledge and skills to offer initial support and signposting, fostering a supportive and empathetic environment for individuals experiencing mental health challenges. Training Course Content Module 1 Introduction Module 2 What is first aid for mental health? Module 3 Identifying mental health conditions Module 4 Providing advice and starting a conversation Module 5 Stress Module 6 Mental health conditions Module 7 Drugs and alcohol Module 8 First aid action plan for mental health - including practical assessment Module 9 Mental health in the workplace Module 10 Assessment and course closure Course delivery details Classroom-Based or Virtual Instruction: The course may be delivered through traditional classroom-based instruction, where participants attend in-person training sessions led by a qualified instructor. The instructor will cover the course content, facilitate discussions, and provide guidance on practical activities. Blended Learning: Some training providers offer a blended learning approach, combining both online and face-to-face components. Participants may complete certain modules or topics online through interactive e-learning platforms or virtual classrooms. This allows for self-paced learning and flexibility before attending practical sessions or assessments in person. Interactive Discussions: The course often includes interactive discussions where participants can share their experiences, ask questions, and engage in conversations related to mental health. This encourages active participation, promotes peer learning, and provides opportunities for clarification and deeper understanding of the course content. Case Studies and Scenario-Based Activities: To enhance practical application, trainers may present case studies or scenarios related to mental health issues. Participants can work in groups or individually to analyse the situations, identify appropriate responses, and discuss possible strategies for providing support. Practical Skills Demonstrations: Trainers may demonstrate practical skills and techniques for providing mental health first aid, such as active listening, empathetic communication, and crisis intervention. Participants will have the opportunity to observe and learn from these demonstrations before practicing the skills themselves. Role-Playing and Simulations: Role-playing exercises and simulations may be used to simulate real-life scenarios and provide participants with hands-on practice in responding to mental health crises. This allows them to develop their skills in a safe and controlled environment and receive feedback from the trainer and peers. Assessment and Certification: Participants will undergo assessments to demonstrate their understanding of the course content and their ability to apply their knowledge and skills in practical scenarios. Successful completion of the assessments leads to the awarding of the RQF Level 2 First Aid for Mental Health qualification. It's important to note that the specific delivery methods and approaches may vary depending on the training provider, course duration, and the resources available. Participants should check with the training provider for detailed information on the course delivery format and any specific requirements or prerequisites for participation. Overall, the aim of the course delivery is to create an engaging and interactive learning environment that allows participants to gain the necessary knowledge, skills, and confidence to provide effective support to individuals experiencing mental health challenges. Why choose Madeleys First Aid Plus Founded in 2021 after Louise left 30 years in the NHS as an Advanced practitioner in A&E/ITU, had spent 1.5 years in Covid ITU Won FSB Best start-up business in the West Midlands in May 2023 Now trained 100's of delegates in Physical and Mental Health First Aid

You can handle the tough stuff with the help of this comprehensive, interactive and thought-provoking course. Our trainers are experienced managers who will guide and support you through the intricacies of people and personal management. The key responsibilities of the manager A manager’s impact on the business and its staff Being a role model Communicating with confidence Questioning skills Managing hybrid teams Assertiveness techniques Managing team performance with ease Giving great feedback Prioritising like a winner Time management techniques Delegating effectively