The SQL Practical Exercises course gives learners hands-on experience solving SQL problems using a practice database. The course provides 35 fully explained examples and exercises with a total duration of eight and a half hours. Each exercise is performed in SQL Server using SQL Server Management Studio (SSMS), allowing learners to follow along and practice on their own computers. This course bridges the gap between theory and practice, helping learners transform their theoretical SQL knowledge into real-world skills. It also benefits those working with other relational databases, such as Oracle or MySQL, by explaining SQL concepts and query logic that apply across systems.
Throughout the course, you will:
- Understand how task descriptions map to database tables
- Learn how tables are related and how to use these relationships in queries
- Explore query flow, including how results move from subqueries to their parent queries
- Write single- and multiple-row subqueries, and use them in the appropriate clauses of their parent queries
- Practice applying comparison, multiple-row, compounding, pattern-matching, and range operators when working with subqueries and parent queries
- Filter table rows using constant values and the result sets of subqueries
- Use aggregate functions to summarize and analyze data
- Work with the DISTINCT keyword, use CAST and SUBSTRING functions, and apply the SELECT TOP clause
- Use the UNION, UNION ALL, INTERSECT, and EXCEPT set operators to generate a single result set from multiple SELECT statements
- Create and apply Common Table Expressions (CTEs) and local variables to simplify query complexity
- Gain confidence in writing complete, efficient, and logically structured SQL queries
Each topic is reinforced through real-world examples, practical exercises, and explanations of query building blocks, showing how data flows between different parts of a query. By the end of the course, learners will have both the confidence and the practical skills to write complex queries and understand how SQL works behind the scenes.
