Introduction
The Basics
Relationships Between Tables
Searching Through Text
Aggregate Functions
Other Types of Joins
General Query Practice & Review
Stored Routines
Power an App With MySQL
-
Getting The Tools For The Job (8:56)
-
Creating a New Empty Database & User (8:24)
-
Connecting The Web App (14:51)
-
Our "Posts" Table (19:56)
-
Reading, Updating, & Deleting Posts (18:04)
-
Solutions For Tasks #1 - #6 Within Post.js
-
Searching For Posts (9:15)
-
Follows Table (10:40)
-
Follow Queries (19:21)
-
Solutions For Follow Queries Tasks
-
Homepage Feed (Posts From Users You Follow) (12:11)
-
Create Tables Programmatically (11:19)
-
Finished Product Reference Example Files
-
Your New Skills Are In Demand & Portable! (16:21)
