Udemy
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
DB Admin Basics: MariaDB Database: Local & VPS Practical Lab
Rating: 4.1 out of 5(8 ratings)
257 students

DB Admin Basics: MariaDB Database: Local & VPS Practical Lab

Server Infrastructure: Hands-on MariaDB fundamentals real-world practice on local machines and VPS server environments..
Created byMana Dowlatshahi Yeganeh
Last updated 10/2026
English

What you'll learn

  • DB Admin Basics:
  • MariaDB Database:
  • Local & VPS Practical Lab
  • Server Infrastructure: Hands-on MariaDB fundamentals real-world practice on local machines and VPS server environments..
  • MariaDB & MySQL Practical Course - SQL, Admin, Replication, Galera, HAProxy
  • MariaDB & MySQL - Fundamentals to High Availability with Replication and Galera
  • Hands-On MariaDB & MySQL - From SQL Basics to High Availability Clusters

Course content

13 sections • 96 lectures • 50h 59m total length

  • 01 Welcome to the Course What You Will Build and Learn2:11
  • 02 What Is a Relational Database and Why Use One4:16
  • 03 Database Structure Tables, Rows, Keys and Relationships3:45
  • 04 Normalization and Designing a Good Schema3:37
  • 05 MariaDB vs MySQL vs PostgreSQL Differences and When to Use Each4:01
  • 06 Install MariaDB on Ubuntu Step by Step2:44
  • 07 Install MariaDB on CentOS Stream and Rocky Linux2:52
  • 08 Practice on Your Own PC Install MariaDB on Windows and macOS2:41
  • 09 First Login, Secure Setup and the Command Line Client2:46
  • 10 SQL Basics Create Databases and Tables2:47
  • 11 Data Types and Constraints That Protect Your Data2:36
  • 12 INSERT Adding Data to Your Tables2:30
  • 13 SELECT Reading, Filtering and Searching Data2:38
  • 14 UPDATE and DELETE Safely2:28
  • 15 Sorting, Grouping and Aggregate Functions2:41
  • 16 JOINs Combining Data from Several Tables2:46
  • 17 Subqueries and Common Table Expressions2:37
  • 18 Window Functions and Ranking2:34
  • 19 Working with Dates, Strings and JSON3:18
  • 20 Indexes and Query Performance with EXPLAIN3:08
  • 21 Transactions and ACID Keeping Data Consistent3:24
  • 22 Views, Stored Procedures and Triggers3:01
  • 23 Project Design and Build the Online Shop Database2:51
  • 24 Users, Roles and Privileges3:22
  • 25 Configuration Files and Server Variables3:36
  • 26 Logs and Monitoring Basics3:30
  • 27 Backup and Restore with mariadb-dump and mariadb-backup3:57
  • 28 Point-in-Time Recovery with Binary Logs3:42
  • 29 Performance Tuning Buffer Pool, Memory and Key Settings4:06
  • 30 Security Hardening Network Rules and TLS Encryption5:06
  • 31 High Availability Concepts Failure, Uptime and Scaling3:41
  • 32 Primary-Replica (Master-Slave) Replication Setup4:47
  • 33 GTID and Semi-Synchronous Replication4:55
  • 34 Master-Master Replication and Its Risks5:18
  • 35 Failover and Switchover Basics5:21
  • 36 What Is Galera Cluster and How It Works5:06
  • 37 Install and Bootstrap a 3-Node Galera Cluster5:06
  • 38 Test Galera Failures, Quorum and Recovery5:20
  • 39 Galera State Transfers SST, IST and Node Recovery5:46
  • 40 Galera Best Practices and Limits4:49
  • 41 Database Load Balancing Concepts5:25
  • 42 Load Balancing MariaDB with HAProxy6:02
  • 43 Keepalived and a Virtual IP for HAProxy High Availability6:14
  • 44 MaxScale and ProxySQL ReadWrite Splitting6:16
  • 45 Connecting Applications Failover-Aware Python4:34
  • 46 MySQL 8 and MariaDB Hands-On Compatibility Differences4:57
  • 47 PostgreSQL Basics Compared with MariaDB Same Tasks, Different Syntax4:50
  • 48 PostgreSQL High Availability Overview Streaming Replication and Patroni6:07
  • 49 MySQL Group Replication and InnoDB Cluster Compared with Galera5:17
  • 50 Which Clouds Support MariaDB, MySQL and Galera4:52
  • 51 Cloud HA Architecture Examples4:36
  • 52 Galera on Cloud Virtual Machines A Three-Node Design5:01
  • 53 Disaster Recovery Planning and Runbooks5:18
  • 54 Final Project Build a Highly Available MariaDB Setup4:33
  • 55 Outro What You Learned and Where to Go Next2:09
  • MariaDB & MySQL Practical Course - SQL, Admin, Replication, Galera, HAProxy0:02

Requirements

  • This course is designed for beginners, so no advanced database knowledge is required; however, students should have basic computer literacy, including installing software and navigating file systems. Familiarity with fundamental IT concepts such as operating systems (Windows or Linux), basic command-line usage, and simple networking concepts (IP address, server, client) will be helpful but not mandatory. A computer with at least 4GB RAM (8GB recommended) and stable internet access is required to install MariaDB locally and connect to a VPS environment. Learners should also be comfortable typing commands and following technical instructions. Prior knowledge of SQL is beneficial but not required, as the course covers essential SQL commands from scratch. Most importantly, students should have a willingness to practice, experiment, and troubleshoot, since this is a practical lab-based course focused on real implementation rather than theory alone.

Description


The MariaDB Database: Local & VPS Practical Lab course is a hands-on, fundamentals-focused training program designed to help learners understand, install, configure, and manage MariaDB databases in real-world environments. This course emphasizes practical lab work over theory, allowing students to build real database systems on both local machines and Virtual Private Servers (VPS). By working directly with live environments, learners gain confidence in managing databases from installation to optimization.

MariaDB is a powerful, open-source relational database management system developed as a community-driven fork of MySQL. It is widely used in web applications, enterprise systems, and cloud infrastructures. Understanding MariaDB is essential because databases form the backbone of modern software systems. From small business websites to large-scale enterprise platforms, structured data management is critical for performance, reliability, and security.

The importance of learning MariaDB lies in its performance, scalability, and compatibility with MySQL. Organizations choose MariaDB for its open-source flexibility, active development community, and enterprise-grade features. By mastering MariaDB, learners gain valuable skills in SQL querying, user management, backup and recovery, database security, performance tuning, and server deployment.

One of the major advantages of this course is its practical lab approach. Students do not just read about commands — they execute them. They configure MariaDB locally for development purposes and deploy it on a VPS to simulate production environments. This dual-environment training bridges the gap between beginner-level learning and real-world database administration.

This course is ideal for aspiring database administrators, backend developers, DevOps engineers, IT students, and anyone interested in understanding how data systems operate behind applications. With businesses increasingly relying on data-driven systems, database knowledge continues to grow in demand.

Looking toward the future, database skills remain highly relevant in cloud computing, SaaS platforms, e-commerce systems, fintech, and AI-driven applications. MariaDB integrates well with modern stacks and cloud providers, making it a future-proof skill. By completing this course, learners build a solid foundation that can lead to advanced database engineering, cloud database management, and high-demand technology roles.



Who this course is for:

  • Aspiring Database Administrators (DBAs): If you want to start a career in database administration, this course provides the essential foundation. You will learn installation, configuration, user management, backups, and server deployment — the core responsibilities of a DBA role.
  • Backend Developers: Developers who work with dynamic applications need strong database skills. Understanding MariaDB helps you design efficient schemas, write optimized queries, and manage production databases with confidence.
  • IT Students & Beginners in Tech: Students studying computer science or information technology will gain practical exposure that complements academic theory. This course provides real-world skills that improve employability.
  • System Administrators & DevOps Beginners: If you manage servers or plan to work with cloud infrastructure, knowing how to deploy and manage MariaDB on a VPS is a critical and valuable skill.

Report abuse