by Integrity Training | Released March 2019 | ISBN: 300000006A0165

The Exploring SQL Server 2016: Fundamentals course helps the experienced database professionals to update their SQL Server skills to the new features introduced in the SQL Server 2016. The new features covered in this course are for performance, security, availability, scalability, reporting and data access. This course also covers the introduction to Transact-SQL (T-SQL) which a key new feature of SQL Server 2016. This SQL Server 2016 course introduces the students to the latest SQL Server 2016’s new capabilities and feature set. The students are also introduced to T-SQL and the enhancements in manageability, memory tables and column store indexes. The course is very helpful for the students planning to undertake the SQL Server 2016 certification exam. Show and hide more

1. Chapter 01 - Introduction to SQL Server 2016
   • Topic A: Introduction - Part 1 00:00:59
   • Introduction - Part 2A 00:05:59
   • Introduction - Part 2B 00:05:45
   • Introduction - Part 2C 00:08:36
   • Introduction - Part 2D 00:07:36
   • Introduction - Part 2E 00:05:00
   • Introduction - Part 3 00:00:45
   • Topic B: Installation - Part 1 00:01:05
   • Installation - Part 2A 00:05:38
   • Installation - Part 2B 00:06:23
   • Installation - Part 2C 00:06:25
   • Installation - Part 2D 00:10:00
   • Installation - Part 3 00:00:35
   • Topic C: Management Studio - Part 1 00:01:33
   • Management Studio - Part 2 00:01:13
   • Topic D: SSDT - Part 1 00:01:36
   • SSDT - Part 2 00:17:34
   • SSDT - Part 3 00:01:03
2. Chapter 02 - T-SQL and Manageability Enhancements
   • Topic A: T-SQL Enhancements - Part 1 00:01:16
   • T-SQL Enhancements - Part 2A 00:06:51
   • T-SQL Enhancements - Part 2B 00:05:59
   • T-SQL Enhancements - Part 2C 00:06:49
   • T-SQL Enhancements - Part 2D 00:07:46
   • T-SQL Enhancements - Part 3 00:00:41
   • Topic B: Manageability Enhancements - Part 1 00:01:08
   • Manageability Enhancements - Part 2A 00:09:31
   • Manageability Enhancements - Part 2B 00:10:25
   • Manageability Enhancements - Part 2C 00:11:06
   • Manageability Enhancements - Part 3 00:01:06
3. Chapter 03 - More Enhancements and In Memory Tables
   • Topic A: More Manageability Enhancements - Part 1 00:01:09
   • More Manageability Enhancements - Part 2A 00:07:16
   • More Manageability Enhancements - Part 2B 00:06:54
   • More Manageability Enhancements - Part 2C 00:09:08
   • More Manageability Enhancements - Part 3 00:01:09
   • Topic B: In Memory Tables and Stored Procedures - Part 1 00:01:00
   • In Memory Tables and Stored Procedures - Part 2 00:01:55
4. Chapter 04 - Column Store Indexes
   • Topic A: Column Store Indexes - Part 1 00:01:11
   • Column Store Indexes - Part 2A 00:05:40
   • Column Store Indexes - Part 2B 00:10:52
   • Column Store Indexes - Part 2C 00:07:32
   • Column Store Indexes - Part 2D 00:07:14
   • Column Store Indexes - Part 3 00:00:45
   • Topic B: Other New Features - Part 1 00:01:26
   • Other New Features - Part 2 00:18:59
   • Other New Features - Part 3 00:01:04
Show and hide more