Topfolio
Career TracksJob Hunt TrackerMicro Free CoursesTask CoursesPracticeInterview PracticeWork ExperienceProjects
Career TrackFree CoursesPracticeSQL BenchmarkBlog
Support
Micro Free Courses

DS Interview Prep — Rounds, Cases, Offer Close

20 lessons

  1. 1. M0 — SQL + Python Screens
    1. Video lesson1. SQL Screen Drills (Timed Sets)9m
    2. Reading2. Python / Pandas / EDA Screens25m
    3. Assignment3. Quiz: SQL/Python Screens20m
    4. Project submission4. Mock Screen Defense (Query + EDA Artifact)
  2. 2. M1 — Stats / Experimentation Rounds
    1. Video lesson1. Stats / Experimentation Rounds13m
    2. Reading2. AB-Test49 Writeup Defense (SRM/Peeking/Readout)30m
    3. Assignment3. Quiz: Stats Rounds20m
    4. Project submission4. Stats-Round Mock (Recorded)
  3. 3. M2 — ML Case Labs
    1. Video lesson1. ML Case Lab (Selection/CV/Leakage/PR-AUC/SHAP)13m
    2. Reading2. Churn / LTV Case Defense (Calibration -> Decision)25m
    3. Assignment3. Quiz: ML Cases20m
    4. Project submission4. ML-Case Mock (Recorded)
  4. 4. M3 — Offer Close: Guesstimates, Portfolio, Final
    1. Video lesson1. Guesstimate + Product Sense13m
    2. Reading2. Resume / Portfolio Checklist (v3)25m
    3. Assignment3. Quiz: Guesstimate + Product + STAR20m
    4. Project submission4. Capstone: Domain Capstone (Vertical)
    5. Assignment5. Quiz: 45Q Proctored Final (Track-Level)75m
    6. Project submission6. Mocks Ladder Proof (30-50: Mentor + Peer + AI)
    7. Reading7. [UNPUBLISHED DRAFT] Proctored Final Brief (45Q Blueprint)15m
  5. 5. Capstone: Domain Capstone Brief (Plan 96 Sec 6)
    1. Reading1. Capstone Brief: Domain Capstone (UNPUBLISHED)30m
Dashboard
Career TracksMicro Free Courses
Task Courses
SQL & PythonInterview Prep
Job Hunt TrackerWork ExperienceProjectsResume Feedback
CertificatesMy OrdersRefer & Earn
Join Community
Micro Free Courses

DS Interview Prep — Rounds, Cases, Offer Close

20 lessons

  1. 1. M0 — SQL + Python Screens
    1. Video lesson1. SQL Screen Drills (Timed Sets)9m
    2. Reading2. Python / Pandas / EDA Screens25m
    3. Assignment3. Quiz: SQL/Python Screens20m
    4. Project submission4. Mock Screen Defense (Query + EDA Artifact)
  2. 2. M1 — Stats / Experimentation Rounds
    1. Video lesson1. Stats / Experimentation Rounds13m
    2. Reading2. AB-Test49 Writeup Defense (SRM/Peeking/Readout)30m
    3. Assignment3. Quiz: Stats Rounds20m
    4. Project submission4. Stats-Round Mock (Recorded)
  3. 3. M2 — ML Case Labs
    1. Video lesson1. ML Case Lab (Selection/CV/Leakage/PR-AUC/SHAP)13m
    2. Reading2. Churn / LTV Case Defense (Calibration -> Decision)25m
    3. Assignment3. Quiz: ML Cases20m
    4. Project submission4. ML-Case Mock (Recorded)
  4. 4. M3 — Offer Close: Guesstimates, Portfolio, Final
    1. Video lesson1. Guesstimate + Product Sense13m
    2. Reading2. Resume / Portfolio Checklist (v3)25m
    3. Assignment3. Quiz: Guesstimate + Product + STAR20m
    4. Project submission4. Capstone: Domain Capstone (Vertical)
    5. Assignment5. Quiz: 45Q Proctored Final (Track-Level)75m
    6. Project submission6. Mocks Ladder Proof (30-50: Mentor + Peer + AI)
    7. Reading7. [UNPUBLISHED DRAFT] Proctored Final Brief (45Q Blueprint)15m
  5. 5. Capstone: Domain Capstone Brief (Plan 96 Sec 6)
    1. Reading1. Capstone Brief: Domain Capstone (UNPUBLISHED)30m

Browse Topfolio

All coursesPracticeProjectsCareer tracks
  1. Home/
  2. Courses/
  3. DS Interview Prep — Rounds, Cases, Offer Close/
  4. M0 — SQL + Python Screens

Micro Free Course — 100% Free Learning

All lessons in this module are free to learn. Sign in with Google to save your progress.

0

M0 — SQL + Python Screens

Timed SQL sets, pandas/EDA cases, screen quiz, and the mock screen defense.

Module Progress0% Complete
58 min total
4 Lessons
0 Completed

Module Content

SQL Screen Drills (Timed Sets)

Outcome: Clear timed set (gaps-islands/recursive-CTE/EXPLAIN) Curated video (CodeEra): Top 5 SQL Window Function Questions for Interviews (With Solutions) — https://www.youtube.com/watch?v=LoS_U22CW_E (verified live via yt-dlp 2026-09-24). Pointer: DA-track-mapped timed sets; shell: courses/video-scripts/ds-interview-prep/01.md.

9 minVideo
Start

Python / Pandas / EDA Screens

Solve 3 timed pandas cases.

25 minArticle
Start

Quiz: SQL/Python Screens

10 timed-set MCQs, Bloom 3-4, gate >= 80.

20 minAssignment
Start

Mock Screen Defense (Query + EDA Artifact)

Defend 1 screen set on artifacts.

minSubmission
Start
Back to Course
Continue Learning
Topfolio

Learn data analytics online. Real skills, real projects, real community.

courses

  • Career Tracks
  • Work Experience
  • Best Data Analyst Course in India
  • SQL Fundamentals
  • SQL Advanced
  • Python for Data
  • Micro Free Courses

practice

  • SQL Fundamentals Interview Test
  • SQL Advanced Coding Test
  • All Practice Tests

resources

  • How to Become a Data Analyst
  • SQL Interview Questions
  • Data Analyst Salary Guide
  • Free Datasets for Practice
  • SQL vs NoSQL Guide
  • Data Analyst vs Data Engineer vs Data Scientist

employers

  • Enterprise Screening
  • AI Proctoring Demo
  • Volume Pricing
  • Employer Portal

company

  • About
  • Terms
© 2026 Topfolio. All rights reserved.Made with ❤️ for aspiring analysts