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
- Table Workshop - welcome to the scriptorium
- CREATE TABLE - building a new shelf
- Data types - choosing the right drawer
- Column constraints - rules of order
- DEFAULT and UNIQUE - additional rules
- Special drawers - DATE, BOOLEAN and ENUM
- A full example - the recenzje shelf
- ALTER TABLE and DROP TABLE - rebuilding a shelf
- The Great Work of the scriptorium - the biblioteka shelf project
- Workshop closed - summary
Scribe's Desk
Modifying data (DML)
INSERT, UPDATE, DELETE, TRUNCATE and the role of WHERE
56 exercises
- The Scribe's Desk - modifying data
- INSERT - writing a new scroll
- INSERT of many rows at once
- UPDATE - correcting a scroll and the WHERE warning
- DELETE - removing a row and the second WHERE warning
- Aiming with the WHERE clause - conditions in DML
- NULL and default values in DML
- DELETE versus TRUNCATE
- The scribe's safe habits
- A great tidy-up in the Library - final project
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
- The Magnum Opus - Callimachus's challenge
- The power of questions - JOIN and GROUP BY
- Back to the Gate - SELECT, WHERE, ORDER BY
- The architect's workshop - CREATE TABLE and INSERT
- The Scriptorium - UPDATE and DELETE
- The Chamber of Riddles - subqueries and HAVING
- The Hall of Seals - transactions and views
- Journey's end - Master of the Catalog
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.