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 & TSQL 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 Address
SQL School (Regd: SequelGate Innovative Technologies Pvt. Ltd.)
Plot No 108, Lane No: 2, Road No: 1
Diag Opp: Almas Hotel, Beside SR Nagar Bus Stop,
Sanjeev Reddy Nagar (SR Nagar), Hyderabad - 38, India.
India: 040 64577244 (Off) 9666440801 (Mobile)
USA: (510)400-4845
-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 Schemabin
