SQL Practical Exercises: Hands-On Learning

Turn theoretical SQL knowledge into practical skills through hands-on practice and detailed explanations.

What you'll learn
- Gain hands-on experience using a practice database, reinforced by numerous examples and exercises that turn theoretical SQL knowledge into practical skills
- Connect task descriptions to the appropriate database tables, and interpret how those tables are related to each other
- Use single-row, multiple-row, compounding, pattern-matching, and range operators with single- and multiple-row subqueries
- Apply the SELECT TOP clause together with the ORDER BY clause to retrieve a limited number of rows
- Use UNION, UNION ALL, INTERSECT, and EXCEPT set operators to combine the results of SELECT statements from the same or different tables
- Apply the modulo arithmetic operator and wildcards in SQL queries
- Use aggregate functions to summarize and analyze data
- Work with the DISTINCT keyword to remove duplicate values in the result set
- Use the CAST function to convert data types, and utilize the SUBSTRING function to retrieve specific portions of text values
- Create and use Common Table Expressions (CTEs) and local variables to simplify complex queries

Requirements
- No prior SQL or programming experience is required—only basic theoretical knowledge
- A guided, step-by-step installation of SQL Server and SQL Server Management Studio (SSMS), as well as the practice database setup, is provided
- Learners only need a computer running Windows and an interest in learning how databases and queries work

Description
This course contains the use of artificial intelligence.

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 inSQL ServerusingSQL 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.

Who this course is for:
- This course is designed for new or intermediate developers who have theoretical SQL knowledge but struggle with writing queries
- It’s ideal for those who want to strengthen their understanding of how to translate a task into a working query, use table relationships to identify and retrieve the data they need, and build efficient data flows to achieve the desired results
- The course focuses on building and improving SQL problem-solving skills in SQL Server or other relational databases
More Info