218 Courses delivered Online

Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now Healthcare assistants (HCAs) are crucial members of any medical team and are in high demand in the UK. They are always there to help physicians and nurses in their work and to care for the patients. Healthcare assistants can provide treatment in a variety of settings, including clinics, hospitals, hospices, and mental health facilities. Some people can view this as a stepping stone to higher-level careers in the healthcare industry. If you are empathetic, kind, and driven to help others, you already have half the abilities needed. Enrol in our Health Care Assistant bundle course, and you'll be prepared to shine. This Bundle Consists of the following Premium courses: Course 01: Healthcare Assistant Training Course 02: Medical Law Course 03: European Medical Device Regulations Course 04: Vaccine Management Course 05: Clinical Observations Skills Course 06: Medication Administration Level 4 Course 07: Medical Transcription Course 08: Nurse Prescribing Diploma Course 09: Phlebotomy Course 10: Wound Care Level 2 Course 11: Verification of Death Training for Nurses Course 12: Consent in Healthcare Course 13: Diabetes Care Diploma Course 14: Public Health Learning Outcomes Get an insight into training. Explore the medical law based in the UK. Learn the European medical device regulations. Explore the core concepts of vaccine management and clinical observational skills. Recognise the importance of medication administration and medical transcription. Gain a better understanding of Phlebotomy and wound care. Learn how to care for diabetic patients. Get an overview of public health. Curriculum Course 01: Healthcare Assistant Training Module 01: Working in Different Healthcare Settings Module 02: Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care Part - 1 Module 03: Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care Part - 2 Module 04: Maintaining Medical Records Module 05: Confidentiality in a Medical Environment Module 06: Health and Safety Responsibilities Module 07: Hygiene in Nursing Module 08: Infection Control Module 09: Mobility and Immobility Issues of Patients in Nursing Module 10: Rights and Responsibilities as a Health and Social Care Worker Module 11: Role as A Caregiver and Healthcare Professional Module 12: Providing Care or Treatment to People Who Lack Capacity Module 13: Managing Service Delivery in Health and Social Care Module 14: Medical Jargon and Terminology Module 15: Effects of Covid-19 on Human Life Module 16: Preventions and Social Measures to Be Taken Module 17: Information Technology in Health Care Module 18: Artificial Intelligence, Data Science and Technological Solutions against Covid-19 CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? For anyone who is interested to learn. Note: Kindly note that these courses will not make you eligible to work professionally. Requirements None. Career path With the knowledge gained from the bundle course, you will be able to explore different career options such as - Health Care Assistant Medical Social Worker Home Care Assistant In the United Kingdom, the average salary of these professions ranges from £22,000 - £32,000 per annum. Certificates Certificate of completion Digital certificate - Included You will get the PDF Certificate for the title course (Healthcare Assistant Training) absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Healthcare Assistant Training) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

In this compact intermediate-level course, you will learn how to use Facebook Prophet to do time series analysis and forecasting. You will learn how Prophet works under the hood and the Prophet API. We will apply Prophet to a variety of datasets, including store sales and stock prices.

In this self-paced course, you will learn how to use TensorFlow 2 to build convolutional neural networks (CNNs). You will learn how to apply CNNs to several practical image recognition datasets and learn about techniques that help improve performance, such as batch normalization, data augmentation, and transfer learning.

In this self-paced course, you will learn how to use TensorFlow 2 to build recurrent neural networks (RNNs). You will learn about sequence data, forecasting, Elman Unit, GRU, and LSTM. You will also learn how to work with image classification and how to get stock return predictions using LSTMs. We will also cover Natural Language Processing (NLP) and learn about text preprocessing and classification.

In this self-paced course, you will learn how to use TensorFlow 2 to build deep neural networks. You will learn the basics of machine learning, classification, and regression. We will also discuss the connection between artificial and biological neural networks and how that inspires our thinking in deep learning.

Tired of browsing and searching for the course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this 14-in-1 extensive bundle that has everything you need to succeed in Social Care and other relevant fields! After surveying thousands of learners just like you and considering their valuable feedback, this all in one Social Care bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand course that will enhance your skills and prepare you for the competitive job market. Also, our Social Care experts are available for answering your queries and help you along your learning journey. Advanced audiovisual learning modules of these courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Social Care, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Bundle Consists of the following Premium courses: Course 01: Level 4 Diploma in Health and Social Care Management Course 02: Work Preparation for Adult Social Care Level 5 Course 03: Mental Health Laws and Awareness - Level 2 Course 04: Level 3 Residential Childcare Worker Course 05: Safeguarding Children Level 3 Course 06: CPR and Paediatric First Aid Course Course 07: Domestic Violence and Abuse Awareness - Level 2 Course 08: Family Law 2021 Course 09: Family Support Worker Diploma Course 10: Consent in Healthcare Course 11: Diabetes Care Diploma Course 12: Nutrition and Diet Awareness Course 13: Addiction and Mental Health - Dual Diagnosis Course 14: Effective Communication Skills Diploma Benefits you'll get choosing Apex Learning for this Social Care: Pay once and get lifetime access to 14 CPD courses Certificates, student ID for the title course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) Curriculum of the Bundle Course 01: Level 4 Diploma in Health and Social Care Management Introduction Communication and its Relevance Rights and Responsibilities Role as A Caregiver and Healthcare Professional Promoting Equality, Diversity and Rights Important Principles and Policies Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care Part - 1 Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care Part - 2 Safeguarding Vulnerable Individuals Health and Safety Responsibilities The Economics of Healthcare Strategic Marketing Managing Finance Managing Service Delivery Course 02: Work Preparation for Adult Social Care Level 5 Adult Nursing Training Introduction to Nursing Working in Different Healthcare Settings Understanding legal, professional standards of practice and ethical aspects of health care- Part 1 and 2 Effective Communication in Nursing Health and Safety in Nursing Hygiene in Nursing Infection Control Asepsis in Nursing Medication Administration in Nursing Adult Care in Different Life Stages Understanding Immune System in Nursing Rest and Sleep Management in Nursing Mobility and Immobility Issues of Patients in Nursing Pain Management for Nurses Nutrition in Nursing Fluid and Electrolyte Balance Assisting with Elimination Oxygenation in Nursing Health and Social Care Training Introduction Communication and its Relevance Role as A Caregiver and Healthcare Professional Working in Health and Social Care; Promoting Equality, Diversity and Rights Important Principles and Policies in Health and Social Care Work Safeguarding Vulnerable Individuals Health and Safety Responsibilities Risk Management Course 03: Mental Health Laws and Awareness - Level 2 The Mental Capacity Act Interface with Legislation, Policy and Procedures Deprivation of Liberty Safeguards The Mental Capacity Act (2005) and Deprivation of Liberty Safeguards During a Pandemic Mental Health Legislation and Services Liberty Protection Safeguards (LPS) Course 04: Level 3 Residential Childcare Worker Introduction to Child Psychology Impacts of Separation and Loss on Attachment Social and Emotional Development Mental Health Problems in Young and Adults Personality and Intellectual Development of Children Language Development in Children Cognitive Development Autism, ADHD and Dyslexia in Young and Adults Dealing With Autism, ADHD and Dyslexia in Young and Adults Children with Special Needs Child Protection Course 05: Safeguarding Children Level 3 Laws and Guidance Social and Emotional Development Personality and Intellectual Development of Children Child Abuse Sexual Abuse The Impact of Domestic Violence and Abuse on Children Risks and Risk Assessment Responding to Disclosure and Reporting Things to Do after Referral Safeguarding Trafficked Children Infant Mental Health and Early Attachment Assessing Need and Providing Early Help Course 06: CPR and Paediatric First Aid Course Introduction to Paediatric First Aid Assessment and Assistance Loss of Responsiveness and CPR Paediatric First Aid for Common Illnesses, Injuries and Incidents First Aid for Acute Medical Conditions Call for an Emergency Course 07: Domestic Violence and Abuse Awareness - Level 2 Introduction to Domestic Violence & Abuse The Components of Domestic Violence The Impact of Domestic Violence on Victims The Impact of Domestic Violence and Abuse on Children Assessing the Risks of Domestic Violence and Abuses on Children Supporting the Victim and Reporting Incidents Record Keeping Domestic Violence and Abuse Legislation in the UK Course 08: Family Law 2021 Introduction to Family Law Framing Family Law Marriage in Family Law Civil Partnership and Cohabitation Nullity in Marriage Divorce and Family Law Child Custody Property and Finance on Divorce Child Support and Family Law Adoption Process Domestic Violence Gender Equality in Family Law Feminist Perspectives on Family Law Course 09: Family Support Worker Diploma Introduction to Family Support Work Legislation, Policy and Guidance Solving Family Issues Safeguarding - Assessing need and providing help Building Relationships Course 10: Consent in Healthcare Covid-19 Awareness for General People and Healthcare Introduction to Covid-19 Understanding of Covid-19 as a Pandemic and How It Is Related to Zoonotic Diseases Like SARS and MERS The Strike of Pandemic Around the World and Great Britain Effects of Covid-19 on Human Life Diagnoses and Treatments Preventions and Social Measures to Be Taken Artificial Intelligence, Data Science and Technological Solutions against Covid-19 Consent Training in Healthcare Course An Introduction to Consent Information Regarding Consent Consent Training in Healthcare Course Best Interest Decision Making Assessing Capacity Providing Care or Treatment to People Who Lack Capacity Public Bodies and Services Created by MCA Act 2005 UK Acts in Relation to Consent Handling Complaints Regarding Consent Course 11: Diabetes Care Diploma What is Diabetes The Diabetes Challenge The Cost of Diabetes Types Prediabetes Gestational Diabetes Other Types of Diabetes Hypoglycaemia Hyperglycaemia and Hyperosmolar Hyperglycaemic State Glossary of Diabetes Terms Course 12: Nutrition and Diet Awareness Overview Nutritional Details What to Avoid & Problem Areas Beyond Food Putting It All Together Handouts Course 13: Addiction and Mental Health - Dual Diagnosis Promotional Video SAMHI Dual Diagnosis Intro video Module 01 - Drugs and Effects Module 02 - Addictions & Mental Health Module 03 - Harm Minimisation & Optimal Health Module 04 - Brain Works - Neurophysiology Module 05 - Trauma Model & Keys to Treatment Module 06 - Brief & Early Intervention and Tripod of Support Course 14: Effective Communication Skills Diploma Module 01: Business Communication Module 02: Verbal and Non-verbal Communication Module 03: Written Communication Module 04: Electronic Communication Module 05: Communicating with Graphic Module 06: Effectively Working for Your Boss CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in thisbundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Please note: This course doesn't entitle you to practice as a professional in this specific field. Rather, this course will assist you in understanding the fundamentals so that you can improve your knowledge in the relevant field. Requirements Our Social Care is fully compatible with PC's, Mac's, laptops, tablets and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so that you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course; it can be studied in your own time at your own pace. Career path Having this various expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Level 4 Diploma in Health and Social Care Management) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

This complete training program comprising levels 1 and 2 is divided into multi-sequential sections to let you gain comprehensive knowledge and understanding of SQL and data analysis. This two-level course is designed to kickstart your SQL knowledge and perform various data analysis tasks and implement SQL in projects independently and efficiently.

***Don't Spend More; Spend Smart*** Life Just Got Better This Summer! Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now Tired of browsing and searching for the course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this 14-in-1 extensive bundle that has everything you need to succeed in Neuroscience and other relevant fields! After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Neuroscience bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Neuroscience course that will enhance your skills and prepare you for the competitive job market. Also, our Neuroscience experts are available for answering your queries and help you along your learning journey. Advanced audio-visual learning modules of these courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Neuroscience, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Neuroscience Bundle Consists of the following Premium courses: Course 01: Neurology Course 02: Neuropsychology and Development of Children Course 03: Concussion and Brain Injury Awareness Course 04: Cerebral Palsy Awareness Course 05: Understanding Autism Awareness and Diagnosis Level 2 Course 06: Dyslexia Awareness Course Course 07: Level 3 Mental Health and Adolescent Course Course 08: Level 3 Mental Health Awareness Course Course 09: Human Anatomy and Physiology Course 10: Nutrition and Diet Awareness Course 11: Medication Administration Level 4 Course 12: GDPR in Healthcare Course 13: Medical Law Course 14: Level 3 - Coronavirus (COVID -19) Awareness Course Benefits you'll get choosing Apex Learning for this Neuroscience: Pay once and get lifetime access to 14 CPD courses Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID for the title course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) Curriculum of Neuroscience Bundle Course 01: Neurology Introduction to Neurology Neurological Disorders Visual Disorders Disorders Of Hearing Spinal Cord Disorders Peripheral Nervous System Disorders Child Neurology Neurological Assessments Medications Course 02: Neuropsychology and Development of Children The Theory of Psycho-social Development Serve & Return Practical Tips For Serve & Return Fuzzy Trace Theory - Explains and Predicts Adolescent Risk Taking Adolescent Risk Taking and the Prefrontal Cortex Operant Conditioning - How Reinforcement Works and How it can help you The Danger of Unearned Rewards (Habituation and Expectations) Influencing behavior through linguistic cuing Does violent media lead to aggressive kids? Parenting Styles Culture and seeing world How childhood experience (i.e. violence) can result in choosing abusive partners A Highly Regimented Life is a Very Stressful Life Heritable vs. Inherited Hormones and Development Course 03: Concussion and Brain Injury Awareness Introduction To Brain Injury Concussion Awareness Acquired Brain Injury Sports-related Concussion And Brain Injury Rehabilitation Prevention Course 04: Cerebral Palsy Awareness Understanding Cerebral Palsy Causes and Symptoms of Cerebral Palsy Epidemiology of Cerebral Palsy Diagnosis of Cerebral Palsy Principles of Treatment Principles of Rehabilitation: Occupational and Physical Therapy Care Planning Typical Child vs Child with Cerebral Palsy Child, Family and Therapist Working as a Team Course 05: Understanding Autism Awareness and Diagnosis Level 2 Autism Spectrum Disorder (ASD) Learning Difficulties Related to Autism Autism Diagnosis Cognitive Approaches in Autism Dealing with Autistic Individuals Other Considerations for Dealing with Autistic Individuals Engagement in Autism Awareness Course 06: Dyslexia Awareness Course Introduction to Dyslexia Dyslexia and Learning Difficulties Dyslexia in the School Cognitive Approaches in Dyslexia The Legal Rights of Dyslexics Course 07: Level 3 Mental Health and Adolescent Course Introduction to Mental Health Child Psychology Attachment and Relationship Building in Childhood Impacts of Separation and Loss on Attachment Factors that Influence Development Mental Health Problems in Young and Adults Other Mental Health Problems in Young and Adults Autism, ADHD and Dyslexia in Young and Adults Dealing With Autism, ADHD and Dyslexia in Young and Adults The Self Harming Behaviour Mental Health Treatment and Medicine Mental Health over Life Span and Society in the UK Mental Health Related Legislations in the UK Course 08: Level 3 Mental Health Awareness Course Introduction to Mental Health Childhood And Adolescent Psychiatric Disorders Stress and Anxiety Disorders Schizophrenia Personality Disorders Mood Disorders Eating and Sleeping Disorders Self-Harm and Suicide Medication and Therapy in the Treatment of Mental Illness Social Attitudes To Mental Illness Mental Health Legislation and Services Mental Health In The Workplace Course 09: Human Anatomy and Physiology Human Body Vocabulary with Pictures Equipment, Instruments and Lab Tests Acronyms and Abbreviation Digestive System Cardiovascular System Blood and Immunity System Respiratory System Musculoskeletal System Central Nervous System Course 10: Nutrition and Diet Awareness Nutrition and Diet Awareness Overview Nutritional Details What to Avoid & Problem Areas Beyond Food Putting It All Together Course 11: Medication Administration Level 4 Introduction to Safe Handling of Medicines Legislation and guidance of medication management Principles of Safe and Appropriate Handling of Medicines Medication Risk Assessment Guidance Handling Medicines in Social Care Settings Consent to Treatment Requirements for Specific Services Levels of Care and Support Procedure for Handling Medication The Six Rights of Medication Administration Covert Administration of Medication Recording Procedures Storage of Medication Transfer and Disposal of Medication Drug Formulation and Ways of Taking It Course 12: GDPR in Healthcare Introduction to GDPR GDPR and Healthcare Setting General Data Protection Regulations Explained Lawful Basis for Preparation Responsibilities and Obligations Electronic Medical Records Rights and Breaches Course 13: Medical Law An Introduction to Medical Law Legislation on Access to Health, Medical Report, Treatment Legislation on Adult Support Legislation on Public Health and Health Service (Part 1) Legislation on Public Health and Health Service (Part 2) Legislation on Public Health and Health Service (Part 3) Legislation on Public Health and Health Service (Part 4) Legislation on Coronavirus Legislation on Mental Health (Part 1) Legislation on Mental Health (Part 2) Legislation on Abortion Other Legislation (Part 1) Other Legislation (Part 2) Course 14: Level 3 - Coronavirus (COVID -19) Awareness Course Introduction to COVID-19 Understanding of Covid-19 as a Pandemic and How It Is Related to Zoonotic Diseases Like SARS and MERS The Strike of Pandemic Around the World and Great Britain Effects of Covid-19 on Human Life Diagnosis and Treatment Preventions and Social Measures to Be Taken Artificial Intelligence, Data Science and Technological Solutions against Covid-19 CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Neuroscience bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Our Neuroscience is fully compatible with PC's, Mac's, laptops, tablets and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so that you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course; it can be studied in your own time at your own pace. Career path Having this various expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included You will get the PDF Certificate for the title course (Neurology) absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Neurology) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

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

Discover Microsoft Fabric's architecture, master Data Engineering with OneLake and Spark, and elevate your skills in data warehousing and real-time processing. Compare SQL and KQL for better insights, and improve storytelling using Power BI. Finally, you will end with practical data science techniques and data management methods.