undefined Tutorials

In this project, you will learn how to create a 'favorite' table in a MySQL database. The 'favorite' table will store the courses with the longest study time for each user in the 'usercourse' table.

In this project, you will learn how to create a custom function in MySQL that returns the larger of two given numbers. This project will guide you through the process of accessing MySQL, importing data, and developing a function to perform a maximum value judgment.

In this project, you will learn how to modify the countrylanguage table in a MySQL database by removing the 'not null' constraint from the IsOfficial field.

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 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 search for students who have taken courses offered by a specific department, in this case, the Biology department. This is a common task that teachers often need to perform when calculating student grades.

In this project, you will learn how to change the default value of a field in a MySQL database table. Specifically, you will be modifying the IsOfficial field in the countrylanguage table of the world database.

In this project, you will learn how to create a stored procedure in MySQL to retrieve courses with credits greater than 3. This project will help you understand the basics of working with stored procedures in a database management system.

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

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

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 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 retrieve the number of users with modify permissions from the user table in a MySQL database.