Featured resource
Tech Upskilling Playbook 2025
Tech Upskilling Playbook

Build future-ready tech teams and hit key business milestones with seven proven plays from industry leaders.

Learn more
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Data

Querying Data from PostgreSQL

In this course, you'll learn how to use PostgreSQL to author queries that retrieve information from databases. Using SQL, you'll learn how to select the data you need, filter that data, and gather data from various tables.

Jason Browning PhD - Pluralsight course - Querying Data from PostgreSQL
by Jason Browning PhD

What you'll learn

While each organization will have its own database preference, data analysts will benefit from knowing the basics of querying data from PostgreSQL, a popular open-source database platform. In this course, Querying Data from PostgreSQL, you will get a comprehensive introduction of how to query data using PostgreSQL and its pgAdmin tool. First, you will learn the basic structure of a relational database. Next, you will discover how to select data from tables, apply criteria and filters to limit your results, and enhance these skills by retrieving data from multiple tables. Finally, you will explore basic aggregation functions and be exposed to ANSI-compliant SQL. When you're finished with this course, you will have the skills and knowledge of PostgreSQL necessary to easily retrieve data from relational databases.

Table of contents

About the author

Jason Browning PhD - Pluralsight course - Querying Data from PostgreSQL
Jason Browning PhD

Jason Browning is a data and analytics professional with extensive experience in both the public and private sector. As a Tableau Desktop Certified Professional, Jason loves to build data visualizations that both inform and inspire.

More Courses by Jason