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.

28 Skills|2 Courses

PostgreSQL for Beginners

PostgreSQL Courses

PostgreSQL for Beginners

Beginner

PostgreSQLDatabase

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

Beginner

PostgreSQLDatabase

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