Category: SQL
You are here if you have a table and a question, and another export into a sheet is how the answer gets worse. These articles are the SQL series in category form. The numbered tutorials start with a playground and the core commands, then reading rows, filtering, sorting, grouping, and joins. Later tutorials cover subqueries, changing rows, views and indexes, and making a query faster and easier to keep. One extra primer, outside that numbered run, asks what SQL is and why you would learn it.
Do not start in the middle because a title mentions joins. Joins make sense after you can read and filter a single table. The series hub states the order. The category page is only the shelf.
Where to start: open the SQL series. Use the first part on that page. If you only needed the word, the primer is enough. If you need to write the query on Monday, use the playground and go in order.
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…




