Faysal AzizMastering MariaDB
From Installation to Advanced Management in 2 days
Why this course
Course Overview
Ready to become a database wizard? Dive into the world of MariaDB, where data management meets modern innovation!
Think MySQL is cool? Wait until you meet its more powerful cousin! MariaDB is the open-source powerhouse that's catching the eye of tech giants and startups alike. In this hands-on adventure, we'll go from zero to hero with MariaDB, whether you're running it on bare Ubuntu metal or spinning it up in Docker containers.
Led by someone who's been taming databases since before the internet was cool, you'll learn the real-world tricks that make the difference between a database that just works and one that flies. No theoretical fluff here – we're talking about practical skills you can use the moment you get back to your desk.
From setting up your first MariaDB instance to crafting queries that'll make your colleagues go "How did you do that?", this course is your ticket to joining the ranks of database pros who make data dance to their tune. Whether you're managing gigabytes or terabytes, we've got you covered with battle-tested strategies that actually work in the wild.
Learning outcomes
By the end of this course, participants will be able to:
- Install and configure MariaDB on a remote Ubuntu server.
- Deploy and manage MariaDB using Docker.
- Use Azure Data Studio to interact with MariaDB databases.
- Implement security best practices for MariaDB installations.
- Perform advanced database management tasks such as backup, restoration, and performance tuning.
Prerequisites
Before attending, participants should have:
✔ Basic understanding of databases (tables, queries, etc.).
✔ Familiarity with the command line.
✔ Basic knowledge of Linux systems (recommended but not mandatory).
10 modules
011. Introduction to MariaDB4 topics
- What is MariaDB?
- Differences between MariaDB and MySQL
- Key features and advantages of MariaDB
- Industry adoption and real-world use cases
022. Setting Up the Environment3 topics
- Provisioning a remote Ubuntu server
- Ensuring required system dependencies are installed
- Introduction to Docker and why it's useful for databases
033. Installing MariaDB on Ubuntu4 topics
- Updating repositories and installing MariaDB
- Starting and enabling MariaDB service
- Running mysql_secure_installation to enhance security
- Verifying installation and default configurations
044. Deploying MariaDB in Docker4 topics
- Pulling the official MariaDB Docker image
- Running a MariaDB container with persistent storage
- Configuring custom environments and networking
- Managing Docker volumes for data persistence
055. Connecting MariaDB to Azure Data Studio4 topics
- Installing and setting up Azure Data Studio
- Configuring MariaDB connection settings
- Running queries and exploring database objects
- Installing extensions and productivity tools
066. User Management and Security4 topics
- Creating user accounts and assigning privileges
- Configuring password policies and authentication plugins
- Securing MariaDB with firewalls and SSL
- Implementing best practices for secure remote access
077. Performance Optimization4 topics
- Monitoring MariaDB resource usage
- Adjusting cache and buffer settings for better performance
- Analyzing slow queries and optimizing them
- Using Performance Schema and EXPLAIN plans
088. Backup and Recovery Strategies4 topics
- Why backups are crucial
- Performing full and incremental backups using mysqldump
- Restoring databases from backup files
- Automating backup processes using cron jobs
099. Advanced Configuration and Replication4 topics
- Fine-tuning MariaDB configuration files
- Setting up Master-Slave Replication for high availability
- Monitoring and troubleshooting replication issues
- Exploring clustering and Galera Cluster for MariaDB
1010. Real-World Applications & Case Studies3 topics
- Industry use cases of MariaDB deployments
- Challenges and solutions in enterprise-level database management
- Interactive Q&A and best practices discussion
Why Take This Course?
- Hands-on Learning: Practical labs, real-world scenarios, and guided exercises.
- Industry-Relevant Content: Focus on real-world challenges rather than just theoretical concepts.
- Expert-Led: Instructor with 30+ years of industry experience in database management.
- Cloud & Container Focus: Learn how to manage MariaDB in Ubuntu servers and Docker environments.
This course is designed for database administrators, DevOps engineers, and developers who want to efficiently deploy and manage MariaDB in modern environments.
A programme built around your team.
Share your training goals and requirements.