Overview

Google, IBM & Meta Certificates – 40% Off

One Coursera Plus subscription covers most Professional Certificates on Coursera.

Get hands-on experience managing real MariaDB databases — from install to Docker deployment. Database management is an essential skill for backend development and system administration. This course provides practical, real-world experience in configuring, managing, and optimizing MariaDB databases, preparing you to tackle data challenges with confidence. You will learn the foundational setup and configuration of MariaDB, progressing to critical topics like user management, table partitioning, and performance tuning. The curriculum guides you through manipulating columns, selecting appropriate storage engines, and implementing robust backup and logging strategies. You will also gain practical knowledge in deploying MariaDB instances using Docker containers. These skills are directly applicable to daily administrative tasks, ensuring your databases are secure, efficient, and reliable. By completing hands-on labs, you will build a practical toolkit for troubleshooting and auditing relational databases. This course is designed for aspiring database administrators, system administrators, and backend developers seeking to expand their relational database expertise. No prior database experience is required, making it an excellent starting point for your career.

Syllabus

Basic Configurations
- Go from a bare server to a running, secured MariaDB you can trust. Install the server, connect with the client, tour the main configuration file, and strip out the dangerous defaults a fresh install leaves behind — before creating your first database.
Basic SQL Commands
- Fill the empty server with real data. Create databases and tables with the right data types and keys, then practice the four everyday operations — add, read, change, remove — plus safe cleanup. These verbs underpin the rest of the course.
User Management
- Move past the single all-powerful root login to per-user, least-privilege access. Create users keyed to a host, grant and revoke precise privileges, audit what a user can do, and use roles to manage access at scale.
Columns
- Design tables whose column rules keep data trustworthy. Pick the right data type for each value, evolve a live table with ALTER TABLE, and add the constraints and defaults that reject bad data on every insert.
Partition Tables
- Keep very large tables fast by splitting them into partitions so a query reads only the slice it needs. Learn what partitioning is and why partition pruning helps, then build all four partition types and when to use each.
Engines
- Look under the hood at storage engines the component that decides how data is written, locked, and protected and extend the server with plugins. The SQL stays the same; the engine underneath changes the rules.
Backup and Logging
- Defend against the two fears every DBA carries losing data, and unexplained slowness. Take logical backups with mysqldump and restore after a simulated disaster, then enable and read the slow query log to find exactly which query is dragging.
MariaDB on Docker
- Run MariaDB in containers and connect a real application to it. Learn why containers solve "works on my machine," containerize a Flask app alongside MariaDB, watch a lone container fail because it can't find the database, then wire both together with Docker Compose.