SQL Problems & Solutions + Practice Database
Database setup file:
https://drive.google.com/file/d/1-fGL...
Installing SQL Server and SQL Server Management Studio (SSMS):
• Video
Setting Up a Practice SQL Database:
• Video
0:00 - Intro
Single- and Multiple-Row Subqueries:
00:33 Exercise 1: Single-row subquery in the WHERE clause
08:30 Exercise 2: Chained subqueries using the IN operator
21:22 Exercise 3: Scalar subquery in the SELECT clause + AVG aggregate function + CAST
function
34:33 Exercise 4: Scalar subquery in the SELECT clause + COUNT aggregate function + Local
Variable
52:38 Exercise 5: Chained scalar subqueries + MAX aggregate function
01:03:14 Exercise 6: Chained scalar subqueries + latest sale lookup
01:20:38 Exercise 7: Chained subqueries + SELECT TOP clause
UNION / INTERSECT / EXCEPT:
01:33:04 Exercise 1: UNION / UNION ALL + Multiple-Row Subqueries
01:44:40 Exercise 2: UNION / UNION ALL + Chained Subqueries
02:02:40 Exercise 3: INTERSECT + BETWEEN Operator
02:14:16 Exercise 4: INTERSECT + Pattern Matching + Numeric Condition
02:25:46 Exercise 5: EXCEPT + Date Range Filter
02:39:18 Exercise 6: EXCEPT + Pattern Matching + Numeric Condition
02:51:42 Exercise 7: EXCEPT + Odd Rounds + IS NULL predicate
This video walks you through a series of challenging SQL exercises with step-by-step solutions and clear explanations. Whether you’re preparing for an interview or leveling up your database skills, these problems reinforce essential SQL concepts.
What You'll Learn & How to Apply It:
• Subqueries: single-row, multiple-row, and chained subqueries
• Using subqueries in SELECT and WHERE clauses
• Operators: comparison, logical, pattern-matching (LIKE), range (BETWEEN), and modulo (%)
• Aggregate functions: COUNT, MAX, AVG, and more
• CAST function and SELECT TOP clause
• Set operators: UNION, UNION ALL, INTERSECT, EXCEPT
• Key differences: NOT IN vs EXCEPT
• Data handling: creating local variables, using wildcards, and comparing NULL values
• Sorting: ordering the result set by column name or position
Full course is available here: https://www.udemy.com/course/sql-prac...
Auf dieser Seite können Sie das Online-Video SQL Problems & Solutions + Practice Database mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer SQL Hands-On 25 November 2025 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 137,440 Mal angesehen und es wurde von 44 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
