-
Lesson 1 - Course Introduction
-
Lesson 2 – Introduction to SQL
-
Lesson 3 – Database Normalization and Entity Relationship (ER) Model
-
Lesson 4 – MySQL - Installation and Setup
-
Lesson 5 – Working with Database and Tables
-
Lesson 6 – Working with Operations Constraints and Data Types
-
Lesson 7 - Function in SQL
-
Lesson 8 - Subqueries, Operators, and Derived Tables in SQL
-
Lesson 9 - Windows Function in SQL
-
Lesson 10 - Working with Views
-
Lesson 11 - Stored Procedures and Triggers in SQL
-
Lesson 12 - Performance Optimization and Best Practices in SQL