CONTENUTI:

Module 1: Introduction to SQL Server 2014

Overview of SQL Server 2014

SQL Server 2014 Editions and Components

Installing SQL Server 2014

Enhancements to SQL Server Management Studio

 

Lab : Exploring SQL Server 2014

Reviewing Installed Components

Using SQL Server Management Studio

 

Module 2: What’s New in SQL Server Database Development

Transact-SQL Enhancements

New and Enhanced Transact-SQL Functions

Enhancements to Spatial Data Support

Storing and Querying Documents with SQL Server 2014

 

Lab : Developing SQL Server 2014 Databases

Using Sequence Objects

Using the THROW statement

Implementing Paging

Querying Documents

 

Module 3: In-Memory Database Capabilities

The Buffer pool Extension

Columnstore Indexes

Memory-Optimized Tables

 

Lab : Using In-Memory Database Capabilities

Enabling the Buffer Pool Extension

Creating Columnstore Indexes

Working with Memory-Optimized Tables

 

Module 4: Scripting SQL Server 2014

New and Enhanced Dynamic Management Views

Using PowerShell to Manage SQL Server

 

Lab : Managing SQL Server with Scripts

Using Dynamic Management Views

Using PowerShell

 

Module 5: Implementing Security in Microsoft SQL Server 2014

Security Management Enhancements

Contained Databases

 

Lab : Implementing Security

Implementing User-Defines Server Roles

Implementing Contained Databases

 

Module 6: High Availability and Data Recovery Enhancements

AlwaysOn High Availability

Enhancements to Data Recovery

 

Lab : Using AlwaysOn Availability Groups

Creating an AlwaysOn Availability Group

Using an AlwaysOn Availability Group

Observing Availability Group Failover Behavior

 

Module 7: New and Enhanced Features in SQL Server Integration Services

Using the CDC Control Task for Incremental Data Loads

Deploying and Operating SSIS Packages

 

Lab : Using SQL Server Integration Services

Extracting Modified Data

Deploying and Operating an SSIS Project

 

Module 8: Data Quality Services

Introduction to Data Quality

Using Data Quality Services to Cleanse Data

Using Data Quality Services to Match Data

 

Lab : Cleansing Data

Creating a DQS Knowledge Base

Using a DQS Project to Cleanse Data

Using DQS in an SSIS Package

 

Lab : Deduplicating Data

Creating a Matching Policy

Using a DQS Project to Match Data

 

Module 9: Master Data Services

Introduction to Master Data Services

Implementing a Master Data Services Model

Using the Master Data Services Add-in for Excel

 

Lab : Implementing Master Data Services

Creating a Basic Model

Editing a Model by Using the Master Data Services Add-in for Excel

Loading Data into a Model

Enforcing Business Rules

Consuming Master Data Services Data

 

Module 10: SQL Server 2014 Reporting Services

Reporting Services Overview

Reporting Services and Microsoft SharePoint Server

Introduction to Data Alerts

 

Lab : Using SQL Server 2014 Reporting Services

Viewing SharePoint Mode Configuration

Authoring, Publishing, and Viewing a Report

Creating and Managing Data Alerts

 

Module 11: Implementing an Analysis Services Tabular Data Model

Introduction to Analysis Services Tabular Data Model Projects

Creating a Tabular Model

Using an Analysis Services Tabular Data Model in the Enterprise

 

Lab : Working with an Analysis Services Tabular Data Model

Creating an Analysis Services Tabular Data Model Project

Configuring Columns and Relationships

Using Custom DAX Expressions

Deploying an Analysis Services Tabular Data Model

 

Module 12: Self-Service BI with Microsoft Excel

PowerPivot for Excel

PowerPivot for SharePoint Server

Power Query

Power View

Power Map

Collaborative Analysis with Power BI for Office 365

 

Lab : Self-Service BI with Excel

Creating a Data Model with PowerPivot

Importing Data with Power Query

Visualizing Data with Power View

Visualizing Geographic Data with Power Map

 

Module 13: Introduction to Cloud Data Solutions

Overview of Cloud Computing

Microsoft Azure Services for Data

 

Lab : Using Microsoft Azure

Creating a Microsoft Azure Storage Account

Backing Up a Database to Microsoft Azure

Storing Data Files in Microsoft Azure

 

Module 14: Microsoft Azure SQL Database

Introduction to Microsoft Azure SQL Database

Microsoft Azure SQL Database Security

Implementing and Managing Databases

 

Lab : Using Microsoft Azure SQL Database

Provisioning Microsoft Azure SQL Database

Configuring Microsoft Azure SQL Database Security

Migrating a SQL Server Database to Microsoft Azure SQL Database

 

Module 15: SQL Server in Microsoft Azure Virtual Machines

Introduction to Microsoft Azure Virtual Machines

Microsoft Azure Virtual Machine Connectivity and Security

Creating Databases in a Microsoft Azure Virtual Machine

 

Lab : Using Microsoft Azure Virtual Machines

Creating a Microsoft Azure Virtual Machine

Configuring Virtual Machine Security and Connectivity

Creating Databases on a Virtual Machine

 

Module 16: Implementing Big Data Solutions

Introduction to Big Data

Microsoft Azure HDInsight

Consuming HDInsight Results in Excel

Obtaining Data from the Microsoft Azure Marketplace

 

Lab : Creating a Big Data Solution

Provisioning an HDInsight Cluster

Processing Data with HDInsight

Analyzing Big Data in Excel

Obtaining Data from the Microsoft Azure Marketplace