Skip to content
Tagged articles

Temporary Functions

3 articles · Page 1 of 1
Linux Tech Enthusiast
Linux Tech Enthusiast
Oct 25, 2026 · Databases

10 Advanced SQL Techniques for Data Science Interviews

This article covers 10 advanced SQL concepts — CTEs, recursive CTEs, temporary functions, CASE WHEN pivoting, EXCEPT vs NOT IN, self-joins, ranking functions, delta calculations, running totals, and datetime manipulation — with practical code examples for data science interviews.

CTEData Science InterviewsDateTime Manipulation
0 likes · 11 min read
10 Advanced SQL Techniques for Data Science Interviews
Code Ape Tech Column
Code Ape Tech Column
Jul 5, 2024 · Databases

10 Essential Intermediate to Advanced SQL Concepts

This article presents ten crucial intermediate‑to‑advanced SQL concepts—including CTEs, recursive queries, temporary functions, CASE pivots, EXCEPT vs NOT IN, self‑joins, ranking functions, delta calculations, cumulative totals, and date‑time manipulation—each explained with clear examples and code snippets.

CTEData PivotRanking
0 likes · 11 min read
10 Essential Intermediate to Advanced SQL Concepts
dbaplus Community
dbaplus Community
Jun 28, 2022 · Databases

Master 10 Advanced SQL Concepts Every Data Scientist Should Know

This article presents ten essential advanced SQL techniques—including CTEs, recursive CTEs, temporary functions, CASE‑WHEN pivots, EXCEPT vs NOT IN, self‑joins, ranking windows, delta calculations, cumulative totals, and date‑time manipulation—each explained with clear examples and code snippets for interview preparation.

CASE WHENCTEData Science Interviews
0 likes · 11 min read
Master 10 Advanced SQL Concepts Every Data Scientist Should Know