دانلود Udemy Sub Query Magic - Write T-SQL Subqueries Using SQL Server

پیش نیازها:

• تقبلاً باید با 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?