• SQL Server
Training Course

Exploring SQL Server 2016: Fundamentals

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(34 Lessons)

Exploring SQL Server 2016: Fundamentals - Module 01 - Introduction to SQL Server 2016
Topic A: Introduction - Part 1
3 lessons34m 40s
Topic B: Installation - Part 1
3 lessons30m 06s
Topic C: Management Studio - Part 1
3 lessons26m 01s
Topic D: SSDT - Part 1
4 lessons20m 13s
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

Course Description

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.

Course Details

4h 54m 11s


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?