Featured resource
2026 Tech Forecast
2026 Tech Forecast

1,500+ tech insiders, business leaders, and Pluralsight Authors share their predictions on what’s shifting fastest and how to stay ahead.

Download the forecast

Introduction to PostgreSQL

Course Summary

The Introduction to PostgreSQL training course focuses on installing, configuring, and tuning PostgreSQL as a Relational Database Management System (RDBMS) for use with Java, Hypertext Preprocessor (PHP), Ruby, and .NET. The training is structured around the most recent PostgreSQL 9.x release.

The course begins with an overview of PostgreSQL including installation, architectural fundamentals, and creating and accessing a database. Next, participants will review the SQL language which includes concepts, creating tables, populating tables, querying, joins, and functions. With the foundation laid, the course then dives into PostgreSQL advanced features, internals, installation, and server setup. The course concludes with a lesson on server configuration, managing databases, routing maintenance tasks, backing up and restoring, and monitoring database activity.

Purpose
Learn how to install, configure, and administer PostgreSQL, the world's most advanced open source database
Audience
Experienced Developers and Administrators wanting to have a production-quality command of PostgreSQL
Role
System Administrator
Skill Level
Intermediate
Style
Lecture | Hands-on Activities | Labs
Duration
3 Days
Related Technologies
PostgreSQL | SQL

 

Learning Objectives
  • Describe the advantages and disadvantages of PostgreSQL vs. other databases
  • Demonstrate how to install PostgreSQL on a Linux/Unix platform
  • Administer basic configuration, including user setup, database design, monitoring, and logging

What You'll Learn:

In the Introduction to PostgreSQL training course, you'll learn:

Getting Started with PostgreSQL

  • Installation
  • Architectural Fundamentals
  • Creating a database
  • Accessing a database

Review of the SQL Language

  • Concepts
  • Creating Tables
  • Populating Tables
  • Querying
  • Joins
  • Functions

Advanced Features

  • Views
  • Foreign Keys
  • Transactions
  • Window Functions
  • Inheritence

Overview of PostgreSQL internals

Installation from Source

  • Requirements
  • Getting the source
  • Upgrading
  • Installation Procedure
  • Post-installation

Server Setup and Operation

  • The PostgreSQL user account
  • Creating a Database cluster
  • Starting the Database server
  • Managing kernel resources
  • Shutting down the server
  • Securing the server

Server Configuration

  • Parameters
  • File locations
  • Connections and Authentication
  • Resource consumption
  • Error reporting and logging
  • Runtime statitistics
  • Vacuuming
  • Versioning and Lock management

Managing Databases

  • Creating databases
  • Template databases
  • Database configuration
  • Destroying a database
  • Tablespaces

Routing Maintenance Tasks

  • Routine Vacuuming
  • Routine reindexing
  • Log file maintenance

Backup and Restore

  • SQL Dump
  • File system level backup
  • Continuous archiving
  • Warm standby servers

Monitoring DB Activity

  • Unix tools
  • Statistics collector
  • Viewing locks
  • Dynamic tracing

PostgreSQL Internals

“I appreciated the instructor's technique of writing live code examples rather than using fixed slide decks to present the material.”

VMware

Dive in and learn more

When transforming your workforce, it's important to have expert advice and tailored solutions. We can help. Tell us your unique needs and we'll explore ways to address them.

Let's chat

By clicking submit, you agree to our Privacy Policy and Terms of Use, and consent to receive marketing emails from Pluralsight.