Learn MySQL fundamentals in this comprehensive 41-minute tutorial. Master database creation, table design, data types, primary and foreign keys, SQL queries, and advanced concepts like joins and aggregate functions. Explore practical examples and best practices for efficient database management, covering 95-98% of essential MySQL knowledge in a single video.
Overview
Syllabus
Introduction
MySQL Workbench
MySQL Terminal
Creating a Database
Creating a Table
Primary Keys
Atomic Tables
Additional Rules
Numeric Types
String Types
Set Types
Class
Foreign Keys
Test Data
Insert Data
Rename Tables
Limit Data
Order Data
Distinct
Count
Group By
Allow
Numeric Functions
Absences
Between
In
Join
Join 3 Tables
Left Join
Inner Join
Taught by
Derek Banas
