10986 – Updating Your Skills to SQL Server 2016

Objetivo: Este curso, provee a los estudiantes que deseen actualizarse desde versiones anteriores de SQL Server, con una introducción a las nuevas características de SQL Server 2016.

Requisitos: Experiencia construyendo y manejando soluciones de base de datos e inteligencia de negocios con versiones anteriores de SQL Server.

Duración: 24 horas

Temario:

  • Introduction to SQL Server 2016
  • SQL Server 2016 Editions and Components
  • Installing SQL Server 2016
  • SQL Server Management Studio Enhancements
  • What’s New in SQL Server Performance
  • Operational Analytics
  • In-memory OLTP Enhancements
  • Query Store
  • Live Query Statistics
  • Native JSON
  • Temporal Tables
  • What’s New in SQL Server Security?
  • Using Always Encrypted
  • Row-level Security
  • Dynamic Data Masking
  • What’s New in SQL Server Availability and Scalability?
  • Enhanced AlwaysOn Availability Groups
  • What’s New with tempdb?
  • Use Windows Server 2016 with SQL Server 2016
  • PowerShell 5.0
  • What’s New in SQL Server Reporting and BI
  • Reporting Services Enhancements
  • PowerBI Enhancements
  • Mobile Report Publisher
  • What’s New in SQL Server Data Access?
  • PolyBase
  • What’s new in Integration Services
  • Working with SSIS and Azure
  • New and Enhanced Features in SQL Server OLAP
  • What’s New in SQL Server Analysis Services
  • What’s New for SQL Server in the Cloud?
  • Stretch Database
  • Enhanced Backups to Azure
  • Introduction to SQL Server 2016 Hybrid Cloud
  • What’s New in SQL Server Azure Database

Técnicas: Al finalizar el curso los estudiantes serán capaces de:

  • 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

Proximamente en calendario

29 abril, 2017

Empower

La misión de Ulearn es brindar soluciones de capacitación para profesionales de TI, que se traduzca en optimización de sus habilidades para una mayor eficiencia.

mail [email protected]
tel
+598 98 410 014

Redes Sociales

linkedin