LabEx
Join Free

Database Tutorials

Our database tutorials provide well-structured learning paths for both SQL and NoSQL databases. Covering essential concepts, query languages, database design, and optimization techniques, our tutorials are suitable for both beginners and intermediate developers. With free labs and practical examples, you'll gain hands-on experience in database operations across different database systems.

Other Skill Trees

LinuxDevOpsCybersecurityDevOps EngineerCybersecurity EngineerDevSecOpsKali LinuxRed Hat Enterprise LinuxRHCSA TrainingRHCE in Enterprise Linux TrainingLFCS TrainingShellGitDockerKubernetesCKA TrainingCKAD TrainingCKS TrainingAnsibleRHCE in Ansible TrainingJenkinsNmapWiresharkHydraCompTIAMySQLPostgreSQLRedisMongoDBSQLitePythonGolangJavaCC++Web DevelopmentData Science
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
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
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
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
Create MongoDB Collection

Create MongoDB Collection

Learn fundamental MongoDB skills by creating a database, inserting documents, and performing basic collection management in this beginner-friendly hands-on lab.
MongoDB
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
Your First MongoDB Lab

Your First MongoDB Lab

Learn the basics of MongoDB by creating a database, inserting documents, and performing simple data operations in this beginner-friendly hands-on lab.
MongoDB
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
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
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 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
Insert Data in MongoDB

Insert Data in MongoDB

Learn essential MongoDB data insertion techniques, from single document inserts to bulk operations, with practical examples and error handling strategies.
MongoDB
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 Multi-Table Operations

MySQL Multi-Table Operations

In this lab, we will explore the fundamentals of working with multiple tables in MySQL
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
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
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
  • Prev
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • ...
  • 135
  • Next