LabEx
Log InJoin For Free

PostgreSQL Tutorials

PostgreSQL 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

LinuxDevOpsCybersecurityDatabasePythonDockerKubernetesGitShellNmapWiresharkHydraJavaBig DataSQLiteMySQLRedisMongoDBGolangC++CAnsibleData ScienceMachine LearningPandasNumPyscikit-learnMatplotlibWeb DevelopmentHTMLCSSJavaScriptReactKali Linux
Data Filtering and Simple Queries in PostgreSQL

Data Filtering and Simple Queries in PostgreSQL

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.
PostgreSQL
Find Marketing Employees in PostgreSQL

Find Marketing Employees in PostgreSQL

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.
PostgreSQL
Manage Employee Data in PostgreSQL

Manage Employee Data in PostgreSQL

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.
PostgreSQL
Create Employee Table in PostgreSQL

Create Employee Table in PostgreSQL

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.
PostgreSQL
Create Your Own Recipe Database

Create Your Own Recipe Database

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.
PostgreSQL
Verify PostgreSQL Connection Details

Verify PostgreSQL Connection Details

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.
PostgreSQL
PostgreSQL Relationships and Joins

PostgreSQL Relationships and Joins

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.
PostgreSQL
PostgreSQL Index Optimization

PostgreSQL Index Optimization

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.
PostgreSQL
Basic Data Operations in PostgreSQL

Basic Data Operations in PostgreSQL

In this lab, we will explore basic data operations in PostgreSQL. We'll learn to insert data, query with SELECT, update records, and delete records within a PostgreSQL database using SQL commands. This provides a hands-on introduction to essential data management techniques.
PostgreSQL
Database Management Basics with PostgreSQL

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.
PostgreSQL
Installation and Initial Setup of PostgreSQL

Installation and Initial Setup of PostgreSQL

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.
PostgreSQL
PostgreSQL Table Creation and Data Types

PostgreSQL Table Creation and Data Types

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.
PostgreSQL
Data Filtering and Simple Queries in PostgreSQL

Data Filtering and Simple Queries in PostgreSQL

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.
PostgreSQL
PostgreSQL Views Management

PostgreSQL Views Management

In this lab, you will explore PostgreSQL Views Management. The primary goal is to understand and implement different types of views, including simple views and materialized views. You'll learn to define, query, modify, create, populate, and refresh views.
PostgreSQL
PostgreSQL Trigger Automation

PostgreSQL Trigger Automation

In this lab, you will learn how to automate tasks in PostgreSQL using triggers. Create a trigger function using PL/pgSQL to log salary changes in an `employees` table to a `salary_changes` table. You'll write the function, bind it to a table event, test it, and disable/drop it.
PostgreSQL
PostgreSQL Stored Function Development

PostgreSQL Stored Function Development

In this lab, you will learn how to develop PostgreSQL stored functions. The lab guides you through the process of defining a basic stored function, adding input parameters, and executing it within a query. You will also learn how to remove an unused function.
PostgreSQL
PostgreSQL Transaction Management

PostgreSQL Transaction Management

In this lab, you will explore PostgreSQL transaction management, a crucial aspect of ensuring data integrity. You'll learn to begin and commit transactions, roll back failed transactions, set isolation levels, and simulate locks with concurrent updates. Practice with accounts table and fund transfers.
PostgreSQL
PostgreSQL Table Partitioning

PostgreSQL Table Partitioning

In this lab, you will learn how to implement table partitioning in PostgreSQL. The goal is to divide a large table into smaller, more manageable pieces to improve query performance and simplify data management. You will set up a range-partitioned table, define partitions by date ranges, insert data, and query across partitions.
PostgreSQL
  • Prev
  • 1
  • 2
  • Next