Database Exercises
This page provides a collection of hands-on exercises designed to strengthen Database skills. Engage with practical challenges that simulate real-world scenarios, covering topics from basic SQL queries to complex database design and optimization. Solving these exercises offers a direct way to apply theoretical knowledge and build practical proficiency in database management.
Discover categories
AllLinuxDevOpsCybersecurityAWSCybersecurity EngineerDevSecOpsNetworkingCompTIAKali LinuxWiresharkNmapHydraRed Hat Enterprise LinuxRHCSA TrainingRHCE in Enterprise Linux TrainingLFCS TrainingShellDevOps EngineerGitDockerKubernetesCKA TrainingCKAD TrainingCKS TrainingAnsibleRHCE in Ansible TrainingJenkinsCloudflareDatabaseMySQLPostgreSQLRedisMongoDBSQLiteData ScienceBig DataPythonGolangRustJavaCC++Web Development
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.
ChallengeDatabase
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.
ChallengeDatabase
Create a Product Catalog Table
A local bookstore needs help setting up their product catalog database with proper table structure, data types, and constraints
ChallengeDatabase
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.
LabDatabase
MySQL Table Structure and Data Types
In this lab, we will explore the fundamentals of MySQL table structures and data types
LabDatabase
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.
LabDatabase
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.
LabDatabase
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.
LabDatabase
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.
LabDatabase
Insert Data in MongoDB
Learn essential MongoDB data insertion techniques, from single document inserts to bulk operations, with practical examples and error handling strategies.
LabDatabase
Delete MongoDB Data
Learn essential MongoDB data deletion techniques, including single document removal, bulk deletes, conditional deletion, and collection clearing in this hands-on practical lab.
LabDatabase
Update MongoDB Records
Learn essential MongoDB update techniques, from modifying single documents to performing bulk updates using powerful update operators in this hands-on lab.
LabDatabase
Honor Roll Tracker
Learn to manage student academic performance using MongoDB, creating and querying a database to track honor roll achievements.
ChallengeDatabase
Populate the Students Collection
Learn how to insert multiple documents into a MongoDB students collection using the insertMany() method, exploring data insertion techniques.
ChallengeDatabase
Database Management Basics with PostgreSQL
In this lab, you will learn the fundamentals of database management using PostgreSQL. The lab covers creating, listing, connecting to, and dropping databases. Explore basic database administration tasks and view database metadata in PostgreSQL.
LabDatabase