About this course
Set up your MySQL environment and verify readiness for comprehensive learning.
Before We Begin
1 Parts
- 0:05 Hr
Global Implementations
5 Min
Prerequisites & Environment Setup
2 Parts
- 1:00 Hr
Prerequisites for Mastering MySQL
45 Min
MySQL Environment Setup Guide
15 Min
Chapter 1: RDBMS Fundamentals & Basic SQL
3 Parts
- 2:30 Hr
Relational Databases
45 Min
Basic SQL Queries
45 Min
Exercise: Write Basic SQL Queries
60 Min
Chapter 2: Database and Table Management
3 Parts
- 2:15 Hr
Database Operations
45 Min
Table Operations
45 Min
Exercise: Design a Relational Schema with Constraints
45 Min
Chapter 3: CRUD Operations and Basic Joins
3 Parts
- 2:30 Hr
CRUD Operations
45 Min
Joins and Aggregates
45 Min
Exercise: CRUD and Join Queries
60 Min
Assignment 1
1 Parts
- 0:45 Hr
Build a Customer Inquiry Tracker
45 Min
Chapter 4: Advanced Joins, Subqueries, and Window Functions
3 Parts
- 2:30 Hr
Advanced Joins and Subqueries
45 Min
Window Functions
45 Min
Exercise: Complex Query with Joins and Window Functions
60 Min
Chapter 5: Stored Procedures, Triggers, and Transactions
3 Parts
- 2:15 Hr
Stored Procedures and Functions
45 Min
Triggers and Transactions
45 Min
Exercise: Automate Data Updates with Stored Procedures
45 Min
Chapter 6: Performance Optimization and Indexing
3 Parts
- 2:30 Hr
Query Optimization
45 Min
Indexing Strategies
45 Min
Exercise: Optimize a Query with Indexing
60 Min
Assignment 2
1 Parts
- 0:45 Hr
Design a Product Catalog with Reporting
45 Min
Chapter 7: Security and User Management
3 Parts
- 2:30 Hr
Basic and Advanced Security
45 Min
Auditing
45 Min
Exercise: Secure a Database
60 Min
Chapter 8: Backup, Restore, and High Availability
3 Parts
- 2:30 Hr
Backup and Restore
45 Min
High Availability
45 Min
Exercise: Implement Incremental Backup
60 Min
Chapter 9: Advanced Database Scaling
3 Parts
- 2:30 Hr
Partitioning and Replication
45 Min
Sharding
45 Min
Exercise: Partition a Table by Range
60 Min
Assignment 3
1 Parts
- 0:45 Hr
Optimize a Sales Performance Dashboar
45 Min
Chapter 10: Cloud, Containers, and Application Integration
3 Parts
- 3:00 Hr
Cloud and Containers
60 Min
Application Integration
45 Min
Exercise: Deploy and Integrate MySQL
75 Min
Capstone Project 1
1 Parts
- 50:00 Hr
Automated Inventory Management with Stored Procedures and Triggers
3000 Min
Capstone Project 2
1 Parts
- 50:00 Hr
Scalable Blog Platform Database with Replication and Sharding
3000 Min
No Reviews Yet
