SQL School is one of the best training institutes for SQL Server Developer Training, SQL DBA Training and MSBI Training. We have been providing Online and Classroom Trainings for the last SEVEN years. All our training sessions are COMPLETELY PRACTICAL.

SQL SERVER & T-SQL COURSE DETAILS - FOR ONLINE TRAINING:

SQL Server Design Architecture

SQL Server 2008 R2 - Installation

SQL Server 2012 - Installation

Service Accounts and Authentication

SQL Server Database Design & Planning

SQL Server Table Design & Pages

Table Compression Techniques

Data Integrity Concepts and Column Value Consistency

PRIMARY KEY, UNIQUE and IDENTITY Constraints

CHECK and DEFAULT Constraints

SQL Server Views and Schemabinding of Views

Updatable Vies adn ALTER consequences

Schema depedancy and Encryptions

JOINS, Sub Queries and Nested Queries

Nested and Linking Tables

Uses of Indexes and Performance

Query Execution Plans and QO Components

Stored Procedures and OUTPUT Parameters

Dynamic SQL and Usage

User Defined Functions, Table Return Values and Parameters

Table Valued Parameters and Variables

DDL Triggers and DML Triggers

Cursors Usage and Limitations

TEMP Tables and Table Variables

T-SQL Transactions Concepts & Types

Locks and Memory Concepts & Locking Hints

Blocking Issues and Open Transactions

New Features in SQL Server 2012

All Sessions are Completely Practical and Realtime.

Detailed Course Curriculum: http://sqlschool.com/TSQL-Online-Training.html

SQL School Training Institute

contact@sqlschool.com

Office: (+91) 040 64577244

Mobile: (+91) 0 9666440801

Flat No: 302, Sai Manor Complex, X Roads, SR Nagar, Hyderabad, India.

http://www.sqlschool.com