MeritKeep

Plan any subject, week by week

Pick a subject and say how many hours a week you actually have. You get the real order the skills have to be learned in, the graded work each stretch ends in, and an honest total in weeks. It is arithmetic over a published skill map, not a plan a model wrote on the way to you.

No accountNo email7 subjects
SubjectSubject
01 · The estimate

11 weeks at 4 hours a week

41.6Hours of work
11Weeks
25Things to do
2Marked
That is the core path. SQL & Data Analysis also declares 8.5 hours of specialist skills that are not counted above — take those too and it is 13 weeks. Both numbers assume you hit 4 hours every week, which nobody does; the plan does not expire if you don’t.
02 · The plan

Week by week, in the order it has to be learned

Each line is one thing to be able to do. The order is the skill map’s own: nothing appears before what it needs.
  1. Week 14h starts here
    • SELECT and projectionWrite a SELECT that returns exactly the columns asked for, with clear aliases1h
    • Filtering with WHEREFilter rows with combined AND/OR conditions and get the precedence right1.5h
    • NULL semanticsPredict and control how NULLs affect a filter, a join and an aggregate1.5h
  2. Week 24.8h starts here
    • Sorting and limitingReturn a deterministic top-N result set with an explicit, total ordering0.8h
    • Data types and castingCast between types deliberately and avoid silent integer-division and timezone errors1.5h
    • Aggregate functionsAggregate a column correctly, knowing which functions skip NULLs1h
    • DISTINCT and duplicate controlDetect where duplicate rows came from and remove them at the right point in the query1.5h · runs into week 3
  3. Week 33.5h starts here
    • GROUP BY and result grainState the grain of a result set and write the GROUP BY that produces it2.5h
    • HAVING vs WHEREChoose correctly between filtering rows and filtering groups, and say why1h · runs into week 4
  4. Week 46.5h starts here
    • Inner joinsJoin two tables on the correct key and predict the shape of the result1.5h
    • Outer joinsPreserve unmatched rows with an outer join without accidentally filtering them back out2h
    • Join grain and fan-outJoin three tables at the correct grain and prove the totals were not inflated by fan-out3h · runs into week 5
  5. Week 51.5h starts here
    • Self joinsWrite a self join with unambiguous aliases to compare rows within one table1.5h · runs into week 6
  6. Week 65h starts here
    • Semi and anti joinsFind rows that do or do not have a match without changing the result grain2h
    • SubqueriesUse a subquery in the right position to compute an intermediate result1.5h
    • Common table expressionsDecompose a complex query into named CTEs that each answer one clear question1.5h · runs into week 7
  7. Week 73.5h starts here
    • Correlated subqueriesWrite a correlated subquery and explain what it costs relative to a join2h
    • Conditional aggregation and pivotingPivot a long result into columns with conditional aggregation1.5h · runs into week 8
  8. Week 84h starts here
    • Date truncation and time seriesProduce a time series with no missing periods, including days with zero activity2h
    • Validating a resultCheck a query result for correctness before trusting it, and say what you checked2h · runs into week 9
  9. Week 94h starts here
    • Window function basicsAdd an aggregate to every row with a window function instead of collapsing the result2.5h
    • LAG and LEADCompare each row to the previous or next row within a partition1.5h · runs into week 10
  10. Week 103.5h starts here
    • Ranking functionsReturn the top N rows per group with the right tie-breaking behaviour2h
    • Revenue by channel, without double-countingMarkedRead the checklist it is marked against1.5h · runs into week 11
  11. Week 111.3h starts here
This is the same plan we would give anyoneThere is no box here for how good you already are, because saying so has never made it true. This is what SQL & Data Analysis takes, and the only thing that takes work out of it is work of yours that has been marked. What the ten-minute check gives you is the other half: where you stand in it before you start.
Check where you stand in SQL & Data AnalysisAbout ten minutes. No account.
The plan above is SQL & Data Analysis in full, and the marked work in it is published with its checklist before you start. Want a subject nobody has written? Ask for it — that one does need an account, and a few minutes.

One cookie, so we can see which subjects people finish and where the site loses them — plus a replay of where you click. Nothing you type is recorded, and once you’re signed in the words on screen are blanked out too. No advertising, nothing sold. The detail.