Category: SQL
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…
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…
