Autoplay
Autocomplete
Previous Lesson
Complete and Continue
MySQL For Beginners: Real Database Experience Real Fast
Introduction
Welcome To The Course! (13:26)
Getting Started (6:38)
Installation Notes (Best Versions of Software)
Installing on Windows (15:00)
Installing on Mac (12:23)
Installing on Linux (12:50)
The Basics
Let's Get To Work (9:53)
Quick Note About Workbench (3:40)
Our First Table (19:04)
What Is A Primary Key? (10:10)
Additional Data Types (17:36)
Products Table (8:11)
Relationships Between Tables
Relating One Table With Another (14:12)
Order Details (Part 1) (11:38)
Order Details (Part 2) (10:21)
What Is An Index? (10:47)
Foreign Keys (19:58)
Quick Note
Searching Through Text
Searching For a Keyword or Phrase (17:59)
Aggregate Functions
Aggregate Functions (19:13)
Note About "GROUP BY"
Other Types of Joins
Left and Right Joins (15:39)
Full Outer Joins (12:53)
General Query Practice & Review
Practice & Review Part 1 (10:40)
Practice & Review Part 2 (13:07)
Stored Routines
Stored Functions (18:51)
Stored Procedures (19:59)
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)
Teach online with
Relating One Table With Another
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock