60-Day Study Plan

A structured preparation plan dramatically improves your interview success rate. This 8-week schedule balances depth and breadth while remaining realistic for working professionals.

The 60-Day Overview

Week	Focus Area	Daily Time	Key Deliverable
1-2	SQL Fundamentals	1-2 hours	50 LeetCode SQL problems
3-4	Statistics & Probability	1-2 hours	Concept flashcards + 30 problems
5-6	A/B Testing & Experimentation	1-2 hours	10 experiment design exercises
7-8	Business Cases & Mock Interviews	2-3 hours	5 mock interviews completed

Week 1-2: SQL Deep Dive

Goal: Write any SQL query in under 5 minutes

Daily schedule:

• 30 min: Learn new concept (window functions, CTEs, etc.)
• 60 min: Practice problems on LeetCode/DataLemur
• 15 min: Review mistakes and patterns

Key topics to master:

1. JOINs (all types) and when to use each
2. GROUP BY with HAVING filters
3. Window functions (ROW_NUMBER, LAG/LEAD, running totals)
4. Subqueries vs CTEs - readability and performance
5. Date/time manipulation

Milestones:

• Complete 25 Medium SQL problems
• Complete 10 Hard SQL problems
• Can explain query execution order

Week 3-4: Statistics & Probability

Goal: Explain any statistical concept in 2 minutes

Daily schedule:

• 45 min: Concept review (textbook or video)
• 45 min: Problem practice
• 15 min: Flashcard review

Key topics to master:

1. Probability basics: Bayes theorem, conditional probability
2. Distributions: Normal, Binomial, Poisson
3. Hypothesis testing: p-values, Type I/II errors
4. Confidence intervals and their interpretation
5. Regression: assumptions, diagnostics, interpretation

Milestones:

• Create 50+ flashcards for quick review
• Solve 30 probability/statistics problems
• Can derive basic formulas from first principles

Week 5-6: A/B Testing Mastery

Goal: Design and analyze any experiment confidently

Daily schedule:

• 30 min: Theory and examples
• 60 min: Case study practice
• 30 min: Sample size calculations

Key topics to master:

1. Randomization and control group design
2. Sample size and power calculations
3. Multiple comparison corrections
4. Common pitfalls: peeking, novelty effects
5. When to use alternatives (multi-armed bandits, etc.)

Milestones:

• Design 10 complete A/B test specifications
• Calculate sample sizes for 5 scenarios
• Analyze 5 mock experiment results

Week 7-8: Cases & Mock Interviews

Goal: Deliver polished interview performance

Daily schedule:

• 60 min: Case study practice (structured thinking)
• 60 min: Mock interview (with peer or service)
• 30 min: Behavioral story refinement

Key activities:

1. Practice metric investigation questions
2. Refine STAR stories for behavioral
3. Complete at least 5 full mock interviews
4. Record yourself and review performance

Milestones:

• Complete 5 mock interviews with feedback
• Prepare 10 STAR stories
• Have 3 questions ready for every interview

Daily Routine Template

Morning (before work):
- 30 min: Problem practice (SQL or stats)
- 15 min: Flashcard review

Evening (after work):
- 60 min: Deep practice on weekly focus
- 15 min: Log progress and plan tomorrow

Pro tip: Track everything in a spreadsheet. Note which question types give you trouble and double down on those areas.

Consistency beats intensity. One hour daily for 60 days beats 60 hours in a weekend. :::