undefined Tutorials

In this lab, we will explore data aggregation and grouping in MySQL, essential skills for analyzing and summarizing data in databases

A local cinema needs help setting up their movie database by inserting accurate movie records with titles, release years, genres, and pricing information

A retail store manager needs help analyzing their sales data to make inventory decisions by calculating revenue performance across different product categories

A small company needs to set up secure database access with appropriate permissions for their new marketing team users

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

A local bookstore is looking to improve their inventory management system by implementing a database query system to search for technical books based on publication date and price

A library database administrator needs help creating a report that combines information from the authors and books tables to generate a comprehensive publication listing

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

In this lab, we will explore user management and privileges in MySQL, essential skills for securing your database system

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

In this lab, we will explore the fundamentals of working with multiple tables in MySQL

In this lab, we will explore essential techniques for filtering and sorting data in MySQL

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 project, you will learn how to perform various DDL (Data Definition Language) operations on a MySQL database. You will create a database, tables, modify table structures, delete data, and drop tables and databases.

In this challenge, we will learn how to make the database more secure.

In this project, you will learn how to access a MySQL database using the sudo command and write an SQL query to calculate the duration of the Wuxu Reform, also known as the 'Hundred Days' Reform'.

In this project, you will learn how to retrieve and view the user permission information from the MySQL database. This project is designed to help you understand the MySQL user management and permission system, which is an essential skill for database administrators and developers.

In this project, you will learn how to create and use database views in MySQL. Database views are virtual tables that provide a customized perspective of the underlying data, allowing you to hide certain data processes from users and simplify data access.