Jobseeker Toolkit

Resources

Curated tools, learning paths, and strategies for the serious jobseeker. Select any section to open it.

SQL Mastery

SQL is the single most important skill for data and dev professionals.

Start with MySQL. It is legendary for a reason. Every SQL concept you learn in MySQL transfers directly to PostgreSQL, BigQuery, Snowflake, and Redshift. Master the fundamentals before you touch the platform-specific syntax.

Practice & Learning Platforms

MySQL

The legendary starting point. Learn MySQL first. Every SQL concept transfers. The most widely deployed relational database.

Interview Query

Real SQL interview questions from top tech companies. Includes company-specific question banks and difficulty ratings.

StrataScratch

Actual interview questions from Google, Netflix, Airbnb, and more. Both SQL and Python solutions.

DataLemur

SQL interview questions from Meta, Amazon, and Twitter. Beginner to advanced with hints and explanations.

LeetCode SQL

LeetCode database category. Essential for FAANG SQL prep. Mix of easy to hard problems across joins, aggregations, and window functions.

DataCamp SQL

Structured SQL learning path from intro to advanced. Good for building foundations before moving to interview prep.

Mode Analytics SQL

Free SQL tutorial with a live query editor. Covers basics to advanced analytics including window functions.

SQLBolt

Interactive SQL lessons with live practice. Best starting point for absolute beginners. Clean and fast.

SQLZoo

Interactive SQL practice with real datasets. Wide range of difficulty. Covers multiple SQL dialects.

SQL Execution Order vs Logical Order

SQL is declarative. You tell it what you want and the Optimizer decides how to get there. The order you write clauses is NOT the order the engine executes them.

Step	Clause	What is actually happening
1	FROM	The engine identifies the source tables and performs any JOINs.
2	WHERE	Filters the raw rows based on conditions.
3	GROUP BY	Aggregates the filtered rows into buckets.
4	HAVING	Filters the groups (not the individual rows).
5	SELECT	Only now does it pick the specific columns and apply aliases.
6	ORDER BY	Sorts the final result set for display.

The Key Insight

This is why you cannot use an alias created in the SELECT clause inside a WHERE clause. The computer has not reached the SELECT step yet when it is filtering rows. Execution order, not writing order.

Data and Logic: The Long-Term Relationship

To understand the digital world, look past the syntax and see it as an ecosystem. It is a long-term relationship between two distinct entities: Data and Logic.

Data (SQL) is the Memory

It knows every detail of the past: names, dates, histories. A vast library waiting for a reader. It cannot act on its own.

Code is the Will

The ability to make decisions and perform tasks. But code is ephemeral. It forgets everything the moment the session ends or power is cut.

Programming is Matchmaking

Teaching these two how to talk to each other. A programming language is the shared dialect, allowing Will to ask Memory for the context it needs.

// The House Metaphor

Data = The Memory (locked vault without logic)

Code = The Will (amnesiac without data)

Framework = The House (foundation, plumbing, walls)

API = The Front Door (controlled exchange with the world)

SQL is Set Theory

You start with a large pile of data and whittle it down through filters until you have a small, precise set of results. Declarative: you describe the destination, the engine finds the route.

Programming is Imperative Logic

You start at a single point (main) and follow a map of instructions step by step. You are not describing a destination, you are drawing the entire path yourself.

The Programming Execution Lifecycle

Phase A: Compile Time (Preparation)

Before the program runs, the compiler checks syntax and prepares the blueprint. This is where Library Linking and Memory Mapping for static variables happen.

Phase B: Runtime (Execution)

Entry Point (main) receives control from the OS. Stack Initialization sets up memory for function calls. Control Flow executes business logic through branching, iteration, and function calls.

// The Layers Perspective

Hardware = Physical CPU and RAM

Kernel (OS) = Manages resources, hands control to your program

Runtime/VM = Python or Java middleman translating to OS language

Application= Your code, logic, and variables

Resources

Learning Paths

SQL Mastery

AI / ML Learning

DSA & Coding Prep

Tech Blogs

Salary Intel

Google Dorking

Networking

Career Strategy

Resume & Portfolio

Resources

Learning Paths

SQL Mastery

AI / ML Learning

DSA & Coding Prep

Tech Blogs

Salary Intel

Google Dorking

Networking

Career Strategy

Resume & Portfolio

DS & ML Learning Paths

Data Science for Beginners

Pick Your Sector

Build Your Data Stack

Data Science & Analytics

Machine Learning & AI

Data Engineering

Computer Science

SQL Mastery

MySQL

Interview Query

StrataScratch

DataLemur

LeetCode SQL

DataCamp SQL

Mode Analytics SQL

SQLBolt

SQLZoo

AI / ML Learning

Claude Skills

Andrej Karpathy

Andrew Ng

CampusX

Krishnaik

HuggingFace

fast.ai

Made With ML

DSA & Coding Interview Prep

LeetCode Patterns

Striver A2Z Sheet

Striver SDE Sheet

NeetCode (Blind 75)

Tech Blogs & Communities

Jane Street Tech Blog

3Blue1Brown

DS4A

JOE - Econ Jobs

Kaggle

Mathjobs.org

PyCon

PyTorch

Standup Maths

Salary & Market Intelligence

Levels.fyi

Layoffs.fyi

Google Dorking for Jobs

Networking

Luma

Meetup

Eventbrite

YC Startup Directory

YC Founders Directory

Jobright.ai

Simplify

Career Strategy

Skip the Master's. Consider a PhD.

Resume & Portfolio

Use Claude for Resume Templates

I Got an Offer

Google Resume Guide