621 Trainer courses in Wetherby 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

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 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)

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.

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

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