• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

34721 Courses delivered On Demand

Emotional Intelligence and Human Behaviour

4.9(27)

By Apex Learning

Course Overview: In today's dynamic world, where interpersonal skills play a vital role in personal and professional success, the demand for individuals with expertise in emotional intelligence and human behaviour is skyrocketing. According to recent studies, job openings in counselling and related fields are projected to grow by 24% over the next decade, highlighting the immense opportunities that await those with a solid understanding of human behaviour and emotional intelligence. The Counselling Course on Emotional Intelligence and Human Behaviour will equip you with the knowledge and skills to thrive in this high-demand field. Whether you aspire to become a counsellor, human resources professional, life coach, or simply seek personal growth and development, this course offers a transformative learning experience that will broaden your understanding of the intricate complexities of human behaviour. Join now and discover the keys to fostering meaningful connections, managing emotions effectively, and thriving in a rapidly evolving world. Key Features of the Course: CPD Certification: Upon successfully completing this course, you will receive a Continuing Professional Development (CPD) certificate, recognised and valued by employers worldwide. 24/7 Learning Assistance: Our dedicated support team is available round-the-clock to assist you with any queries or challenges you may encounter during your learning journey. You can rest assured that you'll never be alone on this transformative educational path. Who is This Course For? This course is ideally suited for individuals from various backgrounds and professions who wish to enhance their understanding of human behaviour and develop essential emotional intelligence skills. This course will provide you with the tools and insights necessary to navigate the intricacies of human interaction. What You Will Learn: Throughout the Counselling Course on Emotional Intelligence and Human Behaviour, you will gain a deep understanding of the evolutionary influences that shape human behaviour and their implications in modern society. Besides, explore the concept of intelligence, including its various forms, while examining intelligence tests and variations in individual intelligence. Examine how individuals acquire new knowledge, skills, and behaviours through different learning and conditioning processes. Also, you will discover the crucial role of language in human communication and learn effective strategies for fostering meaningful connections. Explore the multifaceted nature of emotions and their impact on cognition and decision-making processes. Gain insights into the causes and effects of stress, anger, and conflict, and learn useful techniques for managing and resolving these emotional states. Moreover, develop a deep understanding of emotional intelligence and its significance in building healthy relationships, enhancing personal well-being, and achieving success. Additionally, discover the principles of self-leadership and the powerful techniques of Neuro-Linguistic Programming (NLP) to empower yourself and others for positive change. Why Enrol in This Course: Enrolling in the Counselling Course on Emotional Intelligence and Human Behaviour offers top-rated content, regular updates, high job demand, personal growth opportunities, and relevance in trending industries. Join today! Requirements: No prior experience or specific qualifications are required to enrol in this course. The content is presented in a clear and accessible manner, making it suitable for beginners and professionals alike. Career Path: Upon completing this course, you will possess valuable skills that can open doors to various rewarding careers. Some potential professions include: Counsellor (£30,000 - £45,000 per annum) Human Resources Professional (£35,000 - £60,000 per annum) Life Coach (£25,000 - £50,000 per annum) Therapist (£25,000 - £45,000 per annum) Social Worker (£25,000 - £40,000 per annum) Teacher (£24,000 - £40,000 per annum) Relationship Coach (£30,000 - £50,000 per annum) Certification: Upon completing the Counselling Course on Emotional Intelligence and Human Behaviour, you will be awarded a CPD certificate, recognised as a testament to your commitment to professional development and your acquired skills in this specialised field. Course Curriculum 13 sections • 13 lectures • 04:50:00 total length •Human Behaviour and Basic Psychological Process: 00:23:00 •Evolutionary Perspective of Human Behaviour: 00:25:00 •Human Intelligence: 00:24:00 •Intelligence Test and Variations in Intelligence: 00:22:00 •Learning and Conditioning: 00:23:00 •Language and Communication: 00:29:00 •Introduction to Emotion: 00:16:00 •Emotion Influences Cognition: 00:21:00 •Stress, Anger and Conflict: 00:42:00 •Emotional Intelligence: 00:25:00 •Self-Leadership: 00:16:00 •Neuro-Linguistic Programming (NLP): 00:24:00 •Order your Certificate: 00:00:00

Emotional Intelligence and Human Behaviour
Delivered Online On Demand4 hours 50 minutes
£12

British Cleaning Level 5 Diploma

4.9(27)

By Apex Learning

Course Overview: Did you know that the cleaning industry is one of the fastest-growing sectors in the UK? In fact, the cleaning and janitorial services market is projected to reach a value of £50 billion by 2025. Our British Cleaning Level 5 Diploma course, is designed to equip you with the essential knowledge and skills to excel in this thriving field. With a comprehensive curriculum covering a wide range of cleaning areas, this course provides a solid foundation to understand the intricacies of different cleaning jobs. From house cleaning to commercial kitchen maintenance, from office cleaning to dealing with non-routine waste, you'll gain expertise in diverse aspects of the cleaning profession. Additionally, you'll learn essential business management skills to start your cleaning business or enhance your existing one. So, embark on a rewarding career in the thriving cleaning industry by enrolling in our British Cleaning Level 5 Diploma course today. Key Features of the Course: Receive a CPD certificate upon successful completion Benefit from 24/7 learning assistance for continuous support and guidance Who is This Course For? This British Cleaning Level 5 Diploma is ideal for individuals interested in pursuing a career in the cleaning industry or those already working in the field who wish to upgrade their skills and knowledge. Whether a beginner or an experienced professional, this course will provide valuable insights and techniques to enhance your abilities and advance your career. What You Will Learn: This comprehensive British Cleaning Level 5 Diploma will give you the essential expertise to excel in the dynamic cleaning industry. Explore modules covering many critical areas, from mastering efficient house cleaning techniques to maintaining hygienic kitchens and bathrooms. Gain insights into office cleaning, handling non-routine waste, and ensuring a safe work environment. Learn valuable skills for starting and running a successful cleaning business, including effective planning, customer satisfaction strategies, staff management, and marketing. By embracing this transformative learning experience, you'll acquire the skills and knowledge sought after in the industry, whether starting your career or looking to enhance your expertise. This course equips you with a solid foundation in the cleaning industry and valuable skills to succeed. Discover the importance of the industry across sectors, master house cleaning techniques, and ensure cleanliness in kitchens and bathrooms. Explore office cleaning, waste management, and safety protocols. Gain business skills for starting and growing a cleaning business, such as planning, customer satisfaction, staff management, and marketing. This comprehensive course empowers you to thrive in the competitive cleaning industry, whether starting or advancing your career. Why Enrol in This Course: Enrolling in our British Cleaning Level 5 Diploma course offers several compelling benefits. Firstly, this course has received top reviews from past learners, proving its quality and effectiveness. Additionally, the course has been recently updated to align with the latest industry standards and trends. Requirements: This course has no specific prerequisites, making it accessible to anyone interested in the cleaning industry. Career Path: Upon completing this British Cleaning Level 5 Diploma, you will be well prepared for various exciting career paths in the cleaning industry. Some of the course-related professions and their average UK salaries include: Cleaning Supervisor - £21,000 to £30,000 per year Facilities Manager - £30,000 to £45,000 per year Housekeeping Manager - £20,000 to £35,000 per year Office Cleaner - £15,000 to £20,000 per year Kitchen Steward - £16,000 to £24,000 per year Commercial Cleaner - £16,000 to £22,000 per year Cleaning Business Owner - Salary varies based on the success of your business Certification: Upon completing the British Cleaning Level 5 Diploma, you will receive a CPD (Continuing Professional Development) certificate, recognised globally and providing evidence of your achievement and commitment to professional growth. Course Curriculum 18 sections • 18 lectures • 06:06:00 total length •An Introduction to the Cleaning Job: 00:19:00 •The Diversity of Cleaning Jobs: 00:26:00 •Cleaning Equipment, Products and Clothing: 00:24:00 •House Cleaning: 00:22:00 •Food Kitchen and Commercial Kitchen Cleaning: 00:23:00 •Bathrooms and Toilets: 00:22:00 •Office Cleaning: 00:19:00 •Cleaning External Surfaces and Areas: 00:18:00 •Dealing with Non-Routine Waste: 00:21:00 •Chemical Safety, Keyholding and Alarm Codes for Cleaners: 00:21:00 •Starting a Cleaning Business and Planning for it: 00:14:00 •Running the Business with Quality Service: 00:22:00 •Customer Satisfaction: 00:23:00 •Management of Staff: 00:22:00 •Marketing, Advertising and Sales: 00:24:00 •Expansion Management: 00:17:00 •Business Insurance, Tax and Additional Equipment: 00:24:00 •Assignment - British Cleaning Diploma: 00:05:00

British Cleaning Level 5 Diploma
Delivered Online On Demand6 hours 6 minutes
£12

Level 3 Diploma in Nursing Assistant Complete Training

4.9(27)

By Apex Learning

Course Overview: Unlock Your Potential in Nursing Assistance! The very first requirement in a hospital is that it should do the sick no harm.' The Level 3 Diploma in Nursing Assistant Complete Training ensures just that. With meticulously structured modules, this comprehensive course illuminates the vital role nursing assistants play in patient care, ensuring they uphold the highest standards in all aspects of their work.Besides, it covers a broad spectrum of essential nursing knowledge, from exploring varied healthcare settings to an in-depth study of legal, ethical, and professional standards over two extensive modules. Communication's pivotal role, maintaining health and hygiene, infection control, and understanding the profound importance of the immune system in nursing are all meticulously addressed.Enrol today and take the first step towards a promising future in nursing with the Level 3 Diploma in Nursing Assistant Complete Training. ⭐ Key Features of the Course: ⭐ CPD Certificate: Upon completing the Level 3 Diploma in Nursing Assistant Complete Training, you will receive a prestigious Continuing Professional Development (CPD) certificate, internationally recognised for its quality and value. 24/7 Learning Assistance: Our dedicated support team is available round-the-clock to provide you with guidance, clarify doubts, and offer valuable insights, ensuring that you have an enriching and seamless learning experience. 👥 Who is this Course For? 👥 This course is ideal for individuals eager to kickstart a career in nursing assistance. Whether you're a fresh graduate exploring various career paths or an experienced healthcare professional looking to enhance your skills, this diploma program will equip you with the knowledge required to excel in the field of nursing assistance. 📚 What You Will Learn 📚 Throughout this course, you will delve into a wide range of comprehensive modules that cover all aspects of nursing assistance. Here's a brief overview of the course topics: In Module 1, you'll be introduced to the fundamentals of being a nursing assistant, laying a strong foundation for your future learning journey. Modules 2, 3 and 4 focus on exploring different healthcare settings and understanding ethical practice's legal, standards, and professional aspects. Effective communication is vital in healthcare, and Module 5 will equip you with the skills to communicate effectively with patients, their families, and other healthcare professionals. Subsequent modules will delve into crucial topics such as health and safety, infection control, medication administration, pain management, nutrition, and much more. Each module is designed to enhance your knowledge and practical abilities, ensuring you become a competent nursing assistant. Why Enrol in This Course: 1️⃣ Top Reviewed Course: Our Level 3 Diploma in Nursing Assistant Complete Training has received outstanding reviews from past learners, with many expressing their satisfaction with the course's in-depth content and practical relevance. 2️⃣ Recently Updated: This course has been meticulously updated to reflect the latest advancements and best practices in nursing assistance, ensuring you receive the most up-to-date knowledge and skills. 3️⃣ In-demand Skills: By completing this course, you will develop essential skills highly sought after in the healthcare industry. Employers value professionals with a strong foundation in nursing assistance and can contribute effectively to patient care. Requirements: Enrolling in the Level 3 Diploma in Nursing Assistant Complete Training requires a passion for helping others and a commitment to learning. No prior experience or educational background is required, making this course accessible to individuals from diverse backgrounds. Career Path: Upon completing this diploma program, you'll have edges in many careers in the healthcare sector. Some of the professions you can pursue include: Nursing Assistant - Average UK Salary: £22,000 Care Assistant - Average UK Salary: £18,000 Healthcare Support Worker - Average UK Salary: £20,000 Elderly Care Assistant - Average UK Salary: £19,500 Home Care Assistant - Average UK Salary: £18,500 Palliative Care Assistant - Average UK Salary: £21,500 Hospital Ward Assistant - Average UK Salary: £20,500 Certification: Upon completing the Level 3 Diploma in Nursing Assistant Complete Training, you will be awarded a CPD certificate. This prestigious certification will validate your newfound skills and knowledge, enhancing your professional credibility in the healthcare industry. Course Curriculum 3 sections • 20 lectures • 09:23:00 total length •Module 1: Introduction to Nursing Assistant: 00:15:00 •Module 2: Working in Different Healthcare Settings: 00:15:00 •Module 3: Legal, Standards and Professional Aspects of Ethical Practice: Part - 1: 00:50:00 •Module 4: Legal, Standards and Professional Aspects of Ethical Practice: Part - 2: 00:48:00 •Module 5: Effective Communication in Nursing: 00:47:00 •Module 6: Health and Safety in Nursing: 00:47:00 •Module 7: Hygiene in Nursing: 00:30:00 •Module 8: Infection Control: 00:57:00 •Module 9: Asepsis in Nursing: 00:16:00 •Module 10: Medication Administration in Nursing: 00:18:00 •Module 11: Understanding the Immune System in Nursing: 00:26:00 •Module 12: Rest and Sleep Management in Nursing: 00:17:00 •Module 13: Mobility and Immobility Issues of Patients in Nursing: 00:15:00 •Module 14: Pain Management for Nurses: 00:22:00 •Module 15: Nutrition in Nursing: 00:23:00 •Module 16: Fluid and Electrolyte Balance: 00:21:00 •Module 17: Assisting with Elimination: 00:28:00 •Module 18: Oxygenation in Nursing: 00:28:00 •Mock Exam - Level 3 Diploma in Nursing Assistant Complete Training: 00:20:00 •Final Exam - Level 3 Diploma in Nursing Assistant Complete Training: 00:20:00

Level 3 Diploma in Nursing Assistant Complete Training
Delivered Online On Demand9 hours 23 minutes
£12

Quality Tools and Problem Solving Methods

4.9(27)

By Apex Learning

Course Overview: This comprehensive course on Quality Tools and Problem Solving Methods will deepen your understanding on this topic.After successful completion of this course, you can acquire the required skills in this sector. This Quality Tools and Problem Solving Methods comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.So enrol in this course today to fast-track your career ladder. Key Features of the Course: CPD certificate upon completion 24/7 learning assistance for continuous support Engaging and interactive learning materials A comprehensive curriculum covering various aspects of Quality Tools and Problem Solving Methods Learn at your own pace, anywhere and anytime Who is This Course For? This Quality Tools and Problem-Solving Methods course is designed for anyone interested in quality management, interested problem solvers, engineers, and anybody looking to expand their knowledge of quality assurance procedures. Whether you're new to quality control or have some experience, this course will provide you with the knowledge and skills you need to succeed in your sector. What You Will Learn: This Quality Tools and Problem Solving Methods course covers: the key principles of quality management and problem solving techniques. Techniques for effective data collection and analysis using check sheets. Brainstorming methods for innovative idea generation. Creation and interpretation of cause & effect diagrams for problem identification. Application of Pareto diagrams and histograms in data analysis. Process improvement and analysis using flowcharts and control charts. Implementing problem-solving methodologies like the A3 process and 8D. Why Enrol in This Course: Enrolling in Basic Automotive Engineering: Onboard Diagnostics will provide you with several benefits. Firstly, it is a top-reviewed course that has recently been updated to align with the latest advancements in automotive technology. By staying up-to-date, you'll gain a competitive edge in the job market and increase your chances of securing exciting career opportunities. Requirements: To enrol in the Quality Tools and Problem Solving Methods course, you typically need: Basic knowledge of quality management concepts. Interest in learning advanced problem-solving techniques. Educational or professional background in business or engineering (recommended but not mandatory). Basic computer and internet skills are needed for accessing course materials. Proficiency in the course language, usually English. Completion of any specific registration or application process set by the course provider. Career Path: Upon completing Quality Tools and Problem Solving Methods , you can explore various exciting career paths. Here are five course-related professions, along with their average UK salaries: Quality Manager (£40,000-£80,000 per year) Process Improvement Analyst (£30,000-£60,000 per year) Manufacturing Engineer (£35,000-£70,000 per year) Continuous Improvement Specialist (£35,000-£65,000 per year) Quality Assurance Engineer (£30,000-£55,000 per year) Certification: Upon completing the Quality Tools and Problem Solving Methods course, you'll receive a CPD certificate widely recognised in various industries. This certificate will elevate your professional standing and open up new career prospects. Enrol today to excel in problem-solving and quality management, joining a global community of learners on this transformative journey. Course Curriculum 21 sections • 44 lectures • 03:14:00 total length •About the instructor: 00:01:00 •Summary of the course: 00:01:00 •Checksheet-1: 00:01:00 •CCIN practice final v2: 00:06:00 •The brainstroming: 00:01:00 •Brainstorming ip: 00:06:00 •The cause and effect diagram: 00:01:00 •CE in practice: 00:08:00 •Tool The Histogram-1: 00:01:00 •The histogram in practice: 00:10:00 •Pareto diagram: 00:01:00 •Pareto in practice final: 00:09:00 •Control Chart-1: 00:01:00 •Control chart in practice part 1: 00:11:00 •Control chart in practice part 2: 00:10:00 •Scatter Plot-1: 00:01:00 •Scatterplot In practice: 00:07:00 •Flowchart in practice: 00:10:00 •Flowchart-1: 00:01:00 •Psp Overview: 00:01:00 •The PSP: 00:04:00 •The PSP in detail: 00:08:00 •The A3: 00:01:00 •A3 sheet: 00:04:00 •The A3 in practice: 00:15:00 •The 8D: 00:01:00 •The 8D in practice: 00:12:00 •The 8D sheet final: 00:04:00 •The PDCA: 00:01:00 •5 Why: 00:01:00 •Six Sigma: 00:01:00 •More about six sigma: 00:05:00 •Shainin system: 00:06:00 •Shainin Method: 00:01:00 •Overview of the section: 00:01:00 •The Preventive Tools: 00:01:00 •The Fmea: 00:01:00 •The FMEA in practice: 00:12:00 •The FMEA process: 00:14:00 •Control plan in practice: 00:07:00 •The Control Plan: 00:01:00 •Final Conclusion: 00:01:00 •QMS: 00:04:00 •Resources - Quality Tools and Problem Solving Methods: 00:00:00

Quality Tools and Problem Solving Methods
Delivered Online On Demand3 hours 14 minutes
£12

Microsoft Excel Course for Everyone - Complete Excel Course

4.9(27)

By Apex Learning

Overview This Microsoft Excel Course for Everyone - Complete Excel Course is your passport to spreadsheet mastery.Explore Excel in detail and improve your abilities with practical activities that go beyond boring lectures. Take on spreadsheets like an expert, from data entry to difficult formulas and eye-catching graphics. But the magic doesn't end there! After finishing successfully, you'll not only impress with your proficiency with Excel, but you'll also obtain a respected CPD certification to enhance your CV and make a statement in the job market. Consider it your golden ticket to go up in your job!Enrol right away to see how your confidence and chances rise! Don't wait! How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Microsoft Excel Course for Everyone - Complete Excel Course. It is available to all students, of all academic backgrounds. Requirements Compatible with a wide range of gadgets, including smartphones, tablets, laptops, Macs, and PCs. Particularly designed to be easily accessed with an internet connection on tablets and smartphones. No strict deadlines; learn whenever it's convenient for you. Individuals with basic English proficiency. Career Path After completing this course, it will increase the value of your CV and open you up to multiple sectors, such as : Data Analyst: £25,000 - £50,000 per year Financial Analyst: £30,000 - £60,000 per year Operations Manager: £35,000 - £70,000 per year Accountant: £25,000 - £50,000 per year Business Intelligence Analyst: £35,000 - £65,000 per year These salary ranges can vary based on factors such as experience, location, and the specific industry of the business. Course Curriculum 15 sections • 80 lectures • 06:51:00 total length •Introduction: 00:03:00 •Course Curriculum: 00:04:00 •Getting started on Windows, macOS, Android, and IOS: 00:01:00 •How to ask great questions: 00:02:00 •FAQ's: 00:01:00 •Starting Excel: 00:04:00 •Introduction: 00:02:00 •Worksheet basics: 00:22:00 •Entering values and formulas: 00:12:00 •Data formats: 00:10:00 •Data handling basics - cut copy and paste: 00:07:00 •Save and print in excel: 00:10:00 •Excel Ranges: 00:05:00 •Introduction: 00:01:00 •Basic formula operations: 00:06:00 •Mathematical functions level 1: 00:20:00 •Mathematical functions level 2: 00:12:00 •Text functions level 1: 00:09:00 •Text functions level 2: 00:13:00 •Logical functions: 00:11:00 •Date time functions: 00:06:00 •V Lookup formula: 00:12:00 •HLookup formula: 00:04:00 •HLookup + Match formula: 00:09:00 •Match + Index formula: 00:05:00 •Introduction: 00:02:00 •XLookup: 00:08:00 •Handling #NA and Approximates match in XLookup: 00:11:00 •Wildcard matching in XLookup: 00:06:00 •Introduction: 00:02:00 •Split text into columns: 00:07:00 •Flash Fill: 00:07:00 •Remove Duplicates: 00:08:00 •Data Validation: 00:07:00 •Get- import Data from Text: 00:06:00 •Get - import Data from CSV: 00:03:00 •Introduction: 00:01:00 •Formatting Font: 00:04:00 •Formatting Alignment: 00:06:00 •Formatting Number: 00:05:00 •Formatting Date: 00:03:00 •Formatting tables: 00:05:00 •Introduction: 00:01:00 •Creating Pivot Table: 00:07:00 •Value field settings: 00:04:00 •Number format: 00:02:00 •Pivot Table Design: 00:03:00 •Excel Exercise: 00:01:00 •Solution for Excel Exercise: 00:02:00 •Introduction: 00:01:00 •Excel Charts - Categories: 00:03:00 •Elements of a chart: 00:04:00 •Easy way to create charts: 00:02:00 •Column or Bar charts: 00:04:00 •Formatting charts: 00:04:00 •Line charts: 00:02:00 •Area charts: 00:02:00 •Pie and Doughnut charts: 00:04:00 •Format AreaPlot or XY chart: 00:08:00 •Scatter or bubble charts: 00:02:00 •Introduction: 00:01:00 •Frequency Distribution and Histograms: 00:04:00 •Waterfall charts: 00:02:00 •Hierarchy charts: sunburst and tree map: 00:03:00 •Combination charts: 00:02:00 •Sparklines: 00:05:00 •Pivot charts: 00:02:00 •Maps chart: 00:04:00 •3D Maps chart: 00:03:00 •Introduction: 00:01:00 •Stock charts: 00:02:00 •Radar charts: 00:02:00 •Surface charts: 00:02:00 •Heat maps: 00:04:00 •Named ranges: 00:05:00 •Indirect Name range Function: 00:06:00 •Import Data table from PDF file - Excel 2021: 00:04:00 •Import Data from Website - Excel 2019 above: 00:09:00 •Project: Sales forecast tracker: 00:07:00 •Product Sale Tax invoice: Tax Calculations: 00:05:00

Microsoft Excel Course for Everyone - Complete Excel Course
Delivered Online On Demand6 hours 51 minutes
£12

Physiotherapy, Sports Massage and Reflexology Complete Bundle

4.9(27)

By Apex Learning

🌟 Course Overview 🌟 Unlock your potential and embark on a rewarding career in the field of physiotherapy, sports massage, and reflexology with our comprehensive Counselling Course - Physiotherapy, Sports Massage and Reflexology Complete Bundle. This all-inclusive program is designed to provide you with a deep understanding of the human body, effective therapeutic techniques, and the necessary skills to excel in these specialised fields. Did you know that the demand for physiotherapists, sports massage therapists, and reflexologists is rising? According to recent statistics, the UK healthcare industry is projected to experience a staggering 10% growth by 2028. This presents a significant opportunity for individuals seeking a stable and fulfilling career path. As renowned author John F. Kennedy once said, "Physical fitness is not only one of the most important keys to a healthy body, but also the basis of dynamic and creative intellectual activity." With our Counselling Course, you will become an integral part of this dynamic industry, helping individuals overcome physical challenges and achieve optimal well-being. 💡 Key Features of the Course 💡 CPD Certification: Upon successful completion, you will receive a Continuing Professional Development (CPD) certificate, recognised and respected by employers and professional bodies. 24/7 Learning Assistance: Our dedicated support team is available round the clock to provide guidance and assistance, ensuring you have a seamless learning experience. 🎯 Who is This Course For? 🎯 This Physiotherapy, Sports Massage and Reflexology Complete Bundle is ideal for aspiring physiotherapists, sports massage therapists, and reflexologists eager to acquire the fundamental knowledge and valuable skills required for success in these fields. Whether you are a newcomer or an experienced professional looking to enhance your expertise, this course will provide you with a solid foundation to thrive in the industry. 📚 What Will You Learn? 📚 You will gain a holistic understanding of physiotherapy, sports massage, and reflexology through a comprehensive range of modules. Here's a glimpse of what you will explore: In the Physiotherapy section, you will delve into topics such as the history of physiotherapy, skeletal muscle structure, neuromuscular system, injury prevention, sports physiotherapy, and more. You will learn essential techniques, treatment methods, and even specialised approaches for musculoskeletal conditions and Motor Neuron Disease (MND) patients. The Sports Massage segment will equip you with in-depth knowledge of anatomy, injury phases, athlete history assessment, treatment modification, and various specific treatments. You will understand the crucial role of sports massage in enhancing performance, preventing injuries, and aiding in recovery. Finally, in the Reflexology portion, you will explore the principles and techniques of this ancient practice. From understanding the human foot map to conducting reflexology treatments, you will develop the skills needed to provide holistic care and promote relaxation and well-being. 🌟 Why Enrol in This Course? 🌟 Enrolling in our Physiotherapy, Sports Massage and Reflexology Complete Bundle- Physiotherapy, Sports Massage, and Reflexology Complete Bundle Diploma offers numerous benefits: Top Reviewed Course: This course has received rave reviews from previous learners, who have praised its comprehensive content and applicable relevance. Recently Updated Material: The course content has been carefully curated and updated to ensure you receive the most relevant and up-to-date information in the field. Trending Career Opportunities: By completing this course, you will open doors to exciting and lucrative career opportunities in physiotherapy clinics, sports organisations, wellness centres, and even as a self-employed professional. 🔑 Requirements 🔑 To embark on this journey, you only need a passion for helping others and a willingness to learn. No prior experience or qualifications are necessary, making this course accessible to anyone with a keen interest in these fields. 🚀 Career Path 🚀 Upon completion of this comprehensive physiotherapy, Sports Massage and Reflexology Complete Bundle, you will be well-equipped to pursue various career paths, including: Physiotherapist (£26,000 - £48,000 per annum) Sports Massage Therapist (£18,000 - £35,000 per annum) Reflexologist (£20,000 - £30,000 per annum) Physiotherapy Support Worker (£17,000 - £23,000 per annum) Wellness Centre Practitioner (£20,000 - £40,000 per annum) Fitness Instructor (£15,000 - £30,000 per annum) Rehabilitation Specialist (£25,000 - £45,000 per annum) 🎓 Certification 🎓 Upon successful completion of the Physiotherapy, Sports Massage and Reflexology Complete Bundle - Physiotherapy, Sports Massage, and Reflexology Complete Bundle Diploma, you will receive a CPD certificate. This widely recognised certification will validate your newly acquired skills and knowledge, enhancing your professional credibility in the industry. Course Curriculum 4 sections • 35 lectures • 16:32:00 total length •What is Physiotherapy?: 00:30:00 •What do Physiotherapists do?: 00:15:00 •History of Physiotherapy: 00:15:00 •Skeletal Muscle Structure: 00:15:00 •Neuromuscular System: 00:15:00 •Injury Prevention: 00:15:00 •What is Sports Physiotherapy?: 00:15:00 •Osteoporosis: 00:15:00 •Back Pain & Critical Care: 00:15:00 •Aquatherapy & Hydrotherapy: 00:15:00 •Different Therapy Techniques: 00:30:00 •Treatment Method: 01:00:00 •Physiotherapy For MND Patient: 00:30:00 •Musculoskeletal Physiotherapy (MSK): 00:15:00 •TENS Machines: 00:30:00 •What is Therapeutic Ultrasound?: 00:15:00 •Becoming a Physiotherapist: 00:15:00 •Recommended Reading : Physiotherapy Support Worker Training: 00:00:00 •Introduction to Sports Massage: 01:00:00 •Working as Sports Massage: 00:30:00 •Understanding Anatomy: 00:30:00 •Phases of Injury: 00:30:00 •Athlete History: 01:00:00 •Treatment Modification: 01:00:00 •Specific Treatments: 00:15:00 •Further Education: 00:15:00 •Introduction to Reflexology: 00:15:00 •Historical Roots: 01:00:00 •benefits of reflexology: 00:02:00 •Theories & Effect of Reflexology: 01:00:00 •Foot Reflexology: 01:00:00 •Reflexology Techniques: 00:30:00 •Reflexology Aftercare: 00:15:00 •Hand Reflexology: 00:30:00 •Special Reflexology Treatments: 01:00:00

Physiotherapy, Sports Massage and Reflexology Complete Bundle
Delivered Online On Demand16 hours 32 minutes
£12

Advanced Diploma in Quickbooks Online Bookkeeping

4.9(27)

By Apex Learning

Course Overview: The demand for bookkeepers is growing rapidly, with a projected 10% increase in job openings by 2029. As businesses of all sizes increasingly rely on cloud-based accounting software, the need for skilled QuickBooks Online bookkeepers is becoming even more critical. The Advanced Diploma in QuickBooks Online Bookkeeping course is perfect if you want to take your bookkeeping career to the next level. With the Advanced Diploma in QuickBooks Online Bookkeeping, you can gain the expertise to effectively manage financial transactions, streamline processes, and make informed decisions. This comprehensive course will equip you with the necessary skills and knowledge to excel in online bookkeeping. Enrol in the Advanced Diploma in QuickBooks Online Bookkeeping today and start your journey to a successful career in bookkeeping! Key Features of the Course: CPD Certification: You will receive a prestigious CPD certificate upon successful completion. 24/7 Learning Assistance: Our expert support team is available round the clock to provide guidance and resolve any queries you may have during your learning journey. Engaging Learning Materials: Enjoy a range of multimedia resources, including interactive quizzes, video tutorials, and downloadable study materials, making your learning experience dynamic and captivating. Who is This Course For? This Advanced Diploma in Quickbooks Online Bookkeeping is tailored for aspiring bookkeepers, finance professionals, small business owners, and individuals seeking to enhance their bookkeeping skills. No prior experience is required, making it accessible to beginners and professionals. What You Will Learn: In the first set of modules, you will familiarise yourself with the fundamental aspects of setting up a new company file, entering opening balances, and managing accruals and prepayments. As you progress, you will explore advanced features such as reporting journals, nominal ledger amendments, and generating comprehensive reports listing nominal ledgers. Furthermore, the Advanced Diploma in Quickbooks Online Bookkeeping course will equip you with the skills to handle customer and supplier data effectively. You will learn to enter customer and supplier information, manage invoices and credit notes, and generate reports on customer activity and aged debtors. Understanding the intricacies of managing these vital aspects will enable you to maintain healthy customer relationships and efficiently manage supplier transactions. Additionally, you will delve into crucial areas such as reconciling bank accounts, processing petty cash transactions, managing cash payments, and conducting VAT returns. These modules will equip you with the tools and knowledge necessary to ensure accurate financial records, effective payment processing, and adherence to tax obligations. Why Enrol in This Course: By enrolling in the Advanced Diploma in QuickBooks Online Bookkeeping, you are investing in your future success. Here's why this course stands out: Top Reviewed Course: Our course has received rave reviews from learners, praising its realistic approach and relevance to real-world scenarios. Recently Updated: The course content is regularly reviewed and updated to align with the latest industry standards and best practices. Trending Skill: QuickBooks Online Bookkeeping is in high demand, making this course a valuable asset to boost your employability and career prospects. Requirements: No specific prerequisites are necessary to join this Advanced Diploma in Quickbooks Online Bookkeeping course. A basic understanding of financial concepts and computer literacy will be advantageous but not essential. Career Path: Upon completing this Advanced Diploma in Quickbooks Online Bookkeeping course, you'll have the skills and knowledge for various lucrative career paths in the financial sector. Bookkeeper - £25,000 to £35,000 per annum Accounting Assistant - £18,000 to £25,000 per annum Finance Administrator - £20,000 to £30,000 per annum Payroll Officer - £25,000 to £35,000 per annum Accounts Payable Clerk - £18,000 to £25,000 per annum Accounts Receivable Clerk - £18,000 to £25,000 per annum Financial Controller - £45,000 to £75,000 per annum Certification: Upon completing the Advanced Diploma in Quickbooks Online Bookkeeping course, you will receive a CPD certificate, validating your achievement and demonstrating your expertise in QuickBooks Online Bookkeeping. This certification will significantly enhance your professional profile and open doors to exciting career opportunities. Enrol in the Advanced Diploma in QuickBooks Online Bookkeeping today and embark on a transformative journey to financial excellence!" Course Curriculum 17 sections • 43 lectures • 03:30:00 total length •The structure of the course - first things first!: 00:05:00 •Set up free trial: 00:03:00 •Starting A New Company File: 00:11:00 •Enter opening balances: 00:02:00 •Reverse opening balances - accruals and prepayments: 00:06:00 •Report Journal: 00:05:00 •Amend The Nominal Ledger: 00:07:00 •Report listing the nominal ledgers: 00:02:00 •Enter customers: 00:09:00 •Report on customer contact information: 00:01:00 •Enter Suppliers: 00:05:00 •Supplier Contact List: 00:02:00 •Enter Invoices: 00:09:00 •Invoice Entering: 00:03:00 •Invoice batch: 00:06:00 •Post Sales Credit Notes: 00:08:00 •Report showing Customer Activity: 00:03:00 •Aged Debtors: 00:02:00 •Post Supplier Invoices: 00:03:00 •Entering a Batch of Supplier Bills: 00:09:00 •Credit Notes Suppliers: 00:05:00 •Reclassify Supplier Bills - Flash Bulbs Purchased: 00:04:00 •Supplier Account Activity Report: 00:04:00 •Post Cheques: 00:07:00 •Reports showing supplier payments : 00:01:00 •Receipts from customers: 00:07:00 •Report showing customer receipts: 00:02:00 •Post Petty Cash Transactions and Report: 00:04:00 •Post cash payments to ledgers: 00:02:00 •Enter petty cash items: 00:14:00 •Report on Petty Cash Payments Proper: 00:05:00 •Post Sundry Payments: 00:05:00 •Report Bank Payments: 00:03:00 •VAT Return: 00:03:00 •Reconcile The Bank: 00:10:00 •Provide A Report Showing Any Unreconnciled Transaction: 00:02:00 •Post the Wages Journal: 00:08:00 •Posting Journal Adjustments: 00:02:00 •Month end adjustments: 00:03:00 •Month end reports: 00:06:00 •Task- Crearing the accounts: 00:06:00 •Task - Customer report: 00:01:00 •Assignment - Advanced Diploma in Quickbooks Online Bookkeeping: 00:05:00

Advanced Diploma in Quickbooks Online Bookkeeping
Delivered Online On Demand3 hours 30 minutes
£12

ISO 9001:2015 QMS Clauses Awareness

4.9(27)

By Apex Learning

Our ISO 9001:2015 QMS Clauses Awareness course is a comprehensive program covering all ten clauses of the standard.

ISO 9001:2015 QMS Clauses Awareness
Delivered Online On Demand3 hours 57 minutes
£12

Ultimate Geology Course

4.9(27)

By Apex Learning

Course Overview: Geology, the study of Earth's structure, history, and processes, is a field of immense significance and awe-inspiring discoveries. If you're seeking a comprehensive understanding of our planet's fascinating geologic features and want to explore the secrets hidden beneath its surface, the Ultimate Geology Course is your pathway to mastery. With an extensive curriculum meticulously designed by experts in the field, this course will take you on an enlightening journey through the captivating realms of geology. Geology is not just an academic pursuit; it's a subject that holds immense practical importance. According to recent data, the demand for skilled geologists is rising, with a projected job growth of 14% in the next decade. By delving into the Ultimate Geology Course, you will equip yourself with the knowledge and skills necessary to unlock a world of opportunities in various industries. Key Features of the Course: CPD certificate 24/7 Learning Assistance Interesting learning materials Who is This Course For? The Ultimate Geology Course is ideal for aspiring geologists, students, professionals seeking a career change, or anyone interested in understanding the Earth's dynamic processes. No prior knowledge or experience in geology is required, making this course accessible to beginners and enthusiasts alike. What You Will Learn: In this Ultimate Geology Course course, you will embark on an incredible journey through many aspects of geology. From the solar system's formation to the geological processes shaping our landscapes, you will gain a comprehensive understanding of the Earth's internal structure, plate tectonics, erosion, sedimentation, volcanoes, and much more. After studying the scientific method and the principles of relative and numerical dating, you will unlock the secrets of Earth's vast history, exploring the evolution of life through fossils and the geologic time scale. Moreover, you will gain valuable skills in mineral identification, rock classification, and geological mapping, empowering you to analyse and interpret Earth's complex features. Why Enrol in This Course: Geology is a highly sought-after field, and by acquiring comprehensive knowledge in this domain, you will enhance employability and open doors to diverse career paths. This Ultimate Geology Course has garnered rave reviews worldwide. Benefit from our instructors' collective wisdom and expertise, ensuring an enriching learning experience. The course content is regularly updated to incorporate the latest advancements and discoveries in geology. Requirements: There are no specific prerequisites to enrol in the Ultimate Geology Course. A passion for understanding the Earth's mysteries and a curious mindset are all you need to embark on this transformative learning journey. Career Path: Completing the Ultimate Geology Course is helpful for many exciting career opportunities. Here are seven course-related professions, along with their average annual salaries in the UK: Geologist - £45,000 Environmental Consultant - £35,000 Geotechnical Engineer - £40,000 Hydrologist - £42,000 Mining Engineer - £50,000 Palaeontology - £38,000 Volcanologist - £47,000 Certification: Upon completing the Ultimate Geology Course, you will receive a CPD certificate, recognised and respected globally. This certificate will validate your newfound expertise in geology and enhance your professional credibility in the field. Course Curriculum 17 sections • 80 lectures • 09:35:00 total length •Course Promo: 00:03:00 •Geology: 00:02:00 •Importance: 00:04:00 •Development: 00:09:00 •The Scientific Method: 00:05:00 •Solar System - OverView: 00:06:00 •The Sun: 00:07:00 •The Moon: 00:06:00 •Terrestrial Planets: 00:10:00 •Jovian Planets: 00:12:00 •Other Solar Bodies: 00:05:00 •Geologic Time - OverView: 00:02:00 •Relative Dating: 00:11:00 •Numerical Dating: 00:07:00 •Fossils: 00:11:00 •The Geologic Time Scale: 00:05:00 •Earth's Internal Structure: 00:11:00 •Exploration: 00:16:00 •Continental Drift: 00:10:00 •Modern Evidence: 00:11:00 •Earth's Major Plates: 00:13:00 •Motion Drivers: 00:05:00 •Motion Measurement: 00:04:00 •Continental Margins: 00:05:00 •Ocean Floor Features: 00:05:00 •Oceanic Crust Layers: 00:02:00 •Destruction of Oceanic Crust: 00:02:00 •Features of Subduction Zones: 00:03:00 •Mountains: 00:07:00 •Topography: 00:07:00 •Weathering - OverView: 00:04:00 •Mechanical Weathering: 00:08:00 •Chemical Weathering: 00:07:00 •Spheroidal Weathering: 00:02:00 •Soil: 00:11:00 •Deserts: 00:08:00 •Wind Erosion: 00:05:00 •Wind as a Transporter: 00:05:00 •Wind Deposits: 00:08:00 •Atom: 00:06:00 •Periodic Table: 00:05:00 •Bond-s: 00:07:00 •Minerals: 00:03:00 •Formation: 00:03:00 •Mineral Identification: 00:09:00 •Crystalline Habits: 00:35:00 •Sedimentary Rocks - OverView: 00:04:00 •Detrital Sedimentary Rocks: 00:03:00 •Grain History: 00:07:00 •Chemical Sedimentary Rocks: 00:04:00 •Coal: 00:06:00 •Sedimentary Rocks Identification Table: 00:05:00 •Sediments to Sedimentary Rocks: 00:05:00 •Sedimentary Structures: 00:06:00 •Metamorphism: 00:08:00 •Metamorphic Rocks: 00:04:00 •Metamorphic Drivers: 00:06:00 •Metamorphic Texture: 00:08:00 •Magma: 00:12:00 •Igneous Texture: 00:09:00 •Deformation: 00:09:00 •Deformation Stages: 00:08:00 •Folds: 00:08:00 •Faults & Joints: 00:14:00 •Volcanoes - OverView: 00:04:00 •Volcanic Eruptions: 00:07:00 •Extruded Material: 00:14:00 •Volcanic Landforms: 00:09:00 •Volcanic Hazards: 00:08:00 •Mass Wasting - OverView: 00:05:00 •Types: 00:07:00 •Triggers: 00:04:00 •Surface Water - Overview: 00:05:00 •Hydrologic Cycle: 00:08:00 •Running Water: 00:12:00 •Flow: 00:08:00 •Channels: 00:10:00 •Depositional Landforms: 00:07:00 •Floods: 00:09:00 •Resource - Ultimate Geology Course: 00:00:00

Ultimate Geology Course
Delivered Online On Demand9 hours 35 minutes
£12

SQL Programming Masterclass

4.9(27)

By Apex Learning

Course Overview: Are you ready to embark on a journey into SQL Programming? Unlock the power of data manipulation and database management with the SQL Programming Masterclass. This comprehensive course is meticulously designed throughout this masterclass to provide you with an in-depth understanding of SQL, starting from the basics and progressing to advanced topics. You will explore SQL data types, filtering and sorting data, working with functions, handle NULL values, and even diving into complex SQL concepts like joins, unions, etc. With a course duration of carefully crafted lessons, this Masterclass ensures you grasp SQL's nuances and develop the proficiency to apply these skills effectively.By the end of the SQL Programming Masterclass, you will be prepared to navigate the world of databases confidently. Enrol in this course today and start your journey! Key Features of the Course: CPD certificate upon completion 24/7 learning assistance and support Who is This Course For? This course is perfect for individuals seeking to enhance their data management and analysis skills. Whether you're a data analyst, database administrator, software developer, or professional looking to upskill, this course will empower you to harness the power of SQL programming. Prior programming experience is not mandatory, making it accessible to beginners and intermediate learners. What You Will Learn: Foundations of SQL programming: Learn the basics of SQL, database management systems, and the tools used in this course, such as PostgreSQL and SQLectron. Data manipulation: Master the art of extracting, filtering, and sorting data based on specific requirements using various SQL keywords and operators. Advanced querying techniques: Dive deeper into SQL programming by exploring functions, grouping and aggregating data, and using advanced query techniques. Data conversion and manipulation: Discover how to convert data types, concatenate strings, manipulate characters and numbers, and utilise case statements for more sophisticated queries. Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Data modification: Learn how to insert, update, and delete records in a database, as well as manage table structures and constraints.Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Views and schemas: Explore the concepts of views and schemas, and learn how to create and use them to organise and present data effectively. Why Enrol in This Course: Top-reviewed course: Join thousands of satisfied learners who have praised this course for its clear explanations, comprehensive content, and examples. Recently updated curriculum: Benefit from the most up-to-date information and industry best practices in SQL programming. In-demand skills: SQL programming is a highly sought-after skill in today's job market, opening up numerous career opportunities across industries. Requirements: No prior programming experience is required. All you need is a computer with an internet connection and a willingness to learn. Career Path: Upon completing the SQL Programming Masterclass, you'll have the knowledge and skills for various career paths, including: Data Analyst - Average UK salary: £35,000 per year Database Administrator - Average UK salary: £40,000 per year Business Intelligence Analyst - Average UK salary: £45,000 per year SQL Developer - Average UK salary: £40,000 per year Data Engineer - Average UK salary: £55,000 per year Software Developer - Average UK salary: £45,000 per year Data Scientist - Average UK salary: £60,000 per year Certification: Upon completing the Hygiene and Infection Control CPD Level 4 course, you will receive a CPD certificate. It demonstrates your commitment to maintaining the highest standards of hygiene and infection control. Course Curriculum 17 sections • 117 lectures • 10:47:00 total length •Introduction: 00:01:00 •Tools Used in This Course: 00:01:00 •Download PostgreSQL: 00:02:00 •Install PostgreSQL: 00:03:00 •Download SQLectron: 00:02:00 •Install SQLectron: 00:01:00 •Connect to PostgreSQL - Credentials: 00:01:00 •Connect to PostgreSQL Using SQLectron: 00:02:00 •Import Course Data Using SQLectron: 00:02:00 •FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data: 00:08:00 •Check Imported Data: 00:06:00 •What is a Database?: 00:01:00 •SQL Data Types: 00:02:00 •Finally Some Fun! Extracting Data Based on Requirements: 00:01:00 •Filtering Data using WHERE Keyword: 00:08:00 •Filter Data by Range Using BETWEEN: 00:03:00 •Filter Data by Set of Values Using IN: 00:03:00 •Filter Data by Date: 00:05:00 •More Filtering by Date: 00:03:00 •Another Query Filtering by Date: 00:01:00 •Filter Data by Strings: 00:04:00 •More Filtering by Strings: 00:05:00 •More Filtering by Strings 2: 00:10:00 •More Filtering by Strings 3: 00:02:00 •How to Ignore Caps when Filtering by String: 00:04:00 •AND Operator: 00:10:00 •OR Operator: 00:12:00 •NOT Operator: 00:09:00 •AND, OR & NOT Operators: Which Has the Highest Priority?: 00:06:00 •Basic Math Operations: 00:06:00 •Modulo Operator: 00:04:00 •Calculate The Net Salary for Employees: 00:06:00 •Filter Data with Math Equations: 00:03:00 •Concatenate Strings with '||' Operator: 00:06:00 •Concatenate Strings with Numbers: 00:02:00 •Give Your Report Fields A Cool Name: 00:04:00 •A Report for Payroll: 00:07:00 •Order Records by Column: 00:06:00 •Order Records by Multiple Columns: 00:12:00 •How Alias Names Cannot Be Used with WHERE: 00:02:00 •LIMIT Record Count Fetched by Your Query: 00:08:00 •Fetch A Field's Unique Values Using DISTINCT: 00:03:00 •Using DISTINCT Keyword with Multiple Columns: 00:06:00 •What is a NULL Value Anyway?: 00:05:00 •Build More Sophisticated Queries with CASE Statements: 00:10:00 •Your Knowledge So Far Under A Great Test: 00:09:00 •Let Me Introduce You to Functions: 00:04:00 •SUM Function: 00:04:00 •AVG (Average) Function: 00:04:00 •COUNT Function: 00:07:00 •MIN & MAX Functions: 00:04:00 •How To Count Your Field's Unique Values: 00:04:00 •GROUP BY Clause: Use Functions with Dimensions: 00:06:00 •GROUP BY More Than One Dimension: 00:05:00 •Now For Some Tough Workout: 00:09:00 •Filter By Aggregate Functions with HAVING Clause: 00:08:00 •Character Functions - UPPER, LOWER & INITCAP: 00:08:00 •Character Functions - CONCAT & LENGTH: 00:10:00 •Character Functions - LPAD & RPAD: 00:13:00 •Character Functions - TRIM: 00:04:00 •Character Functions - REPLACE: 00:09:00 •Character Functions - SUBSTR: 00:10:00 •Number Functions - MOD & ROUND: 00:11:00 •Number Functions - TRUNC: 00:07:00 •Selectception: A Select Query inside another Select Query!: 00:06:00 •Auto Data Conversion in SQL: 00:11:00 •Cast Date to Character: 00:10:00 •Cast Number to Character: 00:09:00 •Cast Timestamp to Character: 00:07:00 •Cast Character to Number: 00:08:00 •Cast Character to Date & Timestamp: 00:09:00 •UNION: 00:03:00 •UNION ALL: 00:02:00 •Important Note about Combining Queries: 00:02:00 •INTERSECT: 00:01:00 •EXCEPT: 00:01:00 •Employees & Departments Tables Revised: 00:03:00 •Entity Relationship Diagram (ERD): 00:09:00 •Cartesian Join: 00:09:00 •Table Aliases with Joins: 00:07:00 •Why I Don't Recommend Cartesian Joins: 00:08:00 •Inner Join: 00:06:00 •In-Depth Look into Join Types in SQL: 00:03:00 •Outer Join - Right, Left & Full: 00:08:00 •INSERT a New Record to a Table: 00:09:00 •Insert Without Specifying Column Names: 00:09:00 •UPDATE a Record's Field Values: 00:07:00 •CAUTION! How an UPDATE Query Can Go Wrong: 00:04:00 •Update a Record Using Single-Row Functions: 00:04:00 •A Good Exercise: Extract Employee's Email Address: 00:02:00 •Solution: Extract Employee's Email Address: 00:13:00 •DELETE a Table's Record: 00:06:00 •Insert Records with Nested Select Queries: 00:06:00 •SQL Data Types Revised: 00:13:00 •Bookstore Data Set: Let's Move It to Database: 00:04:00 •Create Your First Table!: 00:08:00 •Insert Data to Your New Table: 00:08:00 •Change Column Data Type: 00:07:00 •Rename Column: 00:04:00 •Add a New Column to Table: 00:04:00 •Constraints in SQL: 00:01:00 •Primary Keys: 00:14:00 •NOT NULL Constraint: 00:05:00 •UNIQUE Constraint: 00:04:00 •DEFAULT Constraint: 00:04:00 •Foreign Keys: 00:08:00 •Use Foreign Keys with Joins - Books & Publishers: 00:06:00 •Foreign Keys - Properties: 00:06:00 •Drop Column: 00:01:00 •DROP Table: 00:01:00 •Create a New Table with Select Statement: 00:05:00 •A Trick to Create an Empty Table with Select Statement: 00:03:00 •Insert New Records Using Select Statement: 00:06:00 •Views: 00:03:00 •Schemas: 00:02:00 •Create & Use Schemas: 00:04:00 •Resources - SQL Programming Masterclass: 00:00:00

SQL Programming Masterclass
Delivered Online On Demand10 hours 47 minutes
£12