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)

Week Focus What to do
1 SQL foundations Joins, aggregations, CTEs; daily drills and a miss log.
2 Window functions + analytics patterns Ranking, rolling metrics, cohort/retention patterns; mixed sets.
3 Databricks SQL workflows Queries, saved queries, parameters/filters; dashboard basics.
4 Dashboards + review Visualizations, alerts, sharing/permissions awareness; timed mixed runs.

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

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

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

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