Master MariaDB: A Hands-On, Learn-by-Doing Database Course

Learn to create a MariaDB database and tables, assign data types and keys, and master the core SQL commands: create, insert, select, update, delete, and drop.

Master the four core CRUD actions in MariaDB: insert, select, update, and delete, and use precise where clauses to safely manage data and differentiate delete from drop.

Learn how to enforce least privilege in MariaDB by creating users with scoped privileges, granting and revoking access, and using roles to manage access at scale.

Create and apply roles to manage privileges efficiently, granting a bundled set to developers on projectalpha.star and updating access for all users by adjusting the role.

Design clean tables by choosing appropriate data types, applying constraints like not null, default, unique, and auto-increment, and evolving schemas with alter table to prevent bad data.

Learn how to select MariaDB data types like int, varchar, decimal, date, boolean, and text, ensuring data integrity. Use alter table to resize columns in place without data loss.

Apply constraints, defaults, and auto-increment to MariaDB tables to enforce data integrity. Make email not null and unique, set default is active to true, and auto-increment the customer_id primary key.

Explore partitioning to tame huge tables by splitting data into partitions and using pruning to read only relevant slices; Learn range and list, plus hash and key partitioning.

Explore how partitioning splits a large table into partitions and enables pruning for faster queries, with range and list strategies and a primary key requirement.

Explore how storage engines like InnoDB, MyISAM, and ARIA affect data storage, speed, and reliability in MariaDB, with practical steps to set defaults and per-table engines.

Back up and restore databases with mysqldump, creating a logical backup of create table and insert statements. Restore by recreating the database and feeding the dump back in with mysql.

Package MariaDB with docker to ensure consistent, isolated databases across machines, using the official image, a dockerfile, and docker compose to connect containers with a shared volume.

Learn to containerize MariaDB and a Flask app, build images, and run them. The app reads four environment variables—dbHost, dbUser, dbPassword, and dbName—to connect, and Docker Compose links the containers.

Use docker compose to connect the app and MariaDB with a shared network and a persistent dbdata volume. Bring up the stack with docker compose up --build -d.