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.
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.