The Comprehensive SQL Course

Course Curriculum

Chapter 1: Introduction and Set Up

Lecture 1: Course Overview

Lecture 2: Udemy Basics

Lecture 3: Relational Databases

Lecture 4: What is MySQL?

Lecture 5: What is SQL?

Lecture 6: Objects in MySQL

Lecture 7: MySQL Installation Overview

Lecture 8: MySQL Installation on Windows OS

Lecture 9: MySQL Installation on Mac OS

Lecture 10: MySQL Workbench UI Overview

Lecture 11: Adding the Countries Data

Lecture 12: Course Resources PDF + Lecture Downloads!

Chapter 2: Data Query Language

Lecture 1: Section Overview

Lecture 2: The SELECT Statement

Lecture 3: USE SCHEMA

Lecture 4: Statements vs Queries

Lecture 5: SELECT STAR (*)

Lecture 6: Aliasing Column Names

Lecture 7: Aliasing Table Names (and Qualifying Columns)

Lecture 8: Adding Comments to SQL Code

Lecture 9: Selecting Distinct Rows

Lecture 10: Ordering Rows

Lecture 11: Limiting Rows

Lecture 12: Order of Execution (So Far)

Lecture 13: Syntax Differences Across Databases

Chapter 3: Challenge Section 1

Chapter 4: Data Types

Lecture 1: Section Overview

Lecture 2: Numeric Data Types

Lecture 3: String Data Types

Lecture 4: Date and Time Data Types

Lecture 5: The Describe Statement

Lecture 6: Data Type Differences Across Databases

Chapter 5: Data Definition and Manipulation Language

Lecture 1: Section Overview

Lecture 2: Creating and Dropping Tables

Lecture 3: Creating and Dropping Schemas

Lecture 4: Inserting Rows

Lecture 5: Inserting Multiple Rows

Lecture 6: Create Table As (CTAS)

Lecture 7: Truncating Tables

Lecture 8: Alter Table

Lecture 9: Updating and Deleting Rows

Lecture 10: Constraints in SQL

Lecture 11: Not Null Constraint

Lecture 12: Unique Constraint

Lecture 13: Default Constraint

Lecture 14: Check Constraint

Lecture 15: Dropping the Not Null and Default Constraints

Lecture 16: Dropping the Unique and Check Constraints

Chapter 6: Relational Database Design

Lecture 1: Section Overview

Lecture 2: Normalization

Lecture 3: Types of Relationships

Lecture 4: Primary and Foreign Keys

Lecture 5: Primary and Foreign Keys (Demo)

Lecture 6: Entity Relationship Diagrams (ERD)

Lecture 7: Tidying Up Our Schemas

Lecture 8: Syntax Differences Across Databases

Chapter 7: HR and Customer Orders Schema

Lecture 1: HR Schema

Lecture 2: Customer Orders Schema

Chapter 8: Challenge Section 2

Lecture 1: Assignment 1

Lecture 2: Assignment 2

Lecture 3: Assignment 3

Chapter 9: SQL Operators and the Where Clause

Lecture 1: Section Overview

Lecture 2: Introduction to the Where Clause

Lecture 3: Comparison Operators and the Where Clause

Lecture 4: Null Values

Lecture 5: Arithmetic Operators, Expressions and Order of SQL Execution

Lecture 6: Logical Operators

Lecture 7: Pattern Matching with the LIKE Operator

Lecture 8: Recapping DDL and DML Statements

Lecture 9: Syntax Differences Across Databases

Chapter 10: Challenge Section 3

Lecture 1: Assignment 1

Lecture 2: Assignment 2

Lecture 3: Assignment 3

Chapter 11: Internal and Metadata Schemas

Lecture 1: Internal and Metadata Schemas in MySQL

Lecture 2: Information Schema Demo

Chapter 12: SQL Functions

Lecture 1: Section Overview

Lecture 2: String Functions – Concat

Lecture 3: String Functions – Upper and Lower

Lecture 4: SQL Literals

Lecture 5: String Functions – Length

Lecture 6: String Functions – Right and Left

Lecture 7: String Functions – Substring and Mid

Lecture 8: String Functions – Locate

Lecture 9: Numerical Functions – Round and Truncate

Lecture 10: Numerical Functions – Abs

Lecture 11: Date and Time Functions – Current Time, Date and Timestamp