پیش نیازها:
- تقبلاً باید با SELECT ، GROUP BY و ORDER BY آشنا باشید
- دسترسی به رایانه شخصی که ویندوز 7 ، 8 یا 10 دارد
این دوره برای چه کسی است؟
- نویسندگان Query ها در SQL و هر کسی که درباره Subqueries کنجکاو است
- اگر در حال نوشتن Subqueries هستید و یا در مورد Subquery های همبسته دچار مشکل شده اید ، این دوره برای شما مناسب است!

در ادامه با برخی از سرفصل های درسی این مجموعه آموزش آشنا می شویم :
Course content
Expand all 20 lectures
Introduction
Welcome to Subquery Magic
What is a Subquery?
Setup your own Learning Lab
Download SQL Server
Install SQL Server
Download and Install SQL Server Management Studio
Download Sample Database Backups
Restore Sample Database
Writing your First Subquery
Place a subquery in the column list
Incorporate Subqueries into Expressions
Review subquery concepts
5 questions
Create Correlated Subqueries
Demystify Correlated Subqueries
Write a Correlated Subquery with Two Tables
Do you have any questions?
Correlated subqueries versus Inner Joins, which is better?
Get some Correlated Subquery Reinforcement
6 questions
Create Subqueries in the WHERE and HAVING Clauses
Get Existential with Exists
Are you in? Use the IN Condition to Test for Membership
Write subqueries in the HAVING clause
Get fancy and write a correlated subquery in the HAVING clause
Review Subqueries in the Where and Having Clause
5 questions
Write Queries using Derived Tables
What is a Derived Table?
Joining Derived Tables
Review Derived Tables
3 questions
Bonus Lecture: Additional Resources and Course Coupons?