Microsoft SQL Server 2016 First Look: Preview


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description
The landscape for database management systems is changing radically. Big data, Hadoop, and NoSQL are becoming key technologies in the sector, and the rise of cloud computing, with all the benefits of off-siting your data, seems inexorable. SQL Server 2016 is Microsoft's answer to these technologies for SQL databases. This course covers new and updated features targeted at big-data and cloud interoperability, and other changes to Microsoft's relational database. This course is based on preview software, and interfaces and features discussed are subject to change.

Target Audience
Developers and users of Microsoft SQL Server looking to get an early first look at SQL Server 2016, and business decision makers evaluating SQL Server 2016

Prerequisites
None

Expected Duration (hours)
1.5

Lesson Objectives

Microsoft SQL Server 2016 First Look: Preview

  • |INS start the course |/INS
  • install the second community technical preview of SQL Server 2016
  • navigate the interface of SQL Server 2016
  • use the new SQL Server 2016 Query Store
  • enforce row level security in SQL Server 2016
  • use the new Temporal Tables feature in SQL Server 2016
  • use the Always Encrypted feature of SQL Server 2016
  • use the updated in-memory OLTP for SQL Server 2016
  • use Stretch Database to extend your SQL Server 2016 database to Azure SQL Database
  • use native JSON in SQL Server 2016 databases
  • describe real-time operational analytics in SQL Server 2016
  • describe how to use PolyBase to access data stored in Hadoop or Azure Blob Storage from SQL Server 2016
  • describe the enhanced AlwaysOn high availability process in SQL Server 2016
  • describe how to connect SQL Server 2016 and Azure SQL Data Warehouse

    • Course Number:
    df_sqfl_a01_it_enus

    Expertise Level
    Intermediate