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.

Online PostgreSQL Database Playground

Online PostgreSQL Database Playground

LabEx provides an Online PostgreSQL Database Playground, an online environment that allows you to quickly set up a PostgreSQL database environment.

PostgreSQL PgBouncer Connection Pooling

PostgreSQL PgBouncer Connection Pooling

In this lab, you will learn how to configure and use PgBouncer for connection pooling with PostgreSQL. You'll configure PgBouncer, connect through it, simulate multiple client connections, and monitor pooling performance. Improve database performance with efficient connection management.

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.

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.

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.

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.

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 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 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 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 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 Streaming Replication

PostgreSQL Streaming Replication

In this lab, you will learn how to set up PostgreSQL streaming replication. You will configure a primary server to accept replication connections, create a replica server from a base backup, and verify that data changes are automatically copied from the primary to the replica in near real-time.

PostgreSQLLinux

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 Role and Permission Management

PostgreSQL Role and Permission Management

In this lab, you will explore PostgreSQL role and permission management. The primary goal is to learn how to create roles with specific attributes and manage database privileges. You'll grant privileges, switch users, and revoke access.

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.

Using the PostGIS Extension in PostgreSQL

Using the PostGIS Extension in PostgreSQL

In this lab, you will learn how to use the PostGIS extension to add spatial capabilities to a PostgreSQL database. You will create a dedicated spatial database, enable the PostGIS extension, create a table with geographic data, and perform spatial queries to analyze the data.

How to start PostgreSQL in Kali Linux

How to start PostgreSQL in Kali Linux

Discover how to set up and manage PostgreSQL databases in Kali Linux, a powerful cybersecurity tool. Learn the essential steps to get started with PostgreSQL for your cybersecurity projects.

PostgreSQLLinux

PostgreSQL JSON/JSONB Advanced Operations

PostgreSQL JSON/JSONB Advanced Operations

In this lab, you will explore advanced operations on PostgreSQL JSON/JSONB data types. The lab focuses on enhancing query performance and data manipulation within JSONB columns. Learn to index JSONB fields, query nested structures, update elements, and aggregate JSON data.

Prev
1
2
Next