Training path
The database behind much of the web: tables, SQL queries, transactions, indexes and backups on a MySQL server of your own.
A MySQL 8 server of your own, with the mysql client, next to every lesson.
learner@linux-server:~$ mysql -e "CREATE DATABASE shop"
learner@linux-server:~$ mysql shop -e "SHOW TABLES"
learner@linux-server:~$ mysqldump shop > shop.sql
Every lesson runs on a MySQL server of your own, where your account has every privilege. You build a small shop database step by step: InnoDB tables and types, queries and aggregates, transactions, foreign keys and joins, indexes and EXPLAIN ANALYZE, then accounts and backups, each checked on your server.
Connect with the mysql client, see how accounts work, and create your first database.
Design an InnoDB table with the right types and constraints, and insert rows.
Filter, sort and limit with SELECT, and summarize with aggregates and GROUP BY.
UPDATE, DELETE and ALTER TABLE, safe updates, and transactions that undo mistakes.
Foreign keys between customers, orders and products; JOIN, LEFT JOIN and views.
Read query plans and make a query on 200,000 rows fast with an index.
A read-only account for an application, then mysqldump and a tested restore.
Linux command-line basics. No SQL experience needed.
Contact for pricing
Flexible payment options available
Open your own MySQL server and write your first query in minutes.