SQL School is one of the best training institutes for Microsoft SQL Server Developer Training, SQL DBA Training, MSBI Training, Power BI Training, Azure Training, Data Science Training, Python Training, Hadoop Training, Tableau Training, Machine Learning Training, Oracle PL SQL Training. We have been providing Classroom Training, Live-Online Training, On Demand Video Training and Corporate trainings.
All our training sessions are COMPLETELY PRACTICAL.
SQL SERVER & T-SQL COURSE DETAILS - FOR VIDEO TRAINING:
SQL Server Design Architecture
SQL Server 2016 - Installation
SQL Server 2017 - 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 2017
All Sessions are Completely Practical and Realtime.
For free SQL Server Video Demo, please visit :
http://www.sqlschool.com/TSQL-Video-Training.html
Schedules for PRACTICAL SQL 2016 & 2017 Video TRAINING :
http://sqlschool.com/register.html
Contact us today (24 x 7) for SQL Server Practical Video Training
SQL School Training Institute
ISO 9001:2008 Certified Organization for Training
Authorized Microsoft Partner (ID# 5108842)
India:
Mobile: +91 (0) 9666 44 0801
Mobile: +91 (0) 9666 64 0801
USA:
Office: +1 (510) 400-4845
Office 1:
#101, UMA Residency, Opp: Sindhu Travels, Beside Metro Station Gate #D, SR Nagar, Hyderabad - 38, India.
Website:
http://sqlschool.com/
Follow us:
https://www.facebook.com/sequelschool
https://www.linkedin.com/company/sql-school
https://twitter.com/sequelschool