7487 Courses delivered Online

An online course for understand and implementing climate change and sustainability in textiles education.

You get the Technical Author/technical writing online training course, plus five additional courses You get the Technical Author/technical writing online training course, plus five additional courses. Access to the 15 modules and the related exercises from the Technical Author/technical writing online training course You send your answers to the exercises in the course back to us for review and feedback. You’ll also receive a certificate, once you’ve completed the assessments correctly. Plus access to these online training courses: Managing Software Documentation Projects Revising and Editing Content Single Sourcing and Content Reuse Trends in Technical Communication Creating Screenshots and Images for User Guides Your Instructor Cherryleaf Cherryleaf is a technical writing services company formed in 2002 by people with a passion for technical communication and learning development. Cherryleaf is recognised as a leader within the technical communication profession. Our staff have written articles for the Society for Technical Communication's (STC) Intercom magazine, the Institute of Scientific and Technical Communicator's Communicator journal and tekom's TCWorld magazine. They've also written books on technical communication. We've presented webinars for Adobe, Madcap Software or the STC, and we've spoken at various conferences around the world. Today, organisations throughout Europe use Cherryleaf’s services so they can provide clear information that enables users and staff to complete tasks productively. Course Curriculum Technical Author/Technical Writing Course The purpose of technical documentation (7:50) The different models for technical documentation (9:33) What is a technical author? (20:55) Adopting a user-centred design approach (14:46) Overview of the writing process (11:13) Planning your content (13:16) Researching the product and audience (16:50) The Information Design stage (22:50) Software tools (10:50) Writing the topics – Overview (23:42) Writing the topics – How to write and present different types of information (13:48) Writing the topics – Using images and videos (10:48) Writing the topics – Index, Search and Metadata (18:01) Hyperlinking (5:51) Reviewing and editing (14:00) End of course (5:19) Single Sourcing and Content Reuse Start Read Me First Introduction (1:19) Definitions (10:29) Why Single Source? (11:28) When Single Sourcing Might be a Bad Idea (1:48) General Approach (7:04) Writing for Reuse (15:44) Structured Writing (1:53) Planning (8:43) Publishing (4:50) Tools (16:20) Summary (2:06) Managing Software Documentation Projects What is Technical Documentation? (19:50) Making the Business Case for Technical Documentation (14:39) Estimating Time Budgets for Documentation Projects (24:06) Technical Documentation Standards (7:30) Metrics in Technical Documentation (27:44) Developing User Documentation in an Agile Environment (13:02) Courses Included with Purchase Creating Screenshots and Images for User Guides CourseEfficient ways to create professional-looking diagrams, images and screenshots Cherryleaf£125 Frequently Asked Questions When does the course start and finish? The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.How long do I have access to the course?How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.What if I am unhappy with the course?We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

Course Overview This comprehensive First Aid at Work course is designed to equip learners with the knowledge needed to effectively manage health-related emergencies in professional settings. Covering a wide range of workplace incidents, it explores the role of appointed persons, emergency protocols, and how to respond to common injuries and illnesses. Learners will develop confidence in managing both physical and mental health-related situations at work, including remote support and procedures adapted for the COVID-19 era. Whether you are an employee, manager, or business owner, this course provides essential guidance that aligns with UK regulations and first aid expectations in modern work environments. By the end of the course, learners will be familiar with key emergency response procedures and legal requirements, contributing to a safer and more responsible workplace culture. Course Description The First Aid at Work course offers in-depth learning across a structured series of modules that cover everything from primary and secondary assessments to CPR, AED usage, and mental health support. It examines various types of injuries and illnesses such as fractures, dislocations, breathing problems, and minor workplace injuries. The course also discusses the legal framework for first aid at work, risk assessments, and the importance of mental health awareness. Additionally, it addresses recent considerations such as pandemic-specific protocols and remote psychological support. Learners will gain theoretical insight into emergency handling, including when and how to contact emergency services. With up-to-date content aligned with UK standards, this course is ideal for those looking to support a health-conscious and safety-oriented work environment. Course Modules: Module 01: Introduction to Workplace First Aid Module 02: Appointed Persons in the Workplace First Aid Module 03: Incident Management at Work Module 04: Classifications and Abbreviations Module 05: Emergency Management Module 06: Primary Survey Module 07: Secondary Survey Module 08: Basic First-Aid Techniques Module 09: AED Module 10: Minor Injuries at Workplace Module 11: Loss of Responsiveness and CPR Module 12: Breathing Problems Module 13: Secondary Illnesses and Injuries Module 14: Fractures and Dislocations Module 15: Call for an Emergency Module 16: Things to Keep in Mind for A First Aider Module 17: Legal Framework for Workplace First Aid Module 18: Mental Health First Aid in the Workplace Module 19: First Aid during Coronavirus Pandemic Module 20: First Aid Qualifications During the Pandemic, Risk at Work and PPE Regulations Module 21: Remote Psychological First Aid (See full curriculum) Who is this course for? Individuals seeking to understand workplace first aid responsibilities. Professionals aiming to support health and safety compliance in the workplace. Beginners with an interest in health and safety protocols. Managers, HR personnel, or safety officers seeking foundational knowledge in first aid. Career Path Workplace Health & Safety Officer HR and Compliance Manager Office Administrator with Safety Responsibilities Site or Facility Supervisor Community Support Worker Mental Health Support Facilitator Risk Management and Corporate Safety Advisor

Slips, trips, and accidental spills might sound harmless—until they’re not. The Health & Safety Level 3 - QLS Endorsed Course is built for those who take responsibility seriously and want to create safer working environments without turning every task into a hazard drill. This course walks you through essential health and safety laws, risk assessments, fire safety, and everything else that keeps workplaces ticking without unwanted surprises. Whether you're overseeing a construction site or a quiet office, this training helps keep things steady, safe, and sensible. You don’t need to carry a clipboard or wear a high-vis vest to benefit. This course is fully online, jargon-free, and made for those who want to do the job properly. It suits supervisors, managers, or anyone stepping into roles that involve looking after others. With workplace safety incidents costing UK businesses over £18 billion a year, this isn't just a good idea—it’s good business. So, if you're looking to understand the risks, protect your team, and keep the wheels turning smoothly, this course ticks the right boxes (without saying so). Health & Safety Level 3 QLS Bundle Includes the following Courses Course 01: Diploma in Health & Safety at QLS Level 3 Course 02: Health and Safety in Construction Environment Key Features of Health & Safety Level 3 Eligibility for QLS endorsed certificate upon successful completion of the Health & Safety Level 3 course Free CPD Accredited Course Fully online, interactive Health & Safety Level 3 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 Health & Safety Level 3training 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 Health & Safety Level 3 course, we will provide assignment and quizzes. For each test, the pass mark will be set to 60%. Accreditation This Health & Safety Level 3 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 Health & Safety Level 3 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 Health & Safety Level 3 course, learners will be able to order an endorsed certificate, titled: [Diploma in Health & Safety 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 Health & Safety Level 3 basics. Requirements No prior degree or experience is required to enrol in this Health & Safety Level 3 course. Career path This Health & Safety Level 3 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.

Course Overview: Are you ready to unlock the world of digital possibilities by understanding the art and science of data analytics? We live in an era where data back every decision and every action requires insightful analysis. Clive Humby said, "Data is the new oil, and it's the new oil, so it's an invaluable resource for companies worldwide. This comprehensive course covers a broad spectrum of data analytics, starting with an engaging 'Introduction to the World of Data,' before delving into the fundamental components like the 'Basics of Data Analytics,' 'Statistics for Data Analytics,' and the 'Actions Taken in the Data Analysis Process.' Each subsequent module is carefully designed to guide you through various stages of data analytics. You'll explore 'Data Mining,' work with 'Excel for Data Analytics,' and discover 'Tools for Data Analytics.' The curriculum wraps up with a focus on 'Data-Analytic Thinking' and 'Data Visualisation.' Enrol today and start your journey to becoming a data analytics expert! Key Features of the Course: This course comes with a CPD certificate, affirming your proficiency in data analytics. It offers 24/7 learning assistance to ensure you get the most out of your learning journey. The content is presented in easy-to-understand and engaging learning materials, carefully curated to make your journey in data analytics enlightening. Who is This Course For? This course suits professionals seeking to leverage data analytics in their respective fields, individuals aspiring to venture into the data science arena, and students keen to acquire contemporary skills for the digital age. What You Will Learn: Understand the fundamental concepts of data analytics. Apply statistical techniques to analyse large data sets. Implement effective strategies for data collection and storage. Master the art of data mining and extraction of valuable insights. Utilise Excel and other tools effectively for data analysis. Develop a data-analytic mindset for problem-solving. Translate data insights into compelling visualisations. Why Enrol in This Course: This course will open doors to many opportunities. You will learn from top-notch professionals, utilise quality learning materials and have access to trending and recently updated curriculum. Requirements: A basic understanding of computers A willingness to learn Career Path: The expertise gained from this Data Analytics course can pave your way into a variety of professions, such as: Data Analyst (£30,000-£60,000) Business Analyst (£35,000-£70,000) Market Research Analyst (£27,000-£55,000) Operations Analyst (£31,000-£62,000) Quantitative Analyst (£45,000-£85,000) Data Scientist (£50,000-£90,000) Data Engineer (£35,000-£75,000) Certification: On successful completion of this course, you will receive a CPD certificate, testifying your mastery in the field of data analytics. With this recognition, you can confidently showcase your skills and expertise in the professional world. Data analytics is a powerful tool that can be used to make better decisions, improve efficiency, and drive innovation. If you want to join this growing field, this course is for you! FAQ What do you mean by data analytics? Data analytics is the process of collecting, cleaning, analyzing, and interpreting data to extract insights. What data analytics actually do? Data analytics helps businesses make better decisions by providing them with insights into their data. This can include insights into customer behavior, market trends, and product performance. What are the 5 data analytics? The 5 data analytics are: Descriptive analytics: This type of analytics describes what has happened in the past. Diagnostic analytics: This type of analytics identifies the root cause of problems. Predictive analytics: This type of analytics predicts what will happen in the future. Prescriptive analytics: This type of analytics recommends actions to take based on the predictions. Visual analytics: This type of analytics uses visual representations of data to make it easier to understand. What is data analytics examples? Here are some examples of data analytics: A retailer uses data analytics to track customer behaviour and identify trends. A bank uses data analytics to predict which customers are likely to default on their loans. A healthcare provider uses data analytics to identify patients who are at risk for certain diseases. What are 4 types of analytics? The 4 types of analytics are: Descriptive analytics: This type of analytics describes what has happened in the past. Diagnostic analytics: This type of analytics identifies the root cause of problems. Predictive analytics: This type of analytics predicts what will happen in the future. Prescriptive analytics: This type of analytics recommends actions to take based on the predictions. Why do we use data analytics? We use data analytics to make better decisions, improve efficiency, and drive innovation. Here are some of the benefits of using data analytics: Better decision-making: Data analytics can help businesses make better decisions by providing them with insights into their data. Improved efficiency: Data analytics can help businesses improve efficiency by identifying areas where they can save time and money. Driven innovation: Data analytics can help businesses drive innovation by identifying new opportunities and trends. Course Curriculum 13 sections • 13 lectures • 12:25:00 total length •Introduction to the World of Data: 01:00:00 •Basics of Data Analytics: 00:40:00 •Statistics for Data Analytics: 01:00:00 •Actions Taken in the Data Analysis Process: 00:55:00 •Gathering the Right Information: 01:00:00 •Storing Data: 01:15:00 •Data Mining: 01:00:00 •Excel for Data Analytics: 01:20:00 •Tools for Data Analytics: 01:20:00 •Data-Analytic Thinking: 01:10:00 •Data Visualisation That Clearly Describes Insights: 00:45:00 •Data Visualization Tools: 01:00:00 •Assignment - Data Analytics: 00:00:00

Course Overview: Transform your health and the well-being of others through the power of knowledge with our "Complete Training on Holistic Health and Nutrition" course. This course will teach you everything you need to know about holistic nutrition, from the basics of macronutrients and micronutrients to the effects of food on your digestion, metabolism, mood, and energy levels. You will also learn how to apply holistic nutrition principles to various scenarios, such as muscle growth, fat loss, thyroid health, liver detoxification, and more. You will also have access to exciting learning materials, such as videos, quizzes, assignments, and case studies, to help reinforce your learning and test your understanding. By the end of this course, you will have a solid foundation in holistic nutrition and be able to use it to enhance your health and well-being and help others achieve their wellness goals. Enrol today and start your journey to a healthier and more fulfilling life! Key Features of the Course: Our health and nutrition course has a Certified Professional Development (CPD) certificate and offers 24/7 learning assistance. Engaging and interactive learning materials, regularly updated content, and support from nutrition experts are just a few of the additional perks you will enjoy during your learning journey with us. Who is This Course For? The Complete Training on Holistic Health and Nutrition course is ideal for anyone seeking a deep understanding of holistic nutrition, whether you are a fitness enthusiast, a health-conscious individual, or aspiring to a career in nutrition. No prior knowledge is required, just an interest in nutrition and a desire to improve health and well-being. What You Will Learn: Understand the principles and importance of holistic nutrition Debunk common myths and avoid typical beginner mistakes in nutrition Identify the role and significance of macro and micronutrients in maintaining optimal health Understand the role of specific nutrients, such as protein, carbohydrates, and fats in health and nutrition Gain knowledge about potential nutritional deficiencies and how to address them Plan and establish effective meal plans for muscle growth and fat loss Understand the science behind digestion and nutrient absorption Why Enrol in This Course: This top-rated, recently updated course provides theoretical knowledge and applicable wisdom to help you integrate healthy dietary practices into everyday life. By enrolling in this course, you will develop a broad set of skills, including critical thinking, meal planning, and understanding the body's nutritional needs. Requirements: This Complete Training on Holistic Health and Nutrition course has no specific prerequisites; it is open to everyone interested in holistic health and nutrition. Career Path: After successful completion of the Complete Training on Holistic Health and Nutrition course, learners can explore various career opportunities, such as: Nutritionist (£23,000 - £45,000), Health Coach (£25,000 - £50,000), Dietitian (£26,000 - £41,000), Fitness Instructor (£14,000 - £30,000), Wellness Consultant (£20,000 - £42,000), Health Writer (£20,000 - £39,000), and Food Scientist (£21,000 - £55,000) in the UK. Certification: Learners will be awarded a CPD certificate upon successfully completing the course. This certification will prove your holistic health and nutrition expertise, enhancing your professional credibility and employability. Course Curriculum 9 sections • 44 lectures • 04:32:00 total length •Introduction & What You Will Learn: 00:03:00 •What is Holistic Nutrition: 00:03:00 •How Nutrition Can Improve Your Health: 00:05:00 •Common Myths About Holistic Nutrition: 00:05:00 •Most Common Beginner Mistakes You Must Avoid: 00:06:00 •Holistic Nutrition Priorities Introduction: 00:02:00 •The 5 Nutrition Priorities Explained: 00:05:00 •Calories in a Holistic Diet: 00:04:00 •Nutrients Overview: 00:02:00 •Macronutrients Explained: 00:02:00 •Protein Explained: Its Role in Health & Nutrition: 00:03:00 •Amino Acids Explained: 00:13:00 •How Much Protein Should You Consume?: 00:03:00 •Fat Explained: Its Role in Health & Nutrition: 00:03:00 •How Much Fat Should You Consume?: 00:02:00 •Carbohydrates Explained: Their Role in Health & Nutrition: 00:03:00 •How Many Carbs Should You Consume?: 00:02:00 •Micronutrients Overview: 00:02:00 •In-Depth Micronutrients: 00:01:00 •Why Micronutrients are More Important Than Macronutrients: 00:10:00 •Antioxidants, Oxidative Stress & Free Radicals Explained: 00:09:00 •Iron Toxicity - Why Your Low Blood Iron is Not a Deficiency: 00:08:00 •Copper toxicity: 00:11:00 •Adrenal Fatigue: 00:09:00 •This Is The Best Protocol to Strengthen Adrenals & Heal Adrenal Fatigue: 00:12:00 •Ceruloplasmin Explained & How To Increase It: 00:11:00 •Foods Overview: 00:01:00 •What Makes Food Healthy: 00:06:00 •The Healthiest Protein Sources: 00:04:00 •The Healthiest Carbohydrate Sources: 00:03:00 •The Healthiest Fat Sources: 00:05:00 •Dirty Dozen & Clean 15 Explained: 00:04:00 •Meal Timing Overview: 00:01:00 •Meal Timing Explained: 00:07:00 •Section Overview: 00:01:00 •How To Set Up A Muscle Growth Meal Plan: 00:29:00 •How To Set Up A Fat Loss Meal Plan: 00:28:00 •Anatomy Overview: 00:01:00 •Digestion And Nutrient Absorption Explained: 00:09:00 •How to Increase Stomach acid naturally: 00:07:00 •Liver Detoxification Explained: 00:08:00 •Nutritional Psychiatry Explained: 00:12:00 •Thyroid Health: 00:07:00 •Resources - Complete Training on Holistic Health and Nutrition: 00:00:00

Course Overview: Embark on a transformative journey to real estate with our esteemed Diploma in Real Estate. This comprehensive course empowers individuals like you with the knowledge and skills necessary to thrive in the dynamic property market. Delve into the intricacies of real estate investing, property management, and the legal frameworks that govern the industry.This comprehensive course spans a broad range of topics, from 'What Is Real Estate Investing?' and 'Basic Rental Properties' to 'Investment Purchase Procedure' and 'Property Management.' Furthermore, it provides an in-depth exploration of the UK legal system and investment structures, ensuring that learners are well-equipped to navigate the complexities of the real estate market.Enrol now in the Diploma in Real Estate course and take the first step towards building a thriving career in the dynamic world of real estate investing. Key Features of the Course: Comprehensive curriculum covering essential topics such as property investment, customer service, and marketing strategies. Flexible learning schedule with 24/7 access to course materials and resources. Dedicated learning assistance is available round the clock to address your queries and provide guidance. Who is This Course For? This Diploma in Real Estate is ideal for individuals passionate about real estate and seeking to embark on a successful career in the industry. Whether you are a recent graduate, an aspiring entrepreneur, or a seasoned professional looking to diversify your skill set, this course will provide you with the necessary knowledge and expertise to excel in real estate. What You Will Learn: Firstly, you will explore effective property investment strategies that will enable you to identify lucrative opportunities and make informed investment decisions. You will learn how to evaluate market trends, assess property values, and analyse risk factors to maximise investment returns.Customer service is a crucial aspect of the real estate industry, and this course will equip you with the best practices to ensure client satisfaction. You will learn how to communicate effectively with clients, manage their expectations, and provide exceptional service throughout the buying, selling, and renting processes. Understanding the legal frameworks is vital for any real estate professional, and this course will provide you with the necessary knowledge of the legal system and regulations regarding property transactions. You will learn about different types of investment structures, commercial leases, title and registration processes, and critical legislations that govern the industry. Furthermore, you will delve into real estate marketing strategies that will help you attract potential buyers and tenants. From digital marketing techniques to effective property showcasing, you will learn how to create compelling marketing campaigns that generate interest and drive sales. Why Enrol in This Course: This Diploma in Real Estate has recently been updated to incorporate industry trends and best practices, ensuring you gain the most up-to-date knowledge. Moreover, the course focuses on providing necessary skills that can be applied in real-world scenarios, allowing you to excel in the field of property investment and management. Requirements: There are no specific prerequisites for this course. However, a basic understanding of business concepts and an interest in real estate will benefit optimal learning. Career Path: Upon completing this course, you will get edges in various rewarding career paths within the real estate industry. Some sought-after professions include Property Manager, Real Estate Agent, Investment Analyst, Property Developer, Leasing Consultant, Mortgage Advisor, and Property Valuer. Salaries in these roles range from £25,000 to £60,000+ per annum, depending on experience and location. Certification: Upon completing the Diploma in Real Estate, you will receive a CPD certificate, further validating your expertise and enhancing your professional prospects in the real estate sector. Course Curriculum 5 sections • 48 lectures • 18:00:00 total length •What Is Real Estate Investing?: 00:30:00 •Basic Rental Properties: 00:30:00 •Why invest in property?: 00:30:00 •Investment After Brexit: 00:15:00 •Recent Housing Market Developments: 00:15:00 •Managing Client Expectation: 00:15:00 •Best Practices of Customer Service: 00:15:00 •Customer Life Cycle: 00:15:00 •Tenant Retention: 00:30:00 •Real Estate Marketing: 00:30:00 •An Introduction to the UK legal system: 00:15:00 •Different Types of Investment Structures: 00:15:00 •Commercial Leases: 00:15:00 •Title & Registration: 00:15:00 •Finance in Real Estate: 00:15:00 •Investment Purchase Procedure: 00:15:00 •Acquisition Costs: 00:15:00 •Land Usage: 00:15:00 •Planning & Environment: 00:15:00 •Investment Structure & Key Legislations: 00:15:00 •What is Property Development?: 00:15:00 •The Players in the Property Market: 00:30:00 •The Risks of Property Development: 00:15:00 •The Stages of a Property Development: 00:30:00 •Site Identification and Acquisition: 00:15:00 •Property Management: 00:30:00 •Selecting The Best Properties: 00:30:00 •Leasing Instead Of Selling: 00:30:00 •Buyers Interest: 00:15:00 •Be Zone Conscious: 01:00:00 •Home Loans: 00:15:00 •Knowing When You're Ready To Buy: 00:15:00 •Is Your Lake Home For Sale?: 01:00:00 •Living The Waterfront Lifestyle Every Day: 00:15:00 •How To Locate Waterfront Property Rentals: 00:15:00 •Real Estate Front: 00:15:00 •How To Maintain Waterfront Property: 00:30:00 •All About Real Estate Clients: 00:15:00 •Real Estate Evaluation: 00:15:00 •Are You Ready To Buy Your First Property?: 00:30:00 •Finding The Actual Real Estate For Sale: 01:00:00 •Home Shopping: The Smart Way: 00:30:00 •How Much Land Do You Need?: 00:15:00 •Real Estate Investments: 01:00:00 •Manufacturing Real Estate Numbers: 00:15:00 •Waterfront Real Estate: 00:15:00 •Purchasing A Home Beside A Lake: 00:15:00 •Fundamentals of Real Estate Development: 00:00:00

Course Overview: Imagine the power of interacting with databases, organising vast information, and extracting valuable insights - all at your fingertips. This might seem like a formidable task, but SQL, or Structured Query Language, brings this within reach. It is one of the most in-demand skills in the tech industry, with a projected 10% job growth rate over the next decade. Our course, The Complete SQL from Scratch: Bootcamp, provides a thorough understanding of SQL, irrespective of your prior familiarity with it. This comprehensive course walks you through the journey from the fundamentals of databases to the intricate functionalities of SQL. The curriculum includes detailed discussions on database creation, table manipulation, SQL statements, and utilisation of various operators. Moreover, it also covers essential operations like data backup and restoration, thus preparing learners for real-life database management scenarios. The course design ensures a smooth transition from one concept to another, enabling learners to solidify their understanding at each step. Enrol today and start learning SQL! Key Features of the Course: CPD certificate: Upon completion of the course, you'll receive a CPD certificate that you can use to demonstrate your skills to employers. 24/7 Learning Assistance: Our team of experts is available 24/7 to answer your questions and help you progress through the course. Interesting learning materials: The course is packed with engaging videos, interactive exercises, and quizzes to help you learn SQL in a fun and effective way. Who is This Course For? The Complete SQL from Scratch: Bootcamp course is suitable for anyone interested in diving into the world of databases or enhancing their skills further. Beginners with no prior knowledge and professionals seeking an in-depth understanding of SQL would equally benefit from the course. What You Will Learn: Through The Complete SQL from Scratch: Bootcamp , you will learn: An in-depth understanding of databases and their functions. Familiarity with PostgreSQL installation and various connections. Proficiency in manipulating data including insert, update, delete operations. A comprehensive grasp of complex SQL commands and queries. Skills to design and alter table structures using SQL scripts. Advanced knowledge about SQL statements, their structure, and usage. Competence in data backup and restoration in databases. Why Enrol in This Course: The Complete SQL from Scratch: Bootcamp course is reviewed as a top choice among learners, and is recently updated to match the trending industry needs. By enrolling, you will acquire a set of skills that are crucial in today's data-centric world, enhancing your employability and competitive edge. Requirements: No prior experience is required A computer with internet access Career Path: Database Administrator (average UK salary £47,000) Data Analyst (£40,000), Business Analyst (£43,000) SQL Developer (£45,000) Database Engineer (£48,000) Systems Analyst (£41,000) Data Architect (£62,000). Certification: After successfully completing the course, you will receive a CPD certificate, signifying your expertise in SQL. This course is your stepping stone to becoming a proficient database professional. Enrol and Lets get started! Course Curriculum 12 sections • 56 lectures • 06:39:00 total length •Introduction: 00:04:00 •Course Curriculum overview: 00:04:00 •Overview of Databases: 00:08:00 •PostgreSQL Installation: 00:13:00 •Connecting to PostgreSQL using psql: 00:04:00 •Connecting to PostgreSQL using PgAdmin: 00:07:00 •Basic of Database and Tables: 00:06:00 •Data Types: 00:07:00 •Primary Keys and Foreign Keys: 00:04:00 •Create Table in SQL Script: 00:17:00 •Insert: 00:05:00 •Update: 00:05:00 •Delete: 00:03:00 •Alter Table: 00:05:00 •Drop Table: 00:02:00 •Check Constraint: 00:12:00 •NOT NULL Constraint: 00:04:00 •UNIQUE Constraint: 00:06:00 •Overview of Challenges: 00:04:00 •SQL Statement Basic: 00:07:00 •SELECT Statement: 00:12:00 •SELECT DISTINCT: 00:10:00 •Column AS Statement: 00:07:00 •COUNT: 00:07:00 •SELECT WHERE Clause - One: 00:06:00 •SELECT WHERE Clause - Two: 00:11:00 •ORDER: 00:05:00 •LIMIT: 00:04:00 •BETWEEN keyword usage on real time: 00:08:00 •IN Operator: 00:06:00 •LIKE and ILIKE: 00:10:00 •Overview of GROUP BY: 00:03:00 •Aggregation Function: 00:12:00 •GROUP BY - One: 00:05:00 •GROUP BY - Two: 00:06:00 •HAVING on SQL Statement: 00:04:00 •Overview of JOINS: 00:07:00 •Introduction to JOINS: 00:06:00 •AS Statement table: 00:05:00 •INNER Joins: 00:14:00 •Full Outer Joins: 00:04:00 •Left Outer join: 00:03:00 •Right Outer Join: 00:05:00 •Union: 00:05:00 •Basic of Advanced SQL Commands: 00:04:00 •Timestamps: 00:17:00 •Extract from Timestamp: 00:05:00 •Mathematical Functions: 00:06:00 •String Functions: 00:16:00 •SubQuery: 00:08:00 •Overview of Databases and Tables: 00:02:00 •Creating a Database backup: 00:03:00 •Restoring a Database from backup: 00:04:00 •Overview Assessment Test: 00:02:00 •Mock Exam - The Complete SQL from Scratch: Bootcamp: 00:20:00 •Final Exam - The Complete SQL from Scratch: Bootcamp: 00:20:00

Introduction: Terminating employment is an unfortunate part of any manager's job. While you may strive to only recruit the best staff, the reality is that not everyone is a good fit for your company or its needs. After you go through disciplinary measures and put staff through coaching, there is a point where you simply need to move on. This is a very difficult task job, one that many managers actively avoid, which can put a strain on the rest of the office. Learning about the legal and practical aspects of employee termination can help make the process easier. This course goes into detail about each aspect of employee termination. It begins by giving you a brief overview of the legal aspects that you need to keep in mind, when considering termination of employment. Next, it covers the financial implications of dismissing an employee, helping you understand the costs involved. The level of involvement that your human resources department should have is also discussed in detail. Finally, we review the more practical aspects of termination of employment, giving you the tools that you need, in order to have that conversation.   You will Learn: The reasons for fair dismissal Information regarding required notice periods, including statutory and contractual ones The steps that your human resources department needs to take, before you can terminate employment Why there is paperwork required, and what you should prepare before your meeting How to tell a staff member that they have been dismissed Who should be with you in that meeting Benefits of taking this Course: Understanding the difference between fair and unfair dismissal Learning what constructive dismissal is, so you can avoid it, where possible Understanding why you may wish to offer dismissed employees extra pay or extended benefits When you should contact security, in order to escort a dismissed employee off the premises How to inform the remaining staff of the change in personnel Course Modules: Module 01: General Information and the Law Module 02: Financial Implications of Termination of Employment Module 03: Human Resources Aspects of Termination of Employment Module 04: Practical Aspects of Termination of Employment

Give a compliment to your career and take it to the next level. This Team Leader bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Team Leader bundle will help you stay ahead of the pack. Throughout the Team Leader programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Team Leader course, you will get 10 premium courses, an originalhardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Team Leader Bundle Consists of the following Premium courses: Course 01: Leadership & Management Diploma Course 02: Team Building Masterclass Course 03: Equality and Diversity Course 04: Diploma in Lean Leadership and Change Management Course 05: Leadership and Management Training Course Course 06: Leadership Skills for The Future Course 07: Effective Listening Skills for Leaders Course 08: Coaching Leaders for Success Course 09: Cross-Cultural Awareness Training Course 10: Effective Communication Skills Diploma Course 11: Motivation Skills Enrol now in Team Leader to advance your career, and use the premium study materials from Apex Learning. The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Team Leader expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Team Leader bundle. Requirements This Team Leader course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Leadership & Management Diploma) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.