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 Video 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
System Views and Metadata Access
Schema Binding and Encryptions
JOINS and Sub Queries
Nested Queries and Linking Tables
Uses of Indexes and Performance
Stored Procedures and Debugging
User Defined Functions and System 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)
