SQL Server Training Course

INTRODUCTION

What is SQL Server?

Architecture of SQL Server

SQL Server Editions

Installing SQL Server

Sql Server Instances

Internal of SQL Server Database

MDF & LDF Files

Basic of Database Design

Normalization

Denormalization

Introduction to SQL Sever Management Studio

Creating Database

Data Types

Designing Table Model

Creating Tables

Alteration of Table Design

Drop Table

WRITING QUERIES

Insert queries

UPDATE queries

DELETE queries

TRUNCATE

The SELECT Clause

The FROM Clause

The WHERE Clause

Mathematical Operator

Conditional Operators

AND , OR Operators

Like Operators

The ORDER BY Clause

Aggregate Functions

String Functions

Date Functions

Using GROUP BY and HAVING

Using TOP N and TOP N PERCENT

Constraint in SQL SERVER

What is Constraint

Adding constraints to columns in Tables

Primary Key Constraints

Unique Constraints

Check Constraints

Default

Alter Constraints

Drop Constraints

Relational Database

Introduction to RDBMS

Why Relational Model

Advantages of Relational Model

Master Table & Child Tables

Introduction to Foreign Key

Creating Relations between tables

JOINS IN SQL SERVER

Introduction to Joins

Types of Joins

Inner Join

Left Outer Join

Right Outer Join

Full Outer Join

Self-Join

Writing Joins queries

APPLYING CLAUSES USING JOINS

Advanced SQL QUERIES

OFFSET & FETCH

SELECT INTO queries

SUB-QUERIES

UNION

INTERSECT

EXCEPT

ROW_NUMBER

RANK

CUBE & ROLLUP

T-SQL

What is T-SQL?

Syntax Conventions

Executing SQL Statements

Identifiers

Operators

Variables

Using T-SQL to Build and Alter Objects

If – else statements

Case statements

Looping statements

Identity statements

Stored Procedures, Functions

Introduction to Stored Procedures

Writing Stored Procedures

Alteration of Processing

Using/Calling Procedures

Using Input & Output Parameters

Advantage of Stored Procedures

Introduction to Functions

Writing Functions

Types of functions

Scalar Functions

Table Value Functions

Comparison between Stored Procedures & Functions

Triggers

Introduction to Triggers

Creating DML Triggers

Altering DML Triggers

Types of Trigger

Instead of Triggers

After Triggers

Using the Inserted and Deleted Tables

Auditing Data using Triggers

Types of Tables in SQL SERVER

Temp Tables

Local Temp Table

Global Temp Table

CTE

Table Variables

Comparison between Temp Tables, CTE & Table Variables

Views

Introduction to Views

Creating Views

Alteration of Views

Types of Views

Indexes

Introduction to Indexes

Types of Indexes

Creating Indexes

Best Practices of Indexes Creation

Cursors

Introduction to Cursors

Types of Cursors

Creating Cursors

Advanced SQL-SERVER

Temporary Tables

Table Variables

Error Handling

Transactions

Authentication Modes in SQL SERVER

Creating Users

Backup

Types of Backups

Restore

Shrinking

Email configuration in SQL SERVER.

Creating Operators

Automating Tasks using Jobs

Fragmentation

Query Optimization Techniques

Execution Plan of SQL SERVER

Query Lifecycle

Execution Lifecycle of a query