Loading...

Data Analytics

280 learners

Mastering SQL Functions and Clauses with PostgreSQL

Take your SQL skills further by exploring PostgreSQL’s powerful functions and rich features. This course is ideal for those who know SQL basics and are ready to enhance data analysis and reporting. Learn to count, summarize, and identify unique data with PostgreSQL’s advanced capabilities.

PostgreSQL

See path

5 lessons

25 practices

2 hours

Data Analysis for Insights

Lessons and practices

Lesson 1: Using the COUNT Function for Quantitative Analysis

Counting Rows in a Table

Counting Marvel Movies by Phase

Count Characters for a Specific Movie

Counting Popular Characters

Counting Marvel Characters by Actor

Lesson 2: Utilizing DISTINCT for Uniqueness Exploration

Distinct Character Names Exploration

Counting Unique Character Names

Counting Unique Actors

Find Characters with Multiple Actors

Counting Popular Characters

Lesson 3: Introducing Aggregate Functions for Data Analysis

Aggregate Function Fundamentals

Aggregate Functions for Sales and Ratings

Fix the IMDb Rating Query

Analyzing Ratings and Runtimes

Aggregate Functions for Screen Time

Lesson 4: Analyzing Trends with GROUP BY

Grouping Characters by Movie

Group and Sort Character Data

Fix the SQL Grouping Issue

Sorting Actors by Screen Time

Analyzing Character Screen Time

Lesson 5: Applying SQL Aggregate Functions to Multiple Tables

Aggregating Box Office Earnings

Counting Characters by Phase

Fix the SQL Query

Advanced Movie Ratings Query

Show Your SQL Super Powers!

Meet Cosmo:

The smartest AI guide in the universe

Our built-in AI guide and tutor, Cosmo, prompts you with challenges that are built just for you and unblocks you when you get stuck.

From our community

Hear what our customers have to say about CodeSignal Learn

I'm impressed by the quality and can't stop recommending it. It's also a lot of fun!

Francisco Aguilar Meléndez

Data Scientist

+11

I love that it's personalized. When I'm stuck, I don't have to hope my Google searches come out successful. The AI mentor Cosmo knows exactly what I need.

Faith Yim

Software Engineer

+14

It's an amazing product and exceeded my expectations, helping me prepare for my job interviews. Hands-on learning requires you to actually know what you are doing.