• SQL Server
Training Course

Exploring SQL Server 2016: Intermediate

Browse All Courses > Databases

Have a question while you're learning?

Get in-depth explanations, tips, further insights, and more from Certified Experts. Our experts are vetted industry professionals eager to help you learn from their experiences.

Course Syllabus(40 Lessons)

Exploring SQL Server 2016: Intermediate - Module 01 - Security and Availability
Topic A: Row Level Security - Part 1
3 lessons16m 52s
Topic B: Always Encrypted - Part 1
3 lessons14m 44s
Topic C: Data Masking - Part 1
3 lessons14m 55s
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

Course Description

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.

Course Details

5h 10m 18s


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

Share Course

  • LinkedIn

Ready to get started?