101 Practice SQL Questions: Basic to Advanced

Answer over one hundred practice SQL questions using Microsoft's Sample database, AdventureWorks (Updated for 2025!)

Created by: Curtis Norman
Healthcare Finance and Analytics Consultant

What Will I Learn?

• Take your SQL understanding to the next level. Questions are available for individuals at all levels; however, a basic understanding is needed.
• Prepare for SQL interviews by practice a plethora of challenging SQL questions.
• Learn how to take a difficult questions, think critically, and apply your SQL knowledge.
• There are many ways to provide the same results. Discover your own style and cultivate your abilities within Microsoft SQL Server.
• Microsoft SQL Server and T-SQL syntax
• Advanced Topics such as Triggers, Functions, Indexes, Self-Joins, Stored Procedures, Common Table Expressions (CTEs), and much mor.e

Requirements

• A level of SQL knowledge above a beginner
• Basic to advanced understanding of SQL Syntax
• Ability to problem solve, think critically, and apply SQL knowledge
• Microsoft SQL Server - Instructor will help you download
• Windows operating system

Target audience

• Any SQL developer, analyst, or individual wanting to become more skilled in SQL
• Individuals who learn by doing and enjoy challenging themselves
• Learners who want to gain a deeper understanding of SQL through practice