SQL Full Course - Build a Database and Deploy It

You use databases every time you tap your phone. You just don't know it yet. In one hour, you'll go from zero to deploying your own database to the cloud. We'll start from absolute zero — what a database is, CRUD operations, tables, primary keys — then build everything hands-on in MySQL Workbench: constraints, normalization, foreign keys, one-to-one, one-to-many, and many-to-many relationships with real SQL joins powering features like profiles, feeds, and likes. By the end, we'll take it all to production on Amazon RDS. AWS Free Tier: https://go.aws/4vFVZ6S Learn how to get up to $200 AWS credits: https://go.aws/4cwfSWv Amazon RDS: https://go.aws/3Qu0xx7 MySQL Downloads: https://go.aws/4sQoFaD Homebrew (macOS): https://go.aws/48ogISR Follow AWS Developers! 🆇 X: https://go.aws/4w5rNCy 💼 LinkedIn: https://go.aws/48lgVWX 0:00 — Introduction — the technology behind every app 1:20 — What is a database? Persistence & why it matters 2:25 — CRUD operations explained 3:02 — Tables, rows, columns & primary keys 4:01 — Demo: Installing MySQL & MySQL Workbench 7:15 — Setting up MySQL Workbench & your first connection 7:48 — CREATE DATABASE — organizing your data 9:18 — CREATE TABLE — building the users table 11:08 — INSERT INTO — adding your first user 13:08 — SELECT & WHERE — reading and filtering data 16:32 — Constraints: NOT NULL, UNIQUE, CHECK 17:40 — ALTER TABLE — adding rules to an existing table 20:20 — UPDATE — the U in CRUD 21:43 — Why one big table fails (the "junk drawer" problem) 24:28 — Normalization — one source of truth 25:21 — Bad practice demo: the mega-table 28:37 — Doing it the right way — separate tables 29:29 — Foreign keys & one-to-one relationships 34:57 — JOINs — how apps pull data from multiple tables 39:10 — Demo: Writing JOIN queries with ORDER BY 43:22 — LEFT JOIN — including users with no posts 45:11 — Many-to-many relationships (likes system) 47:16 — Demo: Building the likes junction table 52:05 — Amazon RDS — what it is and what it gives you 54:23 — Demo: Spinning up an RDS instance in the AWS Console 56:21 — Connecting MySQL Workbench to your cloud database 58:23 — Cleaning up AWS resources (important!) 59:31 — Recap & what's next: NoSQL & graph databases #AWS #AmazonRDS #Database