Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

edX

Unlocking Data Insights with PostgreSQL

via edX

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates

Learn how to work with relational databases using PostgreSQL. This beginner-level path introduces SQL fundamentals for asking questions, finding specific information, and understanding relationships within data. Progress to functions and clauses that count, summarize, filter, and identify unique values. Explore conditional statements and logical operators, including ILIKE, IN, BETWEEN, AND, and OR, to create more precise queries. Complete the path by using subqueries and joins to combine related tables and uncover more complex insights. This path is designed for learners who want practical SQL skills for data analysis and reporting.

Syllabus

  • Write SQL queries to retrieve and filter data in PostgreSQL
  • Apply logical operators and conditional statements to refine query results
  • Use functions and clauses to count, summarize, and identify unique data
  • Create subqueries to answer multi-step data questions
  • Join related tables to analyze relationships across a database
  • Build PostgreSQL queries for practical analysis and reporting

Reviews

Start your review of Unlocking Data Insights with PostgreSQL

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.