Exploring SQL Server 2016: Intermediate

Category
Databases
Level
Beginner
Lessons
40
Duration
5h 10m 06s
Last Updated: 2018-12-15
Microsoft SQL Server is a relational database-management system that stores and retrieves data when requested by other software applications. If you are in need of a more introductory course to the program, please refer to our other course, Exploring SQL Server 2016: Fundamentals.

We will begin this course by discussing security and availability, including the use of row-level security, encryption, data masking, clusters and replication, and stretch database.

Next, we will cover SQL Server Integration Services (SSIS), which is a platform for data integration and workflow applications. We’ll look at the online analytical processing and data-mining tool, SQL Server Analysis Services (SSAS), and the server-based report generating software system, SQL Server Reporting Services (SSRS).

Lastly, we will explain advanced integration by highlighting R Language and master data services.
Category
Databases
Level
Beginner
Lessons
40
Duration
5h 10m 06s
Exploring SQL Server 2016: Intermediate - Module 01 - Security and Availability
Topic A: Row Level Security - Part 1
3 lessons16m 51sCompleted 0 / 3
Topic B: Always Encrypted - Part 1
3 lessons14m 43sCompleted 0 / 3
Topic C: Data Masking - Part 1
3 lessons14m 53sCompleted 0 / 3
Exploring SQL Server 2016: Intermediate - Module 02 - SSIS
Exploring SQL Server 2016: Intermediate - Module 03 - SSAS and SSRS
Exploring SQL Server 2016: Intermediate - Module 04 - Advanced Integration
Thomas LeBlanc
I started using Microsoft SQL Server with a Laboratory Information System in version 6.5. The Analysis Service (also called SSAS) option in version 7 made me excited about Data Warehousing, but before I used a production version of SSAS, I became a Database Administrator for versions 6.5 through 2005 while working at a paper mill and home health agency. After writing reports as an application developer for 10 years, I rediscovered Online Analytical Processing (OLAP) implemented into Data Warehouses. Since 2009, I’ve been a speaker in the SQL Server community and a voice for Microsoft Business Intelligence (MSBI) for enterprises. The transition from Senior DBA to a Business Intelligence Architect has been great and made for a solid career path. My certifications include MCP, MCDBA and MCITP in Database Administration and Business Intelligence.
Thomas LeBlancInstructor and Curriculum Developer
Other Courses by Thomas LeBlanc