OneTab - Shared tabs

Shared: 58 tabs

Scan this QR code using the camera app on your smartphone or tablet

Copy all links to clipboard

How to use this?

Copy links to clipboard

Copy

All my best SQL + Data posts in one place. Browse the sections and open any post in a new tab. Found this useful? 🤩 𝗥𝗲𝗮𝗰𝘁 𝗮𝗻𝗱 𝗱𝗿𝗼𝗽 𝘆𝗼𝘂𝗿 𝘁𝗵𝗼𝘂𝗴𝗵𝘁𝘀 𝗶𝗻 𝘁𝗵𝗲 𝗽𝗼𝘀𝘁 𝗰𝗼𝗺𝗺𝗲𝗻𝘁𝘀.

Hi, I'm Anand 👋

Copy links to clipboard

Copy

Personal: 📩 anandsirius1@gmail.com Professional: 📩 anandanddata@gmail.com

Any Feedback is welcome! Connect & DM me

I won #1 in a SQL hackathon.

I did 1,000+ SQL problems in 66 days.

I was mentored by Ankit Bansal in SQL

🎁 Resources @ Rs 0/-

Copy links to clipboard

Copy

The 12 SQL Patterns that is often asked in Interviews ( w/ Master prompt for practice)

Real World SCD Code examples (Practice)

⚡Patterns Explained + Ready-to-solve SQL sandbox

Copy links to clipboard

Copy

Outside-the-Group Comparison

The Forward Fill

The Alternating Rank pattern

Recursive pattern ↑ ↓

The Recursive Seed pattern

The Gap-and-Island pattern

Frequency Median

The Sequential Session

The Self-Join Filter

The One-Pass Window Distribution.

Find Median

Reverse JOIN

"Nth" row

NEW vs REPEAT customers

Last sunday

Left join turned into Inner join

Did A and B?

Balance calculation

SCD type II Pattern

Weekend / Weekday

⭐ Top SQL Interview Questions

Copy links to clipboard

Copy

20 SQL Pattern Cheatsheet IV

20 SQL Patterns Cheatsheet III

20 Time series SQL Patterns

20 SQL Patterns Cheatsheet II

20 SQL Join Patterns

20 SQL Patterns Cheatsheet

15 SQL Window Function Patterns You Must Know

The 10 SQL Pattems That Actually Matter

10 CTE patterns

🔎 Cheatsheets + Guides

Copy links to clipboard

Copy

10 case studies for Data Engineers

SQL Optimization - SARGable

SCD Master Guide

"How do I break into Data Engineering?"

10 Data Engineering Blogs that actually matter

SQL Optimization Series | Part 2

SQL COUNT() cheatsheet

SQL Keys. Made Easy.

Next [Any day] MySQL pattern

SQL Execution order

70+ critical SQL topics

SQL Optimization - Existence check

1-minute SQL read that clears 90% of date confusion.

SQL Acid Memesheet

SQL Optimization Series | Part 3

SQL -> Pyspark

7 SQL PATTERNS Every Beginner Must Know

SQL PIVOT vs. UNPIVOT

Last Sunday. Next Sunday. One Pattern. MySQL

Window Functions Cheatsheet

6 SQL Optimizations

9 SQL patterns I wish someone forced me to learn on day 1

SQL Optimization Series | Part 1

Page expires in: