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

CodeSignal

Mastering SQL Functions and Clauses with PostgreSQL

via CodeSignal

Go to class Write review

Overview

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.

Syllabus

  • Unit 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
  • Unit 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
  • Unit 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
  • Unit 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
  • Unit 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!

Reviews

Start your review of Mastering SQL Functions and Clauses with PostgreSQL

Go to class

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.