DA-ASSOC Study Plan (30 / 60 / 90 Days)

A practical DA-ASSOC study plan you can follow: 30-day intensive, 60-day balanced, and 90-day part-time schedules with weekly focus and SQL-first practice tips.

DA‑ASSOC is SQL-first. The fastest improvements come from mastering joins + windows and building “result correctness” instincts.


30-Day Intensive Plan (8–10 hrs/week)

WeekFocusWhat to do
1SQL foundationsJoins, aggregations, CTEs; daily drills and a miss log.
2Window functions + analytics patternsRanking, rolling metrics, cohort/retention patterns; mixed sets.
3Databricks SQL workflowsQueries, saved queries, parameters/filters; dashboard basics.
4Dashboards + reviewVisualizations, alerts, sharing/permissions awareness; timed mixed runs.

60-Day Balanced Plan (5–7 hrs/week)

WeeksFocus
1–2SQL foundations
3–4Windows + advanced query patterns
5–6Databricks SQL + dashboards
7–8Review + pacing with mixed sets

90-Day Part-Time Plan (3–4 hrs/week)

MonthFocus
1SQL correctness
2Windows + dashboard workflows
3Practice-heavy review