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

39196 Courses delivered On Demand

Functional Skills Maths

4.5(3)

By Studyhub UK

Embark on a mathematical journey with our Functional Skills Maths course, designed to transform numbers and equations from daunting puzzles into fascinating challenges. Imagine standing at the crossroads of comprehension and mastery, where every integer and decimal is a stepping stone towards success. Our curriculum elegantly weaves through topics like the enigmatic world of integers, the rhythmic dance of factors and multiples, and the delicate balance of fractions. Explore the wonders of BODMAS, a simplification rule that brings order to chaos. Delve into the depths of decimal numbers and rational numbers, where precision meets practicality. Experience the thrill of approximation, and the precision of estimation and scientific notation, as you navigate through the practical realms of percentages, ratios, proportions, and the unitary method. Finally, grapple with real-world scenarios involving profit, loss, discount, and tax - the very essence of everyday maths. As you progress, each module unfolds like a chapter of a grand narrative, revealing the beauty and logic of mathematics. Whether you're deciphering the secrets of percentages or unraveling the complexities of ratio and proportion, this course promises a transformative experience. By turning abstract concepts into tangible skills, you'll not only gain knowledge but also the confidence to apply it in various contexts. Get ready to embark on a journey that not only educates but also empowers, as we guide you through the magical world of functional maths. Learning Outcomes Develop a robust understanding of key mathematical concepts including integers, fractions, and decimals. Master the BODMAS rule for effective problem-solving in mathematical equations. Gain proficiency in applying mathematical principles to real-life scenarios involving profit, loss, and taxation. Acquire skills in approximation, estimation, and understanding scientific notation for practical applications. Enhance ability to calculate and manipulate percentages, ratios, and proportions for diverse mathematical challenges. Why choose this Functional Skills Maths course? Individuals seeking to solidify their foundational maths skills. Students preparing for advanced studies in mathematics or related fields. Professionals requiring enhanced numerical skills for workplace applications. Anyone interested in improving their problem-solving and analytical abilities. Learners aspiring to apply mathematical concepts in everyday life. Who is this Functional Skills Maths course for? Individuals keen on mastering freestyle swimming. Beginners aiming to understand swimming basics and techniques. Athletes looking to enhance their swimming performance. Fitness enthusiasts seeking a comprehensive water workout. Adventurers aiming for open water swims or triathlon participation. Career path Financial Analyst: £30,000 - £50,000 Data Scientist: £35,000 - £70,000 Accountant: £25,000 - £50,000 Actuary: £32,000 - £60,000 Market Research Analyst: £24,000 - £45,000 Operational Researcher: £27,000 - £40,000 Prerequisites This Functional Skills Maths does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Functional Skills Maths was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Integers ( Directed Numbers) Lecture 1 Introduction 00:02:00 Lecture 2 Multiplying any digit number by 11, 22, and 33 00:09:00 Lecture 3 Integers and ordering of integers 00:06:00 Lecture 4 Addition and Subtractions of Integers 00:07:00 Lecture 5 Operations on Integers 00:04:00 Lecture 6 Multiplication and Division of Integers 00:04:00 Lecture 7 Powers of Integers (Exponents) 00:04:00 Factors and Multiples Lecture 8 Complete knowledge about factors and multiples 00:06:00 Lecture 9 Divisibility tests for 2,3,4,5,6 00:07:00 Lecture 10 Divisibility rules 7,8,9,10,11 00:06:00 Lecture 11 Prime Factorization 00:06:00 Lecture 12 Highest Common Factor HCF 00:10:00 Lecture 13 Least Common Multiple LCM 00:16:00 Lecture 14 Relation between LCM and HCF 00:04:00 Fractions Lecture 15 Classification of Fractions 00:04:00 Lecture 16 Convert mixed to improper and improper to mixed fractions 00:03:00 Lecture 17 Equivalent Fractions 00:04:00 Lecture 18 Comparing Fractions after converting to like fractions 00:09:00 Lecture 19 Reducing a fraction to lowest term 00:04:00 Lecture 20 Addition and subtraction OF fractions 00:08:00 Lecture 21 Multiplication and division of fractions 00:11:00 Lecture 22 Word problems on fractions 00:16:00 Simplification Rule : BODMAS Lecture 23 BODMAS and rules to remove brackets 00:03:00 Lecture 24 Simplify expressions using BODMAS rules 00:05:00 Lecture 25 Simplify expressions involving fractions using BODMAS 00:07:00 Decimal numbers Lecture 26 Decimal numbers in relation to fractions 00:08:00 Lecture 27 Like and unlike Decimals 00:05:00 Lecture 28 Ordering of Decimal numbers 00:10:00 Lecture 29 Addition and subtraction of Decimal 00:07:00 Lecture 30 Multiplication of Decimal 00:03:00 Lecture 31 Division of Decimal 00:05:00 Rational Numbers Lecture 32 Rational number 00:02:00 Lecture 33 Representation of Rational Numbers on Number line 00:04:00 Lecture 34 Determining which fraction is terminating or non terminating 00:05:00 Lecture 35 shortcut method of writing decimal expansion of fraction to decimal 00:08:00 Approximation Lecture 36 Rounding to whole number 00:06:00 Lecture 37 Rounding to required number of decimals (1 d.p. ) 00:05:00 Lecture 38 rounding to significant digits 00:07:00 Lecture 39 Practice question on three methods of approximation 00:05:00 Estimation and Scientific Notation or Standard form Lecture 40 Estimation 00:05:00 Lecture 41 Scientific Notation 00:07:00 Lecture 42 Operation on numbers when they are in scientific notation 00:06:00 Percentage Lecture 43 Percentage to fraction and fraction to percentage 00:06:00 Lecture 44 Percentage of a quantity and conversation to decimal 00:06:00 Lecture 45 Expressing one quantity as percentage of another quantity 00:06:00 Lecture 46 Finding increase decrease percent 00:05:00 Lecture 47 Uses of percentages-Word Problems 00:09:00 Ratio and Proportion Lecture 48 Ratio- How to express as simple ratio 00:09:00 Lecture 49 How to compare Ratios 00:04:00 Lecture 50 Word problems on finding ratios 00:07:00 Lecture 51To divide a given quantity into a given Ratio 00:11:00 Lecture 52 Proportion 00:04:00 Lecture 53 Practice problems on Proportion 00:06:00 Lecture 54 Continued proportion 00:06:00 Unitary Method and its Applications Lecture 55 Direct Variation ( or proportion) 00:04:00 Lecture 56 Problems based on Direct proportion 00:10:00 Lecture 57 Inverse Variation ( or proportion) 00:10:00 Lecture 58 Multiple Ratios 00:10:00 Profit , Loss, discount and Tax Lecture 59 Basics - Profit and Loss 00:04:00 Lecture 60 More practice problems on Profit & Loss 00:06:00 Lecture 61 Selling price formula and Problems 00:04:00 Lecture 62 Cost price formula and Problems 00:03:00 Lecture 63 Higher problems on Profit and Loss 00:08:00 Lecture 64 Basics - Discount.mp4 00:05:00 Lecture 65 Practice problems on Discount 00:04:00 Lecture 66 Tax 00:06:00 Mock Exam Mock Exam - Functional Skills Maths 00:20:00 Final Exam Final Exam - Functional Skills Maths 00:20:00

Functional Skills Maths
Delivered Online On Demand7 hours 36 minutes
£10.99

Bereavement Training

By Compete High

🌟 Unlock the Power of Healing with Bereavement Training 🌟 Are you ready to embark on a journey of compassion, understanding, and support? Welcome to Bereavement Training, where empathy meets expertise, and healing begins.   Why Bereavement Training? In a world where loss is an inevitable part of life, having the skills to navigate grief and support others through their darkest times is invaluable. 🕊️ Bereavement Training provides you with the tools, knowledge, and insight needed to effectively assist individuals and communities in coping with loss and bereavement. Benefits of Taking Our Bereavement Training Course   🌈 Comprehensive Understanding: Gain a deep understanding of the grieving process, including its emotional, psychological, and social dimensions. Learn how to recognize and address various manifestations of grief, from denial to acceptance.   💼 Practical Techniques: Acquire practical skills and techniques for providing support and comfort to those experiencing loss. From active listening to empathetic communication, you'll learn how to create a safe and nurturing environment for individuals to express their emotions.   🤝 Building Resilience: Discover strategies for fostering resilience and coping mechanisms in both yourself and others. Learn how to navigate the complexities of grief while maintaining your own emotional well-being.   📚 Current Research and Best Practices: Stay up-to-date with the latest research findings and best practices in the field of bereavement support. Our course integrates evidence-based approaches to ensure you're equipped with the most effective tools and strategies.   🎓 Professional Development: Whether you're a healthcare professional, counselor, social worker, or simply someone who wants to make a positive difference, our Bereavement Training course offers valuable professional development opportunities. Enhance your skill set and expand your career prospects with specialized training in bereavement support. Who is this for? Our Bereavement Training course is suitable for anyone passionate about helping others navigate the complexities of grief and loss. Whether you're a healthcare professional seeking to enhance your patient care skills, a counselor or therapist looking to specialize in bereavement support, or simply an empathetic individual eager to make a meaningful difference in your community, this course is for you. Career Path Upon completing our Bereavement Training course, you'll be equipped with the knowledge, skills, and confidence to pursue various career paths in the field of bereavement support. Potential career opportunities include:   🏥 Healthcare Settings: Work as a grief counselor or bereavement coordinator in hospitals, hospices, and other healthcare facilities, providing crucial support to patients and their families during times of loss.   🧠Mental Health Services: Join the ranks of mental health professionals specializing in grief therapy and support, offering counseling and therapeutic interventions to individuals struggling with bereavement.   👥 Community Organizations: Partner with community organizations and non-profits dedicated to supporting individuals and families affected by loss. Lead support groups, facilitate workshops, and organize outreach initiatives to foster healing and resilience within your community.   📚 Education and Training: Share your expertise by becoming a bereavement educator or trainer, providing workshops, seminars, and continuing education opportunities for professionals seeking to enhance their bereavement support skills.   Enroll Today and Embrace the Power of Compassionate Support Don't miss out on the opportunity to make a profound difference in the lives of those experiencing grief and loss. Enroll in our Bereavement Training course today and embark on a journey of healing, compassion, and growth. Together, let's transform grief into resilience and darkness into light. 🌟   FAQs (Frequently Asked Questions) 1. What is bereavement training? Bereavement training is a specialized course designed to equip individuals with the knowledge, skills, and tools needed to provide support to those experiencing grief and loss. This training encompasses a wide range of topics, including understanding the grieving process, effective communication techniques, and strategies for promoting resilience and coping. 2. Who can benefit from bereavement training? Bereavement training is beneficial for anyone who interacts with individuals experiencing grief and loss, including healthcare professionals, counselors, social workers, clergy members, educators, and community volunteers. Additionally, individuals who have experienced their own loss may find bereavement training valuable for gaining a deeper understanding of the grieving process and learning how to navigate their own emotions. 3. What topics are covered in bereavement training? Bereavement training covers a variety of topics related to grief and loss, including the psychological, emotional, and social aspects of grief, cultural considerations, communication skills, ethical considerations, and self-care strategies for providers. Additionally, some courses may include modules on specialized topics such as grief in children, traumatic loss, and complicated grief. 4. How long does bereavement training take to complete? The duration of bereavement training can vary depending on the provider and the format of the course. Some programs may be completed in a few days or weeks, while others may be more extensive and span several months. Online courses may offer flexibility in terms of scheduling and self-paced learning options. 5. Is bereavement training only for professionals? While bereavement training is valuable for professionals working in healthcare, counseling, and social services, it is also beneficial for anyone interested in supporting individuals experiencing grief and loss. Many courses are open to individuals from diverse backgrounds, including volunteers, caregivers, educators, and concerned community members. 6. How can I find a reputable bereavement training program? When seeking a bereavement training program, it's important to research and evaluate potential providers to ensure they offer high-quality, evidence-based instruction. Look for programs that are accredited, taught by experienced instructors, and have positive reviews or testimonials from past participants. Additionally, consider reaching out to professional organizations or local hospices for recommendations. 7. Can I receive continuing education credits for completing bereavement training? Some bereavement training programs may offer continuing education credits for healthcare professionals, counselors, and social workers. Be sure to check with the provider or accrediting body to confirm eligibility and requirements for obtaining CEUs. 8. Will bereavement training prepare me to work with diverse populations? Yes, bereavement training typically includes content on cultural competence and working with diverse populations. This may include discussions on how cultural beliefs, values, and traditions influence the grieving process, as well as strategies for providing culturally sensitive support to individuals and families from different backgrounds. Course Curriculum Module 1_ Understanding Bereavement. Understanding Bereavement. 00:00 Module 2_ Cultural and Religious Perspectives on Death and Mourning. Cultural and Religious Perspectives on Death and Mourning. 00:00 Module 3_ Supporting Children and Adolescents through Grief. Supporting Children and Adolescents through Grief. 00:00 Module 4_ Supporting the Dying and Their Families. Supporting the Dying and Their Families. 00:00 Module 5_ Self-Care for Professionals Supporting the Bereaved. Self-Care for Professionals Supporting the Bereaved. 00:00

Bereavement Training
Delivered Online On Demand5 hours
£4.99

Employment Law & Agile HR Management Diploma

5.0(1)

By Empower UK Employment Training

Employment Law & Agile HR Management Diploma Gain a competitive edge in the HR landscape with our Employment Law & Agile HR Management Diploma. Acquire mastery over Employment Law & Agile HR Management protocols to lead your organisation to success. Transform your career with this must-have diploma in Employment Law & Agile HR Management. Learning Outcomes: Analyse core principles of Employment Law & Agile HR Management. Apply Employment Law in constructing employment contracts. Evaluate rights and responsibilities during employment using Employment Law. Utilise Agile HR Management Methodology as per UK Employment Law in talent development. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Key Modules from Employment Law & Agile HR Management Diploma: Legal Recruitment Process: Implement lawful hiring procedures as per UK Employment Law. Employment Contract: Draft and review employment contracts, strictly adhering to Employment Law guidelines. Rights During Employment: Navigate and uphold employee rights, employing the pillars of Employment Law. Talent Management: Maximise talent potential through Agile HR Management, while remaining compliant with Employment Law. Agile HR Techniques: Implement cutting-edge Agile HR Management strategies.

Employment Law & Agile HR Management Diploma
Delivered Online On Demand5 hours 36 minutes
£5

Social Care Management

By Training Tale

The bundle Social Care Management course is designed to help you build relationships with employers who provide Health and Welfare services throughout your studies. This fully supported distance learning program is for you if you are looking for your first job or want to grow in your existing wellbeing and social-care management profession. With our help, take the first significant step toward reaching your full potential now. The purpose of the Social Care Management qualification is to help students understand policy, management theory, and practice in health and social care. It allows students to engage with the challenges that professionals, service users, and policymakers face in their own country. It will provide knowledge that will help you work as an effective manager in the hospital/social care industry. The Social Care Management course combines theoretical and practical knowledge in the field of health and social care. The qualification will develop and improve knowledge and skills in areas such as change leadership, effective performance, planning and accountability, development, and team leadership. Learners will be prepared for a lot of occupations in health care administration and/or management.Identify characteristics of good research design in health or social care, and then apply research techniques, collect, and analyse data to complete a health or social care research project. Our Social Care Management course is designed to help you gain knowledge and basic professional employability skills in these fields. The course will give information that will support your capacity to operate as successful management in the hospital or social care business. Social Care Management course also provides both theoretical and practical knowledge in Health and Welfare service professions. This fully supported distance learning program is for you if you are looking for your first job or want to grow in your existing health and socialcare management profession. With our help, take the first significant step toward reaching your full potential now. This qualification takes these factors into account and addresses them, strengthening the learner's skill set for a managerial position. Learning Outcomes After completing bundle Social Care Management course, you will be able to: Describe the fundamentals of health and social-care management. Describe the concepts and principles of the NHS. Describe care and support planning. Know the importance of Person-centred Care. Develop effective communication and listening skills. Describe the concepts of Equality, Diversity and Rights concerning Health and Social-Care. Maintain health and safety regulations. Know about safeguarding in social care. Identify social risk and needs in health care. Why Choose Social Care Management Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Social Care Management Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ***This Bundle Courses Course 01: Social Care Management Course 02: Social Worker: Social Work Diploma Course 03: Level 3 Award in Health and Social Care Course ***Others Included in This Course Free 3 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the Social Care Management course] At the end of the Social Care Management course learners will gain knowledge of applications and in-depth analysis in the care sector, as well as management of health care issues. Graduates may find employment in the medical and wellbeing sectors as managers with managing or an interest in management. Careers may also develop in general hospital administration, quality assurance management, government healthcare coordination, or case management. After completing the Social Care Management course, learners will be able to understand social workers' responsibilities, including policies, procedures, and managerialism, as well as ethical problems and dilemmas in social work practice. Professionals have designed this bundle Social Care Management course to help you learn fast and efficiently, at your own speed and convenience. Course Curriculum of Module 1: A Quick Overview of Health and Social Care Module 2: Understanding Healthcare Module 3: Understanding Social Care Module 4: The UK Health System Module 5: Care and Support Planning Module 6: Person-Centred Care Module 7: Communication in Health and Social care Module 8: Developing Effective Communication Skills Module 9: Developing Listening Skills Module 10: Understanding the Promotion of Equality, Diversity and Rights in Health and Social Care Setting Module 11: Responsibilities for Health and Safety Module 12: Safeguarding in Social Care Module 13: Identifying Social Risk and Needs in Health Care ----------------------- Course 02: ***Social Worker: Social Work Diploma Course Curriculum Module 01: Introduction to Adults Support Worker Module 02: Introduction to Psychology of Older Age - Part I Module 03: Psychology of Older Age - Part II Module 04: Impact of Mental Health in the Old Age Module 05: Dealing with Life Module 06: Enhancing Health and Wellbeing ----------------------- Course 03: ***Level 3 Award in Health and Social Care Course Course Curriculum Module 01: Equality, Diversity and Rights in Health and Social care Module 02: Human Growth and Development Module 03: Safeguarding in Health and Social-Care Assessment Method After completing each module of Social Care Management Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for Social Care Management course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? The Social Care Management has been professionally designed for motivated learners who want to learn the latest industry-specific information on health and social care management. Requirements There are no specific requirements for Social Care Management course because it does not require any advanced knowledge or skills. Students who intend to enrol in Social Care Management course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path Social Care Management course will open doors and lead you to a wide range of sectors. Here are a few options: Occupational Therapist: £25,000 - £45,000 per year Psychologist: £20,000 - £55,000 per year Social Worker: £23,000 - £45000 per year Care Worker: £15,000 - £22,000 per year Certificates Certificate of completion Digital certificate - Included

Social Care Management
Delivered Online On Demand24 hours
£12

Learn MySQL from Scratch for Data Science and Analytics

4.5(3)

By Studyhub UK

Embark on a comprehensive journey into the world of MySQL with a focus on its applications in Data Science and Analytics. This course is structured to take you from the fundamentals to advanced topics in MySQL Server. Covering SQL basics, data manipulation and definition, control and analytic functions, and database management, you'll acquire the essential skills for harnessing MySQL's power in data-driven decision-making. Learning Outcomes: Establish a strong foundation in SQL and MySQL. Set up and configure SQL Server for efficient data handling. Master SQL's Data Manipulation, Definition, and Control Language. Create and optimize SQL queries for data analysis. Perform advanced data analytics using SQL. Understand the power of GROUP BY and JOIN statements. Implement data constraints and views for data integrity and security. Develop proficiency in stored procedures, data import/export, and database backup/restore. Why buy this Learn MySQL from Scratch for Data Science and Analytics?  Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Learn MySQL from Scratch for Data Science and Analytics you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Learn MySQL from Scratch for Data Science and Analytics course is ideal for Aspiring Data Scientists and Analysts. Database Administrators and Developers. Students and professionals seeking to enter the field of Data Science. Anyone looking to enhance their SQL and MySQL skills for data-related roles. Prerequisites This Learn MySQL from Scratch for Data Science and Analytics was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Data Analyst: £25,000 - £50,000 per year. Database Administrator: £30,000 - £60,000 per year. SQL Developer: £30,000 - £60,000 per year. Data Scientist: £40,000 - £80,000 per year. Business Intelligence Analyst: £35,000 - £65,000 per year. Course Curriculum Learn MySQL from Scratch for Data Science and Analytics Section 01: Getting Started Introduction 00:02:00 How to get course requirements 00:01:00 Getting started on Windows, Linux or Mac 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 What is Source Code? 00:09:00 Section 02: SQL Server setting up Section Introduction 00:01:00 MySQL Server Installation 00:14:00 Connect MySQL Server Instance 00:06:00 MySQL Workbench overview 00:11:00 Download and Restore Sample Database 00:08:00 Section 03: SQL Database basics Section Introduction 00:01:00 Overview of Databases 00:09:00 Creating Database 00:07:00 SQL Data Types 00:04:00 Column Data Types on Workbench 00:07:00 Creating Table 00:04:00 Overview of Primary and Foreign Key 00:03:00 Primary Key 00:06:00 Foreign Key 00:12:00 Creating Temporary tables 00:12:00 EER - Enhanced Entity Relationship Diagrams 00:04:00 Section 04: SQL DML (Data Manipulation Language) Section Introduction 00:01:00 Insert statement 00:07:00 Update statement 00:06:00 Delete statement 00:03:00 Section 05: SQL DDL (Data Definition Language) Section Introduction 00:01:00 CREATE table statement 00:08:00 DROP statement 00:03:00 ALTER statement 00:05:00 TRUNCATE statement 00:03:00 COMMENT in query 00:02:00 RENAME table 00:03:00 Section 06: SQL DCL (Data Control Language) Create Database user 00:03:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 07: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:03:00 SELECT DISTINCT 00:02:00 SELECT with column headings 00:01:00 Column AS statement 00:02:00 DASHBOARD Analytics 00:06:00 Section 08: Filtering Data rows SELECT WHERE Clause - theory 00:03:00 SELECT WHERE Clause - practical 00:06:00 Section 09: Aggregate functions for Data Analysis Sum() 00:06:00 Min()-Max() 00:03:00 Section 10: SQL Data Analyticstatements Order By statement 00:05:00 SELECT TOP 3 records 00:02:00 BETWEEN command 00:06:00 IN operator 00:03:00 Search Data usingLIKE cards 00:05:00 Section 11: SQL Group by statement Section Introduction 00:01:00 Group by - theory 00:04:00 Data Analytics with Group By 00:04:00 HAVING statement 00:03:00 Section 12: JOINS Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:07:00 Left outer join 00:02:00 Right outer join 00:02:00 Union 00:03:00 CERTESIAN Product or Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 13: SQL Constraints Section introduction 00:01:00 Check constraint 00:09:00 NOT NULL constraint 00:03:00 UNIQUE constraint 00:06:00 Section 14: Views Creating Views 00:03:00 Data Analytic Views from multiple tables 00:03:00 Section 15: Advanced SQL Functions Section Introduction 00:01:00 Timestamp 00:03:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:03:00 String functions3 00:07:00 Advanced functions 00:04:00 Sub Queries 00:03:00 SELECT with calculations 00:05:00 Section 16: SQL Stored procedures Create stored procedure 00:06:00 Stored procedure with parameter 00:03:00 Drop Procedure 00:01:00 Section 17: Import & Export data Section Introduction 00:01:00 Import .csv file 00:04:00 Export Data to .csv file 00:02:00 Section 18: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:02:00 Restoring Database backup 00:02:00

Learn MySQL from Scratch for Data Science and Analytics
Delivered Online On Demand5 hours 47 minutes
£10.99

Afro Kids Hair Care Level 1

By Compete High

🌟 Unlock the Secrets of Afro Kids Hair Care Level 1 Course! 🌟 Are you ready to embark on a journey that celebrates the beauty and uniqueness of Afro kids' hair? Introducing Afro Kids Hair Care Level 1 - the ultimate course designed to empower parents, guardians, and aspiring hairstylists with the knowledge and skills needed to care for and style Afro-textured hair with confidence and finesse.   ✨ Why Choose Afro Kids Hair Care Level 1 Course? ✨ In today's diverse world, understanding and mastering the art of caring for Afro-textured hair is more important than ever. Whether you're a parent seeking to nurture your child's hair or a professional hairstylist eager to expand your expertise, this course offers a comprehensive foundation to unlock the secrets of Afro hair care.   🔍 What You'll Learn: Fundamentals of Afro-textured hair: Dive deep into the anatomy, structure, and unique characteristics of Afro hair types, including coils, curls, and kinks. Essential hair care techniques: Discover proven methods for washing, conditioning, moisturizing, and detangling Afro hair, while maintaining its natural integrity and health. Styling tips and tricks: From protective hairstyles to creative braiding techniques, learn how to unleash your creativity and express your personal style through Afro-centric hairdos. Product selection and maintenance: Navigate the vast array of hair products available on the market and learn how to choose the best ones tailored to your child's hair type and needs. Cultural significance and empowerment: Gain insight into the rich history, cultural significance, and symbolism of Afro-textured hair, and embrace it as a source of pride and identity.   🎯 Who is this for? 🎯 Parents and guardians: Empower yourself with the knowledge and skills to care for your child's Afro-textured hair with love, care, and confidence. Aspiring hairstylists: Take your hairstyling career to the next level by mastering the art of Afro hair care and expanding your clientele base. Beauty enthusiasts: Explore your passion for hair care and styling and unlock a world of endless possibilities in the vibrant realm of Afro-centric beauty.   🚀 Career Path 🚀 Upon completing Afro Kids Hair Care Level 1, you'll be equipped with the expertise and confidence to pursue various exciting career opportunities, including: Professional hairstylist specializing in Afro-textured hair Salon owner catering to clients with diverse hair textures and needs Hair care consultant providing personalized advice and guidance to parents and individuals Beauty educator sharing your knowledge and passion for Afro-centric hair care with others   FAQ (Frequently Asked Questions): Q: Is prior experience required to enroll in the Afro Kids Hair Care Level 1 course? A: No prior experience is necessary! This course is designed to accommodate beginners and enthusiasts alike, providing a solid foundation in Afro hair care principles and techniques. Q: How long does it take to complete the course? A: The duration of the course may vary depending on individual learning pace and schedule. However, on average, students can expect to complete the course within a few weeks to a few months. Q: Are there any prerequisites for taking the course? A: There are no specific prerequisites for enrollment in the Afro Kids Hair Care Level 1 course. All you need is a passion for learning and a desire to master the art of Afro-textured hair care. Q: Will I receive a certificate upon completing the course? A: Yes, upon successful completion of the course requirements, you will receive a certificate of achievement, recognizing your dedication and mastery of Afro Kids Hair Care Level 1 principles and techniques. Q: Is the course content available online? A: Yes, the course content is delivered entirely online, allowing you to study at your own pace and convenience from anywhere in the world with an internet connection.   Don't miss out on this exciting opportunity to embark on a transformative journey into the vibrant world of Afro Kids Hair Care Level 1. Enroll today and unleash your potential to create beauty, confidence, and empowerment through Afro-centric hair care! 🌟 Course Curriculum Module 1 Introduction to the Afro. Introduction to the Afro. 00:00 Module 2 Nourishing Hair and Scalp Hygiene. Nourishing Hair and Scalp Hygiene. 00:00 Module 3 Hair Styling and Seasonal Considerations. Hair Styling and Seasonal Considerations. 00:00 Module 4 Hair Growth and Products. Hair Growth and Products. 00:00 Module 5 Common Challenges and Hair Accessories. Common Challenges and Hair Accessories. 00:00

Afro Kids Hair Care Level 1
Delivered Online On Demand5 hours
£4.99

US History

By Compete High

Uncover the Rich Tapestry of America: 🇺🇸 US History Course Overview Dive into the riveting narrative of the United States with our comprehensive US History course! 🎓 Embark on a journey through time, exploring the events, people, and movements that have shaped the nation we know today. 🌟 Whether you're a student eager to expand your knowledge or a history enthusiast seeking a deeper understanding of America's past, this course is your gateway to an enlightening experience. Why Choose Our US History Course? 📚 Broaden Your Understanding: Delve into the depths of America's past and gain insight into its rich heritage. From the early colonial period to contemporary times, explore the pivotal moments and influential figures that have sculpted the nation's identity. 🌎 Connect the Dots: By unraveling the intricate tapestry of US history, you'll discover the interconnectedness of events and their enduring impact on society, politics, and culture. Gain a holistic perspective that transcends individual narratives. 🧠Critical Thinking Skills: Challenge your critical thinking faculties as you analyze historical events, debates, and interpretations. Learn to evaluate sources, discern biases, and construct informed opinions-an indispensable skill in navigating the complexities of the modern world. 🎓 Academic Enrichment: For students, our US History course serves as a cornerstone of academic enrichment. Strengthen your comprehension of key concepts and historical themes while honing your research and writing abilities-essential assets for academic success. 💡 Insight into Contemporary Issues: Unravel the threads of history to gain fresh insights into contemporary issues and societal dynamics. By understanding the past, you'll be better equipped to engage with the present and contribute meaningfully to shaping the future. Who is this for? Our US History course is designed for a diverse audience: Students: High school and college students seeking to fulfill academic requirements or deepen their understanding of American history. History Buffs: Enthusiasts eager to explore the intricate tapestry of America's past and uncover lesser-known stories and perspectives. Lifelong Learners: Individuals passionate about lifelong learning and intellectual enrichment, regardless of educational background or profession. Career Path The insights gleaned from our US History course can pave the way for various career paths, including: Education: Pursue a career in teaching, curriculum development, or educational administration with a solid foundation in US history. Public Service: Equip yourself with historical knowledge and critical thinking skills essential for roles in government, policy analysis, and public administration. Journalism and Media: Navigate the dynamic landscape of journalism and media with a nuanced understanding of historical context and social dynamics. Law and Advocacy: Advocate for justice and social change armed with insights into the historical precedents and constitutional principles that underpin contemporary legal issues. FAQ (Frequently Asked Questions) Q: Is prior knowledge of US history required to enroll in this course? A: No prior knowledge is necessary. Our course caters to learners of all levels, from beginners to seasoned history enthusiasts. Q: How is the course structured? A: The course is structured around key chronological periods and thematic modules, providing a comprehensive overview of US history from multiple perspectives. Q: Will there be assessments or exams? A: Yes, the course may include quizzes, assignments, and examinations to reinforce learning and assess comprehension. Q: Can I access course materials online? A: Yes, our course materials are accessible online, allowing for flexible learning at your own pace and convenience. Q: Is this course accredited? A: While our course itself may not offer accreditation, the knowledge and skills gained can supplement academic credentials and enrich personal and professional development. Q: How long does the course take to complete? A: The duration of the course may vary depending on the pace of study and individual learning goals. However, most learners complete the course within a specified timeframe, typically ranging from several weeks to a few months. Q: Are there opportunities for interaction and discussion with instructors and fellow learners? A: Absolutely! Our course fosters a vibrant learning community where participants can engage in discussions, exchange ideas, and receive guidance from experienced instructors. Q: Can I receive a certificate upon completion of the course? A: Yes, upon successfully completing the course requirements, learners may receive a certificate of completion as recognition of their achievement.   Enroll in our US History course today and embark on a captivating voyage through the annals of American history. Uncover the stories, struggles, and triumphs that have shaped the nation-and discover the profound relevance of history in our lives today! 🌟📜🔍 Course Curriculum Module 1 The Colonies The Colonies 00:00 Module 2 Arms and The Rights Of Man Draft Lesson 00:00 Module 3_ The American Revolution The American Revolution 00:00

US History
Delivered Online On Demand1 hour
£4.99

Anti-Bullying Awareness Course

By Compete High

Anti Bullying awareness is a topic that is very important to grasp in the current work culture of the UK. Whether it be an educational institution or a large firm, anti bullying awareness is important to ensure that you are complying with the regulations of your workplace.

Anti-Bullying Awareness Course
Delivered Online On Demand17 hours
£5

DBT and CBT Therapy Online Course

3.0(2)

By Alpha Academy

Master the recent techniques of Dialectical and Cognitive Behavioural Therapy with the DBT and CBT Therapy Training course. Cognitive behavioural therapy (CBT) is an evidence-based psychotherapy that is designed to improve mental health. On the other hand, Dialectical behaviour therapy (DBT) is also an evidence-based psychotherapy designed to ease the effects of depression, anxiety, stress, inner chaos, moodiness, impulsiveness, and self-destructiveness, as well as helping us to improve our relationships. It is a modified form of cognitive behavioural therapy (CBT). Throughout the course, you will explore the techniques to apply these theories in practice so that you can treat your patients’ mental disorders or illness. You will learn how to deal with your clients and how to apply the theories. The course also discusses the effectiveness and limitations of both approaches. DBT and CBT Therapy Training Course Highlights The price is for the whole course including final exam – no hidden fees Accredited Certificate upon successful completion at an additional cost Efficient exam system with instant results Track progress within own personal learning portal 24/7 customer support via live chat DBT and CBT Therapy Training has been given CPD accreditation and is one of the best-selling courses available to students worldwide. This valuable course is suitable for anyone interested in working in this sector or who simply wants to learn more about the topic. If you’re an individual looking to excel within this field then DBT and CBT Therapy Training is for you. We’ve taken this comprehensive course and broken it down into several manageable modules which we believe will assist you to easily grasp each concept – from the fundamental to the most advanced aspects of the course. It really is a sure pathway to success. All our courses offer 12 months access and are designed to be studied at your own pace so you can take as much or as little time as you need to complete and gain the full CPD accredited qualification. And, there are no hidden fees or exam charges. We pride ourselves on having friendly and experienced instructors who provide full weekday support and are ready to help with any of your queries. So, if you need help, just drop them an email and await a speedy response. Furthermore, you can check the validity of your qualification and verify your certification on our website at anytime. So, why not improve your chances of gaining professional skills and better earning potential. Assessment and Certification At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39. Career Path Not only does our CPD and CiQ accredited course look good on your CV, setting you apart from the competition, it can be used as a stepping stone to greater things. Further advance your learning, launch a new career or reinvigorate an existing one. On successful completion of this course, you have the potential to achieve an estimated salary of £42,000. The sky really is the limit.

DBT and CBT Therapy Online Course
Delivered Online On Demand6 hours
£11.99

Level 3 Advanced Diploma on Leadership & Management - Team Leader

5.0(5)

By Online Training Academy

Level 3 Advanced Diploma on Leadership & Management - Team Leader course - Updated 2024 A staggering 79% of employees consider leaving due to lack of appreciation from their team leaders. The team leader can have a significant impact on the satisfaction and motivation of employees, which drives sales to great heights. This course is perfect for aspiring team leaders, supervisors, and managers who are looking to enhance their leadership & management capabilities. Whether you're new to a leadership & management role or seeking to refine your skills, this diploma will provide you with the knowledge and confidence to lead with excellence. According to Reed a Team Leader can earn from £25,000 to £30,000 in a year depending on qualification, experience, location and other factors. Additionally, the demand for skilled Team leaders and managers is steadily rising, with a projected growth rate of 10-15% in the sector over the next decade. Don't miss the opportunity to become the team leader you've always aspired to be. Enrol in the Level 3 Advanced Diploma in Leadership & Management - Team Leader Course today and take on a journey towards professional growth and success. Thus, investing in this Leadership & Management course not only enhances job prospects but also provides a competitive edge in a continuously evolving professional landscape. Key Features: This Leadership & Management - Level 3 Advanced Diploma Course Includes This Leadership & Management course is CPD QS Certified Free Certificate from Reed CIQ Approved Leadership & Management course Developed by Specialist Lifetime Access Why Choose Our Course? By choosing our Leadership & Management - Team Leader course is a smart investment in your professional future. Our Leadership & Management - Team Leader course is designed by industry professionals to stay ahead of trends, offering the most current and relevant content. This Leadership & Management - Team Leader course provides you with the tools and knowledge needed to excel in today's competitive landscape. With flexible learning options and a commitment to your success, our Leadership & Management - Team Leader course is the key to unlocking your potential and advancing your professional journey. Course Curriculum: Level 3 Advanced Diploma on Leadership & Management - Team Leader Module 01: Team Dynamics and Collaboration Module 02: Foundations of Leadership & management Module 03: Strategies for Building High-Performing Teams Module 04: Motivational Strategies for Team Members Module 05: Effective Talent Identification and Management Module 06: Stress Management and Well-being at Work Module 07: Strategic Succession Planning Module 08: Enhancing Communication Skills Module 09: Negotiation Techniques for Effective Leadership Module 10: Navigating Change in the Workplace Module 11: Time Management Strategies for Leaders Module 12: Conflict Resolution and Collaboration Module 13: Risk Management Processes and Strategies Module 14: Leadership & management in Virtual Team Environments Learning Outcomes: After completing this Level 3 Advanced Diploma on Leadership & Management - Team Leader course you will be able to: Define and articulate the essence of teamwork for effective collaboration. Understand the principles of Leadership & management in organizational settings. Build and lead high-performing teams, fostering a culture of excellence. Motivate team members with strategies that inspire and drive collective success. Implement talent management practices for identifying, nurturing, and retaining key skills. Manage stress, prioritize mental health, and create a resilient team environment. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Leadership & Management - Team Leader course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Leadership & Management - Team Leader. Moreover, this Leadership & Management - Team Leader course is ideal for: Aspiring team leaders seeking foundational skills in Leadership & Management. Team leaders aiming to enhance their ability to build and lead teams. Managers and professionals interested in Leadership & Management and team motivation. Individuals looking to develop effective communication and negotiation techniques. Professionals navigating change, conflict, and time management challenges. Requirements There are no requirements needed to enrol into this Leadership & Management - Team Leader course. We welcome individuals from all backgrounds and levels of experience to enrol into this Leadership & Management - Team Leader course. Career path After finishing this Leadership & Management - Team Leader course you will have multiple job opportunities for you. Some of the the following Job sectors of Leadership & Management - Team Leader are: Team Leader - £25K to 40K/year Human Resources Manager - £30K to 60K/year Project Manager - £30K to 60K/year Training and Development Manager - £30K to 60K/year Operations Manager - £30K to 70K/year Certificates Digital certificate Digital certificate - Included Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Level 3 Advanced Diploma on Leadership & Management - Team Leader
Delivered Online On Demand3 hours 36 minutes
£10