ContextliContextli

Students Β· Course Notes

Recap an online lesson into study notes.

Who this is for

Self-learners taking online courses who want to retain what they watch by explaining it back, not just consuming it.

The moment this saves you

I binge an online course feeling productive, but a week later I've retained almost nothing, because watching isn't learning and I never paused to put any of it in my own words.

See it work

Messy spoken thought in. A clean, structured artifact out.

What you said

Just finished the module on SQL joins. Main thing I learned, there are different types of joins and the difference is which rows you keep. Inner join only keeps rows that match in both tables, that's the default and most common. Left join keeps all rows from the left table even if there's no match, and you get nulls for the missing stuff. The aha moment for me was realizing left join is how you find things that don't have a match, like customers with no orders, that's a really practical use. The thing I'm still fuzzy on is the difference between a full outer join and a cross join, need to revisit that.

course-notes.md

Course notes: SQL joins, June 5, 2026

Main idea: The type of join determines which rows you keep.

Key points

  • Inner join: keeps only rows that match in both tables (the default, most common).
  • Left join: keeps all rows from the left table even without a match; missing values come back as nulls.

Aha moment: A left join is how you find things with no match, e.g. customers with no orders. Very practical.

Still fuzzy on: Full outer join vs cross join, revisit.

The workflow

1

Record a voice note

Hit the hotkey and talk, no formatting, no typing.

2

Tag it with this context

Contextli shapes your words into the structured output above.

3

Find it later

Everything's searchable and organised by context.

4

Pull it into Claude or ChatGPT

Bring your contexts straight into your AI tools with the Contextli MCP.

Your raw recording and transcription stay on your device, so you can always go back to the original.

The prompt behind this context

system prompt

I'm going to recap an online lesson or course module in my own words. Turn it into structured study notes: a bold "Course notes: [topic], [today's date]" heading, a **Main idea** line, a **Key points** list (the supporting concepts and examples, in italics for any term I name), an **Aha moment** line for any insight I had, and a **Still fuzzy on** line for what I want to revisit. Keep my own explanations, they show what I understood. Don't add facts or terms I didn't mention. Output only the notes.

Make it your own. This is a starting point. Once it's in Contextli, tweak the instructions so the output comes out exactly how you like it.

Use this context

One tap adds it to your clipboard. Open Contextli and paste to add it.

Next, open Contextli, Contexts, Import, paste.

Make it your own. This is a starting point. Once it's in Contextli, tweak the instructions so the output comes out exactly how you like it.

Your raw recording and transcription stay on your device, so you can always go back to the original.

Related contexts

Browse more

Course Notes