Grokking SQL for Tech Interviews

Name: Grokking SQL for Tech Interviews
Price: 99.9 USD
Availability: InStock
Rating: 4.2 (3459 reviews)

Master SQL, Ace Your Interview.

Level:

Beginner

Study Time:

20h

Lessons:

123

Updated

Last month

4.2

(3,459 ratings)

13,764 learners

Created byArslan Ahmad

Ex FAANG Manager, Expert Behind Grokking SQL for Tech Interviews

Course Overview

This course is designed for software engineers, database engineers, data engineers, and ML engineers who are preparing for SQL interviews. Whether you are a beginner or looking to brush up on your SQL skills, this course is for you. We will start with an introduction to SQL, covering all the basics, and then, dive into 75 carefully selected SQL interview questions. Each question comes with a detailed explanation to help you understand the concepts thoroughly. Our goal is to make sure you feel confident and well-prepared for your SQL interviews. The questions are picked to reflect what you might face in real-world interviews. Join us to master SQL and ace your next coding interview!

Best value

Lifetime access to this course

One-time payment. Yours forever.

$99.90

Discussions

Certificate

Free updates

Want all 36+ courses?

Best value

Lifetime access to this course

One-time payment. Yours forever.

$99.90

Discussions

Certificate

Free updates

Want all 36+ courses?

Course Content

• Chapters • 123 Lessons

Introduction

3 lessons

Course Overview

What is RDBMS?

What is SQL?

A Quick Review of SQL

10 lessons

Read data from table

WHERE Clause

Operators

Handle NULLs in SQL

DISTINCT Clause

ORDER BY Clause

LIMIT and OFFSET

GROUP BY

HAVING

Aggregate Functions

Order of Execution

1 lessons

Order of SQL Query Execution

SQL Functions

3 lessons

Number Functions

String Functions

Date Functions

Nested Queries

2 lessons

Nested Query

Types of Subqueries

JOINS

6 lessons

Introduction

INNER JOIN

LEFT OUTER JOIN

RIGHT OUTER JOIN

FULL OUTER JOIN

SELF JOIN

SET Operations

4 lessons

What are SET operations?

UNION

INTERSECT

EXCEPT

A Quick Review of DDL

6 lessons

Keys in SQL

CREATE

ALTER

DROP

TRUNCATE

Indexes

A Quick Review of DML

3 lessons

INSERT

UPDATE

DELETE

10.

Database Backup & Restore

2 lessons

Backup Database

Restore Database

11.

Interview Problems - Easy

34 lessons

1. Major Cities

2. Not boring movies

3. Triangle Judgement

4. Biggest Single Number

5. Product Sales Analysis I

6. Product Sales Analysis II

7. Game Play Analysis I

8. Game Play Analysis II

9. Queries Quality and Percentage

10. Average Selling Price

11. Weather Type in Each Country

12. Students and Examinations

13. Ads Performance

14. Group Sold Products By The Date

15. Employee Email Verification

16. Sellers With No Sales

17. Average Time of Process

18. Find Followers Count

19. Ad-Free Sessions

20. Bikes Last Time Used

21. Daily User Engagement Levels

22. Employee Attendance Record

23. Library Book Loans

24. Customer Purchase Summary

25. Long Comments (Easy)

26. Unused Accounts

27. Patient Appointment No-Shows

28. Books and Authors

29. High School Attendance

30. Employee Absences

31. Green Product Identification (Easy)

32. Employee Department Exclusion (Easy)

33. Sales Person (Easy)

34. Employee Task Tracking (Easy)

13.

Interview Problems - Hard

15 lessons

1. Trips and Users

2. Human Traffic of Stadium

3. Students Report By Geography

4. Game Play Analysis V

5. Number of Transactions per Visit

6. Find the Quiet Students in All Exams

7. First and Last Call On the Same Day

8. Build the Equation

9. Longest Winning Streak

10. Dynamic Pivoting of a Table

11. Dynamic Unpivoting of a Table

12. Generate the Invoice

13. Popularity Percentage

14. Viewers Turned Streamers

15. Status of Flight Tickets

14.

Test Your Knowledge

14 lessons

1. High Performing Employees (Easy)

2. Student Course Averages (Easy)

3. Library Book Checkout Percentage (Easy)

4. Employee Performance and Improvement Rate (Easy)

5. Find Popular Posts (Easy)

6. Main Office Assignment for Each Employee (Easy)

7. Rectangle Validation (Easy)

8. Library Book Checkouts by Date (Easy)

9. Same-Day Appointment Fulfillment (Medium)

10. Departments with High Earning Employees (Medium)

11. Students Who Attended All Courses (Medium)

12. Library Book Checkouts First Year (Medium)

13. Repeated Values in Sequence (Medium)

14. School Top Achievers by Subject (Hard)

What people say about our courses

Arijeet

Software Engineer

Just completed the “Grokking the system design interview”. It's amazing and super informative. Have come across very few courses that are as good as this!

Eric

Software Engineer

I've completed my first pass of "grokking the System Design Interview" and I can say this was an excellent use of money and time. I've grown as a developer and now know the secrets of how to build these really giant internet systems.

Roger Cruz

Software Engineer

The world gets better inch by inch when you help someone else. If you haven't tried Grokking The Coding Interview, check it out, it's a great resource!

Steven Zhang

Software Engineer

Just wanted to say thanks for your Grokking the system design interview resource (https://lnkd.in/g4Wii9r7) - it helped me immensely when I was interviewing from Tableau (very little system design exp) and helped me land 18 FAANG+ jobs!

Ashley Pean

Software Engineer

Check out Grokking the Coding Interview. Instead of trying out random Algos, they break down the patterns you need to solve them. Helps immensely with retention!

Simon Barker

Software Engineer

This is what I love about http://designgurus.io’s Grokking the coding interview course. They teach patterns rather than solutions.

About the Author

Arslan Ahmad

Design Gurus Founder

Ex-FAANG Manager

Industry Expertise & Leadership

Arslan Ahmad is the lead author of Grokking SQL for Tech Interviews. As the founder of Design Gurus and a former FAANG hiring manager, he has worked at industry giants like Facebook (now Meta) and Microsoft.

He has conducted hundreds of system design interviews, giving him unique insight into what top tech companies look for in candidates.

The course also incorporates expertise from senior engineers at Google, Meta, Amazon, Microsoft, and Uber, ensuring you learn system design best practices from professionals who have built and scaled real-world systems.

500+

Interviews Conducted

10k+

Students Taught