SQL Crash Course for Beginners - MySQL & PostgreSQL

Overview

Embark on a comprehensive SQL crash course designed for beginners, covering both MySQL and PostgreSQL with no prior knowledge required. Learn the fundamentals of databases, core SQL syntax, and data normalization before diving into practical skills like creating databases, defining columns, and implementing constraints. Master essential operations such as inserting, querying, updating, and deleting data, as well as advanced concepts including relationships, foreign keys, and various types of joins. Explore filtering techniques, aggregate functions, and grouping results to enhance your data manipulation capabilities. By the end of this 3-hour 26-minute tutorial, gain a solid foundation in SQL to kickstart your journey in database management and querying.

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