Tag: #window-function
Writing on GPUs, LLMs, MLOps, Kubernetes — and mindset · 1 posts
SQL Mastery 2025: Developer Interview SQL — From JOINs to Window Functions and Query Optimization
Everything about SQL interviews! 7 types of JOINs, Window Functions (ROWNUMBER/RANK/LAG/LEAD), Subquery vs CTE, Index internals (B-Tree/Hash/GIN), EXPLAIN ANALYZE, Transaction Isolation Levels, and 30 practice problems.
2026-03-23 · 30 min read #sql#database#join#window-function#indexing