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
Pricing
-
$220.00
Regular price