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.

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!

Interested in this course? Learn and practice with Cosmo!

Practice is how you turn knowledge into actual skills.