Exploring SQL Server 2016: Fundamentals

About this course:

The Exploring SQL Server 2016: Fundamentals course helps the experienced database professionals to update their SQL Server skills to the new features introduced in the SQL Server 2016. The new features covered in this course are for performance, security, availability, scalability, reporting and data access. This course also covers the introduction to Transact-SQL (T-SQL) which a key new feature of SQL Server 2016.

This SQL Server 2016 course introduces the students to the latest SQL Server 2016’s new capabilities and feature set. The students are also introduced to T-SQL and the enhancements in manageability, memory tables and column store indexes. The course is very helpful for the students planning to undertake the SQL Server 2016 certification exam.

The average salary for a SQL Developer is $71,844 per year.

Course Objective:

• Key capabilities and components of SQL Server 2016
• New and enhanced security, performance, availability and data access features of SQL Server 2016
• New and enhanced features in SQL Server 2016 OLAP
• New SQL Server 2016 cloud functionality
• Key capabilities and components of SQL Server 2016
• T-SQL, sets, and predicate logic

Audience:

• Database professionals with experience in SQL Server 2014 who want to update their skills to SQL Server 2016
• Certified MCSA: SQL Server professionals who want to prepare for the SQL Server 2016 certification

Prerequisite:

• The course is designed for experienced professionals having technical knowledge of building and managing databases, data warehouses and business intelligence solution with SQL Server 2014.
• In addition to this, operational knowledge and familiarity with Microsoft Windows Server 2012 R2 or later is required to grasp the concepts covered in this course.