PostgreSQL: Getting Started

Get hands-on with PostgreSQL basics and core SQL

Duration 1h 52m Rating (4.6) Price Included with subscription on Pluralsight
Created by Pinal Dave
Last updated 2020-08-13
Platform: Pluralsight Topic: Databases Skills: PostgreSQL SQL

PostgreSQL: Getting Started is a concise, beginner-oriented introduction to Postgres that emphasizes hands-on setup and essential SQL workflows. The course focuses on installing PostgreSQL, writing core queries, and applying joins and basic best practices to real data.

Designed for newcomers and developers seeking a quick refresher, it uses practical demonstrations to teach database concepts, SQL syntax, and everyday maintenance tasks so learners can start using PostgreSQL confidently in development projects.

At a Glance

PostgreSQL: Getting Started is a beginner course that introduces the fundamentals of PostgreSQL and common database workflows.

The course is taught by Pinal Dave and covers installations, basic queries, joins, and a few best practices.

Level Beginner
Rating 4.6 out of 5
Duration 1+ hours
Languages English
Certificate Certificate of completion
Access Access for as long as your subscription is active
Course includes
  • Video lessons
  • Transcripts/closed captions
Price Subscription-based (monthly or annual plans); free trial available

What This Course Teaches

The course frames learning outcomes as concrete, job-relevant competencies learners can demonstrate after completion.

By the end of the course learners will be able to perform core PostgreSQL tasks such as installing the server, writing basic SQL, joining tables, and following simple best practices.

Install PostgreSQL
Install and configure PostgreSQL on a local system for development use.
Write SQL Queries
Write basic SELECT, INSERT, UPDATE, and DELETE statements to manipulate data.
Retrieve Data
Retrieve and filter table data using WHERE, ORDER BY, and simple expressions.
Use Joins
Explain and implement common join types to combine data from multiple tables.
Apply Best Practices
Apply a few basic best practices for writing clearer, more reliable SQL.

How the Course Is Structured

PostgreSQL: Getting Started is organized as a compact series of about ten short modules made up of brief video lessons and demonstrations that let learners move from setup through core SQL topics in a single, focused path.

The complete course runs about 1 hour 52 minutes in total, so most learners can finish it across a few focused study sessions.

Audience & Requirements

This course targets learners who need a concise, practical introduction to PostgreSQL’s core operations and workflows.

It’s designed for complete newcomers as well as practitioners who want a quick, hands-on refresher on installing Postgres and running basic queries.

Who It’s For
  • Beginners new to SQL and relational databases.
  • Application developers who need to use PostgreSQL in projects.
  • Data analysts who query data stored in Postgres.
  • Developers experienced with other databases wanting Postgres-specific basics.
What You’ll Need
  • No prior PostgreSQL experience required.
  • Ability to install software locally (a PostgreSQL installation is recommended).
  • Basic familiarity with database or SQL concepts is helpful but not mandatory.
  • A SQL client or text editor for running queries (psql, pgAdmin, or similar) recommended.

Final Verdict

PostgreSQL: Getting Started is a practical, beginner-focused introduction that makes it easy to learn core Postgres tasks and obtain a completion certificate.

It represents a cost-effective, low-friction option on a subscription platform and is well suited to newcomers or developers who want a quick, applied refresher; learners who need deep, production-grade DBA skills or advanced performance tuning should choose a more comprehensive, specialized course instead.