Monday, September 22, 2014

COMPLETE PRACTICAL TRAINING ON T-SQL AND SQL SERVER BASICS

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

No comments:

Post a Comment