IT Career Guides & Free Resources
Expert roadmaps, tutorials, salary guides and interview prep across Data Science, Generative AI, Python, Cloud & Analytics — written by GloryTecks trainers in Hyderabad.
All articles
Window Functions SQL Interview Questions
Interviewers use window functions to see whether you understand how SQL evaluates a query, not just the syntax. These nine questions, each answered with a query run on two years of real bike rentals, cover ranking ties, top N per group, running totals, the default frame trap, gaps and islands, and filtering.
BigQuery Window Functions and Analytic SQL
A window function computes a value for each row from a set of related rows, without collapsing them. This guide works through running totals, moving averages, period change, share of total and top-per-group on 2.9 million real trips, then shows the two frame mistakes that return wrong numbers without an error.
Window Functions in SQL for Data Engineers
The window function patterns data engineers use every week, each run on the real Chinook database: ROW_NUMBER for the latest row per key, RANK and DENSE_RANK on ties, LAG for gaps between events, frames for running totals and moving averages, and the default RANGE frame that silently changes a running total.
Tumbling Window Triggers: Backfills and Dependencies
A tumbling window trigger runs a pipeline once for each fixed, contiguous slice of time, and remembers which slices it has done. This guide explains the window model, a worked backfill of 31 daily windows, concurrency, delay and retry, dependencies between triggers, and passing window boundaries to a pipeline.