- Professional Development
- Medicine & Nursing
- Arts & Crafts
- Health & Wellbeing
- Personal Development
SQL Querying Fundamentals with HUE - Part 1
By Nexus Human
Duration 1 Days 6 CPD hours This course is intended for This course is for employees of Sun Life who want to learn how to use HUE when working with SQL databases. Overview Upon successful completion of this course, students will be able to operate HUE when interacting with SQL databases. In this course, students will learn how to operate HUE when interacting with SQL databases. Executing a Simple Query Connect to the SQL Database Query a Database Save a Query Modify and Execute a Saved Query Performing a Conditional Search Search Using One or More Conditions Search for a Range of Values and NULL Values Search Data Based on Patterns Working with Functions Perform Date Calculations Calculate Data Using Aggregate Functions Manipulate String Values Organizing Data Sort Data Rank Data Group Data Filter Grouped Data Summarize Grouped Data Use PIVOT and UNPIVOT Operators Retrieving Data from Multiple Tables Combine the Results of Two Queries Compare the Results of Two Queries Retrieve Data by Joining Tables Exporting Query Results Generate a Text File Generate an XML File Additional course details: Nexus Humans SQL Querying Fundamentals with HUE - Part 1 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 SQL Querying Fundamentals with HUE - Part 1 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.
Excel - Pivot Table Specialist
By Underscore Group
An in depth look at Pivot Tables and their powerful features to summarise and visualize your data. Course overview Duration: 1 day (6.5 hours) Our Excel – Pivot Table Specialist course is a comprehensive guide to working with Pivot Tables for those who need to learn more about the use of Pivot Tables to summarise and analyse information. This course is designed for existing experienced users of Excel. You should be a confident Excel user and be able to create and edit worksheets and write basic formulas. Objectives By the end of the course you will be able to: Build and customise Pivot Tables Group and sort information Filter information Use slicers and the timeline filter Add different summary calculations Create Pivot Charts Add calculated fields and items Content The anatomy of a Pivot Table Using a Pivot Cache Building a Pivot Table The Pivot Table interface Refreshing the Pivot Table Adding column, row, page and data fields Changing data orientation Showing data fields in columns or rows Drilling down to underlying data Setting Pivot Table options Format options Totals and filters options Display and printing options Data options Customising Pivot Tables Modifying field names Data formatting Changing field layout options Changing summary calculations Working with subtotals Filtering and sorting Filtering items Sorting data Value and label filters Creating top 10 reports Using the Search filter Using the Slicer tool Use the Timeline filter Grouping Grouping date fields Grouping numeric fields Adding your own groups Summary calculations Running totals Differences year on year, month on month % Differences year on year, month on month % of Row, Column, Total and other fields Pivot charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Adding calculated fields Adding calculated items
When it comes to protecting vulnerable individuals, knowledge isn't optional—it’s essential. This Level 3 Safeguarding Children & Vulnerable Adult QLS Endorsed Course has been thoughtfully structured for those who need a strong understanding of safeguarding responsibilities in both children’s and adult care settings. The course bundle combines two in-depth modules: a diploma-level study in safeguarding, and a focused exploration of online safety for children—reflecting today’s ever-evolving risks. Whether you’re working in education, healthcare, social care, or community services, this training offers a well-rounded knowledge base to support safe, ethical, and informed decision-making. With updated content relevant to today’s safeguarding challenges, this course is delivered entirely online, making it flexible and accessible to those with busy schedules or varied commitments. It's not just about what you learn—it's about why it matters. This is safeguarding education designed to meet today’s expectations, not yesterday’s. Our Level 3 Safeguarding Children & Vulnerable Adult course is endorsed by the Quality Licence Scheme - QLS, ensuring you acquire new skills and enhance your professional development. Level 3 Safeguarding Children & Vulnerable Adult QLS Bundle Includes the following Courses Course 01: Diploma in Safeguarding Children & Vulnerable Adult at QLS Level 3 Course 02: Safeguarding Children: Internet Safety Key Features of Level 3 Safeguarding Children & Vulnerable Adult Eligibility for QLS endorsed certificate upon successful completion of the Level 3 Safeguarding Children & Vulnerable Adult course Free CPD Accredited Course Fully online, interactive Level 3 Safeguarding Children & Vulnerable Adult course with audio voiceover Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases To become successful in your profession, you must have a specific set of skills to succeed in today's competitive world. In this in-depth Level 3 Safeguarding Children & Vulnerable Adulttraining course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills. Assessment At the end of the Level 3 Safeguarding Children & Vulnerable Adult course, we will provide assignment and quizzes. For each test, the pass mark will be set to 60%. Accreditation This Level 3 Safeguarding Children & Vulnerable Adult course is QLS - Quality Licence Scheme Endorsed and CPD Certified, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification CPD Certified: Once you've successfully completed your Level 3 Safeguarding Children & Vulnerable Adult course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). QLS Endorsed:After successfully completing the Level 3 Safeguarding Children & Vulnerable Adult course, learners will be able to order an endorsed certificate, titled: [Diploma in Safeguarding Children & Vulnerable Adult at QLS Level 3], as proof of their achievement. This certificate of achievement endorsed by the Quality Licence Scheme. CPD 20 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about Level 3 Safeguarding Children & Vulnerable Adult basics. Requirements No prior degree or experience is required to enrol in this Level 3 Safeguarding Children & Vulnerable Adult course. Career path This Level 3 Safeguarding Children & Vulnerable Adult Course will help you to explore avariety of career paths in the related industry. Certificates Digital certificate Digital certificate - Included Hardcopy Certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.
How to Start in Medical Aesthetics
By Medical Aesthetics Academy
https://www.google.com/maps/place/Medical+Aesthetics+Academy/@41.4063155,2.1260623,17z/data=!3m2!4b1!5s0x12a4981430a548fb:0xc7a59105a7e8e9b6!4m5!3m4!1s0x12a499bf3d7c5363:0x582e58af45180d55!8m2!3d41.4063115!4d2.1282563
Introduction to Minor Illness
By BBO Training
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: CloseDay 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: CloseLearning 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.
Meditation for Beginners
By Boundless Meditation
Meditation for beginners with simple and easy techniques and guidance
