Learning Paths

Querying Data with SQL from PostgreSQL

5 courses
10 hours
Skill IQ

SQL (“sequel” or Structured Query Language) is a common language used to query and manage data in relational database and data stream management systems. This skill will teach you how to use SQL to query data from the PostgreSQL relational database.

Courses in this path

Beginner

Learn to use the SELECT statement, along with JOINs and WHERE clasues, to create organized projections of data stored in PostgreSQL.

Querying Data from PostgreSQL

by Jason Browning
1h 28m
(150)

Combining and Filtering Data with PostgreSQL 9

by Jason Browning
1h 57m
(41)

Intermediate

Insert, update, and delete data from PostgreSQL.

PostgreSQL Data Manipulation Playbook

by Ami Levin
2h 34m
(47)

Advanced

Create PostgreSQL database objects, such as functions to capture reusable query logic.

Capturing Logic with Custom Functions in PostgreSQL

by Gerald Britton
1h 54m
(11)

PostgreSQL Functions Playbook

by Gerald Britton
2h 28m
(21)

Try for free

Get this learning path plus top-rated picks in tech skills and other popular topics.

Your 10 day free trial includes

Expert-led courses

Keep up with the pace of change with thousands of expert-led, in-depth courses.

For teams

Give up to 10 users access to our full library including this path free for 14 days

What You Will Learn

Querying data with the SELECT statement
Filtering data with the WHERE clause
Combining data with JOINs
Aggregating data
Inserting, updating, and deleting data

Experience

Relational database literacy

Learn with the best

Jason Browning

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. He is capable of wrangling messy data both inside and outside of Tableau, and using SQL to perform complex queries. He works in higher education as a data governance and management consultant, and holds a Ph.D. in higher education administration from the University o... more

Ami Levin

Ami has been teaching, consulting, and mentoring data professionals for over 20 years. Ami's broad theoretical knowledge in data management is complemented by extensive hands-on experience working as a data tier architect, performance tuning expert, and a SQL developer, while at the same time directing and teaching others how to get the most value from their data. Ami owns a US patent for an automatic solution for optimizing database performance. Ami has been highly involved in the SQL communit... more

Gerald Britton

Gerald Britton is a Pluralsight author and expert on Python programming practices and Microsoft SQL Server development and administration. A multiple-year of the Microsoft MVP award, Gerald has led introductory classes in Python and SQL for industry-sponsored events at Ryerson University, Toronto and the University of Toronto (his alma mater).

Contact Sales

Learning Paths

Querying Data with SQL from PostgreSQL