Grokking SQL for Tech Interviews

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

Master SQL, Ace Your Interview.

Level:

Beginner

Study Time:

20h

Lessons:

123

4.2

(3,459 ratings)

10,658 learners

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!

Annual Subscription

Get instant access to all current and upcoming courses for one year.

Lifetime Access - This Course

Get lifetime access to this course only.

Discounted Prices for Your Region

Certification on completing the course.

Gift for lifetime

Annual Subscription

Get instant access to all current and upcoming courses for one year.

Lifetime Access - This Course

Get lifetime access to this course only.

Discounted Prices for Your Region

Certification on completing the course.

Gift for lifetime

Course Content

• Chapters • 123 Lessons

1. Introduction

3 lessons

Course Overview

What is RDBMS?

What is SQL?

2. A Quick Review of SQL

10 lessons

3. Order of Execution

1 lessons

Order of SQL Query Execution

4. SQL Functions

3 lessons

Number Functions

String Functions

Date Functions

5. Nested Queries

2 lessons

Nested Query

Types of Subqueries

6. JOINS

6 lessons

7. SET Operations

4 lessons

What are SET operations?

UNION

INTERSECT

EXCEPT

8. A Quick Review of DDL

6 lessons

9. 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

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.

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!

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!

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!

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!