Learning Paths

Querying Data with SQL from PostgreSQL

  • Number of Courses5 courses
  • Duration10 hours
  • Skill IQ available 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 Duration
  •  (115)

Combining and Filtering Data with PostgreSQL

  • by Jason Browning
  • 1h 57m Duration
  •  (36)

Intermediate

Insert, update, and delete data from PostgreSQL.

PostgreSQL Data Manipulation Playbook

  • by Ami Levin
  • 2h 34m Duration
  •  (41)

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 Duration
  •  (11)

PostgreSQL Functions Playbook

  • by Gerald Britton
  • 2h 28m Duration
  •  (18)

Learn with the best

Jason Browning
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 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
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). 

Join our learners and upskill
in leading technologies