This site is powered by
course builder. Create your online course today.
Start now
Create your course
with
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)
Introducing Stored Procedures
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock