undefined Tutorials

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.

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 data aggregation and grouping in MySQL, essential skills for analyzing and summarizing data in databases

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 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 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 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.

In this project, you will learn how to manage user permissions in a MySQL database. Specifically, you will create a new local user named 'Rong' and grant them access to the performance_schema database.

In this project, you will learn how to create a student view in a MySQL database and update the data in the view.

In this project, you will learn how to update a student's GPA (Grade Point Average) in a database using the UPDATE statement in SQL.

In this project, you will learn how to retrieve the top 5 countries by land area from the MySQL country table. You will learn how to access MySQL, import data, and write SQL queries to retrieve the desired information.

In this project, you will learn how to use subqueries to retrieve relevant information from the employee (emp) and department (dept) tables in the personnel database. You will practice writing complex SQL queries to access and analyze data from multiple tables.

In this project, you will learn how to create a database view based on the student table in the edusys database. The view will include the ID, name, and dept_name columns from the student table, providing a simplified and focused view of the student data.

In this project, you will learn how to create a student information management system using MySQL. This system includes two tables: student_info and student_score, with a foreign key relationship between them.

In this project, you will learn how to retrieve the maximum and minimum salary for each department in a MySQL database using built-in functions and SQL queries.