Course curriculum

    1. Lesson 1. - Introduction

    2. Lesson 1.1 - From Flat Files to Databases

    3. Lesson 1.2 - What is a Relational Database?

    4. Lesson 1.3 - Primary Keys & Relationships

    5. Lesson 1.4 - Relational vs Non-Relational

    6. Lesson 1.5 - What is SQL

    7. Lesson 1.6 - Practical - Setting Up Our Environment

    8. Lesson 1.7 - Course Project Direction

    1. Lesson 2. Module Introduction

    2. Lesson 2.1 - Exploring Tables Like a Blueprint

    3. Lesson 2.2 - Columns & Data Types

    4. Lesson 2.3 - Primary Keys

    5. Lesson 2.4 - Foreign Keys & Relationships

    6. Lesson 2.5 - Why Data Is Split Across Tables

    7. Lesson 2.6 - Data Profiling Mindset

    8. Lesson 2.7 - Module Wrap Up

    1. Lesson 3. - Module Introduction

    2. Lesson 3.1 - SELECT Statement

    3. Lesson 3.2 - SELECT* vs Specific Columns

    4. Lesson 3.3 - Aliases

    5. Lesson 3.4 - Calculated Fields

    6. Lesson 3.5 - DISTINCT

    7. Lesson 3.6 - ORDER BY

    8. Lesson 3.7 - LIMIT

    9. Lesson 3.8 - Module Wrap Up

    1. Lesson 4. - Module Introduction

    2. Lesson 4.1 - WHERE Clause

    3. Lesson 4.2 - Comparison Operators

    4. Lesson 4.3 – Combining Multiple Conditions

    5. Lesson 4.4 - IN

    6. Lesson 4.5 - BETWEEN

    7. Lesson 4.6 - LIKE

    8. Lesson 4.7 - Handling NULL's

    9. Lesson 4.8 - Aggregation

    1. Lesson 10 - Module Introduction

    2. Lesson 10.1 - Total Sales By Product

    3. Lesson 10.2 - Profit by Product

    4. Lesson 10.3 – Profit Margin Analysis

    5. Lesson 10.4 – Category-Level Performance

    6. Lesson 10.5 – Sub-Category Analysis

    1. Course Feedback Form

About this course

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

Discover your potential, starting today

Enroll today