SQL Crash Course for Beginners - MySQL & PostgreSQL

This beginner course introduces SQL through a complete example database project using MySQL and PostgreSQL. It covers database and table creation, data types, constraints, CRUD operations, relationships, joins, filtering, ordering, grouping, and aggregate functions.

Syllabus

Intro
What is SQL
A Closer Look at Databases
The Core SQL Syntax
Course Setup
The Example Project
Data Normalization
Planning Tables & Relationships
Creating a New Database
Choosing Identifier Names
Defining Columns
Exploring Key Value Types
Storing Files & Adding More Data Types
Introducing Constraints
Introducing Functions
Primary Keys & Unique IDs
Inserting Data
Querying Data
Updating & Deleting Data
Filtering & Ordering
Adding More Tables
Relations & Foreign Keys
ON DELETE & ON UPDATE
Adding More Tables & Relationships
Many-to-Many Relationships & Linking Tables
Inserting Related Data
Introducing Inner Join
Multiple Joins Combined
Introducing Left Join
Joins & Filtering
LIKE Text Filtering
Introducing Aggregate Functions
Grouping Aggregate Results
The HAVING Clause
Summary