SQL Quizzes
Practice SQL from SELECT basics to window functions and query optimization for real interview prep.
Log in to track your progress across SQL quizzes.
Log in →Your learning path
Basic
1 quiz
Advanced
3 quizzes
Certification
1 quiz
Interview
1 quiz
SQL Basics
SELECT, FROM, basic filtering and core SQL syntax.
WHERE Clause
Filtering rows with comparison, logical and pattern operators.
ORDER BY
Sorting result sets ascending, descending and by multiple columns.
Aggregate Functions
COUNT, SUM, AVG, MIN, MAX and when to use each.
GROUP BY
Grouping rows and combining with aggregate functions.
HAVING Clause
Filtering grouped results — HAVING vs WHERE.
JOINs Fundamentals
INNER JOIN and the basics of combining tables.
LEFT JOIN
Keeping all rows from the left table in a join.
RIGHT JOIN
Keeping all rows from the right table in a join.
FULL OUTER JOIN
Combining all matched and unmatched rows from both tables.
SELF JOIN
Joining a table to itself for hierarchical/relational data.
UNION & UNION ALL
Combining result sets and deduplication behavior.
Subqueries
Nested queries in SELECT, WHERE and FROM clauses.
Common Table Expressions
WITH clauses for readable, reusable query logic.
Window Functions
ROW_NUMBER, RANK, LAG/LEAD and OVER() partitions.
CASE WHEN
Conditional logic inside SQL queries.
Views
Creating and querying virtual tables with CREATE VIEW.
Indexes
How indexes speed up queries and when to use them.
Stored Procedures
Encapsulating reusable SQL logic.
SQL Interview Questions
Frequently asked SQL interview questions for analyst roles.
SQL Certification Prep
Comprehensive review for SQL certification exams.