ORDER BY: Sorting Your Results
SQL returns rows in no guaranteed order; the same query can come back differently twice. ORDER BY gives you control, like Python's sorted() with keys.
Sql
SELECT: Choosing Your Columns
SQL's SELECT is more than picking columns. Rename with AS, compute expressions, and use DISTINCT for unique values.
FROM: Where Your Data Lives
We write SELECT first, but FROM runs first. It's the `for item in collection` part of a Python loop: pick your data source before anything else.
SQL Thinks in Sets, Not Loops
The mental model that makes SQL click: describe what you want instead of looping row by row. Think in sets and the keywords become intuitive.
Don't forget to save! Persisting your DuckDB database
Your in-memory database disappears when Python exits. Let's fix that with a one-line change that saves everything to disk.
Generate Practice Data with faker
Real SQL practice needs real-looking data. Generate hundreds of customers with Python's Faker library without downloading a single CSV
I know Python; Why learn SQL
Learning SQL makes you a better Python developer, even if you use pandas and ORMs. The first post in a series that teaches it with DuckDB and Python.
AWS Data Engineer Associate Certification Test - Take 2
I took the DEA-C01 AWS Data Engineer Associate exam for the second time this morning. No results yet, but here are my thoughts on the attempt.
DBeaver Sample Database: What's Inside and How to Query It
DBeaver ships a sample database with employees, customers and orders. Here's what's inside and the first queries to run on it.
I installed dBeaver today
I downloaded the community edition of dBeaver today and enjoyed the installation experience and sample database option.