Beginner to Intermediate

MySQL

A practical, in-depth MySQL course covering relational fundamentals, schema design, querying, joins, window functions, programmability, performance tuning, transactions, security, and administration, finished with real projects and interview preparation.

11 modules
32 lessons
About 194 min reading

Start learning

Course syllabus

Select any lesson to open it.

Module 1: Database Fundamentals & Setup

3 lessons

Relational concepts, installing MySQL, and how the server and storage engines are put together.

Module 2: Data Definition & Schema Design (DDL)

3 lessons

Building schemas: databases, tables, data types, keys, and constraints.

Module 3: Data Manipulation & Basic Querying (DML & DQL)

3 lessons

Inserting, changing, deleting, and reading data with SELECT, WHERE, ORDER BY, and LIMIT.

Module 4: Functions & Data Aggregation

3 lessons

Summarizing data with aggregates, GROUP BY, HAVING, and built-in scalar functions.

Module 5: Multi-Table Operations & Advanced Queries

4 lessons

Joins, set operations, subqueries, CTEs, and window functions.

Module 6: Database Programmability

4 lessons

Views, stored routines, control flow, cursors, triggers, and events.

Module 7: Performance, Security & Administration

4 lessons

Indexes, EXPLAIN, transactions, locking, privileges, backups, replication, and partitioning.

Module 8: Real-World Usage

2 lessons

Schema design for real applications and talking to MySQL safely from application code.

Module 9: Tooling & Testing

2 lessons

Debugging slow and wrong queries, testing databases, and managing migrations.

Module 10: Projects

2 lessons

Two realistic projects built end to end.

Module 11: Interview Questions

2 lessons

Conceptual questions and coding exercises with worked solutions.

What you will learn

Explain relational concepts and normalize a schema to third normal form
Install MySQL 8 and connect with the command-line client and Workbench
Design tables with correct data types, keys, and constraints
Write SELECT, INSERT, UPDATE, and DELETE statements confidently
Aggregate and transform data with GROUP BY, HAVING, and scalar functions
Combine tables with joins, subqueries, CTEs, and window functions
Build views, stored procedures, functions, triggers, and events
Read EXPLAIN output and design indexes that match real queries
Use transactions and understand isolation levels and locking
Manage users and privileges, and back up and restore databases
Connect to MySQL safely from application code
Complete two realistic projects and answer common interview questions

Prerequisites

Comfort using a terminal or command prompt
Basic computer literacy (files, folders, installing software)
No prior SQL or database experience required
Helpful but optional: any programming language, for Module 8

Loading course...