-
MODULES
11-
Introduction to Microsoft SQL Server 2016 30 minLecture1.1
-
Introduction to T-SQL Querying 30 minLecture1.2
-
Writing SELECT Queries 30 minLecture1.3
-
Querying Multiple Tables 30 minLecture1.4
-
Sorting and Filtering Data 30 minLecture1.5
-
Working with SQL Server 2016 Data Types 30 minLecture1.6
-
Using DML to Modify Data 30 minLecture1.7
-
Using Built-In Functions 30 minLecture1.8
-
Grouping and Aggregating Data 30 minLecture1.9
-
Using Subqueries 30 minLecture1.10
-
Using Set Operators 30 minLecture1.11
-
Using Subqueries
This module will introduce the use of subqueries in various parts of a SELECT statement. It will include the use of scalar and multi-result subqueries, and the use of the IN and EXISTS operators.
Lessons
- Writing Self-Contained Subqueries
- Writing Correlated Subqueries
- Using the EXISTS Predicate with Subqueries
Lab : Using Subqueries
After completing this module, you will be able to:
- Describe the uses of queries which are nested within other queries.
- Write self-contained subqueries which return scalar or multi-valued results.
- Write correlated subqueries which return scalar or multi-valued results.
- Use the EXISTS predicate to efficiently check for the existence of rows in a subquery.