3460 Courses

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.

Duration 45.625 Days 273.75 CPD hours Overview Live, instructor-led virtual classes: Benefit from an interactive classroom with added flexibility and convenience. Access to Red Hat certified instructors: Virtual classes are taught by the same experienced subject matter experts who lead classroom trainings. Flexible scheduling options: Various class topics and time options facilitate incorporating learning and preferences into busy schedules. Focused training sessions: Participants can narrow their learning to more specific topic areas. Choice of learning modality: A combination of self-paced materials and expert-taught classes maximizes learning. Train without traveling: Learn when, where, and how it is best for you Red Hat© Learning Subscription Premium provides a customizable learning experience with self-paced and live training options. Users can tailor their learning with recorded video classes, e-books, online content, and live virtual classes. A subscription provides access to content across the entire Red Hat product portfolio, content that is continuously updated by Red Hat experts. Live, instructor-led classes create an engaging, immersive learning experience. These interactive sessions compliment the on-demand, self-paced learning materials available with a Red Hat Learning Subscription for highly effective, flexible training for everyone from beginners to experienced professionals.This subscription provides an array of additional features to complement the learning experience. Cloud-based labs give the opportunity for hands-on practice in actual Red Hat environments. Expert extras are short, on-demand videos where Red Hat practitioners demonstrate innovative technologies in practical scenarios. Skills paths and pre-assessments are available for course selection guidance. Red Hat Learning Subscription Premium also includes certification exams. Red Hat?s exams are industry-recognized and performance-based. These exams validate that holders have the skills needed to undertake even the most ambitious technology projects. Reporting capabilities to track progress toward training and certification goals. 24x7 self-paced access to Red Hat online training and video classroom courses Content is created by Red Hat experts who build and use Red Hat technology and is directly related to Red Hat certification exams. Early access Be the first to explore in-development technology before it is officially released by accessing courses and labs in development. Cloud-based labs Get hands-on practice in authentic Red Hat environments, delivered 24x7 on six continents. Skills paths Map your learning and certification goals to one of the skills paths inside the platform to develop a strong foundation for a specific skill set. Certification exams and retakes Validate your skills through performance-based exams remotely or at a testing station. Exams can be taken when and where it's most convenient. Expert extras Red Hat field practitioners present short demo videos to supplement courses by showing innovative technologies and practices based on actual use cases. Expert chat Get direct answers and guidance from curriculum experts via a 30-minute chat session per day. Machine translations provide chat dialogue in local languages. E-book Downloads Download course e-books to continue learning offline. Reporting An individual?s dashboard provides a summary of training progress, courses and labs taken, and exam status. Management reports provide insights so a team?s engagement and progress can be measured. Globally available,translated content Access Red Hat?s most popular courses in as many as 11 languages: English, International Spanish, Brazilian Portuguese, French, Italian, German, Simplified Chinese, Korean, Japanese, Hindi, and Czech. Additional course details: Nexus Humans Red Hat Learning Subscription Premium 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 Red Hat Learning Subscription Premium 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.

Duration 5 Days 30 CPD hours Additional course details: Nexus Humans ES07 IBM z/OS JCL and Utilities 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 ES07 IBM z/OS JCL and Utilities 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.

Anyone who works with children or lives with them would benefit learning from this Child Attachment and Development, and instructors looking to learn more about the psychology of "Little people" would find it to be a particularly useful course. With this course, you will learn how to think like a genuine expert in the subject of child attachment theory. It will teach you the fundamentals of nursery assistance while understanding children's development and child psychology. This course covers all the essential details and clarifies the key ideas. You will be able to practically implement the guiding ideas of child attachment theory at the conclusion of the course. Learning Outcome: Learn the duties and responsibilities of a nursery assistant, including who they are and what they do. Learn more about the basics of connecting with children, Explore the importance of child psychology. Discover how to handle childcare responsibilities. Understand the concepts used in law and ethics regarding child development. What will Make You Stand Out? On completion of this Child Attachment and Development online course, you will gain: CPD QS Accredited course After successfully completing the Course, you will receive a FREE PDF Certificate as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials. Enroling in the Course has no additional cost. 24x7 Tutor Support You can study and complete the course at your own pace. Course Curriculum Child Attachment and Development Module 01: Introduction to Nursery Assistance Module 02: Understanding Child Development Module 03: Importance of Early Years Development Module 04: Introduction to Child Attachment Module 05: Introduction to Child Psychology Module 06: Fundamentals of Attachment Theory Module 07: Assessments of Attachment Module 08: Attachment Disorder Module 09: Care for Children Module 10: Keeping Children Healthy and Safe Module 11: Child Protection Show off your new skills with a certificate of completion. After successfully completing the course, you can order your CPD Accredited Certificates as proof of your achievement absolutely free. Please Note: The delivery charge inside the U.K. is £4.99, and international students have to pay £8.99. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Course the Right Option for You? This Child Attachment and Development course is open to everybody. You can access the course materials from any location in the world and there are no requirements for enrolment. Requirements Without any formal requirements, you can delightfully enrol in this Child Attachment and Development course. Just get a device with internet connectivity and you are ready to start your learning journey. Thus, complete this course at your own pace. Career path The aim of this exclusive Child Attachment and Development course is to help you toward your dream career. So, complete this course and enhance your skills to explore opportunities in relevant areas.

As a medical professional, you understand the importance of venepuncture. But are you ready for anything that might come up? Venepuncture Level 3 will teach you how to use sophisticated methods, figure out issues, and lower dangers when performing venepuncture.

Elevate your expertise in Food Safety Management Systems (FSMS) with this comprehensive course. From leadership principles to risk management and compliance, grasp the facets of FSMS to ensure quality and safety in food operations.

Workplace health and safety course covers all aspects of ensuring the workplace environment is both safe and healthy.

Health: Level 1 Diploma in Hormone Health Embark on a journey to Hormone Health with our Level 1 Diploma course.Learn strategies to optimize your Hormonal Health through diet and lifestyle improvements. Gain knowledge about artificial and anabolic steroid hormones in this comprehensive program. Learning Outcomes: Define the concept of Hormone Health and its significance. Identify different types of hormones and their functions. Explain the role of sex hormones in hormonal health. Analyse strategies for optimizing hormone health through diet. Apply lifestyle improvements to enhance hormonal well-being. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Health: Level 1 Diploma in Hormone Health Course Syllabus Hormone Health Basics: Gain a foundational understanding of hormone health, its significance, and its impact on overall well-being. Explore the essential role hormones play in various bodily functions. Types Hormones: Dive into the diverse world of hormones. Learn about different types of hormones and their specific functions in regulating bodily processes, from growth to metabolism. Understanding Sex Hormones: Explore the intricacies of sex hormones, including estrogen, progesterone, and testosterone. Understand their roles in reproductive health, sexual development, and overall hormonal balance. Strategies for Optimising Hormone Health: Discover how dietary choices can influence hormonal health. Learn about nutrition strategies and dietary patterns that promote hormonal balance and overall well-being. Lifestyle Improvements for Better Hormone Health: Explore lifestyle factors that impact hormonal health. Gain insights into the importance of sleep, stress management, exercise, and other lifestyle adjustments for maintaining optimal hormonal balance. Understanding Artificial and Anabolic Steroid Hormones: Delve into the topic of artificial and anabolic steroid hormones. Learn about their effects on the body, potential risks, and ethical considerations surrounding their use.

Level 1 Award in Basic Life Support (BLS) & Safe Use of an Automated External Defibrillator Begin your journey to becoming a lifesaver with our Level 1 Award in Basic Life Support (BLS) & Safe Use of an Automated External Defibrillator. Master the essentials of BLS, CPR, and AED use to respond effectively in emergencies. Learning Outcomes: Understand Basic Life Support (BLS) fundamentals. Perform Cardiopulmonary Resuscitation (CPR) correctly. Operate an Automated External Defibrillator (AED) safely. Respond to choking incidents with BLS techniques. Apply BLS skills confidently during emergencies. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Key Modules from Level 1 Award in Basic Life Support (BLS) & Safe Use of an Automated External Defibrillator: Basic Life Support (BLS) 101: Grasp the core principles and techniques of Basic Life Support (BLS) to provide initial care. Cardiopulmonary Resuscitation (CPR): Learn the life-saving technique of CPR to maintain blood circulation in emergency scenarios. Automated External Defibrillator (AED): Gain proficiency in the safe and effective use of AEDs for emergency cardiac events. Choking: Acquire the skills to assist choking individuals using BLS protocols. BLS During Emergencies: Prepare to implement BLS strategies swiftly and effectively during emergency situations.

Developing the high performing team takes time and effort. But above all, it requires an understanding of the dynamics of high performing teams. This programme helps managers and leaders understand what high performing teams do and how they do it. It focuses on enabling managers to see their teams from different perspectives, allowing them to adapt their styles to maximise team outputs. A core theme is the need for managers of teams to 'hold up the mirror' to themselves and to see themselves as a leader of people, to reflect on how others see them and to modify their style accordingly. This programme will help managers / team leaders: Analyse the constituents of a 'high performing' team Apply essential influencing techniques Use a range of communication techniques to support effective teamwork Create and articulate team vision Generate common values Assess team effectiveness and take/recommend the appropriate actions Make more efficient use of team time Understand and agree on techniques to manage conflict Define and implement team meeting protocols that will facilitate team effectiveness Use the Prime Focus model to create the environment and framework for a high performing team Draft your team strategy to take them to the next level Day 1 1 Welcome and introduction Participants are welcomed to the programme and invited to share their personal objectives and people challenges Participants are given an action plan template to complete throughout the workshop 2 Your team The concept of 'positive intention' The difference between a team and a high performing team Assess your team effectiveness What is your 'interference'? 3 The team environment Setting the scene Building rapport Active listening Team goals and role profiling 4 Your style Tuckman model of team stages - how do you manage each stage? Team standards and goals Your team vision 5 Effective team meetings Influencing in team meetings How to make them interesting and relevant The pure role of the chair Day 2 1 Effective communication techniques Giving and receiving feedback Your communication style How to adapt, pace and lead to build rapport The Mehrabian theory of communication 2 How to manage conflict What is conflict? What is your default conflict approach? Tools and tips for managing conflict Practice sessions 3 Team skills Undertake a team skills analysis Types of team member Motivating team members Reframing situations 4 Setting your strategy Seeing the bigger picture The Prime Focus Model Your strategy for success Articulating your strategy Action plans revisited