Hands-On-Lab: Subqueries in SQL Server

Home/HOLs/Hands-On-Lab: Subqueries in SQL Server

Hands-On-Lab: Subqueries in SQL Server

Hello Friends,

Here is another popular lab from Hands-On-Lab library: Subqueries in SQL Server.

Transact-SQL (T-SQL) supports writing queries with in queries or nested inside a SELECT, INSERT, UPDATE and DELETE. This lab is divided into five exercises. In the first exercise we will look at self-contained scalar subquery, problems that it can solve and limitations associated with it. In the second exercise we will overcome the limitations of scalar subquery by using multivalued subquery. In the third exercise we will learn about correlated subqueries. Exercise four is for self-assessment where a problem will be given and we have to solve it using subquery. Finally, exercise 5 presents a T-SQL challenge that needs to be solved (T-SQL challenge is slightly tougher self-assessment).

Exercise 1: Self-Contained Scalar Subqueries
Exercise 2: Self-Contained Multivalued Subqueries
Exercise 3: Correlated Subqueries
Exercise 4: Self-Assessment
Exercise 5: T-SQL Challenge

SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.

Learn More
 

 

Happy Learning – The Practical Way.

Data Platform Virtual Summit 2020

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin.

SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter

By |2020-09-02T12:37:45+05:30July 29th, 2020|HOLs|0 Comments

About the Author:

Leave A Comment