The Great Library
Enter the Great Library of Alexandria and master MySQL from scratch under Callimachus, Keeper of the Catalog. From your first SELECT, through JOINs and subqueries, to indexes and transactions - learn to manage data like a master of the catalog.
What you'll learn
Main projects
During the course you will build real projects that you can add to your portfolio
Library Catalog
Design tables for books, authors and categories, plus catalog queries
Lending System
Model loans with foreign keys and safe transactions
Library Reports
Build complex reports with JOIN, GROUP BY and subqueries
Course program
11 modules full of interactive exercises and practical projects
Library Gate
Introduction to databases
What an RDBMS and MySQL are, tables, rows, columns, first SELECT
56 exercises
Catalog Hall
Querying data (SELECT)
Choosing columns, aliases, DISTINCT, ORDER BY, LIMIT
58 exercises
Scriptorium
Filtering (WHERE)
Operators, AND/OR/NOT, IN, BETWEEN, LIKE, IS NULL
59 exercises
Table Workshop
Creating tables (DDL)
CREATE TABLE, data types, keys, AUTO_INCREMENT, ALTER
58 exercises
Scribe's Desk
Modifying data (DML)
INSERT, UPDATE, DELETE, TRUNCATE and the role of WHERE
56 exercises
Hall of Numbers
Aggregation and grouping
COUNT, SUM, AVG, MIN, MAX, GROUP BY, HAVING
58 exercises
Bridge of Knowledge
Joining tables (JOIN)
INNER, LEFT, RIGHT JOIN, foreign keys, self-join
61 exercises
Query Labyrinth
Subqueries
Subqueries, EXISTS, UNION, correlated queries
61 exercises
The Pinakes Catalog
Indexes and normalization
Indexes, EXPLAIN, foreign keys, 1NF-3NF normalization
58 exercises
The Watchtower
Transactions and advanced SQL
ACID transactions, views, CTEs, window functions
58 exercises
The Magnum Opus
Capstone project
Design and query a complete library-system database
54 exercises
Course theme
The Great Library of Alexandria
Each module is set in a unique theme that makes learning an adventure.
Your guide
Kallimach
Keeper of the Catalog
Will guide you through all challenges and help you gain new skills.
Start learning MySQL today
Join CodeWorlds and discover modern learning methods that make programming fascinating and accessible to everyone.