Learn PostgreSQL

Learn PostgreSQL with a comprehensive learning path designed for beginners. These PostgreSQL courses provide a structured roadmap to master the powerful, open-source relational database system. Progress through topics like fundamental SQL, database design, and administration. Gain practical, real-world experience through hands-on, non-video tutorials and interactive exercises in a dedicated SQL playground focused on database management and querying.

42 Skills|5 Courses

PostgreSQL for Beginners

DatabasePostgreSQL

In this course, learn PostgreSQL basics from installation to data operations, including database management, table creation, and simple queries.

Completed 0 of 10 Labs

Installation and Initial Setup of PostgreSQL

Verify PostgreSQL Connection Details

Database Management Basics with PostgreSQL

Create Your Own Recipe Database

PostgreSQL Table Creation and Data Types

Create Employee Table in PostgreSQL

Basic Data Operations in PostgreSQL

Manage Employee Data in PostgreSQL

Data Filtering and Simple Queries in PostgreSQL

Find Marketing Employees in PostgreSQL

Advanced PostgreSQL Practical Labs

DatabasePostgreSQL

In this course, master PostgreSQL through hands-on labs covering relationships, advanced data types, indexing, transactions, views, permissions, queries, triggers, backups, partitioning, full-text search, and more.

Completed 0 of 20 Labs

Closing Sales Across Time Zones

ProjectPostgreSQLDatabase

Close each venue’s local sales day with reusable PostgreSQL queries and complete ticket reports across midnight and daylight-saving changes.

Completed 0 of 2 Labs

Preventing Overbooked Workshops

ProjectPostgreSQLDatabase

Build atomic PostgreSQL group bookings that protect the last places, preserve original reservations and roll back failed confirmations.

Completed 0 of 3 Labs

Limiting Access to Exhibitor Records

ProjectPostgreSQLDatabase

Protect shared PostgreSQL registration records with real account ownership, safe writes and continued organizer access.

Completed 0 of 2 Labs