SQL and MySQL online course
The SQL and MySQL online course in CodeWorlds is 11 modules of short lessons with a code editor and 658 hands-on exercises, told as a story-driven adventure. You can read the lessons for free on this site.
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.
Your guide
Kallimach
Keeper of the Catalog
What you'll learn
- The relational model and SQL basics
- Querying data: SELECT, WHERE, ORDER BY
- Filtering: IN, BETWEEN, LIKE, NULL
- Designing tables and data types (DDL)
- Modifying data: INSERT, UPDATE, DELETE
- Aggregation and grouping: GROUP BY, HAVING
- Joining tables: INNER, LEFT, RIGHT JOIN
- Indexes, transactions and normalization
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
57 exercises
Catalog Hall
Querying data (SELECT)
Choosing columns, aliases, DISTINCT, ORDER BY, LIMIT and OFFSET
60 exercises
Scriptorium
Filtering (WHERE)
Operators, AND/OR/NOT, IN, BETWEEN, LIKE, IS NULL
61 exercises
Table Workshop
Creating tables (DDL)
CREATE TABLE, data types, keys, AUTO_INCREMENT, ALTER
60 exercises
Scribe's Desk
Modifying data (DML)
INSERT, UPDATE, DELETE, TRUNCATE and the role of WHERE
58 exercises
Hall of Numbers
Aggregation and grouping
COUNT, SUM, AVG, MIN, MAX, GROUP BY, HAVING
60 exercises
Bridge of Knowledge
Joining tables (JOIN)
INNER, LEFT, RIGHT JOIN, foreign keys, self-join
63 exercises
Query Labyrinth
Subqueries
Subqueries, EXISTS, UNION, correlated queries
63 exercises
The Pinakes Catalog
Indexes and normalization
Indexes, EXPLAIN, foreign keys, 1NF-3NF normalization
60 exercises
The Watchtower
Transactions and advanced SQL
ACID transactions, views, CTEs, window functions
60 exercises
The Magnum Opus
Capstone project
Design and query a complete library-system database
56 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.
SQL and MySQL course FAQ
Is the SQL and MySQL course free?
Partly. You can read the SQL and MySQL lessons for free on this site. The course tasks in the app require a premium plan, while a free account lets you complete the HTML and CSS course in the app with 10 fuel units a day.
How long does the SQL and MySQL course take?
The estimated learning time for the SQL and MySQL course is 30-45 hours. The course has 11 modules and more than 658 tasks, and you set the pace.
Do I need previous experience for the SQL and MySQL course?
Before the SQL and MySQL course it helps to know: Basic computer skills, Logical thinking, No prior database knowledge required.
What will I learn in the SQL and MySQL course?
In the SQL and MySQL course you will learn, among other things: The relational model and SQL basics, Querying data: SELECT, WHERE, ORDER BY, Filtering: IN, BETWEEN, LIKE, NULL, Designing tables and data types (DDL).
What is learning in CodeWorlds like?
In CodeWorlds, every module is a series of short lessons with a live code editor, check questions and hands-on tasks. Progress earns you XP and unlocks new locations in the The Great Library world.
Start learning MySQL today
Join CodeWorlds and discover modern learning methods that make programming fascinating and accessible to everyone.