Tangy is building your next step
Shaping the lesson around what you want to make.
Tangy is building your next step
Shaping the lesson around what you want to make.
SQL for analysis Lesson 3
Example · not liveA join pairs each customer with every matching order. Three customers can become more than three rows.
Predict before you run
SELECT c.name, o.id
FROM customers c
JOIN orders o
ON o.customer_id = c.id;Your guess
3 rows
Actual result
5 rows
| customers |
|---|
| Ada |
| Lin |
| Sam |
| name | order |
|---|---|
| Ada | #101 |
| Ada | #104 |
| Lin | #102 |
| Sam | #103 |
| Sam | #105 |
Tangy: Before I explain — how many orders does Ada have?
Two. Oh — so Ada shows up once per order.
Lessons are short and mix a few kinds of blocks, like these. Which ones appear depends on the topic.
01 Read
A few short paragraphs, with a diagram when a picture says it faster.
Sample
git stash shelves your uncommitted changes, so the working tree is clean again.
02 Predict
Committing to an answer first is what makes the result stick.
Sample
print(len("héllo"))Guess 6 · Output 5
03 Debug
Find the one line that is wrong and explain why.
Sample
for i in range(1, len(items)):The first item never gets counted.
04 Check
A short question before you move on.
Sample
The second request took 4 ms instead of 180 ms. Where did the response most likely come from?
Stuck at any point? The tutor chat sits next to the lesson. Ask about the line you don't understand, in your own words.
One sentence is enough. A topic, a tool, or something you want to be able to do.
Tangeble writes modules and short lessons around what you asked for, rather than handing you a generic syllabus.
Open a lesson, do the blocks, and ask whenever something doesn’t click.
Tangy starts with a question or a nudge, not the full solution.
Any line, any term, any “wait, why?” — in plain language.
Tangy explains and points. You write the code and the answers.
Write it down. Your first lesson starts from there.
