LabEx
Join Free

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.

Other Skill Trees

LinuxDevOpsCybersecurityDevOps EngineerCybersecurity EngineerDevSecOpsKali LinuxRed Hat Enterprise LinuxRHCSA TrainingRHCE in Enterprise Linux TrainingLFCS TrainingShellGitDockerKubernetesCKA TrainingCKAD TrainingCKS TrainingAnsibleRHCE in Ansible TrainingJenkinsNmapWiresharkHydraCompTIADatabasePostgreSQLRedisMongoDBSQLitePythonGolangJavaCC++Web DevelopmentData Science
MySQL Data Filtering and Sorting

MySQL Data Filtering and Sorting

In this lab, we will explore essential techniques for filtering and sorting data in MySQL
MySQL
Author Book Information Challenge

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
MySQLLinux
Book Search Challenge

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
MySQLLinux
Record Movie Data Challenge

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
MySQL
MySQL Data Aggregation and Grouping

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
MySQL
MySQL User and Privileges Management

MySQL User and Privileges Management

In this lab, we will explore user management and privileges in MySQL, essential skills for securing your database system
MySQL
MySQL Backup and Recovery

MySQL Backup and Recovery

In this lab, you will learn how to back up and restore MySQL databases using the `mysqldump` command-line tool. The lab covers essential techniques for creating logical backups and restoring them to ensure data integrity and availability.
MySQL
Database Management Fundamentals with MySQL

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.
MySQL
Create a Product Catalog Table

Create a Product Catalog Table

A local bookstore needs help setting up their product catalog database with proper table structure, data types, and constraints
MySQL
Create Your First MySQL Database

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 Table Structure and Data Types

MySQL Table Structure and Data Types

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

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
MySQLLinux
Build URL Shortener with Flask MySQL

Build URL Shortener with Flask MySQL

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.
HTMLPythonMySQLCSS
MySQL Common Table Expressions (CTEs)

MySQL Common Table Expressions (CTEs)

In this lab, you will learn how to use Common Table Expressions (CTEs) in MySQL to improve query readability and maintainability. The lab covers defining simple CTEs using the `WITH` clause, writing recursive CTEs for hierarchical data, joining CTEs with tables, and testing CTE query output.
MySQL
MySQL Basic Data Manipulation

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.
MySQL
MySQL Multi-Table Operations

MySQL Multi-Table Operations

In this lab, we will explore the fundamentals of working with multiple tables in MySQL
MySQL
Installation and Basic Configuration of MySQL

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 Database Access Challenge

MySQL Database Access Challenge

A small company needs to set up secure database access with appropriate permissions for their new marketing team users
MySQL
  • Prev
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • ...
  • 62
  • Next