Skip to content
UdemySQLPaid courseAll LevelsCertificate

101 Practice SQL Questions: Basic to Advanced (Udemy.com)

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

Created by: Curtis Norman

Last updated November 2024

icon
What you will 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

How it compares

Against the other 388 rated Udemy courses in SQL on CourseDuck:

  • Rating4.5 out of 5higher than 48% of them
  • Reviews733#177 of 389 by number of reviews
  • Length16.9 hourslonger than 88% of them
  • Last updatedNovember 2024more recently than 59% of them

icon
Course Description

Let me guess, you’ve taken an Intro SQL course and don’t know what to do next? Or maybe you’ve taken a few months or years away from SQL and need to brush up. Either way, this course is for you!

This course literally includes 101 Practice SQL Questions! In fact, majority of questions include multiple parts. Including those multiple parts students get access to 286 practice questions. This gives individuals ample opportunity to try, fail, learn, and succeed.

The instructional level is listed as “All Levels.” However, those taking this course do need to have some basic understanding of SQL. The course includes basic, intermediate, and advanced questions. This course will not teach you concepts step-by-step. You will learn by attempting the question, using a hint if needed, then watching the video explanation. Video explanations are provided to show students how to answer the question; however, each question has multiple answers. The instructor simply shows students how he would answer the question.

Microsoft SQL Server Management Studio (SSMS) will be the database management system used in the course. All the questions in the course are answered using the Microsoft Sample database, AdventureWorks. The syntax used in SSMS is T-SQL. T-SQL is similar to syntax used in MySQL, PostgreSQL, Oracle, Snowflake, MariaDB, etc., however, Microsoft SQL Server will be needed to load the AdventureWorks database.

List of commands used in course questions:

  • Basic concepts: Select, From , Where , Order by , Group by , Count, Inner Join, Select Into, Distinct, Having, Create Database, Use Database, Sum, Avg, Min, Max, Create Table, Drop Table, Insert Into

  • Intermediate Concepts: And/Or, In/Not In, Between/Not Between, Like/Not Like, Case When, Concatenation, Left/Right Join, Format, Left/Right, Declare (local variable), Alter Table, Drop Column, Alter Column, Update, GetDate, DateAdd, DatePart, DateDiff, DateName, Month, Year, Day, Len, NewID

  • Advanced Concepts: Truncate, Delete, Exists, Inner Query (Subquery), Stored Procedure, CTEs , Temp Tables, Union, Self-Join, Cross Join, Convert, Cast, IsNull, Nullif, Coalesce, Lag, Lead, Ceiling, Floor, Views, Alter View, Foreign Keys, Default Constraints, Rollup, Pivot, Unpivot, Over, Partition, Rank, Row_Number, NTile, Percent_Rank, Choose, IIF, User Defined Types, Rollback, Begin Transaction, Commit, While loop - Batching, CharIndex, Triggers, Function, Cross Apply, Outer Apply, Index

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Curtis Norman

Hello, my name is Curtis and I enjoy solving problems. More specifically, I enjoy solving problems through logical, strategic, and data-driven thinking. I studied finance before finding my passion for healthcare, which led to studying healthcare administration at the University of Minnesota. My passion for healthcare come when my daughter was born prematurely, only weighing 1 lb at birth. This passion was inspired by clinical professionals who are driven to help patients heal. I love knowing that my work is in turn helping clinicians and patients. I've recently found a love for teaching complex subjects and simplifying them.

icon
More courses by Curtis Norman

$11.99

icon
More SQL courses

$94.99

$16.99

$12.99

$13.99

$10.99

$34.99

icon
Reviews

4.5

733 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Srinath G on 9/13/2026

I was really looking for a course that can help me practice T-SQL in a guided fashion and this course was just that. It is helping me build familiarity with T-SQL Syntax, explore the various scripting constructs et al. I also liked the way the questions have been categorized as Basic, intermediate and advanced, which aids in objective self-assessment.

By Anthony Stuart on 8/25/2026

Probably the best SQL course I've come across, as the instructor is highly knowledgeable and covers all the bases for how SQL is used in a professional context. He attempts to get you thinking about database fundamentals and system tables, and introduces a broad swath of tools frequently used in a production environment. The course isn't limited to your usual SELECT * FROM. Presentation can be a bit monotone at times and a bit dry but I would suggest looking past this as a lot of thought has gone into this course.

By Anyike Maduegbuna on 3/28/2026

Honestly learned so much more with his questions. Made me see what areas I was not comfortable in (took notes of the functions and etc to work on). I would say that patience is needed, some of the questions were confusing for me, maybe it was the way they were worded but all in all it was an amazing experience. Part of taking this course will help you learn how to ask the right question, I found out that in the later questions, I could solve most easier because I had become familiar with functions I never knew existed. Thank you for such a beautiful course, not many courses let you practice like this and get hands on experience. The course also helped improve the ways I would make a database.

By Łukasz Gajdzis on 12/15/2024

The course is a wonderful set of multiple excercises to practice on AdventureWorks. I recommend getting some theoretical knowledge first aswell, especially taking into consideration more advanced topics. The course has an index of functions and techniques, which really supports practicing particular subjects. One of the best courses I bought on this platform till now.

By Rethinavelu on 11/7/2024

This one of the best courses you will indulge to learn lot of things about querying, and it will let you to think not only in the query aspect but also in the data aspect. In this course i have learnt how to write a query in different way it helps me gaining confidence on writing query. The most important part is writing query is easiest thing here you will be subjected to solve the problem based on understanding data. I have got some tips in understanding data before writing the query all of sudden. In my opinion tutor can give us more question on query which will help us to understand data that is the only concern which I have, apart from this everything is great.

By Aung Win on 5/22/2024

There needs to be more time spent going over the ERD. I'm still confused on how the views work and how it connects with the AdventureWorks Entity Diagram. Majority of the questions haven't been hard in terms of using the tools of SQL, a lot of time is spent understanding how the entities connect.

By Muskan Gupta on 4/23/2024

This is a real wonderful course I ever had on Udemy business, it helped me a lot in understanding how various function works, but a little improvement could be there if the questions were more difficult. Anyways anyone doing this course I would suggest doing it twice, this manner you will understand the db more.

By Gustavo Arnaldo Rodrigues on 2/28/2024

Ótimo curso. Basta saber o básico que já dá para iniciar. As 10 primeiras questões são mais difíceis, faça acompanhando os vídeos, para as outras sugiro fazer, pesquisar, ir aprendendo junto com os exercícios. Obs: o curso toma muito mais tempo do que o estimado, já que é o seu tempo e conhecimento que vão ditar o ritmo. Gostei muito do curso e recomendo para aqueles que querem se tornar mais fluentes na escrita de queries no SQL.

By Rafiullah Shaheedullah on 6/9/2023

I found this course a great way of practising SQL Server. It has some advantages over other methods, including the use of many tables, and a clear E-R diagram. There are questions at all levels. The video explanations are very useful when you struggle. Overall, highly recommended.

By Shreya Thacker on 5/16/2023

I love this course. I have recently learnt SQL through various online courses and was looking to test my knowledge on mock dataset and challenges: this is a perfect place for that! The course is very well-thought out and structured. It tests you on a wide array of topics... while giving you small tips & trick along the way which I suppose one can only learn while solving problems. I liked the pace the instructor set. He is concise and clear. So if you are new to SQL and want to familiarize yourself with what it has to offer, this is the course to take.

Showing all 10 reviews on CourseDuck

Read all 733 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 90 / 100