In this course, you will learn what Structured Query Language (SQL) and databases are, the basics of database management, how to set up and configure MySQL, and how to get MySQL client to connect to a MySQL Server.
17 Labs
Installation and Basic Configuration of MySQL
Explore MySQL System Tables
Database Management Fundamentals with MySQL
Create Your First MySQL Database
MySQL Table Structure and Data Types
Create a Product Catalog Table
MySQL Basic Data Manipulation
Record Movie Data Challenge
MySQL Data Filtering and Sorting
Book Search Challenge
MySQL Multi-Table Operations
Author Book Information Challenge
MySQL Data Aggregation and Grouping
MySQL Sales Data Analysis Challenge
MySQL User and Privileges Management
MySQL Database Access Challenge
Make Database More Secure
In this project, you will learn how to create a new user in a MySQL database. This is a fundamental skill for database management and administration, as creating and managing user accounts is a crucial aspect of securing and controlling access to your database.
Lab
In this hands-on project, you will embark on a journey to master the art of SQL querying by working with the personnel database and its emp table. Through a series of practical exercises, you will acquire the skills necessary to retrieve, filter, and analyze employee data effectively.
Lab
In this project, you will learn how to access a MySQL database, import data, and perform various SQL queries to retrieve information from the `emp` table in the `personnel` database.
Lab
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.
Lab
In this project, you will learn how to create a student view in a MySQL database and update the data in the view.
Lab
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.
Lab
In this project, you will learn how to identify the Most Valuable Player (MVP) recipient in a basketball game using SQL queries. You will create a database, set up a table, and write an SQL statement to determine the player who received the most votes and is awarded the MVP honor.
Lab
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.
Lab
In this project, you will learn how to use a cursor to output the course information from the `section` table where the semester is Spring. You will create a stored procedure to retrieve the course details and then execute the procedure to display the results.
Lab
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.
Lab
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.
Lab
Explore Related Skill Trees
Data Science
Unlock Your MySQL Skills
Completed 0
Locked 28
Join Our Discord and Learn Together
Join Now
