The following is a list of available Advanced T-SQL Querying, Programming and Tuning for SQL Server 2008, 2012 & 2014 classes at ISInc. If you do not see the course you are interested in, please contact us. We can setup dedicated, online and onsite classes too! Minimum students required: 4, Maximum students: 15
The five day instructor-led course focuses on writing and tuning queries and programming with T-SQL in SQL Server 2008, 2012 and 2014. In this course you will learn the details and capabilities of T-SQL in the following areas: Logical Query Processing; Query Tuning (Internals and Index Tuning, including Columnstore Indexes, Temporary Tables, Sets vs. Cursors, Query Tuning with Query Revisions); Subqueries and Table Expressions (Derived Tables, CTEs, Views, Inline Table-Valued Functions), Recursive Queries, APPLY Operator, Joins and Set Operators; Aggregating, Pivoting and Windowing (including Ranking, Aggregate and Offset Window Functions); TOP and OFFSET-FETCH; Data Modification; Working with Date and Time; Programmable Objects (Dynamic SQL, User Defined Functions, Stored Procedures, Triggers, Transactions and Concurrency, Exception Handling); In-Memory OLTP.
Before attending this course, it is recommended that students have the following skills:
-At least one year of T-SQL querying and programming experience in SQL Server
$3950.00
Serving the business community since 1982, ISInc provides in depth, hands-on training on a wide variety of topics
2554 Millcreek Drive
Sacramento CA 95833
Tel: 800-877-1707
Email: [email protected]