🚫 Ongoing session enrollments are closed.
We are accepting only 100 enrollments for the August 2026 batch starting 1 Aug. Secure your spot before it fills up.
Python · SQL · PySpark — same problem each day, two approaches. Then build a complete DE project: Bronze → Silver → Gold, SCD Type 2, CDC, backfill & tests.
All 4 sessions as one complete bundle — 10% off included.
15 days of Python · SQL · PySpark problems, then the Build DE Project — each step builds on the last.
Master the Python topics tested in DE interviews — loops, strings, lists, dicts, sets, file I/O, APIs, DSA patterns and generators. 15 days of problems, one session.
For loops, enumerate, zip, HashMap, HashSet, Stack, Queue, Deque, heapq — used in real DE interviews
CSV, JSON, TXT handling; API pagination & JSON parsing; SQLite parameterized queries
Comprehensions, generators for large files, itertools.groupby, copy vs deepcopy
Every SQL topic tested in DE interviews — filters, strings, dates, aggregation, joins, window functions, CTEs and mixed problems. 15 days, one session.
Rank employees per region, top-N per group, running totals, previous-row comparisons
Manager lookup via self join, customers with no orders, all join types with real DE datasets
Multi-CTE pipelines, correlated subqueries, GROUPING SETS, ROLLUP, full mixed problems
Solve every SQL problem from the roadmap again — using PySpark DataFrame API and Spark SQL. Same 15-day problem set, distributed computing approach.
filter(), where(), groupBy().agg(), join(), Window — every SQL pattern mapped to PySpark
rank(), dense_rank(), lag(), sum().over(), ntile() — all 15 SQL window problems in PySpark
Broadcast joins, repartition vs coalesce, data skew, AQE, shuffle explained for interviews
Four weekend sessions — build a complete local DE project from scratch using Python, PySpark and SQL. Bronze ingestion → Silver cleaning → SCD Type 2 → Gold layer.
Read CSV files with PySpark StructType schema enforcement, write idempotent partitioned Parquet to data/bronze/
Business rule validation, deduplication, SHA-256 hash change detection, expire-and-insert SCD on dim_customers
Daily KPIs (orders, revenue, AOV), top products, idempotent backfill by date, interview walk-through prep
Kafka · Airflow · Databricks Delta Live Tables
Live mock rounds · Resume review · System design walkthroughs
Everything you need to know about the Live Sessions