Microsoft SQL SERVER TRAINING IN NOIDA

Basics

• Database
• DBMS
• RDBMS

SQL Server Environment

• SQL Server 2005 and 2008, 2012

Membership, Authorization And Security

• DDL
• DML (INSERT, UPDATE, DELETE, MERGE)
• TCL
• DDL
• DCL

Data Integrity

• Domain Integrity
• Entity Integrity
• Referential Integrity

Joins and Sub Queries

• SQL Operators
  • Relational Operators
    • Basic Relational operators
    • Advanced Relational operators
• 3. Logical operators
• Simple Queries
• Built in Functions
  • Character Functions
  • Number Functions
  • Date Functions
• Joins
• Sub-Queries
• Advanced Queries

Views

• Create View
• Advantage of Views
• Updatable Views
• Non Updatable Views
• Indexed View

Introduction to T-SQL

• Anonymous Block
• Stored Block

Anonymous block(including 2008 features)

Structured Exception Handling

Cursors

• Declaring Cursors
• Modifications Through Cursors
• Types of Cursors
• Advantages of Cursors

Stored block/Stored Procedures

• System Stored Procedure
• User Stored Procedures
• Advantages of Procedures
• Passing In/Out Parameters
• Altering Procedure
• Extended Stored Procedures

User Defined Functions

• Scalar UDF
• Inline UDF
• Multi Statement Table UDF
• Table Variables, Temporary Tables

Triggers

• DML Triggers (After | Instead of )
• DDL Triggers
• Advantages of Triggers

Transactions and Locks

• Implicit Transactions
• Explicit Transactions
• TCL Commands
• Lock Types
• Isolation Levels
• Dead Locks
• MS-DTC

Indexes

• Clustered Index
• Non Clustered Index
• Creating Index
• Advantages of Indexes

Security

• Windows Authentication
• SQL Server Authentication
• Creating Login
• Database Permissions
• Introduction to Roles, Schema
• Droping Login

Data Transformation Services

• BCP
• Data Transformation Services Packages / Sql
• Server Integration Services Packages

Features of 2012

• Column store indexes
• Sequence objects
• Pagination
• Error handling