FreeCourseWeb com Udemy SQL for Business and Interview Prep

/

Get Bonus Downloads Here.url

/1. Introduction/

1. Welcome to SQL Interview Questions.mp4

2. Getting Started.html

/2. Chapter #1/

1. Chapter 1 Lesson 1 Aggregating Data in SQL.mp4

10. Lesson 3, Exercise 1 Top Groups Aggregation.html

11. Lesson 3, Exercise 2 Average Calculation with Window Functions.html

2. Lesson 1 Exercise 1 HAVINGS vs WHERE.html

3. Lesson 1, Exercise 2 Grouped Calculations.html

4. Lesson 1, Exercise 3 Filtering Group Data.html

5. Chapter 1 Lesson 2 Window Functions in SQL.mp4

6. Lesson 2, Exercise 1 Using Partitions with Window Functions.html

7. Lesson 2, Exercise 2 Running Totals in SQL.html

8. Lesson 2, Exercise 3 Lagging with Window Functions.html

9. Chapter 1 Lesson 3 Aggregation Interview Questions.mp4

/3. Chapter #2/

1. Intro to Chapter 2.mp4

10. Lesson 2 QUIZ Inner JOINs.html

11. Lesson 2, Exercise 2 Most Popular Group Topics.html

12. Chapter 2 Lesson 3 Left JOINs.mp4

13. Lesson 3, Exercise 1 Find Dirty Data with JOINs.html

14. Lesson 3, Exercise 2 Returning a Dataset.html

15. Chapter 2, Lesson 4 Multiple JOINs.mp4

16. Lesson 4, Exercise 1 Frozen Foods Marketing Campaign.html

17. Lesson 4, Exercise 2 More Frozen Foods.html

18. Lesson 4, Exercise 4 Unique Aisles Per User.html

19. Lesson 4, Exercise 3 Asparagus Orders.html

2. Chapter 2 Lesson 1 Unions.mp4

20. Lesson 4, Exercise 5 Counting Distinct Hometowns Per Event.html

21. Chapter 2 Lesson 5 Case Statements.mp4

22. Lesson 5, Exercise 1 Categorize Order Times.html

23. Lesson 5, Exercise 2 Numerically Identifying Packaged Foods Aisles.html

3. Lesson 1, Exercise 1 Retrieve a Complete List.html

4. Lesson 1, Exercise 2 Tracking Customer Retention.html

5. Lesson 1, Exercise 3 (Part 1) Finding Overlap.html

6. Lesson 1, Exercise 3 (Part 2) Finding Overlap.html

7. Lesson 1, Exercise 3 (Part 3) Finding Overlap.html

8. Chapter 2 Lesson 2 Inner JOINs.mp4

9. Lesson 2, Exercise 1 Count Events with Venues.html

/4. Chapter #3/

1. Intro to Chapter 3.mp4

10. Lesson 2, Exercise 3 Identifying Last Items Ordered.html

11. Chapter 3 Lesson 3 Data Cleaning in SQL.mp4

12. Lesson 3, Exercise 1 Get a List of Members Without Names.html

13. Lesson 3, Exercise 2 Identifying Popular Professional Networking Groups.html

14. Lesson 3, Exercise 3 Troubleshooting a Query Error.html

15. Chapter 3 Lesson 4 Subquery Interview Questions.mp4

16. Lesson 4, Exercise 1 Pulling Data with Custom Calculations.html

17. Lesson 4, Exercise 2 (Part 1) Categorize and Count Suppliers.html

18. Lesson 4, Exercise 2 (Part 2) Categorize and Count Suppliers.html

19. Lesson 4, Exercise 2 (Part 3) Categorize and Count Suppliers.html

2. Chapter 3 Lesson 1 Subqueries in FROM.mp4

3. Lesson 1, Exercise 1 Finding Popular Topics.html

4. Lesson 1 Exercise 2 (Part 1) Calculating Percentages.html

5. Lesson 1 Exercise 2 (Part 2) Calculating Percentages.html

6. Lesson 1, Exercise 3 Counting Group Categories in the Database.html

7. Chapter 3 Lesson 2 Filtering with Subqueries in WHERE.mp4

8. Lesson 2, Exercise 1 Groups in Top Cities.html

9. Lesson 2, Exercise 2 Returning Above Average Orders.html

/5. Thank you!/

1. Congratulations! You have completed SQL Interview Questions!.mp4

2. Thank You & Obtaining Your Certificate.html

/~Get Your Files Here !/

Bonus Resources.txt

Total files 59