STUDY

Database Server Lab

Learn what it takes to run a database server – the skills behind PostgreSQL, MySQL/MariaDB and SQL Server. Twenty lessons in five modules: from a file to a server, connecting safely, indexes, reading query plans, transactions and ACID, SQL injection, users and least privilege, backups, keys and constraints, normalisation, views, triggers and audit trails, locking and deadlocks, connection pooling, watching performance, replication and failover, scaling and partitioning, encryption and personal data, managed cloud databases, and SQL v NoSQL. Then five lab stations on real SQLite compiled to WebAssembly with 50,000 orders: time a slow query and fix it with an index, move money in a transaction and watch ROLLBACK, break into an unsafe login and see the parameterised version stop you, give a user read-only rights, and back up, break and restore – plus a free SQL console. Six missions.

Ready to try · Learn what it takes to run a database server – the skills behind PostgreSQL, MySQL/MariaDB and SQL Server. Twenty lessons in five modules: from a file to a server, connecting safely, indexes, reading query plans, transactions and ACID, SQL injection, users and least privilege, backups, keys and constraints, normalisation, views, triggers and audit trails, locking and deadlocks, connection pooling, watching performance, replication and failover, scaling and partitioning, encryption and personal data, managed cloud databases, and SQL v NoSQL. Then five lab stations on real SQLite compiled to WebAssembly with 50,000 orders: time a slow query and fix it with an index, move money in a transaction and watch ROLLBACK, break into an unsafe login and see the parameterised version stop you, give a user read-only rights, and back up, break and restore – plus a free SQL console. Six missions.