SQL from Scratch, Pt. 5: Our Local Database Gets Its Data
Hi, We finished by creating our database file: see part 4 of the course It’s time to populate it with data. Step 1: Download the SQL file …
Read more →Blog category
SQL Course
SQL from Scratch, Pt. 4: A Quick Recap and Leaving the Sandbox! Installing Local Tools and Your First Database
Introduction: The Plan of Action Hi, Today we’ll start with a quick recap of what you already know, and on this occasion, we’ll dive a little into theory—but…
Read more →
SQL from Zero, Part 3: Joining Three Tables and Sorting Results (LEFT JOIN, ORDER BY)
Introduction: From Simple Pairs to a Complex Web of Connections Welcome back. In previous lessons, we learned how to look inside a single “binder” (SELECT … FROM), filter…
Read more →
SQL from Scratch, Part 2: How to Filter Data (WHERE) and Connect Worlds (JOIN)
Introduction: From a simple question to a precise investigation Welcome to the second part of our journey into the world of SQL. In the previous lesson, we took…
Read more →
SQL from Scratch: Your First Step into the World of Data (Even If You’re Not in IT)
Introduction: Forget “coding,” learn to ask precise questions Do the words “database” or “programming” make you feel a little anxious? Do you picture complex screens full of incomprehensible…
Read more →