Call 0203 995 1156

ELSSR1: Exploring SQL Server
2016, Vol 1 –
eLearning Course

ELSSR1: Exploring SQL Server
2016, Vol 1 –
eLearning Course

£29.99 ex VAT



90 Days Access

Course Description :

Begin your exploration of SQL Server 2016 with an overview of what’s new and what’s been updated. Following an installation example, discover the changes in R services and configuring tempdb, then take a close-up look at the various ways SQL Server Management Studio has been updated. Gain an understanding of the enhancements that have been made to ETL packages, integration services, and reporting services for something like mobile reporting and analytical databases for cubes and tabular models, then take a peek at enhancements in TSQL, temp tables, CHECKDB, and the online altering of tables and store procedures and functions. Enhancements in performance are an important reason to upgrade to SQL Server 2016. Learn about changes in manageability features and execution, as well as query plans with live query statistics before taking a look at Powershell and integration with automation, and discovering 3 new groups of command. Continue your exploration with a focus on in-memory table improvements, columns store index changes, and the new temporal tables, then learn about some additional improvements including enhancements of optimizer, cloud first development, and testing in the cloud.

Course Outline :

  1. Introduction
  2. Installation
  3. Management Studio
  4. SSDT
  5. T-SQL Enhancements
  6. Manageability Enhancements
  7. More Manageability Enhancements
  8. In Memory Tables And Stored Procedures
  9. Column Store Indexes
  10. Other New Features


Target Audience :

Developers and IT Professionals