Skip to content
Tagged articles

Data Science Interviews

4 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
Top Architect
Top Architect
Apr 2, 2024 · Databases

Ten Advanced SQL Concepts Every Data‑Science Interview Candidate Should Master

This article explains ten advanced SQL techniques—including common table expressions, recursive CTEs, temporary functions, CASE‑WHEN pivots, EXCEPT vs NOT IN, self‑joins, ranking functions, delta calculations, cumulative sums, and date‑time manipulation—providing clear explanations and complete query examples to help readers ace data‑science interview questions.

CTEData Science InterviewsSQL
0 likes · 14 min read
Ten Advanced SQL Concepts Every Data‑Science Interview Candidate Should Master
Liangxu Linux
Liangxu Linux
Aug 14, 2022 · Databases

Master 10 Advanced SQL Concepts for Data Science Interviews

This guide walks you through ten essential advanced SQL techniques—including CTEs, recursive queries, temporary functions, CASE pivots, EXCEPT vs NOT IN, self‑joins, ranking window functions, delta calculations, running totals, and date‑time manipulation—providing clear explanations and practical code examples to boost your interview performance.

Advanced QueriesCTEData Science Interviews
0 likes · 12 min read
Master 10 Advanced SQL Concepts for Data Science Interviews
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