MySQL Tutorials

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.

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

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

In today's lab, we will learn and practice how to modify, delete, rename the database table and the contents of the table and other operations.

In this lab, we will learn and practice index, view, backup and recovery. These concepts are very crucial for a database manager.

SELECT statement, one of the most commonly used statements in SQL, is used to select data in a table. This lab will learn SELECT and how to apply it to real practices.

In this lab, you'll learn how to configure and deploy a LAMP (Linux, Apache, MySQL, PHP) stack to create a dynamic web server. LAMP is a widely used open-source web server environment that combines the Linux operating system, Apache HTTP server, MySQL database, and PHP scripting language. These components form a powerful platform for building web applications. In this lab, we'll set up a LAMP server and deploy a WordPress blog to understand how this stack works.

This project guides you through creating a simple URL shortener service using Flask and MySQL. You'll learn to set up a database, design a web interface, and implement functionality to shorten URLs, search for URLs by tags, and view analytics. The project is beginner-friendly and offers a comprehensive insight into web development with Python and database management.

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 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 a new user in a MySQL database, set the maximum number of connections, and configure the binary log retention period. This project is designed to help you understand the basic database administration tasks and how to automate them using SQL scripts.

In this project, you will learn how to create a university information query system using Java and MySQL. This project will guide you through the process of setting up a MySQL database, connecting to it using Java, and querying information about students, courses, and instructors.

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