MySQL Bootcamp: Beginner to Advanced
Welcome, champion! 🔥
You've mastered 0 of 185 lessons. Start your first lesson free — no signup needed.
About this course
MySQL Bootcamp: Beginner to Advanced is a guided course that teaches MySQL 8 from your first SELECT to joins, window functions, indexes, transactions and stored procedures. Every lesson works on the same sample database, an online store with customers, orders, order_items and products tables, so each new idea lands on data you already know. Each lesson is a few minutes of reading cards with diagrams and narration, followed by a quiz that checks you understood it.
Lesson 1 is a first query against the customers table: select a few columns, keep only the customers in one city with WHERE, sort them with ORDER BY and read the result set that comes back. By the final topics, the same store data is used for monthly revenue reports, top-N-per-group queries with window functions, reading EXPLAIN output and a trigger that keeps an audit log of price changes.
Who this MySQL course is for
It is built for students and freshers with no SQL experience, and it carries on through intermediate SQL into advanced topics such as query plans, isolation levels and stored programs. It also suits backend developers who use an ORM and want to understand the SQL underneath it, analysts who need joins, GROUP BY and window functions for reporting, and students who expect SQL questions in placement tests and technical interviews. If you already know basic SELECT queries, the early lessons go quickly and the later topics are where the course earns its time.
How the course works on Abekus
The course runs as 185 short lessons in 14 topics: getting started, schema design, data modification, filtering and sorting, functions and expressions, aggregation, joins, subqueries and CTEs, window functions, indexes and performance, transactions and concurrency, programmability, and security, JSON and backups. A lesson is a handful of reading cards with the SQL for each step, diagrams where a picture explains more than a paragraph, and narration you can play while you read. Every lesson ends with a quiz, and each question shows an explanation after you answer, so a wrong pick turns into the rule you were missing. The course and each of its topics open with a short overview of what is coming.
The course shows queries only, with no installation steps and no GUI tools such as MySQL Workbench. To run the queries yourself, use any MySQL 8 server you can reach. If your applications also need fast caching next to a relational database, Redis for Developers: Caching & Data Structures is a separate course.
SQL choices the course untangles
Much of writing good SQL is choosing between two ways that both seem to work. The course sets the common pairs side by side:
- JOIN vs subquery, and EXISTS vs IN
- WHERE vs HAVING
- DELETE vs TRUNCATE, and CHAR vs VARCHAR
- Primary key vs unique key
- A JSON column vs a separate table
- An index lookup vs a full table scan, and window functions vs GROUP BY
It also practises choosing a join type, an isolation level, and a trigger or application code, and closes with cases on the store data: customer order reporting, a monthly revenue dashboard, a nightly backup routine and auditing price changes.
Lessons and quizzes vs video courses for MySQL
Udemy and Coursera SQL courses are mostly video lectures in which an instructor types queries on screen. W3Schools is a handy quick reference, with short tutorial pages and examples you can try in the browser. This course does a different job: one idea per lesson, then questions on it straight away, so you find out whether you can predict what a query returns, say which join keeps unmatched rows, or tell which index a query can use. Watching someone write SQL builds familiarity; answering questions about it shows what you can actually do.
Best way to learn MySQL
Predict before you run. Before each query in a lesson, guess the rows it will return, then check your guess against the cards and the quiz. Take a few lessons a day rather than one long weekly session, read every explanation, including the ones for answers you guessed, and after each topic write two or three queries of your own against a copy of the store schema on a MySQL 8 server. Once you reach indexes, run EXPLAIN on those same queries and see what changes.