دوره T-SQL

1 – Introduction to Language T-SQL

Getting Started with SELECT

Working With Set Statistics Time ON

Working With Set Statistics IO ON

Check the Logical Order process

Check the Physical Order process

Checkthe Component of the Select Command

Working With INTO

2 – Grouping concepts

Review the concept of the group by

Introduction to all kinds of Aggregation Function

Introduction to Having

Introduction to CUBE & Rollup

3- Ranking & Window Function

Introduction to all kinds of Ranking

Working by OVER

Introduction to Partition Function

Introduction to Window Function

4 – Concepts Join

Working With of Join

Introduction to Inner Join

Introduction to Left OUTER Join

Introduction to Right OUTER Join

Introduction to Cross Join

Introduction to Full OUTER JOIN

5 – Concepts Sub Query

Introduction Sub Query

Working with Kind of Sub Query

Use Exists in Sub Query

6 – Concepts Set Operation

Working with Set Operation

Introduction with Union

Introduction with Union ALL

Introduction with Intersect

Advanced Select Techniques

7 – Concepts DML (Data Manipulation Language)

Working with Insert Command

Working With Kind of

Working with Delete Command

Working with TRUNCATE Command

Working with Update Command

Introduction Merge

8 – Concepts DDL (Data Definition Language)

Working with Create Command

Working with Alter Command

Working with Drop Command

9 – Concepts DCL (Data Control Language)

Working with Grant Command

Working with with Grant Command

Working with Deny Command

10 – Concepts CONCURRENCY & Transaction

Introduction Transaction

Introduction to ASID

Introduction to Locking & Blocking

Introduction to Deadlock

11 – Customizable objects

Working with Table

Working with King of Data Type

Working with View

Introduction to Tabular Variables

Introduction to Stored Procedures

Introduction to Functions

Introduction to Triggers

Introduction to DMV

Introduction with DMF

Objects and Dependencies

12 – Working with tools and auxiliary tools on SQL Server

Working with tools ApexSQL

Working with tools REDGATE

13 – Performance Tips for SQL Queries

Working With Execution Plan

How can SQL Server improve SQL query performance?

How do you optimize SQL queries?

What is SQL performance tuning?

How do I tune a SQL query?

How can SQL Server improve SQL query performance?

14 – Backup AND Restore

Working With Backup Full Database

Working With Backup Differential Database

Working With Backup Log Database

Working With Restore Full Database

Working With Restore Differential Database

Working With Restore Log Database