All Articles & Tutorials
Explore practical guides, step-by-step masterclasses, and foundational definitions across AI, SQL, and data systems — written in plain, human English.
All articles
How to Check AI-Written SQL Before You Ship It
Chatbots can draft queries in seconds. Here’s a simple checklist so you catch bad joins, wrong filters, and confident nonsense.
SQL Tutorial 13: Strategies for Maintenance and Optimization
Keep databases healthy over time with backups you can restore, slow query awareness, stats and vacuum concepts, access grants, and on-call hygiene. Close the SQL series with a…
SQL Tutorial 12: Best Practices and Optimization
Write cleaner and faster SQL with an EXPLAIN mindset, tight select lists, sargable filters, and index awareness on real customer and order patterns. Learn practical optimization habits without…
SQL Tutorial 11: Stored Procedures, Triggers, and User-Defined Functions
Understand stored procedures, triggers, and user-defined functions as database objects you may inherit at work. Learn when analysts should care, when SQL scripts or dbt-style models fit better,…
SQL Tutorial 10: Advanced SQL Techniques
Level up multi-step SQL with CTEs for readable named steps, window functions like ROW_NUMBER and running sums on detail rows, and a small conceptual recursive example you can…
