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 COURSE DETAILS FOR ONLINE TRAINING
SQL Server Design Architecture
SQL Server 2008 R2 - Installation
SQL Server 2012 – Installation
SQL Server Service Accounts and Configurations
TCP/IP and Named
Pipes Configurations
Authentication Modes
and Authorization Techniques
Collation and File
Stream Settings
SQL Server Database Design & Planning
SQL Database: FileGroups and Files
Log File Sizing and
Placement
SQL Server Table Design & Pages
INSERT, UPDATE and DELETE
SELECT and Inner Queries
DELETE versus
TRUNCATE
SELECT INTO and
INSERT..SELECT statements
Table Compression Techniques
Data Integrity & Consistency
SQL Server Views and Schemas
Schema Binding and Encryptions
JOINS and Sub Queries
Nested Queries and Linking Tables
Uses of Indexes and Performance
Stored Procedures
and User Defined Functions
DDL Triggers and DML Triggers
Cursors Usage and Limitations
Table Variables and Temporary Tables
SET Based Queries
Inner Queries and Nested Queries
T-SQL Transactions Concepts & Types
Locks and Memory Concepts & Locking Hints
Blocking Issues and Open Transactions
New Features in SQL Server 2012
*ALL OUR SESSIONS ARE COMPLETELY PRACTICAL*
Detailed Course Curriculum and Fee details available at http://sqlschool.com/T-SQL-Online-Training.html
SQL School
contact@sqlschool.com
Office: (+91) 040 64577244 (India) | Mobile: (+91)
09666440801 (India)
Office: (+1) 214 628 5666 (USA)
