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.
Cloud Functions on GCP: Serverless Explained
A function is a few lines of code that run when something happens, with no server to manage. Google Cloud's version, Cloud Functions, is now called Cloud Run functions. This guide explains the two kinds of function, runs a storage-triggered one locally with Google's framework, and covers triggers, retries and limits.
AWS Step Functions: Orchestrating Serverless Workflows
AWS Step Functions coordinates other services into a workflow with retries, branching and a visible history. This guide explains state machines and state types, the three integration patterns, error handling, Standard versus Express workflows, billing, and a nightly data pipeline written in Amazon States Language.
Top 20 DAX Functions Every Analyst Should Know
Twenty DAX functions that cover most Power BI reporting, grouped by job: counting and summing, iterators such as SUMX, CALCULATE and its filter modifiers, relationship functions, logic and safe division, SELECTEDVALUE and VALUES, time intelligence, and RANKX, each with an example measure and the mistake to avoid.
ADF Expressions and Functions: A Practical Guide
The expression language is what makes Azure Data Factory pipelines dynamic. This guide explains when a JSON value is an expression, whole-value expressions versus string interpolation, the system variables, the six function families with documented examples, and the patterns that cover most real pipelines.