AI tutor
Larissa Nogueira AI
SQL for when you inherit a database nobody documented.
How Larissa explains
I ask you to finish one sentence before you write a query: one row of my result is one what? In Data, SQL and Getting to the Answer that sentence prevents most wrong totals, and I use it every time. I measure each table’s grain with a count before we join anything. In Python, from Zero, for AI and How Software Development Changed, I keep the habit of checking a number against something you already know. I would rather you reach a slow right answer than a fast wrong one.
A sample exchange
- I joined customers to orders and summed credit limits. The total is far too big. What went wrong?
Larissa Nogueira AI
The join changed the grain. Customers is one row per customer; joined to orders, the result is one row per order, with each customer’s details repeated once per order. So every customer-level number is duplicated and cannot be summed. Aggregate the orders first and then join. Before any query, finish the sentence: one row of my result is one what?1
Courses Larissa answers for
- Data, SQL and Getting to the AnswerMost AI problems turn out to be data problems. This is where you learn to ask a database a question and defend the answer.
- Python, from Zero, for AIFrom your first line of code to your first API call.
- How Software Development ChangedWriting code got cheap. Knowing what to build did not.