SQL Aggregate Functions and GROUP BY in Depth
How aggregate functions interact with GROUP BY, HAVING, and window functions, with practical patterns and pitfalls every backend engineer should know.
·4 min read · #sql#group-by#aggregates
#analytics
4 posts · page 1 of 1
SQL Materialized Views: A Practical Tutorial
Learn how materialized views work in PostgreSQL, when to use them over regular views, and how to refresh them efficiently without blocking readers.
·4 min read · #sql#postgres#materialized-views
SQL PIVOT and UNPIVOT Tutorial
How to reshape rows into columns and back using PIVOT, UNPIVOT, CASE aggregations, and lateral unions across Postgres, MySQL, and SQL Server.
·4 min read · #sql#pivot#unpivot
SQL Window Functions: A Practical Tutorial
Learn how window functions work in SQL, when to use ROW_NUMBER, RANK, LAG, and SUM OVER, and how they differ from GROUP BY.
·5 min read · #sql#window-functions#analytics