Exploring SQL Server 2016: Fundamentals

Category
Databases
Level
Beginner
Lessons
34
Duration
4h 54m 08s
Last Updated: 2018-10-17
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.
Category
Databases
Level
Beginner
Lessons
34
Duration
4h 54m 08s
Exploring SQL Server 2016: Fundamentals - Module 01 - Introduction to SQL Server 2016
Topic A: Introduction - Part 1
3 lessons34m 40sCompleted 0 / 3
Topic B: Installation - Part 1
3 lessons30m 05sCompleted 0 / 3
Topic C: Management Studio - Part 1
3 lessons25m 59sCompleted 0 / 3
Topic D: SSDT - Part 1
4 lessons20m 11sCompleted 0 / 4
Exploring SQL Server 2016: Fundamentals - Module 02 - T-SQL and Manageability Enhancements
Exploring SQL Server 2016: Fundamentals - Module 03 - More Enhancements and In Memory Tables
Exploring SQL Server 2016: Fundamentals - Module 04 - Column Store Indexes
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