MySQL Free Labs

Learn how to start the MySQL service and explore system databases and tables to gain insights into MySQL's internal structure and management.

Learn how to create and manage your first MySQL database using essential commands. Perfect for beginners starting with database administration.

A local bookstore needs help setting up their product catalog database with proper table structure, data types, and constraints

In this lab, we will explore the fundamental data manipulation operations in MySQL including inserting, selecting, updating, and deleting data using SQL commands.

In this lab, we will explore the fundamentals of MySQL table structures and data types

Previously, we have covered the process of installing a MySQL server, connecting to it using a client and performing some basic administration tasks.

Learn how to install, secure, and perform basic operations in MySQL, a popular open-source relational database management system. This lab covers verifying installation, securing the MySQL instance, accessing the MySQL shell, creating databases and tables, and performing basic data operations.

In this lab, you will learn how to create and use custom functions in MySQL. The lab focuses on encapsulating reusable logic within your database by creating a function to calculate the area of a rectangle. Steps involve creating, using, testing, and dropping a MySQL function.

In this lab, you will learn about MySQL indexes and performance optimization techniques. The lab focuses on creating and managing indexes to improve database query performance. You'll analyze query plans, add composite indexes, and remove unused indexes.

In this lab, you will learn the basics of MySQL stored procedures. The goal is to understand how to create, call, and modify stored procedures to manage data within a MySQL database. You will learn to insert data, call procedures, add parameters, and drop procedures.

In this lab, you will explore MySQL subqueries and nested operations, focusing on using subqueries within the WHERE clause. Learn to filter data, use EXISTS, test correlated subqueries, and compare performance. Connect to MySQL, create databases, and construct SQL queries.

In this lab, you will explore MySQL transactions and their importance in maintaining data integrity. You'll learn how to use transactions to ensure that a series of SQL operations are treated as a single unit of work. The lab covers BEGIN, COMMIT, ROLLBACK, and savepoints.

In this lab, you will learn how to automate tasks in MySQL using triggers. The lab focuses on creating a trigger that logs insert operations on a `products` table into a separate `product_logs` table. You will test, update, and drop the trigger.

In this lab, you will learn how to work with MySQL views, which are virtual tables based on the result-set of an SQL statement. The lab covers creating, updating, querying, and dropping MySQL views. You'll create a database, populate it with data, and then create and manipulate a view.

In this lab, you will learn how to perform disaster recovery by creating a logical backup of a MySQL database using mysqldump and restoring it after simulating data loss.