Updating Your Skills to SQL Server 2016

מק"ט: #10986 | משך קורס: 24 שעות אק'
| מספר מפגשים: 3

This three-day instructor-led course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016.

לפרטים נוספים, מלא את פרטיך או התקשר 03-7100673
*שדות חובה

מטרות

  • Describe key capabilities and components of SQL Server 2016
  • Describe new and enhanced features in SQL Server performance
  • Describes new and enhanced features in SQL Server security
  • Describe what’s new in SQL Server Availability and Scalability
  • Describe new and enhanced features in reporting and PowerBI in SQL Server 2016
  • Describe new and enhanced data access features
  • Describe new and enhanced features in SQL Server OLAP
  • Describe new SQL Server cloud functionality

קהל יעד

  • The primary audience for this course are existing database professionals with experience of SQL Server 2014 who want to update their skills to SQL Server 2016.
  • Additional this course is for existing SQL Server 2014 MCSAs who want to prepare for the Upgrade exam for SQL Server 2016 certification.

תנאי קדם

  • Experience of building and managing database, data warehouse, and business intelligence (BI) solutions with SQL Server 2014.
  • Familiarity with the Windows Server 2012 R2 operating system and networking.
  • Familiarity with Microsoft Excel and Microsoft SharePoint Server 2013.

נושאים

Module 1: Introduction to SQL Server 2016
Describe key capabilities and components of SQL Server 2016

  • Overview of SQL Server 2016
  • SQL Server 2016 Editions and Components
  • Installing SQL Server 2016
  • SQL Server Management Studio Enhancements


Module 2: What’s New in SQL Server Performance
This module describes new and enhanced features in SQL Server performance.

  • Columnstore Indexes for Operational Analytics
  • In-memory OLTP Enhancements
  • The Query Data Store
  • Native JSON
  • Temporal Tables

 

Module 3: What’s New in SQL Server Security?
This module describes new and enhanced features in SQL Server security.

  • Using Always Encrypted
  • Row-level Security
  • Dynamic Data Masking

 

Module 4: What’s New in SQL Server Availability and Scalability?
This module introduces what’s new in SQL Server Availability and Scalability.

  • Enhanced AlwaysOn Availability Groups
  • What’s New in Database Caching?
  • Using Windows Server 2016

 

Module 5: What’s New in SQL Server Reporting and BI
This module introduces reporting and BI enhancements and new features in SQL Server 2016.

  • Reporting Services Enhancements
  • PowerBI Enhancements

 

Module 6: What’s New in SQL Server Data Access?

  • At the end of this module you will be able to describe data access enhancements in SQL Server 2016.
  • PolyBase
  • Enhancements to Integration Services

 

Module 7: New and Enhanced Features in SQL Server OLAP
This module describes enhancements in SQL Server OLAP.

  • New and Enhanced Features in SQL Server OLAP
  • What’s New in SQL Server Analysis Services

 

Module 8: What’s New for SQL Server in the Cloud?
This module describes new SQL Server cloud functionality.

  • Stretch Database
  • Enhanced Backups to Azure
  • Introduction to SQL Server 2016 Hybrid Cloud
  • What’s New in SQL Server Azure Database 
לפי יצרן: 
תגיות