New: 6 free SQL practice datasets with 300+ questions — try the SQL Compiler →
Free · No signup needed

The Journal

Practical SQL, Python, data science and AI guides, written from real practice — not just to rank.

SQL

SQL Subquery vs CTE: Differences and When to Use

Subquery or CTE? Learn what each is, how they differ and when to use which in SQL, with…

September 24, 2026 8 min read
SQL

NULL in SQL: IS NULL, COALESCE and Common Mistakes

What is NULL in SQL? Learn IS NULL, COALESCE and how NULL affects COUNT, AVG and NOT IN,…

September 24, 2026 7 min read
SQL

SQL Window Functions Explained With Examples

SQL window functions explained simply: OVER, PARTITION BY, ROW_NUMBER, RANK, LAG and running totals, with sample tables and…

September 24, 2026 8 min read
SQL

SQL WHERE vs HAVING: Difference With Examples

WHERE filters rows before grouping, HAVING filters groups after it. Learn the difference between WHERE and HAVING in…

September 24, 2026 7 min read
SQL

How to Prepare for a SQL Interview: A Plan

How to prepare for a SQL interview: what rounds test, a topic checklist, a practice loop with timed…

September 24, 2026 6 min read
SQL

SQL Quiz vs Tutorials: Which Builds Skill Faster?

SQL quiz vs tutorials: why testing yourself beats re-reading, three sample quiz questions with explanations, and how to…

September 24, 2026 6 min read
Career

What Is an ATS? How Applicant Tracking Works

What is an ATS? How applicant tracking systems really work, the myths, how to make your resume parse…

September 24, 2026 7 min read
Career

How to Ask for an Employee Referral: Templates

How to ask for an employee referral: who to ask, how to make it easy to say yes,…

September 24, 2026 6 min read
Career

Not Getting Shortlisted? 7 Fixes Beyond the Resume

Not getting shortlisted? Seven fixes with examples: target one role, use the job's words, write result bullets and…

September 24, 2026 6 min read
Scroll to Top