SQL Interview Prep Bootcamp - Aug2025

The SQL Interview Prep Bootcamp (Aug 2025) is a live and interactive learning experience designed to take you from SQL fundamentals to advanced concepts, all while building strong problem-solving skills tailored for real SQL interviews.

What sets this bootcamp apart is its highly structured curriculum, carefully designed to cover all essential topics needed to crack SQL interviews. Whether you're a beginner or at an intermediate level, this bootcamp will give you hands-on experience solving realistic SQL interview problems in a guided, live classroom setting.

The bootcamp includes 10 live sessions spread over 5 weekends. Classes are conducted only on weekends at:

• 07:30 PM IST (India)
• 04:00 PM CET (Central Europe)
• 10:00 AM ET (Eastern US)

Course content covered in each session is mentioned below:

SESSION 1:

Introduction, DB Setup & SQL Fundamentals

Quick Introduction about the bootcamp, SQL and RDBMS
DB Installation & Setup
SQL Fundamentals
SQL case study - 20 basic problems

SESSION 2:

SQL Fundamentals - Case Study

Continue - SQL case study - 20 basic problems
Assignment SQL case study - 20 new problems, Q&A

SESSION 3:

Basic/Intermediate SQL

Inner join, Group by, Having clause, Aggregate functions
SQL case study - 20 intermediate problems
Assignment Problems, Q&A

SESSION 4:

Basic/Intermediate SQL

Order of Operation, Inbuilt date & string functions
Continue - SQL case study - 20 intermediate problems
Assignment SQL case study - 20 new intermediate problems, Q&A

SESSION 5:

Intermediate SQL

Subqueries & CTE, Views
SQL Problem solving using Subqueries & CTE
Assignment Problems, Q&A

SESSION 6:

Intermediate/Advanced SQL

Joins in SQL - Left, Right, Full, Cross, Self
SQL Problem solving using JOINS
Assignment Problems, Q&A

SESSION 7:

Intermediate/Advanced SQL

Window functions - Row_number, Rank, Dense_rank, Lead, Lag
Window functions - First_value, Last_value & Frame clause
SQL Problem solving using window functions
Assignment Problems, Q&A

SESSION 8:

Advanced SQL

Recursion, Pivot & Crosstab
SQL Problem solving using Recursion, Pivot & Crosstab
Assignment Problems, Q&A

SESSION 9:

SQL Problem Solving

SQL Interview Problem solving - Part 1
Assignment Interview Problems

SESSION 10:

SQL Problem Solving

SQL Interview Problem solving - Part 2
Assignment Interview Problems