Database Tutorials

In this lab, you will explore basic data management techniques in Redis. You'll begin by learning how to increment and decrement numerical values using the atomic `INCR` and `DECR` commands, suitable for counters and rate limiters. You'll connect to the Redis server using `redis-cli`, set initial values, and then increment and decrement them, verifying the results with the `GET` command. Furthermore, you will learn how to retrieve all keys stored in Redis using the `KEYS` command.

In this lab, we will explore basic key-value operations in Redis, focusing on how to interact with Redis as a data store. We'll use the `redis-cli` command-line interface to connect to the Redis server and perform fundamental operations. We will learn how to set and retrieve key-value pairs using the `SET` and `GET` commands. Furthermore, we will practice setting different key-value pairs to solidify our understanding of these core operations.

In this challenge, you will design and create a `employee_contacts` table in PostgreSQL to store employee contact details, ensuring data integrity through appropriate data types and constraints. You'll be working within a pre-configured environment where an `employees` table already exists.

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.

In this lab, you will learn how to optimize PostgreSQL database performance through indexing. You'll create a sample table, analyze query plans, build multi-column indexes, and remove unused indexes. This hands-on experience provides practical skills in PostgreSQL index management.

In this challenge, you'll leverage your SQL skills to query specific data within an SQLite database named `treasure.db`. The goal is to retrieve a hidden artifact by crafting a `SELECT` statement that filters results based on the artifact's `id`. You'll connect to the database, write a query to select the `name` column from the `artifacts` table, and use a `WHERE` clause to identify the artifact with an `id` of 2.

In this lab, we will explore PostgreSQL table creation and data types. We'll connect to PostgreSQL using `psql`, create tables with primary keys, and add constraints like `NOT NULL` and `UNIQUE`. We will then inspect the table structure and insert data to demonstrate data types.

In this lab, we will install and perform the initial setup of PostgreSQL on the LabEx VM. The goal is to get PostgreSQL up and running and verify its basic functionality. We will explore default databases and check server status and basic configuration.

In this lab, you will learn how to install and perform the initial setup of Redis on a LabEx VM. The lab covers essential steps to get Redis up and running, including verifying the installation and ensuring the server is accessible. You'll update packages, install Redis, and test connectivity.

In this challenge, you'll step into the role of a database administrator and manage employee data within a PostgreSQL database. The task involves using PostgreSQL commands to update employee records in the `employees` table to reflect changes in the organization.

In this lab, you will learn how to perform data filtering and simple queries in PostgreSQL. You'll use WHERE clause to filter data, LIKE for pattern matching, ORDER BY for sorting, and LIMIT and OFFSET to control result set size. Connect to a PostgreSQL database and create a sample table.

In this lab, you will explore PostgreSQL relationships and joins. You'll create tables with foreign key constraints, insert data ensuring referential integrity, query data using INNER JOIN, and compare LEFT, RIGHT, and FULL OUTER JOIN results to understand data relationships.

In this lab, you will explore fundamental Redis data structures and how to interact with them using the `redis-cli` command-line tool. The lab focuses on practical exercises to help you understand how to store and retrieve data in Redis. You'll work with Strings, Lists, Sets, and Hashes.

In this challenge, verify PostgreSQL server operational status after a critical alert. Confirm the server accepts connections and connect to the 'postgres' database using `pg_isready` and `psql` commands as the `postgres` user. Ensure the PostgreSQL service is functioning correctly.

In this lab, we will explore how to manage Redis configuration and persistence. We'll use `CONFIG GET` to view configuration, `CONFIG SET` to modify parameters, and `SAVE` and `BGSAVE` to save data to disk. This provides a comprehensive understanding of data persistence in Redis.

In this lab, you will learn how to perform data filtering and simple queries in PostgreSQL. You'll use WHERE clause to filter data, LIKE for pattern matching, ORDER BY for sorting, and LIMIT and OFFSET to control result set size. Connect to a PostgreSQL database and create a sample table.

In this challenge, you'll embark on a culinary journey by creating your own recipe database using PostgreSQL. As a budding food blogger, you'll set up a dedicated database named `recipe_db` to manage your growing collection of recipes.

In this challenge, you'll assist the HR department by extracting a list of Marketing employees from a PostgreSQL database. You'll need to write a SQL query to select the `id` and `name` of employees in the 'Marketing' department, and save the query results to a file for verification.