Udemy
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
MySQL/MariaDB Fundamentals: Practical Lab on Google Colab!!
Rating: 4.1 out of 5(4 ratings)
374 students

MySQL/MariaDB Fundamentals: Practical Lab on Google Colab!!

DB Admin:: Learn core MySQL database administration with hands-on labs using Google Colab in a cloud-based environment..
Created byMana Dowlatshahi Yeganeh
Last updated 10/2026
English

What you'll learn

  • MySQL/MariaDB Fundamentals
  • Practical Lab
  • Google Colab LAB
  • Learn core MySQL database administration with hands-on labs using Google Colab in a cloud-based environment..
  • 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

14 sections • 94 lectures • 51h 45m 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 prior MySQL experience is required. However, learners should have basic computer literacy, familiarity with using a web browser, and a fundamental understanding of how software applications work. A basic understanding of programming concepts (such as variables and logic) is helpful but not mandatory. Students should have a Google account to access Google Colab and a stable internet connection for cloud-based practice. Most importantly, learners should have curiosity, willingness to practice hands-on exercises, and an interest in understanding how databases store and manage data in real-world systems.

Description


MySQL Fundamentals: Practical Lab on Google Colab is a hands-on, beginner-friendly course designed to teach the core concepts of MySQL through guided practical exercises. Instead of focusing only on theory, this course emphasizes real lab practice using Google Colab as a cloud-based development environment. Learners will write queries, create databases, manage tables, and perform administrative tasks directly in the browser without complex local setup.

MySQL is one of the most widely used relational database management systems in the world. It powers websites, business applications, analytics platforms, and enterprise systems. Understanding MySQL is a foundational skill for database administrators, backend developers, data analysts, and IT professionals. Strong database skills are essential because almost every modern application depends on structured data storage, retrieval, and management.

The importance of learning MySQL lies in its real-world demand and practical usability. Organizations rely on database professionals to ensure data integrity, performance optimization, security, and efficient data handling. This course provides a solid starting point for understanding how databases function and how administrators manage them effectively in cloud-based environments.

One major advantage of this course is its practical lab approach using Google Colab. Students can practice instantly from anywhere without installing heavy software. The cloud-based setup makes learning flexible, accessible, and beginner-friendly. By the end of the course, learners will be confident in writing SQL queries, managing databases, and performing basic administrative tasks.

This course is ideal for beginners entering the IT field, students pursuing computer science, aspiring database administrators, web developers, and professionals who want to strengthen their database foundations. As data continues to drive business decisions, automation, AI systems, and cloud applications, MySQL knowledge will remain highly valuable in the future. Building strong fundamentals today opens pathways to advanced database management, data engineering, cloud computing, and analytics careers.



Who this course is for:

  • Beginner IT Students and Computer Science Learners Students who want to build a strong foundation in databases will benefit from practical exposure to MySQL. This course simplifies core concepts and provides hands-on experience, making it easier to understand relational databases and SQL operations early in their academic journey.
  • Aspiring Database Administrators (DBAs) Individuals planning a career in database administration can use this course as a starting point. It introduces essential administrative tasks and database management fundamentals required for more advanced DBA roles.
  • Web Developers and Backend Developers Developers who work with dynamic websites and applications need database skills to manage user data, transactions, and application records. This course strengthens their ability to design and manage structured data effectively.
  • Data Enthusiasts and Career Switchers Professionals transitioning into tech or data-related roles can gain foundational database knowledge that supports careers in data analysis, cloud computing, and software development.

Report abuse