Microsoft SQL Server is a relational database-management system that stores and retrieves data when requested by other software applications.
This course will explore SQL Server 2016 and the fundamentals to help you understand the program. We will begin with an introduction to the program, its installation process, its management studio, and the SQL Server Data Tools (SSDT).
We will then dive into T-SQL and manageability enhancements that were introduced with the 2016 program. Here, we will also explain memory tables and stored procedures that are essential to understanding the system.
Lastly, we will discuss the column store indexes and other new features that Microsoft added with the update.
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.