| Unit 01: Introduction |
|
Module 01: Introduction to MySQL Server and Databases |
|
00:07:00 |
|
Module 02: Download and Install MySQL Server and MySQL Workbench |
|
00:12:00 |
| Unit 02: Manipulating Tables and Data - CRUD Operations |
|
Module 01: Connect and Create a Database |
|
00:13:00 |
|
Module 02: Drop or Remove Database |
|
00:04:00 |
|
Module 03: Create an SQL Database Table |
|
00:23:00 |
|
Module 04: Insert Data into the Table with SQL Script |
|
00:09:00 |
|
Module 05: Insert Data into the Table with Workbench |
|
00:09:00 |
|
Module 06: Select Data from the Table with SQL Script |
|
00:08:00 |
|
Module 07: Select Data with Filters |
|
00:20:00 |
|
Module 08: Update Data in the Table |
|
00:09:00 |
|
Module 09: Delete Data from the Table |
|
00:10:00 |
|
Module 10: Reverse Engineer Database into Model |
|
00:07:00 |
|
Module 11: Forward Engineer Data Model into Database |
|
00:12:00 |
| Unit 03: Relationships and Foreign Keys |
|
Module 01: What are Relationships, Foreign Keys and Normalization? |
|
00:11:00 |
|
Module 02: Create Relationships with Data Modeling |
|
00:15:00 |
|
Module 03: Create Relationships with Workbench Table Design Tool |
|
00:20:00 |
|
Module 04: Insert Records in Related Tables |
|
00:09:00 |
|
Module 05: Run Queries on Related Tables (Inner Joins) |
|
00:15:00 |
|
Module 06: Left, Right and Cross-Joins |
|
00:07:00 |
| Unit 04: Aggregate Functions |
|
Module 01: Grouping Data using SQL GROUP BY Clause |
|
00:10:00 |
|
Module 02: SQL AVG Aggregate Function |
|
00:09:00 |
|
Module 03: SQL COUNT Aggregate Function |
|
00:08:00 |
|
Module 04: SQL MIN & MAX Aggregate Functions |
|
00:03:00 |
|
Module 05: SQL SUM Aggregate Function |
|
00:05:00 |
|
Module 06: Splitting Groups using HAVING Clause |
|
00:05:00 |
| Assignment |
|
Assignment – MySQL Database Development |
|
1 week, 5 days |
| Order Your Certificate |
|
Order Your Certificate QLS |
|
00:00:00 |