#07 · SQL and analytics · 5.9 minSQL Window Functions and CTEs in DuckDB: Two Mistakes
Learn CTEs and window functions with DuckDB on a tiny orders table, then see two common mistakes, with real output.
Python 3.12.15 | duckdb==2.0.05 videos tagged "duckdb tutorial".
#07 · SQL and analytics · 5.9 minLearn CTEs and window functions with DuckDB on a tiny orders table, then see two common mistakes, with real output.
Python 3.12.15 | duckdb==2.0.0
#14 · Data engineering and pipelines · 6.2 minBuild a complete dbt project on DuckDB with models and tests, then watch a test catch a bad row that dbt run lets through.
Python 3.12.15 | dbt-core==1.12.6, dbt-duckdb==1.11.1, duckdb==2.0.0
#37 · AI agents and MCP · 5.7 minA read only database stopped three of eight attacks on my SQL agent. The other five needed other layers.
Python 3.12.15 | duckdb==2.0.0
#227 · Data strategy · 5.1 minIn a made-up traffic mix, one kind of query was 2 percent of the traffic and 60 percent of the compute cost. Here is how to find it.
Python 3.12.15 | duckdb==2.0.0
#309 · Forward deployed engineer interviews · 6.3 minMy data profile said 275 blank amounts. The file had 363. Here is why.
Python 3.12.15 | duckdb==2.0.0