Overview of MySql Masterclass The digital world has changed how businesses work in the UK, and database management is now a key part of every successful company. MySQL is one of the most popular tools for this job, used by over 40% of websites around the world. In the UK, big names like BBC, Sky, and many tech startups in London’s Silicon Roundabout rely on MySQL. The MySql Masterclass is designed to help people learn the skills needed to build a strong career in this growing field. Database experts in the UK earn an average salary of £45,000 each year, making it a smart career choice. The MySql Masterclass has 41 helpful modules that start with the basics and move up to more advanced topics. Students will learn how to create databases, write MySQL commands, use joins, and manage stored procedures. The course also teaches how to make systems run faster and safer with performance and security tools. Other important topics include handling JSON data, using full-text search, and working with replication. These are all things that modern companies look for in a database specialist. This MySql Masterclass is made for beginners and gives them the knowledge they need to handle real business databases. It helps students build strong skills in design, optimisation, and administration. The UK’s tech industry is worth £150 billion a year, and the MySql Masterclass helps learners get ready for job opportunities in many areas like retail, health, and finance. Learning Outcomes By the end of the MySql Masterclass, learners will be able to: Build and manage MySQL databases from the ground up Use SELECT, INSERT, UPDATE, and DELETE commands with confidence Work with advanced joins, unions, and stored procedures Design and use indexes, views, and full-text search for better performance Set up MySQL replication, backups, and basic system administration Handle JSON data and manage time zone settings within databases Who is this course for? Aspiring Database Administrators who want full MySQL training to manage databases, user access, and backups in organisations needing strong data systems. Software Developers who want to improve their backend development by learning MySQL queries, stored procedures, and database performance skills. Data Analysts who need advanced SQL to pull useful data from complex tables using joins, group functions, and reporting tools. IT Professionals looking to build database knowledge, including how to configure, tune, and fix issues in MySQL systems. Career Changers with little or no tech background who want to start in database roles, learning from the basics to advanced MySQL tasks. Process of Evaluation After studying the MySql Masterclass Course, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the MySql Masterclass Course, you can order your CPD Accredited Digital / PDF Certificate for £5.99. (Each) Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. (Each) Shipping Charges: Inside the UK: £3.99 International: £10.99 Requirements You don’t need any educational qualification or experience to enrol in the MySql Masterclass course. Career Path Completing this MySql Masterclass course could lead to rewarding jobs like: Database Administrator – £35K to £65K per year MySQL Developer – £30K to £55K per year Data Analyst – £25K to £45K per year Backend Developer – £35K to £60K per year Database Consultant – £40K to £70K per year Course Curriculum: MySql Masterclass Module 1: Introduction on MySQL 01:00:00 Module 2: Data Types 00:51:00 Module 3: SELECT Statements 00:59:00 Module 4: Backticks 00:15:00 Module 5: NULL 00:18:00 Module 6: Limit and Offset 00:13:00 Module 7: Creating databases 00:18:00 Module 8: Using Variables 00:25:00 Module 9: Comment MySQL 00:14:00 Module 10: INSERT Statements 00:29:00 Module 11: DELETE Statements 00:21:00 Module 12: UPDATE Statements 00:20:00 Module 13: ORDER BY Clause 00:08:00 Module 14: Group By 00:18:00 Module 15: Errors in MySQL 00:10:00 Module 16: Joins 00:37:00 Module 17: Joins continued 00:11:00 Module 18: UNION 00:18:00 Module 19: Arithmetic 00:20:00 Module 20: String operations 00:33:00 Module 21: Date and Time Operations 00:08:00 Module 22: Handling Time Zones 00:07:00 Module 23: Regular Expressions 00:19:00 Module 24: VIEWS 00:20:00 Module 25: Table Creation 00:23:00 Module 26: ALTER TABLE 00:23:00 Module 27: Drop Table 00:05:00 Module 28: MySQL LOCK TABLE 00:10:00 Module 29: Error codes 00:08:00 Module 30: Stored routines (procedures and functions) 00:29:00 Module 31: Indexes and Keys 00:24:00 Module 32: Full-Text search 00:18:00 Module 33: PREPARE Statements 00:09:00 Module 34: JSON 00:11:00 Module 35: Extract values from JSON type 00:05:00 Module 36: MySQL Admin 00:08:00 Module 37: TRIGGERS 00:12:00 Module 38: Configuration and tuning 00:07:00 Module 39: Events 00:08:00 Module 40: ENUM 00:09:00 Module 41: Collations, Transactions, Log files, Replication, Backup 00:41:00
The Medication Administration Training course are designed to help you understand the skills and knowledge required for working in the healthcare settings. Learn to take care of drugs correctly and understanding how the right way of administering them can reduce both major and minor risks. We understand the value of medication knowledge as it's essential for those working in the health and social care sector. The focus of this course to equip you with all the information required for the safe control, handling and administration of medicines in health and care settings. This course covers the function of the medication administration, including how to prescribe, manage and supervise medicines safely. This course also explains the crucial legislation and direction correlating to the classification of medications, grasp Govt. policies and procedures for ensuring the safe handling of drugs, dispensing, receiving and verifying the validation of medicines, the significance of keeping accurate recording and much more. On successful completion of the course, you will be able to expertly administer a range of medicines such as morphine, sedatives, laxatives and antibiotics, etc. Who is this course for? Medication Administration Training is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Medication Administration Training is open to all from all academic backgrounds and there is no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Medication Administration Training Introduction to Safe Handling of Medicines 00:30:00 Legislation and guidance of medication management 00:30:00 Principles of Safe and Appropriate Handling of Medicines 00:45:00 Medication Risk Assessment Guidance 00:30:00 Consent to Treatment 00:30:00 Handling Medicines in Social Care Settings 01:00:00 Requirements for Specific Services 00:45:00 Levels of Care and Support 00:15:00 Procedure for Handling Medication 00:30:00 The Six Rights of Medication Administration 00:30:00 Covert Administration of Medication 00:30:00 Recording Procedures 00:15:00 Storage of Medication 00:15:00 Transfer and Disposal of Medication 00:30:00 Drug Formulation and Ways of Taking It 01:00:00 Mock Exam Mock Exam - Medication Administration Training 00:20:00 Final Exam Final Exam - Medication Administration Training 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00
Duration 5 Days 30 CPD hours This course is intended for Horizon Cloud Service on Microsoft Azure administrators, system integrators, account managers, solutions architects, solutions engineers, sales engineers, and consultants. Overview By the end of the course, you should be able to meet the following objectives: Describe the architecture of Horizon Cloud Service on Microsoft Azure Discuss the initial Microsoft Azure configurations required for the Horizon Cloud Service on Microsoft Azure deployment Discuss Horizon Cloud Service on Microsoft Azure networking concepts Discuss Horizon Cloud Service on Microsoft Azure AD requirements and integration best practices Determine steps and requirements to deploy or upgrade Horizon Cloud Service on Microsoft Azure Recognize Horizon Cloud Service console controls that are available for administrators Identify Horizon Cloud upgrade features and benefits List the steps and considerations to take when setting up a primary VM to be used as an assignable image Identify how to access desktops and application from Horizon Cloud Service on Microsoft Azure Discuss and create Remote Desktop Session Host Farms Explain power management options in the RDSH farm Create VDI desktop assignments and entitlements Manage assignable images on Horizon Cloud Service on Microsoft Azure Describe and Use Image management service for Horizon Cloud Service on Microsoft Azure Describe the integration of Dynamic Environment Manger with Horizon Cloud Service on Microsoft Azure Manage user personalization and application configurations using the Dynamic Environment Manager management console and application profiler Discuss the usage of App Volumes for Horizon Cloud Service on Microsoft Azure Discuss the integration of Workspace ONE Access with Horizon Cloud Service on Microsoft Azure Interpret scalability considerations for Horizon Cloud Service on Microsoft Azure Determine the process of deploying, configuring, and paring Horizon Cloud Connector into your pod's environment Apply troubleshooting techniques relevant to Horizon Cloud Service and Microsoft Azure Summarize the analytics and monitoring capabilities in Horizon Cloud Service on Microsoft Azure This five-day, hands-on training provides you with the knowledge, skills, and abilities to achieve competence in deploying and managing VMware Horizon© Cloud Service? on Microsoft Azure. This training increases your skills and competence in using the VMware Horizon© Cloud Administration Console and Microsoft Azure portal.Through a combination of hands-on labs and interactive lectures, you learn how to import and manage images for VDI and RDSH assignments. You also learn how to configure and use the Universal Broker function, VMware App Volumes?, Workspace ONE Access and VMware Dynamic Environment Manager? in the Horizon Cloud Service on Microsoft Azure deployment. Course Introduction Introduction and course logistics Course objectives Introduction to Horizon Cloud Service on Microsoft Azure Identify Horizon Cloud Service on Microsoft Azure features, benefits, and licensing options Interpret Horizon Cloud Service on Microsoft Azure architecture components to identify configuration prerequisite Interpret Horizon Cloud Service on Microsoft Azure deployment models Discuss the initial Microsoft Azure configurations required for the Horizon Cloud Service on Microsoft Azure deployment Microsoft Azure Networking Requirements Summarize Horizon Cloud connectivity considerations and tasks Discuss Horizon Cloud on Microsoft Azure networking concepts Identify ports required for local connections, remote connections, and endpoint operating system firewall rules Active Directory List the features and limitations of supported AD configurations Discuss Horizon Cloud Service on Microsoft Azure AD integration best practices Determine Horizon Cloud Service on Microsoft Azure AD requirements Deployment and Upgrades Determine steps and requirements to deploy Horizon Cloud Service on Microsoft Azure Discuss the features and benefits of using multiple tenant subnets for desktops and RDSH Discuss the features and benefits of using Internal and External UAG Recognize Horizon Cloud Service console controls that are available for administrators Identify Horizon Cloud upgrade features and benefits Creating Images Outline the process and choices to set up primary VMs Identify the configuration choices for importing primary VMs List steps to install the user software on the primary VM Identify steps to convert a configured primary VM to an assignable image Access Desktops and Applications Use Horizon Client to access desktops and remote applications Compare the remote display protocols that are available for Horizon Cloud Remote Desktop Session Host Farms List the steps and considerations to take when creating an RDSH farm List the actions that can be performed on farms listed on the console?s Farms page List the actions to assign an application to a user or group List the prerequisites and steps to create an RDSH session assignment VDI Desktops Compare a dedicated assignment to floating assignment Outline steps to create a VDI desktop assignment Explain the entitlement of desktops Managing Assignable Images Describe and manage assignable images Describe and Use Image management service for Horizon Cloud Service on Microsoft Azure VMware Dynamic Environment Manager Identify the VMware Dynamic Environment Manager functional areas and their benefits Prepare an infrastructure for VMware Dynamic Environment Manager Outline the steps that are required to install and configure Dynamic Environment Manager components Manage user personalization and application configurations using the Dynamic Environment Manager management console and application profiler App Volumes for Horizon Cloud Service on Microsoft Azure Explain how App Volumes works with Horizon Cloud Service on Microsoft Azure Identify the features and benefits of App Volumes in Horizon Cloud Service on Microsoft Azure Identify the interface elements of App Volumes in Horizon Cloud Service on Microsoft Azure Install and configure App Volumes in Horizon Cloud Service on Microsoft Azure Workspace ONE Access Describe the benefits of integrating VMware Horizon Cloud service with Workspace ONE Access. Describe how a user obtains access to an entitled virtual desktop or application from the Intelligent Hub catalog. Describe the importance of binding directory with Workspace ONE Access and setting up custom user attribute synchronization. Describe the importance of configuring the Remote App Access Client in Workspace ONE Access. Summarize the steps of configuring the Access settings in Horizon Cloud control panel. Access an entitled Horizon virtual desktop or application in the Intelligent Hub catalog. Scalability Considerations Discuss the Horizon Cloud Service on Microsoft Azure scalability cost and settings Describe the usage of Universal Broker in Horizon Cloud Service on Microsoft Azure Horizon Cloud Connector Describe the features and benefits of Horizon Cloud Connector List the prerequisites and requirements to connect a Horizon pod with Horizon Cloud Connector Determine the process of deploying, configuring, and paring Horizon Cloud Connector into your pod?s environment Troubleshooting Horizon Cloud Service on Microsoft Azure Discuss Horizon Cloud Service on Microsoft Azure troubleshooting basics Discuss Horizon Cloud Service troubleshooting basics Summarize the analytics and monitoring capabilities in Horizon Cloud Service on Microsoft Azure
Course Overview The Phlebotomy Diploma offers a comprehensive insight into the skills and knowledge essential for working within healthcare environments that require blood collection. This course provides learners with a thorough understanding of blood circulation, the use of specialist phlebotomy equipment, and the importance of quality control and infection prevention. By studying the stages of venipuncture, dermal puncture techniques, and the handling of complications, learners will develop the theoretical expertise to support clinical teams effectively. Ideal for those pursuing healthcare careers or aiming to strengthen their clinical knowledge, this diploma ensures learners are well-prepared to meet industry standards. Upon completion, students will possess a strong foundation in safe blood collection procedures, patient care considerations, and quality management, equipping them for future professional success in the healthcare sector. Course Description The Phlebotomy Diploma delves into the fundamental principles and practices underpinning blood collection and specimen handling. Learners will explore the human circulatory system, understand the function and composition of blood, and become familiar with the various types of phlebotomy equipment used in clinical settings. Topics include routine and special blood collection procedures, managing complications during venipuncture, infection control measures, and ensuring quality in phlebotomy services. Designed to provide a structured and engaging learning experience, the course supports the development of essential theoretical skills needed to perform safe and accurate blood draws. Learners will gain valuable insights into healthcare regulations, risk management protocols, and best practices for quality assurance. Whether seeking to enhance a healthcare career or build a foundation for further clinical training, participants will finish the course with a deep understanding of modern phlebotomy practices and patient-centred care. Course Modules Module 01: Introduction to Phlebotomy Module 02: Blood Circulation, Function, and Composition Module 03: Phlebotomy Equipment Module 04: Routine Venipuncture Module 05: Venipuncture Complications and Pre-Examination Variables Module 06: Dermal Puncture Module 07: Quality Assessment and Management in Phlebotomy Module 08: Special Blood Collection Procedure Module 09: Infection Control and Risk Management (See full curriculum) Who is this course for? Individuals seeking to pursue a career in healthcare support services. Professionals aiming to enhance their clinical knowledge and expertise. Beginners with an interest in phlebotomy, healthcare, and medical sciences. Career changers looking to enter the healthcare industry. Employers wishing to upskill their staff in healthcare environments. Career Path Phlebotomist Healthcare Assistant Medical Laboratory Assistant Clinical Support Worker Blood Donation Specialist Healthcare Administration Roles (related to specimen handling) Laboratory Technician (entry-level)
Duration 1 Days 6 CPD hours This course is intended for Learners taking this course are interested in employee experiences or Microsoft Viva and want to learn how to assess, plan, strategize, design, and manage digital employee experiences that use Microsoft Viva, Microsoft Teams, SharePoint, and Power Platform. A learner in this role will collaborate with multiple teams to scope, design, and implement new digital employee experiences, such as onboarding, career and skill development, rewards and recognition, employee wellbeing, and employee retention. Learners should have a foundational understanding of Microsoft technologies, including Microsoft 365, Teams, SharePoint, and a deep understanding of Microsoft Viva features and capabilities. They may have experience in one or more of the following disciplines: human resources, people development, change management, information technology, or culture development. Overview By the end of this module, you'll be able to: Evaluate existing systems and identify requirements Identify stakeholders and users Recommend employee experience solutions and strategies Describe the four experience areas of Connection, Growth, Purpose, and Insights supported by Viva. Explain what Microsoft Viva apps are. Identify resources needed to set up each Viva app. Create an adoption plan to use Viva to solve business scenarios for the four employee experience areas of Connection, Insight, Purpose, and Growth. Describe the main features of Viva Connections List technical requirements/prerequisites for Viva Connections implementation Explain the differences between desktop and mobile experiences Identify 2-3 business use cases for Viva Connections Identify key stakeholders for the deployment of Viva Connections Align and prioritize scenarios for Viva Connections Plan and design for the Dashboard, the Feed, and Resources by scenarios and audiences Consider how your organization will scale adoption Assess your organization's existing learning experiences. Plan and strategize for Viva Learning. Coordinate the implementation of Viva Learning. Recommend an adoption strategy for Viva Learning. In this course, you'll learn how to bring people together to create an optimal employee experience that enables your organization to improve productivity, develop empathetic leadership, and transform how employees feel about their work. In your organization today, are people being treated well, or are their needs neglected? Are your teams aligned on goals with a sense of purpose? Are you driving the business outcomes that you need? The Microsoft Viva employee experience platform provides the infrastructure to create the culture of trust, collaboration, well-being, and active listening that you envision. This training course will provide Microsoft Employee Experience Platform Specialists with a comprehensive overview of Microsoft Viva, as well as Microsoft 365, Teams, and SharePoint. It will cover how to identify requirements for designing experiences for employee onboarding, career and skill development, rewards and recognition, compensation and benefits, employee wellbeing, and employee retention. It will also cover how to design solutions to meet these requirements, and how to collaborate with senior executive leadership, human resources, IT, adoption and change management, and learning and organizational development departments. Finally, it will cover how to continuously improve employee experiences based on data-driven insights and feedback. Design digital employee experiences Introduction Case study - Tailwind Traders Evaluate current employee experiences Consider employee privacy and data requirements Assemble business stakeholders and define goals Explore Viva experience areas Understand Viva licensing Knowledge check Summary and resources Introduction to the Microsoft Viva suite Introduction to Microsoft Viva Understand Viva apps Get started with Microsoft Viva Use Viva to keep everyone informed, included, and inspired Use Viva to get actionable insights to foster well-being and productivity Use Viva to align people's work to team and organization goals Use Viva to help employees learn, grow, and succeed Knowledge check Summary Introduction to Viva Connections Introduction What do users experience? When to use Viva Connections? What technical requirements must be met to deploy Viva Connections? Knowledge check Summary Plan for Viva Connections Introduction Build your team and meet requirements Analyze tasks and scenarios for Viva Connections Plan for Viva Connections Dashboard, Feed and Resources Plan to announce, launch, and scale adoption Knowledge check Summary Design skilling and growth experiences with Viva Learning Introduction Case study - Tailwind Traders Plan for Viva Learning Assemble Viva Learning admins and stakeholders Understand content sources with Viva Learning Coordinate setup and configuration of Viva Learning Develop adoption strategies for Viva Learning Develop an org-wide learning culture Knowledge check Summary and resources Additional course details: Nexus Humans MS-080T00: Employee Experience Platform Specialist 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 MS-080T00: Employee Experience Platform Specialist 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.
Overview Understand the role of corporate structure, dividends and equity indices in equity markets. Become familiar with the building blocks of repos / stock lending, futures and forwards – and how to use these products. Understand how to price, and risk manage equity swaps and dividend swaps. Gain experience in their uses in trading, corporate finance and portfolio management. Learn how to price equity options and the features that make them different from other asset classes, explore how to use these products for taking equity risk, yield enhancement and portfolio protection. Understand strategies designed to trade / hedge volatility using options. Who the course is for Risk management Finance Sales and trading Treasury Technology Financial Engineering Course Content To learn more about the day by day course content please click here To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now
Food Allergens & Intolerance in Catering course is for those who want to advance in this field. Throughout this course, you will learn the essential skills and gain the knowledge needed to become well versed in Food Allergens & Intolerance in Catering. Our course starts with the basics of Food Allergens & Intolerance in Catering and gradually progresses towards advanced topics. Therefore, each lesson of this Food Allergens & Intolerance in Catering is intuitive and easy to understand. So, stand out in the job market by completing the Food Allergens & Intolerance in Catering course. Get an accredited certificate and add it to your resume to impress your employers. Along with the Food Allergens & Intolerance in Catering course, you also get: Lifetime Access Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials- Anytime, Anywhere - From Any Smart Device (Laptop, Tablet, Smartphone Etc.) 100% Learning Satisfaction Guarantee Learn at your own pace from the comfort of your home, as the rich learning materials of this course are accessible from any place at any time. The curriculums are divided into tiny bite-sized modules by industry specialists. And you will get answers to all your queries from our experts. So, enrol and excel in your career with Compliance Central. Course contains advanced and latest curriculum study modules: Module 01: Basics of Food Allergens Module 02: Allergen Guidance for Food Businesses Module 03: Allergen Guidance for Consumers Module 04: Allergic Reactions and Treatments Assessment Complete this Food Allergy and Intolerance in Catering course and sit up for a short online assessment to instantly evaluate your understanding of the subject. The test will be an automated one, your answers will be checked and reviewed then and there, and you'll get unlimited chances to retake the exam! CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Food Allergens & Intolerance in Catering course. Requirements To enrol in this Food Allergens & Intolerance in Catering course, all you need is a basic understanding of the English Language and an internet connection. Career path After completing this course, you can explore trendy and in-demand jobs related to Food Allergens & Intolerance in Catering. Certificates Certificate of completion Digital certificate - Included Get a CPD Accredited PDF Certificate for Free. Certificate of completion Hard copy certificate - £9.99 Get a CPD Accredited Hardcopy Certificate for £9.99. The delivery charge for the hardcopy certificate inside the UK is £3.99 and international students need to pay £9.99 to get their hardcopy certificate.
Occupational Therapy Online Course Occupational Therapy Course is the only profession that helps people to participate in the activities of everyday life. The therapy promotes health and well being through occupation. Occupational Therapy Course course covers the techniques you need to know for involving people with various activities and making them independent. Firstly, the course explains the very concept of occupational therapy and shows you the techniques while working with adults and kids. Then, you will know the basic anatomy of physiology such as Blood & the Immune System, Brain injuries, physical disabilities, etc. Next, the course teaches you creative and management skills including the use of creative activities, management and leadership skills, developing confidence and self-esteem and the techniques to deal with depression. Finally, the course covers the career growth and opportunities of occupational therapy and alternative career options. Course Curriculum Introduction to Occupational Therapy (Basic) Anatomy & Physiology Creative & Management Skills Career Growth in Occupational Therapy Individual (Client's) Development (Learn more about this online course)
Nurturing 'Good Employee Relations' in the Workplace Approved Online Training