Looking for course support options? Please scroll to the bottom of this page.

Course Highlights

  • Real World SQL Application

    You'll be using the actual PgAdmin program during this course - no fake interface! This is the actual program you'd use on the job if your company uses PostgreSQL. If your company uses something else (Microsoft, Oracle, etc.) don't worry, PgAdmin is very similar.

  • Relevant Business Problems

    In addition to review slide decks and videos, this course contains dozens of real world practice problems designed to mimic what you'd face on the job or in an interview.

  • Support

    Stuck on an exercise? Want to ask general SQL questions? We offer both email and video chat support options. For the video chats, you can even ask questions about other related analytics topics like Excel, Python, or a problem you are having at work.

Course curriculum

  • 1
    Getting Started
  • 2
    Chapter #1
  • 3
    Chapter #2
  • 4
    Chapter #3
  • 5
    Thank you
  • Welcome to SQL Interview Questions FREE PREVIEW Getting Started FREE PREVIEW
  • Chapter 1 Lesson 1: Aggregating Data in SQL FREE PREVIEW Lesson 1 Exercise 1: HAVINGS vs WHERE FREE PREVIEW Lesson 1, Exercise 2: Grouped Calculations FREE PREVIEW Please submit your answer to Lesson 1 Exercise 2 to continue FREE PREVIEW Lesson 1, Exercise 3: Filtering Group Data FREE PREVIEW Please submit your answer to Lesson 1 Exercise 3 to continue FREE PREVIEW Chapter 1 Lesson 2: Window Functions in SQL Lesson 2, Exercise 1: Using Partitions with Window Functions Please submit your answer to Lesson 2 Exercise 1 to continue Lesson 2, Exercise 2: Running Totals in SQL Please submit your answer to Lesson 2 Exercise 2 to continue Lesson 2, Exercise 3: Lagging with Window Functions Please submit your answer to Lesson 2 Exercise 3 to continue Chapter 1 Lesson 3: Aggregation Interview Questions Lesson 3, Exercise 1: Top Groups Aggregation Please submit your answer to Lesson 3 Exercise 1 to continue Lesson 3, Exercise 2: Average Calculation with Window Functions Please submit your answer to Lesson 3 Exercise 2 to continue
  • Intro to Chapter 2 Chapter 2 Lesson 1: Unions Lesson 1, Exercise 1: Retrieve a Complete List Please submit your answer to Lesson 1 Exercise 1 to continue Lesson 1, Exercise 2: Tracking Customer Retention Please submit your answer to Lesson 1 Exercise 2 to continue Lesson 1, Exercise 3 (Part 1): Finding Overlap Please submit your answer to Lesson 1 Exercise 3 (Part 1) to continue Lesson 1, Exercise 3 (Part 2): Finding Overlap Please submit your answer to Lesson 1 Exercise 3 (Part 2) to continue Lesson 1, Exercise 3 (Part 3): Finding Overlap Please submit your answer to Lesson 1 Exercise 3 (Part 3) to continue Chapter 2 Lesson 2: Inner JOINs Lesson 2, Exercise 1: Count Events with Venues Please submit your answer to Lesson 2 Exercise 1 to continue Lesson 2 QUIZ: Inner JOINs Lesson 2, Exercise 2: Most Popular Group Topics Please submit your answer to Lesson 2 Exercise 2 to continue Chapter 2 Lesson 3: Left JOINs Lesson 3, Exercise 1: Find Dirty Data with JOINs Please submit your answer to Lesson 3 Exercise 1 to continue Lesson 3, Exercise 2: Returning a Dataset Please submit your answer to Lesson 3 Exercise 2 to continue Chapter 2 Lesson 4: Multiple JOINs Lesson 4, Exercise 1: Frozen Foods Marketing Campaign Please submit your answer to Lesson 4 Exercise 1 to continue Lesson 4, Exercise 2: More Frozen Foods Lesson 4, Exercise 3: Asparagus Orders Lesson 4, Exercise 4: Unique Aisles Per User Please submit your answer to Lesson 4 Exercise 4 to continue Lesson 4, Exercise 5: Counting Distinct Hometowns Per Event Chapter 2 Lesson 5: Case Statements Lesson 5, Exercise 1: Categorize Order Times Please submit your answer to Lesson 5 Exercise 1 to continue Lesson 5, Exercise 2: Numerically Identifying Packaged Foods Aisles Please submit your answer to Lesson 5 Exercise 2 to continue
  • Intro to Chapter 3 Chapter 3 Lesson 1: Subqueries in FROM Lesson 1, Exercise 1: Finding Popular Topics Please submit your answer to Lesson 1 Exercise 1 to continue Lesson 1, Exercise 2 (Part 1): Calculating Percentages Please submit your answer to Lesson 1 Exercise 2 (Part 1) to continue Lesson 1, Exercise 2 (Part 2): Calculating Percentages Please submit your answer to Lesson 1 Exercise 2 (Part 2) to continue Lesson 1, Exercise 3: Counting Group Categories in the Database Please submit your answer to Lesson 1 Exercise 3 to continue Chapter 3 Lesson 2: Filtering with Subqueries in WHERE Lesson 2, Exercise 1: Groups in Top Cities Please submit your answer to Lesson 2 Exercise 1 to continue Lesson 2, Exercise 2: Returning Above Average Orders Please submit your answer to Lesson 2 Exercise 2 to continue Lesson 2, Exercise 3: Identifying Last Items Ordered Please submit your answer to Lesson 2 Exercise 3 to continue Chapter 3 Lesson 3: Data Cleaning in SQL Lesson 3, Exercise 1: Get a List of Members Without Names Please submit your answer to Lesson 3 Exercise 1 to continue Lesson 3, Exercise 2: Identifying Popular Professional Networking Groups Lesson 3, Exercise 3: Troubleshooting a Query Error Chapter 3 Lesson 4: Subquery Interview Questions Lesson 4, Exercise 1: Pulling Data With Custom Calculations Please submit your answer to Lesson 4 Exercise 1 to continue Lesson 4, Exercise 2 (Part 1): Categorize and Count Suppliers Please submit your answer to Lesson 4 Exercise 2 (Part 1) to continue Lesson 4, Exercise 2 (Part 2): Categorize and Count Suppliers Please submit your answer to Lesson 4 Exercise 2 (Part 2) to continue Lesson 4, Exercise 2 (Part 3): Categorize and Count Suppliers Please submit your answer to Lesson 4 Exercise 2 (Part 3) to continue
  • Congratulations! You have completed SQL Interview Questions! Thank You and Obtaining Your Certificate End of Course Survey

Get Started Now

Prep for your upcoming interview or build your skills to feel more confident in your current role.

Sign Up

Pricing

Get Course Support

Please visit support site to view and purchase course support options.

Support Site