8976 Courses delivered Online

Let’s face it — good skin never goes out of style. Whether you're curious about what actually causes breakouts or wondering if expensive serums are worth the hype, this Dermatology & Skincare Course dives deep into the science behind skincare without drowning you in fluff. From understanding the layers of the skin to exploring how lifestyle, diet, and common products affect it — you’ll explore everything skin-related with clarity, precision and just the right amount of wit. This course is ideal for anyone looking to build strong knowledge about dermatology and skincare, whether for personal use or to support a skincare-related role. It doesn’t matter if you’re a skincare enthusiast or someone working in beauty or wellness — you’ll find each module straightforward, jargon-free, and surprisingly enjoyable. Forget the myths, ignore the miracle cures — this course deals in facts, skin science, and well-structured knowledge, all from the comfort of your device. If you're ready to understand what your skin really needs, this course is your go-to guide — no microscope required. Learning Outcomes of Dermatology & Skincare Course Identify fundamental concepts in dermatology. Understand the structure and function of skin. Recognise essential nutrients for skin health. Diagnose common skin diseases and conditions. Analyse various skin infections and treatments. Tailor skincare routines for diverse skin types. Implement anti-ageing techniques and strategies. Apply sunburn prevention and remedies effectively. Key Features This Dermatology & Skincare Course Includes: CPD Accredited Dermatology & Skincare Course Instant e-certificate Fully online, interactive Dermatology & Skincare course with audio voiceover Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Dermatology & Skincare Course Curriculum Module 01: Basics of Dermatology Module 02: Skin Anatomy Module 03: Skin Nutrients Module 04: Diagnosis of Skin Disease Module 05: Skin Infections Module 06: Atopic Eczema Module 07: Care of Different Skin Types Module 08: Different Ethnicities Skin Care Module 09: Reducing Ageing Effects Module 10: Acne and Its Remedies Module 11: Seasonal Skin Care Module 12: Effect of the Sunburn and It's Remedies Accreditation All of our courses are fully accredited, including this Dermatology & Skincare Course, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in Dermatology & Skincare. Certification Once you've successfully completed your Dermatology & Skincare Course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our Dermatology & Skincare Course certification has no expiry dates, although we do recommend that you renew them every 12 months. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Dermatology & Skincare Course can be taken by anyone who wants to understand more about the topic. With the aid of this Dermatology & Skincare course, you will be able to grasp the fundamental knowledge and ideas. Additionally, this Dermatology & Skincare Course is ideal for: Beauty enthusiasts wanting to improve their skincare knowledge Makeup artists seeking to enhance their expertise Aspiring dermatologists and skincare professionals Individuals with Dermatology & Skincare issues desiring self-care solutions Parents wanting to care for their children's skin Health and wellness coaches looking to expand their services Requirements Learners do not require any prior qualifications to enrol on this Dermatology & Skincare Course. You just need to have an interest in Dermatology & Skincare Course. Career path After completing this Dermatology & Skincare Course you will have a variety of careers to choose from. The following job sectors of Dermatology & Skincare Course are: Dermatology Nurse - £25-40k/year Skincare Specialist - £20-35k/year Beauty Therapist - £18-30k/year Medical Aesthetician - £20-40k/year Cosmetic Dermatology Consultant - £45-80k/year Skincare Product Developer - £25-60k/year Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Dive deeper into economic principles with our Intermediate Economics Course. Explore advanced concepts, analyze real-world scenarios, and sharpen your understanding of market dynamics, policy implications, and economic decision-making. Take your knowledge to the next level and thrive in economic discourse. Enroll now!

Master the art of architectural drawing with this compact course. From floor plans to furniture placement, hatching to text insertion, learn essential skills for creating professional architectural drawings. Suitable for aspiring architects, designers, and drafters, this course empowers you to create stunning architectural designs with confidence and precision.

Master the art of effective communication with 'The Complete English Spelling, Punctuation, and Grammar Course.' Enhance your writing skills, conquer tricky spelling rules, and perfect punctuation with comprehensive lessons. This online course is your key to polished and error-free writing. Elevate your language proficiency today!

Financial Analysis: Finance Reports Course Overview Financial Analysis: Finance Reports is a practical course that helps you decode company reports like a pro. From understanding the income statement and balance sheet to evaluating cash flows and investment performance, this course gives you the tools to analyse financial health with confidence. Designed for beginners and professionals alike, this instructor-led training uses real-world scenarios to teach key financial analysis skills. The course is fully online with recorded video lessons, allowing you to learn at your convenience and build a strong foundation in interpreting business performance. Extra Included: Free Accredited Certificate Included Lifetime Access Free Student ID Card Learning Outcome Understand the structure and purpose of a 10-K report Analyse profitability using income statements Evaluate operational efficiency and link it to financial results Conduct a balance sheet analysis to assess financial strength Examine cash flow generation and its impact Perform basic investment analysis and decision-making Why Choose This Course? Financial reporting can seem daunting, but this course breaks it down into clear, easy-to-follow steps. You’ll gain the skills to read and interpret reports used by analysts, investors, and business leaders. Perfect for aspiring finance professionals or anyone who wants to make smarter financial decisions. Who Is This Course For This course is perfect for anyone with basic BSL knowledge who wants to advance their skills. It's ideal for professionals in education, healthcare, or customer service, as well as anyone looking to communicate better with the Deaf community. Entry Requirements No previous experience is needed — just a willingness to learn and apply financial thinking. Accredited Certification After successfully completing the course, you can get a UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. For the PDF certificate, you’ll need to pay £9.99. You can get the hard copy for 15.99, which will reach your doorstep by post.

Overview Become a certified TEFL and TESOL teacher with this accredited course and learn how to teach English as a second language. This specially designed TEFL and TESOL Teacher Essentials course is CPD accredited and Bite-size modules will teach you what you need to become a language trainer within the shortest period of time. The TEFL and TESOL Teacher Essentials course will guide learners on how to teach English pronunciation, basic grammar, reading and writing to the students who do not use English as their primary language. You can do the course at your own pace and a professional certificate will be provided as soon as you are done. Besides, it will add 10 CPD points to your CV. The essentials of classroom management will also be discussed, from lesson planning to goal-setting and task-based learning. Through practical and theoretical training, you will be introduced to a range of language teaching methodologies and models that have influenced modern teaching practices, including learning how to use digital tools for creating dynamic and engaging lessons. All the lessons of this TEFL and TESOL Teacher Essentials course have been designed in such a way that anyone with no prior knowledge on the subject can easily dive into them. Get qualified in no time and kickstart your career. What You Will Learn The role, skills and responsibilities of a Language Teacher Fundamentals of pronunciation, phonetics and sentence structure Tips for teaching English language Teaching models that have influenced current teaching practices How to plan lessons and learning activities in a classroom setting How to set learning goals and objectives for your pupils Digital tools for teaching in a modern classroom environment Skills You Will Gain Classroom management Lesson planning Excellent language skills Knowledge of teaching methodologies Pupil motivation Organisation Who Is This Course For This TEFL and TESOL Teacher Essentials course is ideal for anyone who wants to: Gain a formal, accredited qualification to fast track their career Learn more about the role of a language teacher Test their skills and knowledge to become a more competent professional Use their love of languages to earn some extra income Career Path Become a language teacher and teach in a classroom environment or at students' homes. Career Opportunities in this field include the following: TEFL Teacher TESOL Teacher English pronunciation Instructor SEN Teacher Language Tutor Why Choose Teachers Training Some of our features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Numeracy and IT Desire for entrepreneurship Over the age of 16 Assessment The assessment is straightforward, you need to complete the assignment questions that will be provided to you at the end of the course, you can complete the assignment anytime you want. After you complete and submit your assignment, our tutors will assess your assignment and give you feedback if needed.  After your assignment has been assessed and you have passed, you will be qualified and will be able to apply for a course completion certificate. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Professional Development Certificate for TEFL Teachers Professional Development and Employment 00:27:00 Advanced Course on Linguistics for TEFL Teachers Linguistics 00:45:00 Language Teaching Methodologies for TESOL Teachers Language Teaching Methodologies 00:23:00 English Pronunciation Course for TESOL Teachers English Pronunciation 00:30:00 Essentials of Teaching for TESOL Teachers Teaching Grammar and Vocabulary 00:33:00 Teaching Receptive Skills Reading 00:16:00 Teaching Productive Skills Writing 00:13:00 Teaching Receptive Skills Listening 00:14:00 Teaching Productive Skills Speaking 00:14:00 Lesson Planning and Creating Materials 00:28:00 Classroom Management and Student Motivation 00:30:00 Teaching English Situational Approach 00:35:00

Overview of Google Classroom Essentials Google Classroom Essentials is a helpful course for teachers who want to use digital tools to improve how they teach. After the pandemic, more UK schools have started using online platforms. Over 170 million students and teachers around the world now use Google for Education. This means learning how to use Google Classroom Essentials has become very important for modern-day teaching. The course shows you how to create and manage your online classroom simply and clearly. In this course, you will learn how to set up your first virtual class, share work with students, give feedback, and make grading easier. It also helps with organising lessons, talking to students, and using tools that help with teamwork. Whether you are just starting with online teaching or want to improve the way you already teach digitally, this Google Classroom Essentials course is made to support your progress step by step. The UK education system has seen a 300% rise in digital learning. Because of this, more schools are looking for teachers who can use tools like Google Classroom Essentials. This course helps you build the skills needed for today’s classrooms. With practical training and simple methods, Google Classroom Essentials gives you the support you need to become more confident with digital teaching and meet the needs of students in a changing world. Learning Outcomes By the end of this Google Classroom Essentials course, you will be able to: Set up and manage your Google Classroom account easily Find your way around the classroom dashboard and adjust the settings Add other teachers and invite students to your online class Create and organise assignments, share learning materials, and post updates Use marking rubrics and keep track of student progress Create quizzes and ask questions using built-in classroom tools Who is this course for This course is a good fit for: Primary and Secondary School Teachers who want to bring digital tools into their classrooms and support students aged 5–18 with better learning University Lecturers and Education Staff who want an easier way to share course content, manage assignments, and stay connected with students Corporate Training Managers who need a smart way to deliver training and learning materials to employees Tutoring Centre Coordinators who work with many students and need a clear system to manage classes, track progress, and share resources Support Staff in Education, such as teaching assistants or learning mentors, who help with classroom tasks and support student learning Process of Evaluation After studying the Google Classroom Essentials Course, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Google Classroom Essentials Course, you can order your CPD Accredited Digital / PDF Certificate for £5.99. (Each) Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. (Each) Shipping Charges: Inside the UK: £3.99 International: £10.99 Requirements You don't need any educational qualification or experience to enrol in the Google Classroom Essentials course. Career Path: Completing the Google Classroom Essentials course can support your move into roles such as: Teaching Assistant – £18,000 to £25,000 per year Primary School Teacher – £28,000 to £45,000 per year Secondary School Teacher – £28,000 to £50,000 per year Educational Technology Coordinator – £25,000 to £40,000 per year Corporate Training Specialist – £30,000 to £48,000 per year Course Curriculum Unit 01: Setting up your Classroom Getting Google Account and Signing in 00:02:00 Creating a Class 00:04:00 Classroom Navigation 00:09:00 Class Settings 00:04:00 Add Co-Teacher and Students 00:09:00 Creating of Additional Class 00:02:00 Google Drive Structure & Class options 00:07:00 Unit 02: Managing Google Classroom Topics 00:07:00 Assignment 00:14:00 Assignment Dashboard & Student Communication 00:06:00 To Do List and Calendar 00:05:00 Materials 00:06:00 Announcement 00:06:00 Quiz Assignments 00:17:00 Questions 00:03:00 Reusing Posts 00:05:00 Grade 00:05:00 Rubric 00:11:00 Unit 03: Bonus (Update) Join Google Classroom using link 00:02:00 Google Classroom Home Page Changes 00:01:00

Learn from relevant industry professionals and quickly equip yourself with the specific knowledge and skills needed to excel in your chosen career through the Counselling : Counsellor Training bundle training. Study the course and get an expertly designed training experience. Improve your knowledge and enhance the skills you need to succeed as a professional in any workplace with this Counselling : Counsellor Training Bundle. Designed to build your professional skill set and enable you to do the best job possible, the Bundle course is ideal for those who aim to be the best in their fields. Our Counselling : Counsellor Training Bundle Course contains 8 of our premium popular courses for one discounted price: Course 01: Couples Therapy and Counselling Course 02: Mental Health Awareness Course Course 03: Counselling and Psychotherapy Course Course 04: Anti-Social Behaviour Course Course 05: Life Coaching and Counselling Course 06: Child Development & Psychology Diploma Course 07: Dialectical Behaviour Therapy (DBT) Course 08: Dual Diagnosis Level 2 Students can expect to complete this Counselling : Counsellor Training Bundle Program in around 38 hours. Get dedicated student support from our expert instructors if you need assistance or have any questions about the Bundle courses. All the courses under this Bundle are split into a number of expertly created modules to provide you with an in-depth and professional learning experience. Students who successfully complete this program will receive an instant e-certificate as proof of their new skills and knowledge. Stand out from the crowd and train for the job you want with the Bundle Courses. With this comprehensive Bundle, you can achieve your dreams and train for your ideal career. The Counselling : Counsellor Training Bundle provides students with an in-depth learning experience that they can work through at their own pace to enhance their professional development. The Counselling : Counsellor Training Bundle covers everything you need in order to progress in your chosen career. Enrolling in the Counselling : Counsellor Training Bundle will ensure that you land your dream career faster than you thought possible. Stand out from the crowd and train for the job you want with the Bundle Course. Why Train With the Academy for Health & Fitness? All-in-one package of 8 Premium Bundle Courses Opportunity to earn a certificate accredited by CPD after completing this Bundle course Interactive Bundle course material The online assessment included testing your knowledge Globally accepted standard structured lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support Start your learning journey straight away with this Counselling : Counsellor Training Bundle and take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the courses: Course 01: Couples Therapy and Counselling Module 01: Introduction Module 02: Communication Module 03: Conflict Resolution Module 04: Intimacy Module 05: Pre-Marital Counselling Module 06: Healthy Fighting Module 07: Affairs Module 08: Apology & Forgiveness Module 09: Adapting to Changes Module 10: Moving Forward Together Course 02: Mental Health Awareness Course Introduction Childhood And Adolescent Psychiatric Disorders Anxiety and Stress Disorders Mood Disorders Eating and Sleeping Disorders Self-Harm and Suicide Social Attitudes To Mental Illness Dealing with Stress in the Workplace Additional Reading Materials Course 03: Counselling and Psychotherapy Course Module 01: Introduction to Counselling Module 02: Types of Counselling Module 03: Introduction to Psychotherapy Module 04: Therapeutic Relationship Module 05: Counselling and Psychotherapy Module 06: Dynamic Psychotherapy Module 07: Mental Health Conditions Module 08: Mental Disorders Module 09: Psychotherapy Healing Course 04: Anti Social Behaviour Course Module 01: Overview of Anti-social Behaviour Module 02: Family Influences on Anti-social Behaviour Module 03: Anti-Social Behaviour Order Module 04: Anger and Anti-social Behaviour Module 05: Understanding Antisocial Personality Module 06: Prevention of Anti-social Behaviour Course 05: Life Coaching and Counselling Introduction PART 01: LIFE COACHING CERTIFICATION Coaching Fundamentals Understanding Personalities Coaching Models Explained Why We Will Use The GROW Model Coaching Step 2: Reality Coaching Step 3: Options & Obstacles Coaching Step 4: Will & Action Planning How To Structure Your Coaching Sessions Client Coach Relationship Advanced Coaching Strategies PART 02: HOLISTIC HEALTH COACHING CERTIFICATION Diet & Nutrition Fundamentals Diet & Nutrition Coaching Exercise Coaching: Cardio Exercise Coaching: Resistance Training Hormone Health Explained Supplements Health & Fitness Motivation Health & Fitness FAQ Answered PART 03: WELLNESS COACHING CERTIFICATION Stress Management Sleep Emotional Self Care Resources Course 06: Child Development & Psychology Diploma Babies from Birth to One Year Stages and Sequences of Social and Emotional Development Language and Linguistic Skills Development Cognitive Development Course 07: Dialectical Behaviour Therapy (DBT) Introduction What is Counselling & Psychotherapy About Dialectical Behaviour Therapy (DBT) DBT Strategies & 'Life Skills' Treatment by DBT DBT for Psychological Disorders Effectiveness of DBT Course 08: Dual Diagnosis Level 2 Module 01: Dual Diagnosis: A Challenge of New Era Module 02: Drugs and Their Effects Module 03: Mental Health: An Introduction Module 04: Brain Works - Neurophysiology Module 05: Harm Minimisation and Optical Health Module 06: Models of Care and Dual Diagnosis Module 07: Psychological Interventions in Dual Diagnosis Module 08: Practice and Policy Issues Module 09: Ethical Issues and Mental Health Act Module 10: The Assessment Process in Dual Diagnosis Module 11: Treatment in Dual Diagnosis Assessment Process Once you have completed all the modules in the Counselling Bundle , you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 85 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Counselling : Counsellor Training Bundle is ideal for anyone interested in this topic and who wants to learn more about it. This Bundle will help you gain a strong understanding of the core concepts and will allow you to gain in-depth knowledge of the subject matter. Career path This Bundle course will allow you to kickstart or take your career in the related sector to the next stage. Our whole Counselling Bundle course will assist you in achieving a position of respect and dignity, as well as allowing you to gain an advantage over your competitors. The certificate will strengthen your CV and assist you in finding work in the related industry. Certificates CPDQS Accredited Certificate Digital certificate - £10 Upon passing the Bundle, you need to order to receive a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPDQS. CPDQS Accredited Certificate Hard copy certificate - £29 Upon passing the Bundle, you need to order to receive a Hard Copy certificate for each of the courses inside this bundle as proof. If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

This comprehensive course, 'SQL for Data Science, Data Analytics, and Data Visualization,' covers essential SQL concepts and tools for working with data. Participants will learn to manipulate, analyze, and visualize data using SQL Server, Azure Data Studio, and other relevant tools. The course also delves into advanced SQL commands, stored procedures, and data import/export, making it ideal for aspiring data professionals. Learning Outcomes: Set up and configure SQL Server and SQL Azure Data Studio for data analysis. Master SQL statements for data manipulation, data structure, and user management. Utilize SQL queries, joins, and aggregate functions for efficient data analysis. Understand SQL constraints, views, and advanced commands for in-depth data exploration. Create and implement SQL stored procedures to automate tasks. Leverage Azure Data Studio for data visualization and perform data analysis with SQL. Why buy this SQL for Data Science, Data Analytics and Data Visualization? 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 SQL for Data Science, Data Analytics and Data Visualization there will be a written assignment test which you can take either during or at the end of the course. 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 SQL for Data Science, Data Analytics and Data Visualization course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This SQL for Data Science, Data Analytics and Data Visualization does not require you to have any prior qualifications or experience. You can just enrol and start learning.This SQL for Data Science, Data Analytics and Data Visualization 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 As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This SQL for Data Science, Data Analytics and Data Visualization is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Getting Started Introduction 00:03:00 How to get course requirements 00:03:00 Getting started on Windows, Linux or Docker 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 Section 02: SQL Server setting up Section Introduction 00:02:00 Microsoft SQL Server Installation 00:19:00 SQL Server Management Studio (SSMS) Installation 00:08:00 How to connect MS SQL (Windows Authentication) 00:04:00 How to connect MS SQL (SQL Server Authentication) 00:03:00 Download and Restore Sample Database 00:07:00 Section 03: SQL Azure Data Studio What is Azure Data Studio 00:06:00 Azure Data Studio Installation steps 00:07:00 Azure Data Studio to Connect SQL Server 00:09:00 Create a Database 00:07:00 Create a Table 00:09:00 Insert Data rows 00:07:00 View the Data returned by Query 00:03:00 Section 04: SQL Database basic SSMS Section Introduction 00:01:00 Overview of Databases8 00:11:00 Creating Database 00:05:00 SQL Data Types 00:03:00 Column Data Types on SSMS 00:04:00 Creating Table 00:09:00 Overview of Primary Key and Foreign Key 00:04:00 Primary Key 00:04:00 Foreign Key 00:07:00 Creating Temporary tables 00:06:00 Section 05: SQL Statements for DATA Section Introduction 00:01:00 Insert statement 00:08:00 Update statement 00:05:00 Delete statement 00:03:00 Section 06: SQL Data Structure statements Section Introduction 00:01:00 CREATE table statement 00:03:00 DROP statement 00:02:00 ALTER statement 00:05:00 TRUNCATE statement 00:04:00 COMMENT in query 00:01:00 RENAME 00:02:00 Section 07: SQL User Management Create Database user 00:04:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 08: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:07:00 SELECT DISTINCT 00:03:00 SELECT with column headings 00:03:00 Column AS statement 00:02:00 Section 09: Filtering Data rows SELECT WHERE Clause - theory 00:04:00 SELECT WHERE Clause - practical 00:07:00 Section 10: Aggregate functions Sum() 00:08:00 Min()-Max() 00:06:00 Section 11: SQL Query statements Order By statement 00:05:00 SELECT TOP clause in SQL 00:04:00 BETWEEN command 00:08:00 IN operator 00:04:00 Wildcard Characters and LIKE 00:05:00 Section 12: SQL Group by statement Section Introduction 00:01:00 Group by - theory8 00:03:00 Group by - practical 00:05:00 HAVING statement 00:04:00 Section 13: JOINS for Multiple table Data Analysis Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:08:00 Left outer join 00:03:00 Right outer join 00:02:00 Full outer join 00:01:00 Union 00:03:00 Cartesian Product with the Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 14: SQL Constraints Section introduction 00:01:00 Check constraint 00:07:00 NOT NULL constraint 00:08:00 UNIQUE constraint 00:05:00 Section 15: Views Creating Views 00:04:00 Reporting with multiple tables 00:03:00 Section 16: Advanced SQL commands Section Introduction 00:01:00 Timestamp 00:04:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:04:00 String functions 00:05:00 Sub Query 00:03:00 SELECT with calculations 00:06:00 Section 17: SQL Stored procedures Create stored procedure 00:05:00 Stored procedure with parameter 00:04:00 Section 18: Azure Data Studio Visualization Installing SandDance Extension 00:03:00 Visualization Charts 00:05:00 Multiple Table Data Charts 00:06:00 Section 19: Azure Studio SQL for Data Analysis Type Decision for Data Analysis 00:13:00 Data Analysis with Case Statement and String Text 00:09:00 Section 20: Import & Export data Section Introduction 00:01:00 Import Flat File 00:05:00 Import .csv or excel file 00:03:00 Export Data to Excel or any format 00:06:00 Section 21: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:04:00 Restoring Database backup 00:04:00

Master Web Design using HTML5, CSS3, and Bootstrap. Dive deep into designing modern, responsive websites that impress.