lrnit
For analysts

Learn SQL in a course built only for you. And actually retain it.

Go from spreadsheet exports to writing your own production queries: joins, aggregations, window functions, and the query patterns behind real business reporting.

Free to start · no account needed
Built around your goal, not a catalog

What your course could open with

lrnit interviews you first (what you know, why you’re learning, how you think), then generates every lesson for that. Sample lessons from a course like yours:

  1. 01SELECT, WHERE, and the mental model of a table scan
  2. 02Joins without fear: inner, left, and the duplicate-row trap
  3. 03Window functions: running totals, rankings, and month-over-month deltas
  4. 04The cohort query: retention analysis you can re-run every Monday
  5. …and the rest is generated for you: your gaps, your pace, your job.
Measured, not watched

By the end, you’ll be able to

What a capability check looks likebeforenow
Write a multi-table join+65
Use window functions+66
Build a cohort query+66

Every lesson ends in assessment. Mastery is tracked per concept with spaced review, and the course adapts to what you actually retain. Finishing means a timed final exam and a verifiable certificate, not a completion badge.

“It felt like the course already knew what I did for a living.”
Early lrnit learner

Questions people ask

Do I need to have written code before?
No. It starts from a single SELECT and the mental model of how a query reads a table, then builds to joins and window functions at a pace that assumes you have never coded.
Which database does it teach?
The SQL is standard and portable across Postgres, MySQL, BigQuery, and Snowflake. Where dialects differ, the course flags it.
Will I be able to write real reporting queries by the end?
Yes. It works up to cohort and retention queries you can re-run on your own data, and every lesson checks your queries are correct, not just plausible.

Your version of this course doesn’t exist yet.

Free to start · no account needed
More outcomes

Other courses people build here

Browse all outcomes