MySQL Tutorials
MySQL provides a well - structured learning path for relational database management. Our tutorials cover SQL queries, database design, and optimization techniques, suitable for both beginners and intermediate developers. With free labs and practical examples, you'll gain hands - on experience in database operations. Our interactive database playground allows you to practice SQL queries and see instant results.
MySQL Database Access Challenge
A small company needs to set up secure database access with appropriate permissions for their new marketing team users
MySQLSQL
Create Your First MySQL Database
Learn how to create and manage your first MySQL database using essential commands. Perfect for beginners starting with database administration.
MySQL
MySQL Multi-Table Operations
In this lab, we will explore the fundamentals of working with multiple tables in MySQL
MySQLSQL
Installation and Basic Configuration of MySQL
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.
MySQLLinux
MySQL Table Structure and Data Types
In this lab, we will explore the fundamentals of MySQL table structures and data types
MySQLSQL
MySQL User and Privileges Management
In this lab, we will explore user management and privileges in MySQL, essential skills for securing your database system
MySQLSQL
Record Movie Data Challenge
A local cinema needs help setting up their movie database by inserting accurate movie records with titles, release years, genres, and pricing information
MySQLSQL
MySQL Basic Data Manipulation
In this lab, we will explore the fundamental data manipulation operations in MySQL including inserting, selecting, updating, and deleting data using SQL commands.
SQLMySQL
MySQL Data Aggregation and Grouping
In this lab, we will explore data aggregation and grouping in MySQL, essential skills for analyzing and summarizing data in databases
MySQLSQL
MySQL Data Filtering and Sorting
In this lab, we will explore essential techniques for filtering and sorting data in MySQL
MySQLSQL
Author Book Information Challenge
A library database administrator needs help creating a report that combines information from the authors and books tables to generate a comprehensive publication listing
MySQLSQL
MySQL Sales Data Analysis Challenge
A retail store manager needs help analyzing their sales data to make inventory decisions by calculating revenue performance across different product categories
MySQLSQL
Database Management Fundamentals with MySQL
Previously, we have covered the process of installing a MySQL server, connecting to it using a client and performing some basic administration tasks.
MySQLLinuxSQL
Book Search Challenge
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
MySQLSQL
Create a Product Catalog Table
A local bookstore needs help setting up their product catalog database with proper table structure, data types, and constraints
MySQLSQL
Explore MySQL System Tables
Learn how to start the MySQL service and explore system databases and tables to gain insights into MySQL's internal structure and management.
MySQL
MySQL Database Management Fundamentals
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.
MySQLSQL
Online MySQL Playground
LabEx offers an Online MySQL Playground, a cloud-based environment that allows you to quickly set up a MySQL development environment for learning and experimentation.
MySQL
- Prev
- 1
- 2
- 3
- 4
- 5
- 6
- ...
- 10
- Next