Course Room
Beginner to Advanced

MySQL Unlocked: Zero to Production-Grade Database Engineer

Master MySQL from your first SELECT statement to indexing, stored procedures, transactions, and real schema design, then use AI tools to write and review SQL faster.

18 Modules
59 Lessons
0 Students
English
Certificate on completion

MySQL Unlocked: Zero to Production-Grade Database Engineer

Course Overview

This course takes you from a complete beginner to a confident, production-ready MySQL engineer. You start with installing MySQL and writing your first queries, then build up through filtering, multi-table joins, inserting and updating data, aggregate functions, and subqueries. From there you move into built-in MySQL functions, modern window functions and CTEs (the query techniques most real-world analytics work actually runs on), views, stored procedures, triggers, events, and full transaction/concurrency control with isolation levels. A dedicated database design module covers conceptual, logical, and physical modeling, normalization through 3NF, and two complete design projects (a flight booking system and a video rental application) worked end to end. You finish with creating real databases, tables, and relationships, indexing for performance, user and privilege management, and a practical look at how AI coding assistants like GitHub Copilot and ChatGPT change (and don't change) the way SQL gets written on the job.

18 modules
59 lessons
18 module quizzes

Taught in English
Beginner to Advanced level
Certificate on completion

Course Content

18 modules59 lessons18 quizzes

Introduction / What is SQL / Installing MySQL on Mac8:43
Installing MySQL on Windows / What You'll Learn7:53

Module quiz · 30 questions

The SELECT Statement / The SELECT Clause / The WHERE Clause19:58
The AND, OR and NOT Operators / The IN Operator - Title / The BETWEEN Operator - Title12:10
The ORDER BY Clause / The LIMIT Clause10:34

Module quiz · 30 questions

Inner Joins / Joining Across Databases / Self Joins15:29
Joining Multiple Tables / Compound Join Conditions / Implicit Join Syntax12:50
Outer Joins / Outer Join Between Multiple Tables / Self Outer Joins15:00
The USING Clause / Natural Joins / Cross Joins10:00
Unions8:30

Module quiz · 30 questions

Column Attributes / Inserting a Row / Inserting Multiple Rows12:31
Inserting Hierarchical Rows / Creating a Copy of a Table / Updating a Single Row18:38
Updating Multiple Rows / Deleting Rows / Restoring the Databases5:47

Module quiz · 30 questions

Aggregate Functions9:20
The GROUP BY Clause - Title7:22
The HAVING Clause - Title8:51
The ROLLUP Operator - Title5:06

Module quiz · 30 questions

Introduction / Subqueries / The IN Operator7:39
Subqueries vs Joins / The ALL Keyword / The ANY Keyword12:38
Correlated Subqueries / The EXISTS Operator / Subqueries in the SELECT Clause15:47
Subqueries in the FROM Clause2:59

Module quiz · 30 questions

Numeric Functions / String Functions / Date Functions in MySQL12:52
Formatting Dates and Times / Calculating Dates and Times / The IFNULL and COALESCE Functions8:54
The IF Function / The CASE Operator10:19

Module quiz · 30 questions

SQL Window Functions Basics | PARTITION BY, ORDER BY, FRAME / SQL Aggregate Window Functions | COUNT, AVG, SUM, MAX, MIN / SQL Ranking Window Functions | ROW_NUMBER, RANK, DENSE_RANK, NTILE3:09:25
SQL Value Window Functions | LEAD, LAG, FIRST_VALUE, LAST_VALUE / SQL CTE (Common Table Expression) Visually Explained | Full Guide WITH Clause2:02:44

Module quiz · 30 questions

Creating Views / Altering or Dropping Views / Updatable Views13:43
THE WITH OPTION CHECK Clause / Other Benefits of Views4:57

Module quiz · 30 questions

What are Stored Procedures / Creating a Stored Procedure / Creating Procedures Using MySQLWorkbench9:16
Dropping Stored Procedures / Parameters / Parameters with Default Value15:56
Parameter Validation / Output Parameters / Variables15:11
Functions / Other Conventions / Triggers15:53
Viewing Triggers / Dropping Triggers / Using Triggers for Auditing7:07

Module quiz · 30 questions

Events / Viewing, Dropping and Altering Events / Transactions9:24
Creating Transactions / Concurrency and Lockign / Concurrency Problems16:46
Transaction Isolation Levels / READ UNCOMMITTED Isolation Level / READ COMMITTED Isolation Level12:12
REPEATABLE READ Isolation Level / SERIALIZABLE Isolation Level / Deadlocks12:01

Module quiz · 30 questions

Introduction / String Types / Integer Types6:03
Fixed point and Floating point Types / Boolean Types / Enum and Set Types6:07
Date and Time Types / Blob Types / JSON Type12:28

Module quiz · 30 questions

Introduction_2 / Data Modelling / Conceptual Models8:28
Logical Models / Physical Models / Primary Keys17:17
Foreign Keys / Foreign Key Constraints / Normalization12:37
1NF- First Normal Form / Link Tables / 2NF- Second Normal Form13:18
3NF- Third Normal Form / My Pragmatic Advice / Don't Model the Universe9:05
Forward Engineering a Model / Synchronizing a Model with a Database / Reverse Engineering a Database10:37

Module quiz · 30 questions

Project- Flight Booking System / Solution- Conceptual Model / Solution- Logical Model17:28
Project- Video Rental Application / Solution- Conceptual Model / Solution Logical Model16:36

Module quiz · 30 questions

Creating and Dropping Databases / Creating Tables / Altering Tables7:53
Creating Relationships / Altering Primary and Foreign Key Constraints / Character Sets and Collations13:29
Storage Engines2:28

Module quiz · 30 questions

Introduction / Indexes / Creating Indexes8:33
Viewing Indexes / Prefix Indexes / Full text Indexes14:52
Composite Indexes / Order of Columns in Composite Indexes / When Indexes are Ignored19:34
Using Indexes for Sorting / Covering Indexese / Index Maintenance10:28

Module quiz · 30 questions

Introduction / Creating a User / Viewing Users5:18
Dropping Users / Changing Passwords / Granting Privileges6:50
Viewing Privileges / Revoking Privileges / Wrap Up - Code with Mosh3:41

Module quiz · 30 questions

SQL With Gen AI Full Course 2026 | SQL Tutorial For Beginners | SQL With Generative AI | Simplilearn12:20

Module quiz · 30 questions

Skills You'll Gain

Write SELECT queries with filtering, sorting, and pagination
Join tables correctly: inner, outer, self, natural, and cross joins
Insert, update, and delete data safely
Summarize data with aggregate functions, GROUP BY, and HAVING
Write subqueries and know when to use them instead of joins
Use MySQL's built-in numeric, string, and date functions
Write modern window functions and Common Table Expressions (CTEs)

Create and manage views, stored procedures, functions, and triggers
Control transactions and understand concurrency and isolation levels
Design a database from conceptual model through 3rd Normal Form
Create databases, tables, relationships, and indexes for performance
Manage MySQL users and privileges
Use AI coding assistants responsibly when writing SQL

Requirements

No prior database experience is required. A computer that can run MySQL Server and MySQL Workbench (Windows or Mac) is all you need
installation is covered in the course itself.

Who this course is for

Complete beginners who have never written a line of SQL
developers who need real database skills for backend or data roles
and anyone who wants to use AI tools to write and review SQL more effectively without skipping the fundamentals.