Blog
SQL, data, and practical AI — plain English. Filter by topic or search.
All articles
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…
SQL Tutorial 9: Views and Indexes
Reuse logic with views and speed lookups with indexes on everyday customer and order queries. Learn what each database object is for, how teams share meaning safely, and…
SQL Tutorial 8: Modifying Data with SQL
Change data safely with INSERT, UPDATE, and DELETE on the customers and orders toy schema. Practice row adds, targeted edits, and careful deletes, plus a light take on…
