Autoplay
Autocomplete
Previous Lesson
Complete and Continue
MySQL and SQL for Beginners
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
Exporting and Importing Data (7:06)
Exporting Using the Command Line (5:48)
Importing Using the Command Line (4:31)
MySQL Operators
Some Test Data (3:09)
Comparison Operators (12:43)
Logical Operators (12:47)
Exclusive Or (7:46)
Exercises Part 1 (6:19)
Solutions Part 1 (13:44)
Update, Order and Limit
Beginning Update Statements (6:18)
Order By (4:49)
Limiting Results (3:48)
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
The distinct keyword (6:24)
Counting Distinct Values (6:14)
Aggregate Functions (5:12)
Arithmetic in MySQL (3:52)
The Health Survey Dataset (5:56)
Group By (9:50)
Having: Restricting Groups By Aggregate Functions (7:02)
Exercises 3 (7:59)
Solutions 3 (8:20)
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
Union and Union All (10:02)
Subqueries with "in" (7:02)
Inline Views (8:02)
Altering Schemas
Adding Columns (4:35)
Adding Foreign Keys (8:24)
Adding Indexes (5:40)
Indexes on Multiple Columns (4:14)
Users and Privileges
Creating Users (8:37)
Granting Privileges (9:21)
Views
Creating a Simple View (8:15)
View Algorithms (11:02)
With Check Option (7:16)
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
String Functions (14:07)
Dates, Intervals and Queries (8:29)
Date Diff and Dayname (4:49)
Str_To_Date and Date_Format (11:32)
Control Flow Functions (10:04)
Casting (6:27)
Functions Exercises (5:24)
Functions Solution (15:53)
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
Introducing Triggers (12:46)
Triggers and Validation (7:49)
Triggers and Transactions (15:54)
Triggers Exercise (2:29)
Triggers Exercise Solution (6:29)
User-Defined Functions
Functions vs. Procedures (5:03)
User-Defined Functions (11:37)
Visual Design
Designing Databases Visually (16:36)
Final Exercise
Final Exercise (2:41)
Conclusion (2:24)
Appendix
Connecting With Java (14:29)
Retrieving Data with Java (9:14)
Teach online with
Aggregate Functions
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock