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

The Exploring SQL Server 2016: Intermediate course is the second course in the two course series on Microsoft SQL Server 2016. The course builds on the topics covered in the Exploring SQL Server 2016: Fundamentals course and explores the topics of SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS). The course also touches the security and encryption aspect in SQL Server programming. This SQL Server 2016: Intermediate course covers the more advanced topics of integration, analysis and reporting related to the SQL Server 2016. It also explores the advanced integration in R language, security and encryption features in MS SQL Server 2016. The course when combined with the SQL Server 2016: Fundamentals course is a comprehensive package to master Microsoft SQL Server 2016 and pass any certification exam related to it. Show and hide more

1. Chapter 01 - Security and Availability
   • Topic A: Row Level Security - Part 1 00:00:34
   • Row Level Security - Part 2 00:15:36
   • Row Level Security - Part 3 00:00:41
   • Topic B: Always Encrypted - Part 1 00:00:34
   • Always Encrypted - Part 2 00:13:46
   • Always Encrypted - Part 3 00:00:24
   • Topic C: Data Masking - Part 1 00:00:32
   • Data Masking - Part 2 00:13:53
   • Data Masking - Part 3 00:00:30
   • Topic D: Clusters and Replication - Part 1 00:00:39
   • Clusters and Replication - Part 2 00:14:48
   • Clusters and Replication - Part 3 00:00:39
   • Topic E: Stretch Database - Part 1 00:00:43
   • Stretch Database - Part 2A 00:05:43
   • Stretch Database - Part 2B 00:10:22
   • Stretch Database - Part 2C 00:10:50
   • Stretch Database - Part 3 00:00:46
2. Chapter 02 - SSIS
   • Topic A: SSIS - Part 1 00:00:43
   • SSIS - Part 2A 00:08:28
   • SSIS - Part 2B 00:08:50
   • SSIS - Part 2C 00:09:22
   • SSIS - Part 3 00:00:42
   • Topic B: SSIS Continued - Part 1 00:00:27
   • SSIS Continued - Part 2A 00:07:22
   • SSIS Continued - Part 2B 00:06:54
   • SSIS Continued - Part 2C 00:05:26
   • SSIS Continued - Part 2D 00:09:21
   • SSIS Continued - Part 3 00:00:26
3. Chapter 03 - SSAS and SSRS
   • Topic A: SSAS - Part 1 00:00:30
   • SSAS - Part 2A 00:07:44
   • SSAS - Part 2B 00:11:58
   • SSAS - Part 2C 00:12:27
   • SSAS - Part 3 00:00:29
   • Topic B: SSAS Continued - Part 1 00:00:30
   • SSAS Continued - Part 2 00:20:18
   • SSAS Continued - Part 3 00:00:37
   • Topic C: SSRS - Part 1 00:00:28
   • SSRS - Part 2A 00:05:49
   • SSRS - Part 2B 00:07:14
   • SSRS - Part 2C 00:10:23
   • SSRS - Part 2D 00:10:21
   • SSRS - Part 2E 00:10:34
   • SSRS - Part 3 00:00:37
4. Chapter 04 - Advanced Integration
   • Topic A: R Language - Part 1 00:00:22
   • R Language - Part 2A 00:06:56
   • R Language - Part 2B 00:07:05
   • R Language - Part 2C 00:06:42
   • R Language - Part 2D 00:06:16
   • R Language - Part 3 00:00:42
   • Topic B: Master Data Services - Part 1 00:00:31
   • Master Data Services - Part 2A 00:10:26
   • Master Data Services - Part 2B 00:10:40
   • Master Data Services - Part 2C 00:11:00
   • Master Data Services - Part 3 00:00:38
Show and hide more