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...
In questa pagina del sito puoi guardare il video online SQL Problems & Solutions + Practice Database della durata di ore minuti seconda in buona qualità , che l'utente ha caricato SQL Hands-On 25 novembre 2025, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 137,440 volte e gli è piaciuto 44 spettatori. Buona visione!
