723 Professional Development courses delivered Live Online

Afternoon Cuppa Session - Running a careers themed Takeover Day     Tuesday 21 May, 2-3.30pm   Join us for an informal virtual briefing and discussion session to inspire your own careers themed Takeover Day.  Kids in Museums Takeover Day is when museums, galleries, historic homes, archives and heritage sites invite young people to take over jobs normally done by adults for the day. This year Takeover Day is on Friday 22 November. The theme for Takeover Day in 2024 is careers. We are bringing Takeover Day back to its roots and highlighting how it can support young people of all ages to learn about different jobs in museums and develop their skills, both in the sector and beyond. The date also coincides with Discover Creative Careers Week [https://discovercreative.careers/about/discover-creative-careers-week-2024/#:~:text=Creative%20Careers%20Week%20will%20take,in%20our%2077%20priority%20areas.] In this session, we will: * provide a range of ideas to inspire your own careers themed Takeover Day involving local children and young people  * hear a case study from Dover Museum about their careers themed Takeover Day in November 2023 * create opportunities for attendees to informally share their ideas and other projects they have undertaken around careers. Please bring along your own cuppa and snacks! Take a look at the full schedule. [https://kidsinmuseums.org.uk/wp-content/uploads/2024/03/Schedule-creating-a-careers-themed-Takeover-Day-afternoon-cuppa-session-21.05.pdf]   This event will be delivered virtually over one and a half hours. 

Become a professional in the Telecomms industry with our EUSR SHEA Telecommunications Card Training Overview Our Energy Utilities Skills Register Safety Health Environmental Awareness EUSR SHEA Telecommunications Card Training is designed for professionals working in telecommunication-related industries, such as Telephone Exchanges, on the network, customer properties and more. The course equips participants with essential knowledge and skills to ensure safe and environmentally responsible practices on work sites near telecommunication environments. Upon completion, you’ll receive the coveted EUSR SHEA Telecommunications Card.

Introduction to Wound Care via Zoom Join us via Zoom for this informative and interactive course designed for nurses, healthcare professionals, and healthcare assistants who are new to wound management in the primary care setting. This course will empower you with the knowledge and skills to confidently manage wound care for both adults and children, ensuring the highest standards of patient care in your practice. Day One Learning Objectives: 1. Develop a comprehensive understanding of wound care in the primary care setting. 2. Explore the anatomy and physiology related to wound healing. 3. Learn how to assess wounds, including the various stages of wound healing. 4. Understand wound infections and their management. 5. Familiarize yourself with wound closure techniques such as sutures, Steri-strips, and clips. 6. Gain knowledge about emollients, barrier creams, and steroids. 7. Discover commonly used dressings for wound care. 8. Create an action plan, evaluate your learning, and access resources for further study. Day Two Learning Objectives: 1. Review the topics covered on Day One and explore wound care formularies and pathways. 2. Differentiate between leg ulcers of arterial and venous origin. 3. Understand exudate management in wound care. 4. Learn about the theory behind compression therapy for wound management. 5. Engage in case studies to apply your knowledge. 6. Explore competencies that can be achieved in practice. 7. Create an action plan for your next steps, evaluate your learning, and access additional resources. Learning Outcomes for Both Days: By the end of this 2-day Introduction to Wound Care course, participants will: 1. Develop a solid understanding of the physiology of wound healing, including chronic venous and arterial insufficiency. 2. Acquire knowledge about topical medications and emollients commonly used in wound care. 3. Familiarize themselves with a range of dressings frequently employed in wound management. 4. Recognize the importance of regular wound review and supervised self-management plans. 5. Engage in discussions about relevant practice problems and work toward effective solutions. 6. Understand the significance of ongoing professional development in wound care practice.

Come and join Supported Loving's Community of Practice for anyone working with people with learning disabilities and/or autistic people delivering relationships and sex education, this can be formally groups or informally within your job role. Working in this area can be challenging but as a community we can grow and learn - there is always something new to learn! Each month we will take a topic to discuss and reflect upon what are the challenges and what has worked/ positive approaches. Each session will include a case study to explore , a section where we share our favourite resources to use on this topic and space to discuss our practice surrounding this topic. Please book on and lets get sharing :) This months topic- How to developing relationships 

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.

Do you just need a quick chat to move things forward? Do you have some pressing questions and need feedback that relates directly to you and your book? Did you want to do Taking Your Book To School but are not quite ready yet? I have three half-hour brainstorm sessions available to you on Saturday 18th March at a discounted rate of £20.00 per session. Would you like one? First come first served!

**Peer Supervision for Clinical Hypnotherapists: Key Benefits for SEO** Peer supervision for clinical hypnotherapists fosters professional growth through enhanced reflective practice, continuous learning, emotional support, feedback and validation, ethical guidance, networking, and professional accountability. - **Enhanced Reflective Practice**: Facilitates self-reflection, helping hypnotherapists identify strengths, weaknesses, and areas for improvement through peer discussions. - **Continuous Learning**: Expands knowledge by sharing innovative techniques, research findings, and emerging trends, promoting ongoing professional development. - **Emotional Support**: Provides a supportive space for therapists to share experiences and receive emotional support, addressing the emotional demands of the profession. - **Feedback and Validation**: Offers constructive criticism and fresh perspectives, aiding in skill refinement and improved clinical practice. - **Ethical Guidance**: Allows discussion of ethical dilemmas and collaborative solutions, ensuring adherence to professional standards. - **Networking and Collaboration**: Builds professional networks, leading to collaboration, referrals, and partnerships. - **Professional Accountability**: Encourages high standards and self-reflection through peer discussions, enhancing practice quality.

Designed to help individuals and their organisations develop new products, services and ways of working to create sustainable value. The EFQM Innovation Leader Training is designed to help individuals and their organisations understand what innovation means for them and challenge them to focus on developing new products, services and ways of working to add new value. The training will focus on how to: * Develop your understanding of innovation and how it can be successfully implemented using a structured innovation management approach * Demonstrate the ability to effectively manage innovation activities to achieve the intended outcomes Course Content * Overview of the EFQM Lens Concept * Introduction to Innovation Lens * Groupwork – Megatrends and how they impact on you * Innovation Lens Framework – Structure and Content * Groupwork – Completion of Innovation Questionnaire * Discussion – Feedback on the Questionnaire and Outcomes * How to manage the Innovation process * Using Assess Base to baseline performance/conduct a gap analysis Pre-course Work * Pre-reading on the new EFQM Model. Delivery * The course is delivered through virtual trainer led live workshop. Upon registration, you will receive a link to the workshop. Cost * £450 + VAT which includes the training course, the Innovation Lens e-book and your EFQM Innovation Leader Certificate. If you are not yet a member but are already thinking about joining CforC, you can find more information on how to become a member and the benefits by clicking here [http://www.cforc.org/join-us].

Course Description: These two days are dedicated to nurses and other allied healthcare professionals (AHPs) who are either new to or revisiting the realm of minor illness assessment and treatment. The course progression is designed to take you from foundational knowledge to more confident and adept management of patients, encompassing both adults and children. Course Details: Day One: - 09:15 AM: Coffee and registration - 09:30 AM: Introduction and course objectives - 09:40 AM: What constitutes a 'Good Consultation?' - 10:00 AM: Fever and Flu Like Illness - 10:45 AM: Coffee break - 11:00 AM: Respiratory Tract Infections (including breath sounds) - 13:00 PM: Lunch break - 14:00 PM: Case Studies - 14:30 PM: Urinary Tract Infections (UTIs) - 14:30 PM: Ears, Nose, and Throat conditions - 15:00 PM: Abdominal Pain - 15:30 PM: Action plan, evaluation, and resources - 15:45 PM: Close Day Two: - 09:15 AM: Coffee and registration - 09:30 AM: Review of work from day 1 - any feedback/questions? - 09:45 AM: Head, Neck, and Back Pain - 10:30 AM: Eye Infections - 10:45 AM: Coffee break - 11:00 AM: Mental Health (low mood) - 13:00 PM: Lunch break - 13:45 PM: Rashes - 14:30 PM: Minor Injuries - 16:00 PM: Case Studies, Action plan, evaluation, and resources - next steps? - 16:15 PM: Close Learning Outcomes: - How to conduct an effective consultation. - Enhanced understanding of diagnosing and treating specific minor illnesses. - Expanded knowledge of medicine management, including when and what to prescribe. - Understanding when to initiate tests for better illness management. - Ability to discuss the patient's options and proposed management plan effectively. - Knowing when to refer a patient to another health professional. - Encouraging discussions about relevant practice problems and their solutions. - Appreciating the importance of ongoing professional development.

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview After completing this course, students will be able to: - Identify independent and dependent variables and measurement levels in their own analytical work scenarios. - Identify variables of interest in relational database tables. - Choose a data aggregation level and data set design appropriate for the intended analysis and tool. - Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. - Create stored procedures, views, and functions to modularize data retrieval code. This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE * Two Approaches to SQL Programming * TSQL Data Retrieval in an Analytics / Business Intelligence Environment * The Database Engine * SQL Server Management Studio and the CarDeal Sample Database * Identifying Variables in Tables * SQL is a Declarative Language * Introduction to the SELECT Query * Lab 1: Introduction to TSQL for Business Intelligence 2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY * Turning Columns into Variables for Analysis * Column Expressions, Data Types, and Built-in Functions * Column aliases * Data type conversions * Built-in Scalar Functions * Table Aliases * The WHERE clause * ORDER BY * Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS * Primary Keys, Foreign Keys, and Joins * Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product * Understanding Joins, Part 2: The INNER JOIN * Understanding Joins, Part 3: The OUTER JOINS * Understanding Joins, Part 4: Joining more than two tables * Understanding Joins, Part 5: Combining INNER and OUTER JOINs * Combining JOIN Operations with WHERE and ORDER BY * Lab 1: Write SELECT queries 4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY * Identifying required aggregation level and granularity * Aggregate Functions * GROUP BY * HAVING * Order of operations in SELECT queries * Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS * Non-correlated and correlated subqueries * Derived tables * Common table expressions * Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC * Views * Table-valued functions * Stored procedures * Creating objects for read-access users * Creating database accounts for analytical client tools * Lab 1: Encapsulating Data Retrieval Logic 7 - GETTING YOUR DATASET TO THE CLIENT * Connecting to SQL Server and Submitting Queries from Client Tools * Connecting and running SELECT queries from: * Excel * PowerBI * RStudio * Exporting datasets to files using * Results pane from SSMS * The bcp utility * The Import/Export Wizard * Lab 1: Getting Your Dataset to the Client ADDITIONAL COURSE DETAILS: Nexus Humans 55232 Writing Analytical Queries for Business Intelligence 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 55232 Writing Analytical Queries for Business Intelligence 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.