New · Cohort 3Engineering Analytics Cohort 3 goes live 25 July — only 30 seatsRegister Now
NY Times Square Billboard
Cohort Spotlight

120

Live Lecture Hours

20 topics × 6 hrs (2 classes each), across 5 modules

9

Project Hours

Three real projects you build end-to-end

3

GitHub Projects

Public proof recruiters can open and verify

4.6/5

Learner Rating

Practical guidance, doubt support, and interview focus

Durgesh Yadav, Founder and Lead Data Mentor at PrepNPlaced

Founder & lead instructor

Durgesh Yadav — rated 4.6★ by 1,000+ learners

Data Engineer @ 7-Eleven · ex-Target · Instructor @ Scaler & Bosscoder

100K+ learners mentored600+ written reviews

Bosscoder

4.85/5

535 ratings · 160 learners

Live cohort teaching

Newton School

4.7/5

Python lecture series

Live lectures

Topmate

4.3/5

503 ratings · 350+ reviews

1-on-1 mentorship

Durgesh isn't just a mentor, he's more like a brother to me. His wisdom and kindness have taught me things money can't buy. I've grown so much under his guidance — he knows how to make it click for each person individually.
AAdnan Umar MallickDevOps EngineerLinkedIn
An amazing, eye-opening experience for anyone confused as a fresher or experienced person about what to learn or which domain to switch into. Durgesh gave a clean, clear view, understood everything with patience, and shared very useful tips to crack companies within 3-4 months.
NNishithaTopmate
The most informative and best session. Durgesh genuinely tries to guide you according to your preferences — his candid suggestions and precise insights are value-driven. It was an absolute delight talking to him.
PPaarth KohliTopmate
The way he guides you and shows you the right path using his knowledge and experience is really amazing. You feel charged up after a chat with him. I'd really recommend this for anyone who wants to make a mark in this domain.
RRaghav PunjTopmate
A wonderful and amazing session — so informative and motivating throughout. Thanks for helping me with the whole roadmap of data analytics and your guidance. I would recommend a 1-on-1 session with Durgesh!
RRiya PalTopmate
A great conversation with Durgesh. He gave me a clear guidance path as well as free resources for self-learning. Hats off to the work you're doing for novice aspirants who want to come into this data world.
KKunalTopmate
Pragya Rathi, Co-Founder and Lead Data Mentor at PrepNPlaced

Co-founder & lead instructor

Pragya Rathi — rated 4.6★ by 820+ learners

Co-Founder, PrepNPlaced · Data Engineer @ 7-Eleven · SQL, PySpark, Power BI & Excel Instructor

127 live classes taught518+ written reviews

Bosscoder

4.9/5

127 class ratings · 83% perfect 5★

Live DSML & DE cohorts

Topmate

4.5/5

697 ratings · 518 reviews

1-on-1 mentorship

Newton School

4.8/5

Live lecture series

Live lectures

Learning with PR as my SQL trainer has been an absolute game-changer. As a complete novice I approached SQL with trepidation, but her expertise, patience and dedication transformed my experience entirely — a rare combination of deep knowledge and the ability to make it click.
PPrabeer Kumar JenaTopmate
Practical live lessons are very useful and the teaching method is clear and straightforward — the interview-based questions with every topic are very useful!
KKavitha KaliswaranTopmate
Had a very insightful session within a stipulated time. Her experience helps in bringing tough SQL concepts simpler even for a layman.
SSathish Kumar PTopmate
I like her teaching. She explains everything very well and clears every doubt.
RRahulTopmate
The demo session was truly amazing — I loved it. I'm really looking forward to this course and would love to keep the session to revisit in future.
SSenjuti KunduTopmate
Pragya's way of teaching is so good. She explained all the topics in depth with simpler examples. JUST AMAZING.
AAnkitaBosscoder
Comprehensive curriculum

120 hours of live lectures across 5 modules · 20 topics · 6 hrs each (2 classes) — click any topic to open it.

Every module covers the sub-topics that hiring teams actually screen for. Expand a topic to see exactly what you will master, from SQL and Spark to Snowflake, dbt, Kafka, and Agentic AI.

01

Module 1

SQL & Analytics Foundation

The querying, modeling, and BI base every data role is screened on.

24 hours
Query execution order & how the engine runs SQLINNER / LEFT / SELF / ANTI joinsWindow functions — ROW_NUMBER, RANK, LAG / LEADRunning totals, moving averages & partitionsCTEs, recursive & correlated subqueriesQuery optimization, indexing & execution plans
02

Module 2

Big Data & Apache Spark

Process data at scale the way product companies actually run it.

24 hours
03

Module 3

Modern Data Engineering

Snowflake, dbt, and Airflow — the modern data stack employers ask for.

24 hours
04

Module 4

Real-Time Streaming

Kafka and Spark Structured Streaming — the in-demand real-time skillset.

24 hours
05

Module 5

AI Automation & Agentic AI

Use LLMs and AI agents to automate real data work — the 2026 edge.

24 hours
Course fit

A cohort for learners who want proof, not only lectures.

The course page now explains who should enroll, who should avoid it, how each module maps to skills, and how projects become resume and interview evidence.

Who should enroll

Learners moving toward data analyst, analytics engineer, or data engineering roles

Freshers who need SQL, Power BI, Python, PySpark, and project proof in one sequence

Working professionals who want structured assignments, real projects, and interview practice

Who should not enroll

Anyone looking for a passive certificate without assignments or project work

Candidates expecting guaranteed placement, salary, or interview outcomes

Learners who are not ready to revise, submit work, and practice explanations

Module-to-skill map

Each module connects to a hiring signal.

The curriculum is useful only when the learner can explain what skill was built, where it appears in a project, and how it becomes interview proof.

Module 1 · SQL & Analytics Foundation

SQL, window functions, data modeling, Python/Pandas, Power BI & DAX

Resume/interview proof: Dashboard, SQL analysis, and business-metric explanation

Module 2 · Big Data & Apache Spark

Spark, PySpark, Databricks, Delta Lake, distributed data concepts

Resume/interview proof: PySpark transformation notebook and lakehouse explanation

Module 3 · Modern Data Engineering

Snowflake, dbt, Airflow, medallion pipelines, CDC, data quality

Resume/interview proof: Tested dbt models, orchestrated DAGs, and failure-handling story

Module 4 · Real-Time Streaming

Kafka, Spark Structured Streaming, watermarks, exactly-once semantics

Resume/interview proof: Streaming pipeline, live dashboard, and latency/throughput tradeoffs

Module 5 · AI Automation & Agentic AI

Prompt engineering, text-to-SQL, RAG, AI agents (LangChain, CrewAI)

Resume/interview proof: An AI-assisted data workflow and a working data agent you can demo

9 hours · real projects on GitHub

Three real projects you build — and publish as public proof.

Beyond the 30 lecture hours, you build three production-style projects (9 guided hours). Each one ships to GitHub so recruiters can open the repo and verify your work — not just read a resume bullet.

3 hours

StreamCommerce Lakehouse 360

KafkaSpark Structured StreamingDelta LakeDatabricks

A real-time e-commerce lakehouse: stream orders and clickstream through a bronze → silver → gold medallion and serve live revenue analytics.

Event ingestion, exactly-once streaming, medallion modeling, and live dashboards you can defend in an interview.

View on GitHub
3 hours

Retail Revenue Intelligence

SQLPythonPandasPower BI

End-to-end retail analytics: model the data, compute revenue, cohort, and retention metrics, and ship an executive dashboard.

SQL metrics, EDA, revenue and customer analysis, and stakeholder-ready BI storytelling.

View on GitHub
3 hours

Snowflake + dbt Analytics Engineering

SnowflakedbtSQLELT

A modern ELT warehouse: build tested, documented dbt models and incremental pipelines into dimensional marts on Snowflake.

dbt models, tests, docs and lineage, incremental loads, and warehouse cost/performance tradeoffs.

View on GitHub
CareerOS connection

The cohort connects directly to resume, ATS, mock interview, and learning workflows.

After a learner builds proof in the cohort, the next step is to convert that proof into a resume, check JD fit, and practice the interview explanation.

Placement outcomes

Career switchers and non-tech learners moving into data roles.

A compact version of the academy placement proof, using the same learner images already available in the PrepNPlaced asset library.

Senthilkumar placement story

Senthilkumar

Deloitte

From

Operations and Accounts

To

Data Analyst

100% career growth signal
Ritesh Gandhare placement story

Ritesh Gandhare

Infor

From

Mechanical Field

To

Data Analyst

120% career growth signal
Sneha Kulkarni placement story

Sneha Kulkarni

7-Eleven

From

Career Gap

To

Data Engineer

500% career growth signal
Lipika Gupta placement story

Lipika Gupta

Target

From

EduTech Domain

To

Data Analyst

70%+ career growth signal
Om Rai placement story

Om Rai

People INC.

From

Service Company

To

Data Analyst

110%+ career growth signal
Mohit Dudeja placement story

Mohit Dudeja

Wells Fargo

From

Ericsson

To

Data Analyst

60%+ career growth signal
Taught by industry experts

Founder-led cohort with practical project and interview guidance.

The instructor cards use the same people, images, and profile links as the source academy page.

Durgesh Yadav

Durgesh Yadav

Founder and Lead Instructor

Senior Data Engineer at 7-Eleven. Ex-Product Analyst at Target. Trained thousands of learners for analytics, data engineering, and product-based roles.

Pragya Rathi

Pragya Rathi

Co-Founder and Lead Instructor

Product Analyst at Target. Data Specialist and Analytics Instructor across SQL, analytics thinking, interview readiness, and practical business cases.

Learner voices

What learners say after joining.

Real feedback framed as compact proof cards so the page stays readable on CareerOS.

Darshani Teltumbade

Course Value

5

Honestly, I don't know what Durgesh was thinking while pricing this course. Power BI, SQL, Python, EDA, projects, interview prep — all in one super-affordable package. This is not a course, it's a full data analytics universe. Other institutes charge a fortune for half this content.

Moumita Debbarma

Big Data Session

5

The session on Big Data was extremely insightful. Durgesh explained complex concepts in a simple, beginner-friendly manner. I now feel much more confident about exploring Big Data further. Highly recommended for anyone starting their journey.

Salvin George

Resume Template

5

Durgesh's LaTeX resume template was exactly what I needed — clean, professional, and super easy to customize even for someone who isn't a LaTeX expert. It saved me hours of formatting frustration and really helped my resume stand out.

Shreyansh Panwar

SQL Teaching

5

Durgesh sir is the best teacher — the way he teaches complex SQL queries so easily is very commendable. He teaches with such ease that everyone can understand. Once you study from him, there is no looking back.

Mosaddik Hussain

1:1 Mentorship

5

I have known Durgesh since his time as an instructor at Masai School. His character and teaching style are top-notch. To become a data analyst you need a good mentor, not just a course. For real, industry-based projects at low cost, Durgesh Yadav is the person for you.

Isita Gupta Sharma

Resume AI

5

The whole process and the information is wonderful. Thank you for creating such a great site where we can clearly see both the gaps and strengths in our resume.

Bindu Bharti

Roadmap

5

It was a great session. He is good at giving the right direction — very helpful. One must try it if looking for a roadmap!

Taniya Loomba

Course Structure

5

I really love the structure in which the course is designed. I feel even a complete beginner can learn it very well.

Anonymous

Clarity

5

Durgesh explains every concept in depth and with great clarity. The session was really interesting and helpful, and it motivated me to learn even further.

Instructor rating · Topmate

4.4

out of 5

1,200+ ratings · 850+ testimonials on Topmate

Combined Topmate rating of the cohort instructors — Durgesh 4.3/5 (503 ratings) and Pragya 4.5/5 (697 ratings). The featured reviews below are a small sample of 850+ testimonials.