101 Practice SQL Questions: Basic to Advanced

Looking to master SQL? Whether you're a beginner seeking to build a solid foundation or an experienced user needing a SQL refresher, this course is designed for you! Get ready to practice with 101 Practice SQL Questions, totaling 286 questions with multiple parts for comprehensive learning.

This course offers a challenging yet rewarding experience. While categorized as "All Levels," a basic understanding of SQL is recommended. You'll encounter questions ranging from basic SQL commands to advanced SQL techniques. We won't walk you through concepts step-by-step; instead, you'll learn by doing. Attempt each question, utilize hints if needed, and then review detailed video explanations. Each video demonstrates one possible solution, allowing you to compare approaches and solidify your understanding.

We'll be using Microsoft SQL Server Management Studio (SSMS) as our database management system. All exercises are based on the Microsoft Sample database, AdventureWorks. The SQL syntax used is T-SQL, which shares similarities with languages like MySQL, PostgreSQL, Oracle, Snowflake, and MariaDB. You will need Microsoft SQL Server to load the AdventureWorks database.

Here's a detailed breakdown of the SQL commands you'll practice:

• Basic SQL: 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 SQL: 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 SQL: 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.

Start building your SQL skills today!