Skip to content
Tagged articles

DateTime Manipulation

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

10 Advanced SQL Techniques for Data Science Interviews

This article explains ten advanced SQL concepts — including CTEs, recursive CTEs, temporary functions, pivoting with CASE WHEN, EXCEPT vs NOT IN, self joins, ranking functions, delta calculations with LAG/LEAD, running totals, and datetime manipulation — with practical code examples for data science interview preparation.

CTEDateTime ManipulationLAG
0 likes · 11 min read
10 Advanced SQL Techniques for Data Science Interviews
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
Architect's Guide
Architect's Guide
Sep 30, 2026 · Databases

10 Advanced SQL Techniques for Data Science Interviews

This article explains ten advanced SQL concepts including CTEs, recursive queries, temporary functions, pivoting with CASE WHEN, EXCEPT vs NOT IN, self-joins, ranking functions, delta calculations with LEAD/LAG, running totals, and datetime manipulation, with code examples for data science interview preparation.

CTEDateTime ManipulationPivoting
0 likes · 12 min read
10 Advanced SQL Techniques for Data Science Interviews