About This Course
Course Curriculum
-
Module 01: Introduction to MySQL Server and Databases
00:07:00 -
Module 02: Download and Install MySQL Server and MySQL Workbench
00:12:00
-
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
-
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
-
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 – MySQL Database Development
05:06:00
-
Order Your Certificate

Development
QLS
Business
Healthcare
Health & Fitness
Technology
Teaching
Lifestyle
Design




