Autoplay
Autocomplete
Previous Lesson
Complete and Continue
MySQL Database Development Mastery
Introduction
Introduction to MySQL Server and its Databases (6:33)
Downloading and Installing MySQL and MySQL Workbench (12:23)
Manipulating Tables and Data – CRUD Operations
Creating and Connecting to a Database (12:50)
Dropping or Removing a Database (3:40)
Creating an SQL Database Table (22:59)
Inserting Data into the Table with an SQL Script (8:49)
Inserting Data into the Table with Workbench (9:04)
Selecting Data from the Table with an SQL Script (8:09)
Selecting Data with Filters (19:53)
Updating Data in the Table (8:33)
Deleting Data from the Table (10:20)
Reverse Engineering a Database into a Model (6:54)
Forward Engineering a Data Model into a Database (11:44)
Relationships and Foreign Keys
What are Relationships, Foreign Keys, and Normalization? (10:49)
Creating Relationships with Data Modelling (15:28)
Creating Relationships with the Workbench Table Design Tool (20:24)
Inserting Records in Related Tables (8:55)
Running Queries on Related Tables (INNER JOIN) (15:21)
LEFT, RIGHT, and CROSS JOINS (7:07)
Aggregate Functions
Grouping Data using the SQL GROUP BY Clause (9:52)
SQL AVG Aggregate Function (9:00)
SQL COUNT Aggregate Function (7:45)
SQL MIN and MAX Aggregate Functions (2:53)
SQL SUM Aggregate Function (5:18)
Splitting Groups Using the HAVING Clause (4:33)
What are Relationships, Foreign Keys, and Normalization?
This video explains the concepts of relationships, foreign keys, and normalization in a database.
Complete and Continue