Getting Started
-
Introducing MySQL (7:14)
-
Installing MySQL and the Workbench (6:20)
-
Using the Command Line (7:10)
-
Creating Tables (9:30)
-
Multiple Columns, int and Data Types (4:47)
-
Null Values and Not Null (8:25)
-
Mysql Storage Engines and Configuration (13:04)
-
SQL Modes (13:43)
-
Deleting All the Data in a Table (4:24)
-
Primary Keys (8:10)
-
Auto Increment (5:12)
-
Narrowing Down Select Statements (5:48)
Importing and Exporting Data
MySQL Operators
Update, Order and Limit
MySQL Data Types
-
MySQL Types (3:14)
-
Text Types (13:01)
-
Floating Point Types and Integers (11:30)
-
Bool (8:48)
-
Blobs - Binary Data (4:48)
-
The Bit Type (6:11)
-
Time, Date and Year (11:23)
-
Timestamp and Datetime (8:54)
-
Enumerations (6:45)
-
Brackets and Conditions Revisited (9:47)
-
Data Types Exercises (5:35)
-
Data Types Solutions to Exercises (8:29)
Aggregate Functions and Grouping
Foreign Keys and Multiple Tables
-
Naming Columns and Tables (6:15)
-
Foreign Keys (11:59)
-
ER Diagrams (8:19)
-
Joins and Cartesian Products (10:22)
-
Inner Joins (5:49)
-
Left and Right Outer Joins (7:51)
-
Joins on Multiple Tables (5:40)
-
Querying Chains of Tables (4:41)
-
One to Many and One to One (4:50)
-
Many to Many (13:28)
-
Joining Tables to Themselves (13:23)
-
Restrict Foreign Keys (12:05)
-
Cascade Foreign Keys (14:19)
-
Exercises 4 (5:04)
-
Solutions 4 (12:07)
Combining Queries
Altering Schemas
Users and Privileges
Locks and Transactions
-
Exclusive Table Locks (10:04)
-
Shared Table Locks (4:34)
-
Using Variables (6:40)
-
Setting Variables with Selects (7:10)
-
A Select-Update Example (9:31)
-
Fixing Select-Updates with Table Locks (6:45)
-
ACID (5:34)
-
A Simple Transaction (11:10)
-
Start Transaction (4:35)
-
InnoDB Row Locking and Isolation (7:01)
-
ACID Isolation Levels (9:42)
-
Serializable and Row vs Table Locking (12:13)
-
Demonstrating the Other Isolation Levels (9:55)
-
Rolling Back to Savepoints (8:00)
-
The Account Transfer Problem (8:39)
-
Select for Update (12:49)
-
Lock in Share Mode (8:33)
MySQL Functions
Stored Procedures
-
Introducing Stored Procedures (2:41)
-
Changing the Delimiter (3:08)
-
Hello World (7:08)
-
Editing Stored Procedures (5:37)
-
Setting the Definer (7:25)
-
Procedure Permissions (6:52)
-
Passing Parameters (5:11)
-
Multiple Parameters (4:18)
-
Select Into Variables (2:44)
-
Out Parameters (5:52)
-
Inout Parameters (6:09)
-
The If Statement (6:10)
-
Local Variables (6:06)
-
Implementing Account Withdrawal (7:36)
-
Transactional Withdrawal (3:26)
-
Errors and Warnings (3:59)
-
Error Handlers (6:50)
-
While Loops (9:57)
-
Labelled Loops (9:59)
-
Generating Random Data (7:59)
-
A Data Generating Procedure (12:24)
-
Cursors (8:25)
-
Fetching Cursor Data in a Loop (11:45)
-
The Case Expression (17:14)
-
Variable Scope and Multiple Cursors (10:54)
-
Procedures Exercises (10:26)
-
Procedures Solutions (14:22)
Triggers
User-Defined Functions
Visual Design
Final Exercise
