Course curriculum

    1. Lesson 1.0 – Introduction

    2. Lesson 1.1 – SQL fundamentals

    3. Lesson 1.2 – Database Structure

    4. Lesson 1.3 – Environment Setup

    5. Lesson 1.4 – Loading our Database

    6. Lesson 1.4 - Resources

    7. Lesson 1.5 – MySQL Workbench Tour

    8. Lesson 1.6 – Module Wrap Up

    9. Module 1 - Quiz

    1. Lesson 2.0 – Introduction

    2. Lesson 2.1 - The Schema

    3. Lesson 2.2 - User Table

    4. Lesson 2.3 – Projects & Tasks Tables

    5. Lesson 2.4 - Comments & Task_Tags Tables

    6. Lesson 2.5 - Inspect the Schema

    7. Lesson 2.6 – Knowing the Data

    8. Lesson 2.7 – Module Wrap Up

    9. Module 2 - Quiz

    1. Lesson 3.0 – Introduction

    2. Lesson 3.1 – The SELECT statement

    3. Lesson 3.2 – Aliases & Calculated Fields

    4. Lesson 3.3 – Distinct & ORDER BY

    5. Lesson 3.4 – LIMIT & Combining It All

    6. Lesson 3.5 – Module Wrap Up

    7. Module 3 - Quiz

    1. Lesson 4.0 – Introduction

    2. Lesson 4.1 – The WHERE Clause & Comparison Operators

    3. Lesson 4.2 – AND, OR, IN & NOT IN

    4. Lesson 4.3 – BETWEEN & LIKE

    5. Lesson 4.4 – IS NULL, IS NOT NULL & Combining It All

    6. Lesson 4.5 - Module Wrap Up

    7. Module 4 - Quiz

    1. Lesson 5.0 - Introduction

    2. Lesson 5.1 - JOIN & INNER JOIN

    3. Lesson 5.2 - LEFT JOIN

    4. Lesson 5.3 - RIGHT JOIN - Joining More Than Two Tables

    5. Lesson 5.4 - Table Aliases in JOINS

    6. Lesson 5.5 – Module Wrap Up

    7. Module 5 - Quiz

    1. Lesson 6.0 – Introduction

    2. Lesson 6.1 – Aggregation

    3. Lesson 6.2 – GROUP BY & JOINS

    4. Lesson 6.3 – HAVING

    5. Lesson 6.4 – Combining it All

    6. Lesson 6.5 – Module Wrap Up

    7. Module 6 - Quiz

About this course

  • £199.00
  • 92 lessons
  • 0 hours of video content

Discover your potential, starting today

Enroll today