enosis learning
Creating Software Professionals

SQL SERVER COURSE CONTENTS

SQL-SERVER-Training-Course-Content

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
Restore
Email configuration in SQL SERVER.
Creating Operators
Automating Tasks using Jobs

Need More Details ? Fill The Enquiry Form

Interview Questions