Introduction to PostgreSQL for Developers and Administrators

Customized Onsite Training

  • Customized Content
  • For Groups of 5+
  • Online or On-location
  • Expert Instructors

The primary objective of this course is to provide an introduction to the PostgreSQL database. The course targets both administrators and developers.

  1. Learn about the history of PostgreSQL.
  2. Learn where to find PostgreSQL documentation and resources.
  3. Understand PostgreSQL Server Architecture.
  4. Learn about different popular PostgreSQL clients.
  5. Learn to work with PostgreSQL functions.
  6. Learn to create your own functions.
  7. Learn to program with plpgsql.
  8. Learn to install and setup PostgreSQL securely.
  9. Learn basic administration tasks such as user creation, cataloging and backing up.
  10. Learn about SLONY and PGPOOL.
  11. Understand inheritance in PostgreSQL.
  12. Learn to partition tables.
  13. Learn to use Tablespaces.
  14. Learn about database monitoring.
  15. Understand the EXPLAIN Statement
  16. Learn about PITR
  17. Learn to tune the Postgresql Server
  1. Intro and Architecture
    1. History and Overview
    2. PostgreSQL Major Features
    3. PostgreSQL Limits
    4. PostgreSQL Architecture
    5. MVCC
    6. Write Ahead Logs
    7. The Background Writer
    8. PostgreSQL Data Types
  2. Installation
    1. Overview
    2. Binary Installation
    3. Source Installation
    4. Initializing a PostgreSQL cluster
    5. Starting and stopping a PostgreSQL cluster
    6. Automatic startup/shutdown
    7. Lab
  3. Configuration
    1. Access Control
    2. Connection settings
    3. Security and Authentication settings
    4. Memory settings
    5. Kernel resource settings
    6. Log management
    7. Background writer settings
    8. Vacuum cost settings
    9. Autovacuum settings
    10. Lab
  4. Intro to psql
    1. Command line parameters
    2. Meta commands
    3. Security
    4. Lab
  5. Managing PostgreSQL Databases
    1. PostgreSQL Clusters
    2. PostgreSQL Databases
    3. Tables, Joins and Aggregates
    4. PostgreSQL Indexes and Foreign Keys
    5. Lab
  6. Roles and Security
    1. Schemas
    2. Tables, Views and Rules
    3. Users, Groups and Roles
    4. Tables and Sequences
    5. Object Security
    6. Lab
  7. Tablespaces, Partitioning and Advanced Features
    1. Vacuum
    2. Tablespaces
    3. Inheritance
    4. Table Partitioning
    5. Windowing Functions
    6. Transactions
    7. Concurrency Control
    8. Functions and Operators
    9. Type conversion
    10. Full text search
    11. Lab
  8. Moving Data with PostgeSQL
    1. Basic DML
    2. COPY
    3. Other Tools
    4. Lab
  9. Routine DBA Tasks and Best Practices
    1. Log Management
    2. Query analysis
    3. Routine Vacuuming
    4. Recovering disk space
    5. Managing Planner statistics
    6. REINDEX
    7. Lab
  10. Monitoring and Statistics
    1. Database Logs
    2. OS Process monitoring
    3. The PostgreSQL Statistics Collector
    4. Statistics Views
    5. Statistics Functions
    6. Lab
  11. Performance Tuning
    1. OS Tuning
    2. Hardware configuration
    3. Transaction logs
    4. Tablespaces and Partitioning
    5. Checkpoint tuning
    6. Query tuning
    7. Lab
  12. Backup and Recovery
    1. The pg_dump utility
    2. The pg_dumpall utility
    3. Recovery options
    4. Point In Time Revovery
    5. Lab
  13. PostgreSQL Upgrades
    1. The pg_upgrade utility
    2. RPM based upgrades
    3. Source based upgrades
    4. Replication based upgrades
    5. Rolling back
    6. Lab
  14. Replication and HA
    1. Streaming Replication
    2. Synchronous Replication
    3. Replication Slots
    4. Failover management
    5. Connection Poolers
    6. HA configurations
    7. Lab
  15. Triggers
    1. Overview
    2. Triggers
    3. Lab
  16. Event Triggers
    1. Overview
    2. Event Triggers
    3. Lab
  17. RULEs
    1. Overview
    2. SELECT Views
    3. Updating a View
    4. Materialized Views
    5. Rules and privileges
    6. Lab
  18. The PL/pgSQL Language
    1. Structure
    2. Declarations
    3. Expressions
    4. Statements
    5. Control Structures
    6. Cursors
    7. Errors and Messages
    8. Trigger Procedures
  19. Other Procedural Languages
    1. PL/Perl
    2. PL/Python
    3. More...
  20. PostgreSQL Contribs
    1. Overview of additionally supplied modules
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this PostgreSQL class:

  • Oracle SQL as taught in our Introduction to Oracle SQL and Advanced Oracle SQL classes.
Preparing for Class

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing


Students who have taken Live Online Training


Organizations who trust Webucator for their training needs


Satisfaction guarantee and retake option


Students rated our Introduction to PostgreSQL for Developers and Administrators trainers 7.17 out of 10 based on 11 reviews

I liked the instructor. I liked the book. I liked the way the instructor and the facilitator ensured that my PC and I were both 100% ready to take an online class far in advance of it starting. I liked the many reminders to check in on the website to do all the software and hardware prep work. It was all managed very well!

Jessica Short, City of San Jose
San Jose CA

Good class. Great way to get an instructor to your location when on a tight budget. Webucator was aware of our needs and made sure that all of them were met. Thanks.

Rocco Rosa, Public Health Agency of Canada
Guelph ON

This Introduction to Crystal Reports 2011 class was exactly what I was looking for. The instructor was great! I highly recommend taking this course.

Alyx Dimino, SAGE Publications
Thousand Oaks CA

Great instructor! Class was tailored to our needs as a company. We will invite Webucator back!

Lori Council, Midwest Mole Inc

Contact Us or call 1-877-932-8228