Introduction to PostgreSQL

Skip to Scheduled Dates

Course Overview

What good is a terabyte of data if no one knows how to query it? Over 60% of hiring managers ranked SQL as one of the top three most in-demand skills, with PostgreSQL leading among open-source relational database systems. Knowing how to work with relational data, write queries, and manage databases is essential for teams building modern data solutions.

This hands-on PostgreSQL tutorial teaches you how to use PostgreSQL to query, create, and manage databases using SQL. You’ll work directly with a relational database, gain experience with real-world database management techniques, and learn how to integrate PostgreSQL with Python for automation and reporting.

Private classes on this topic are available. We can address your organization’s issues, time constraints, and save you money, too. Contact us to find out how.

Course Objectives

    This course is designed to give learners a practical introduction to PostgreSQL. You’ll also gain context around how PostgreSQL compares to other RDBMS tools like MySQL, Oracle, and MongoDB, and understand what makes Postgres uniquely flexible with features like JSON support and robust constraint handling.

    • Set up and connect to a PostgreSQL database using standard tools
    • Write SQL queries to extract, filter, and aggregate relational data
    • Create and manage structured databases and tables with constraints
    • Integrate PostgreSQL with Python to automate and extend your workflow

Course Outline

Setup of PostgreSQL

  • Install and configure PostgreSQL on your local machine
  • Create a database and connect to it using psql
  • Explore Postgres user roles and permissions
  • Use PostgreSQL to manage schemas in an RDBMS context

Use SQL to Query Data

  • Learn SQL syntax to retrieve and filter relational data
  • Analyze results using aggregate functions and GROUP BY
  • Merge data across tables using JOINs
  • Use string operations, logical operators, and conditional expressions
  • Compare PostgreSQL’s query syntax to MySQL, Oracle, and MongoDB alternatives

Creation of Databases and Tables

  • Create and manage new databases and structured tables
  • Apply data types and constraints like primary/foreign keys
  • Insert, update, and delete records with SQL
  • Ensure relational integrity across multiple tables

Combination of PostgreSQL and Python

  • Connect a PostgreSQL database to Python scripts
  • Use libraries to query, retrieve, and process data
  • Automate reporting tasks and lightweight ETL
  • Demonstrate how PostgreSQL supports integration for real-world automation

< Back to Course Search

Class Dates & Times

Class times are listed Eastern time

This is a 2-day class

Class dates not listed.
Please click here to contact us for available dates and times.

The classes listed are available to all United Training customers and does not reflect, in any way,
the availability or support of technology within the University of Maine System.