Beginning T-SQL for SQL Server Developer, Data Analyst & DBA

This course starts from the beginning , no prior knowledge is needed and it is step By step Practical Training on Programming Transact SQL Query from basics on Microsoft SQL Server Database Engine

This course is must for all the Aspirants who want to become Microsoft SQL Server Database Developers , Microsoft Database Administrator, Web Developers such as .NET Developers,Database ANALYSTS , Report Developers such as SSRS or ETL Developers such as SSIS etc

Following are the course contents which are covered in this course T-SQL Online SQL Server Video Step By Step Training

Introduction

What is a Relational Database

What is Relational Database Management System

SSMS and SQL Server Database Engine

SQL Server and SSMS Installation

Basic T-SQL

Creating DB Tables & Inserting Data into the tables

Primary Key and Foreign Key

Basic Select Commands

Aggregate Functions with SELECT Command

Group By Clause using Single and Multiple Columns

Difference Between WHERE and HAVING Clause

Syntax of SELECT Command

T-SQL Joins to query SQL Server

Inner Join

T-SQL with Inner Join and Group By Together

Left Join

Right Join

Full Join

Cross Join

Self-Join

Union Operation

Union All Operation

Intersect Operation

Except Operation

Working with Schema

What is Schema and its Importance

Schema Creation & Transfer and Viewing the objects inside Schema using T-SQL

Subqueries

Getting Started with first Subquery Example

Common Interview Question on Subquery

Joins Group by Derived table Subquery combined TSQL

Subquery as a Column

Subquery using NOT Exists

ALL ANY SOME Keywords in Subquery

Correlated Subquery

Not Exists Keyword Scenario of Correlated Subquery to speed up query performance

Datatypes

Datatype Conversion

Implicit & Explicit Conversion (Type Casting)

DML Operations and Constraints

Many Different Options while performing insert update and delete operations

Primary Key, Foreign Key, Unique, Not NULL, Default, Check Constraints

Joining more than two tables

Joining three tables

Joining four Tables

One more example in joining four tables

Working with CASE Statements and Inbuilt Functions

Performing Select and Update operation using case statement

WHILE Loop

Inbuilt Functions - EOMONTH, IIF, CHOOSE, DatePart, String Functions etc.