The Complete SQL For Absolute Beginners Course

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Course Materials

Chapter 2: Installing MySQL and Loading the Sakila DataBase

Lecture 1: Installing MySQL Server and Workbench

Lecture 2: Installing MySQL On Mac

Lecture 3: [Windows] – Starting MYSQL Server from Scratch

Lecture 4: Setting up the Sakila Database

Chapter 3: Basic Querying

Lecture 1: Basic Select Statements

Lecture 2: Column and Table Aliases

Lecture 3: Table Filtering – Simple Filters

Lecture 4: Table Filtering – Multiple Filters, AND and OR

Lecture 5: Table Filtering – Other Concepts

Lecture 6: Creating New Columns – Same Value for all Rows

Lecture 7: Creating New Columns – Using Functions and Existing Columns

Lecture 8: Creating New Columns – Mathematical Expressions

Lecture 9: Query Clauses – Group By

Lecture 10: Query Clauses – Having

Lecture 11: Query Clauses – Order By

Lecture 12: [Case Study] – Basic Querying

Lecture 13: [Case Study] – Code Along Solutions

Lecture 14: Tutorial on [Coding Exercises]

Chapter 4: Data Types

Lecture 1: Data Types – Integers

Lecture 2: Data Types – Decimals/Floats

Lecture 3: Data Types – Text and Characters

Lecture 4: Data Types – Dates

Lecture 5: Data Types – Implicit Conversions

Lecture 6: Data Types – Explicit Conversions

Lecture 7: [Case Study] – Data Types

Lecture 8: [Case Study] – Code Along Solutions

Chapter 5: Creating and Modifying Tables

Lecture 1: Create Database Command

Lecture 2: Creating Tables

Lecture 3: Inserting Data into a Table

Lecture 4: Inserting Multiple Rows and Inserting Into Specific Columns

Lecture 5: Common Pitfalls when Inserting Data

Lecture 6: Deleting Data and Tables

Lecture 7: Alter Table – Changing and Modifying Tables

Lecture 8: [Case Study] – Creating and Modifying Tables

Lecture 9: [Case Study] – Code Along Solutions

Lecture 10: Detail on the Udemy Platform Coding Exercises

Chapter 6: Combining Tables

Lecture 1: Table Join Example

Lecture 2: Inner Join Explanation

Lecture 3: Left and Right Join Explanation

Lecture 4: Multiple Key Joins – Composite Key Definition

Lecture 5: Multiple Key Joins – Explanation and Syntax

Lecture 6: Union and Union All

Lecture 7: [Case Study] – Combining Tables

Lecture 8: [Case Study] – Code Along Solutions

Chapter 7: More on Select Statements

Lecture 1: SubQueries Introduction

Lecture 2: More on SubQueries

Lecture 3: Combining Insert Into and Select Statements

Lecture 4: Insert Into and Select with Multiple Columns

Lecture 5: [Case Study] – More on Select Statements

Lecture 6: [Case Study] – Code Along Solutions

Chapter 8: Updating Information on Tables

Lecture 1: Update -> Set -> Where Sequence

Lecture 2: Updating Tables with Multiple Conditions

Lecture 3: Updating Multiple Columns and Where Clause Warning

Lecture 4: [Case Study] – Updating Information on Tables

Lecture 5: [Case Study] – Code Along Solutions

Chapter 9: Advanced Filtering

Lecture 1: The NOT Clause

Lecture 2: Filtering – Order of Operations