Microsoft SQL Server 2008/2012/2016 Training Institute in Dehradun

Microsoft SQL Server Training

Get trained in SQL Server and gain the skills needed to become a SQL Server database administrator. SQL is widely used with ASP.NET, SharePoint and many more technologies. If you want to start your career in SQL then it is a good option for you.

Our SQL Server training program is designed to train IT professionals and developers how to implement and manage their database solutions, including how to migrate to live server & cloud server. We provide training to fresher & professional. Our training program covers all the capabilities of SQL Server that pertain to creating scalable, secure, and robust applications.

Course Outline

Introduction To DBMS

Introduction of SQL SERVER
Overview of File Management System And Its Drawbacks
Overview of Database Management System (DBMS) and Data Models
Overview of Entity – Relationship (E-R) Model

Setting up and Installing SQL Server

Availability and Scalability Features
Security Features
Data Management Features
Administration and Maintenance Features
Development Features
Installation of SQL Server
System Requirements
Query Editor

Introduction To TSQL

History and Features of TSQL
Types Of TSQL Commands
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
- Data Query Language (DQL)
- Data Control Language (DCL)
- Transaction Control Language (TCL)
- Database
  - Creating Database
  - Altering Database
  - Deleting Database
  - Constrains
    - Procedural Integrity Constraints
    - Declarative Integrity Constraints
      - Not Null, Unique, Default and Check constraints
      - Primary Key and Referential Integrity or foreign key constraints
      - Data Types In TSQL
      - Table
        
        Creating Table
        
        Altering Table
        
        Deleting Table

Data Manipulation Language

Insert
- Identity
- Creating A Table From Another Table
- Inserting Rows From One Table To Another
- Update
  - Computed Columns
  - Delete
    - Truncate
    - Differences Between Delete and Truncate

Data Query Language (DQL)

Select
Where clause
Order By Clause
Distinct Keyword
Isnull() function
Column aliases
Predicates
- Between … And
- In
- Like
- Is Null

Built In Functions

Scalar Functions
- Numeric Functions
- Character Functions
- Conversion Functions
- Date Functions
- Aggregate Functions
  - Convenient Aggregate Functions
  - Statistical Aggregate Functions
  - Group By and Having Clauses
  - Super Aggregates
  - Over(partition by …) Clause
  - Ranking Functions
    - Common Table Expressions (CTE)

Operators

Union
Intersect
Except

Joins

Inner Join
- Equi Join
- Natural Join
- Non-Equi Join
- Self Join
Outer Join
- Left Outer Join
- Right Outer Join
- Full Outer Join
- Cross Join

Sub Queries

Single Row Sub Queries
Multi Row Sub Queries
- Any or Some
- ALL
- Nested Sub Queries
- Co-Related Sub Queries
  - Exists and Not Exists

Indexes

Clustered Index
NonClustered Index
Create , Alter and Drop Indexes
Using Indexes

Security

Login Creation
- SQL Server Authenticated Login
- Windows Authenticated Login
- User Creation
- Granting Permissions
- Revoking Permissions
- Roles

Views

Purpose Of Views
Creating , Altering and Dropping Indexes
Simple and Complex Views
Encryption and Schema Binding Options in creating views

Transaction Management

Introduction
Begin Transaction
Commit Transaction
Rollback Transaction
Save Transaction
Role Of Log File In Transaction Management
Implicit Transactions

TSQL Programming

Drawbacks Of TSQL that leads to TSQL Programming
Introduction To TSQL Programming
Control statements In TSQL Programming
- Conditional Control Statements
  - If
  - Case
Looping Control Statements
- While

Cursors

Working With Cursors
Types Of Cursors
- Forward_Only and Scroll Cursors
- Static, Dynamic and Keyset Cursors
- Local and Global Cursors

Working With XML Data Type

Working With XML Data Type

Backup and Restore Of Database

How to Create Database Scripts
How to take backup of any database
Restore database from backup file

Attach and Detach of Database

Attach database file to current SQL Server
Detach database from current SQL Server

Normalization

Normalization of database

Microsoft SQL Server

Microsoft SQL Server Training

Course Outline

Microsoft .Net Training

Core Skills & Expertise

Programming

Course Registration

About Us