dbt: The SQL-First Transformation Tool for Data Teams
Discover how dbt brings software engineering practices—version control, testing, documentation—to SQL-based data transformations.
Posts tagged with #sql
DuckDB: The SQLite for Analytical Workloads
Explore DuckDB, the in-process analytical database that runs anywhere, handles columnar storage efficiently, and brings analytics to where your data lives.
Joins and Aggregations: SQL Patterns for Data Analysis
Master SQL joins and aggregation techniques for building efficient analytical queries in data warehouses and analytical databases.
Presto and Trino: Querying Everything From Anywhere
Learn how Presto and Trino enable federated SQL queries across data lakes, warehouses, databases, and object storage without moving data.
Constraint Enforcement: Database vs Application Level
A guide to CHECK, UNIQUE, NOT NULL, and exclusion constraints. Learn database vs application-level enforcement and performance implications.
Database Indexes: B-Tree, Hash, Covering, and Beyond
A practical guide to database indexes. Learn when to use B-tree, hash, composite, and partial indexes, understand index maintenance overhead, and avoid common performance traps.
Understanding SQL JOINs and Database Relationships
Master SQL JOINs with this practical guide covering INNER, LEFT, RIGHT, FULL OUTER, and CROSS joins. Learn how relationship types between tables shape your queries.
Database Normalization: From 1NF to BCNF
Learn database normalization from 1NF through BCNF. Understand how normalization eliminates redundancy, prevents update anomalies, and when denormalization makes sense for performance.
Primary and Foreign Keys: A Practical Guide
Learn the difference between natural and surrogate keys, how foreign keys enforce referential integrity, cascade rules, and best practices for constraint naming.
Query Execution Plans: Reading EXPLAIN Output Like a Pro
Learn to decode PostgreSQL EXPLAIN output, understand sequential vs index scans, optimize join orders, and compare bitmap heap scans with index-only scans.