Your cart is empty.
Keep shoppingMariaDB Server Lab: Install & Automate on Ubuntu Linux VM!!
260 students
MariaDB Server Lab: Install & Automate on Ubuntu Linux VM!!
Basic Practical Database Administration LAB Hands-on setup with Bash, Terraform, Ansible, Python, PHPMyAdmin & Workbench
Created byMana Dowlatshahi Yeganeh
Last updated 7/2026
English
What you'll learn
- MariaDB Server Lab..
- Install & Automate on Ubuntu Linux VM!!
- Basic Practical Database Administration LAB
- Hands-on setup with Bash, Terraform, Ansible, Python, PHPMyAdmin & Workbench + Docker
Explore related topics
Course content
14 sections • 47 lectures • 49h 57m total length
Requirements
- To get the most out of this Fundamental Practical Lab Course on MariaDB Server Installation and Configuration on Ubuntu Linux, learners should have a basic understanding of computers, operating systems, and general networking concepts. Familiarity with Linux or command-line interfaces is helpful but not mandatory, as the course provides guided, step-by-step instructions for all commands used in Ubuntu. Participants are encouraged to have a working computer or virtual machine with Ubuntu Linux installed (or access to a cloud environment such as AWS, Azure, or Google Cloud) to perform the lab exercises. Basic knowledge of how to execute terminal commands and navigate the file system will make learning smoother. While no prior experience with databases is required, having a general idea of what a database is and how data is stored in tables can be beneficial. Learners should be comfortable installing software packages and using simple text editors like Nano or Vim. For the automation and infrastructure sections, a beginner’s curiosity about DevOps tools such as Terraform, Ansible, and Docker is sufficient — all necessary steps will be demonstrated in detail during the course. You’ll also need a stable internet connection to download and install packages, Docker images, and additional tools like phpMyAdmin and MySQL Workbench. Some exposure to programming concepts, especially in Python or shell scripting, will be advantageous for understanding the database testing and automation exercises, but it is not a strict requirement. The course is designed to start from the basics and build up practical, job-ready skills through real-world examples. In short, this course is suitable for beginners who are eager to learn how to install, configure, and test MariaDB servers in a Linux environment using modern DevOps tools — no advanced background is required, just enthusiasm, patience, and a willingness to practice hands-on.
Description
The Fundamental Practical Lab: MariaDB Server Installation and Configuration on Ubuntu Linux is a beginner-friendly, hands-on course designed to teach the essential skills for setting up and managing a MariaDB database server in a real-world environment. This course focuses on practical learning through guided lab exercises using Ubuntu Linux, Bash scripting, Terraform, Ansible, and Docker. You’ll learn not just how to install MariaDB, but also how to automate deployments, manage configurations, and connect to the database using phpMyAdmin, MySQL Workbench, and Python scripts.
What is this course about?
This course walks you step-by-step through the entire process of installing and configuring MariaDB on Ubuntu Linux. You’ll start with understanding Linux basics, package management, and system preparation. Then, you’ll perform manual installation using Bash commands and learn how to automate the same process using Infrastructure as Code (IaC) tools like Terraform and Ansible. You’ll also explore how to deploy MariaDB using Docker containers for quick testing and scalability. Once the server is up and running, you’ll connect it to phpMyAdmin and MySQL Workbench for database management and perform basic SQL operations such as creating databases, tables, and running queries.
Why is it important?
MariaDB is one of the most widely used open-source relational databases, trusted for its performance, reliability, and compatibility with MySQL. Understanding how to properly install, configure, and automate MariaDB environments is a crucial foundation for anyone entering the world of system administration, DevOps, or backend development. This course emphasizes hands-on, real-time learning — ensuring that you gain practical skills that can be applied immediately in work environments, cloud deployments, or personal projects.
Advantages of this course
Learn by doing through structured lab activities.
Practice Bash scripting for automation and server configuration.
Gain foundational knowledge of Terraform and Ansible for IaC automation.
Explore Docker containers for portable MariaDB deployments.
Understand how to use phpMyAdmin and MySQL Workbench for visual database management.
Run and test SQL commands using both GUI tools and Python scripts.
By the end of the course, you’ll not only know how to set up a MariaDB server but also how to automate and test your database in multiple environments — a critical skill for any IT professional.
Who should learn this course and why
This course is ideal for students, beginners, aspiring DevOps engineers, Linux enthusiasts, and database administrators who want to gain practical experience in database setup and automation. No prior database experience is required — just a basic understanding of Linux and a willingness to learn.
Future scope and career relevance
As businesses continue to adopt cloud computing and automation, professionals who understand how to deploy and manage databases using IaC and containerization tools will be in high demand. The skills learned in this course provide a strong foundation for advanced studies in DevOps, cloud infrastructure, database administration, and software engineering. You’ll be equipped with the confidence to build, automate, and test real-world MariaDB environments using modern tools and best practices.
Who this course is for:
- This Fundamental Practical Lab Course on MariaDB Server Installation and Configuration on Ubuntu Linux is ideal for anyone who wants to gain real, hands-on experience with open-source databases and modern automation tools. It is especially designed for students, beginners in IT, system administrators, DevOps enthusiasts, cloud learners, and software developers who want to understand how databases are deployed, configured, and managed in real environments. If you are new to Linux or databases, this course provides an easy and guided introduction without requiring deep prior knowledge. For system administrators and DevOps professionals, it offers practical experience in using tools like Terraform, Ansible, and Docker to automate infrastructure and streamline deployments. Developers will benefit by learning how to connect their applications to a MariaDB server using phpMyAdmin, MySQL Workbench, and Python for testing and data handling. IT students and career changers can use this course as a stepping stone into roles such as Database Administrator (DBA), Linux System Engineer, DevOps Engineer, or Cloud Infrastructure Specialist, as it covers essential foundational skills used in real-world environments. The course emphasizes practical lab work rather than theory, making it perfect for those who prefer learning by doing. With the growing demand for professionals skilled in database management, automation, and infrastructure-as-code, mastering these skills provides a competitive advantage in the job market. Whether you aim to build your first database server, automate deployments, or simply understand how web applications store and manage data, this course will equip you with the right tools and knowledge to confidently set up and manage MariaDB in any environment. Ultimately, it’s designed for anyone eager to strengthen their technical foundation, improve their career prospects, or explore the intersection of databases, Linux, and DevOps automation in a practical, beginner-friendly way.