upgrading your sql server skills to microsoft sql...

M10977 www.globalknowledge.be [email protected] 0800/84.009

Upgrading Your SQL Server Skills to Microsoft SQL Server 2014

Duration: 5 Days Course Code: M10977

Overview:

This course has been replaced by course M10986 , Updating Your Skills to SQL Server 2016. This five-day instructor-led course teaches students how to use the enhancements and new features that have been added to SQL Server andthe Microsoft data platform since the release of SQL Server 2008. The course focuses on teaching individuals how to use SQL Server 2014product features and other Microsoft data platform components.

Target Audience:

The primary audience for this course is database and business intelligence (BI) professionals who are familiar with SQL Server 2008 and wantto update their skills to SQL Server 2014, and become familiar with related Microsoft data technologies.

Objectives:

After completing this course, students will be able to:

Describe key features and capabilities of SQL Server 2014. Use SQL Server 2014 Master Data Services.

Leverage new and enhanced features to develop database in Manage SQL Server 2012 Agent and Jobs.SQL Server 2014.

Implement a tabular data model in SQL Server 2014 AnalysisUse in-memory database capabilities in SQL Server 2014. Services.

Manage SQL Server 2014 by using dynamic management views Implement a Self-Service BI solution with Microsoft Excel 2013.and PowerShell.

Describe key elements of cloud solutions for data.Implement security in SQL Server 2014.

Implement a database in Windows Azure SQL Database.Implement high-availability and data recovery techniques in SQLServer 2014.

Implement a SQL Server database in a Windows Azure virtualmachine.

Use SQL Server 2014 Integration Services.

Implement a Big Data solution with Windows Azure HDInsight andUse SQL Server 2014 Data Quality Services. the Windows Azure Marketplace.

Prerequisites:

Experience of building and managing database, data warehouse,and business intelligence (BI) solutions with SQL Server 2008.Familiarity with the Windows Server 2012 operating system and


networking.Familiarity with Microsoft Excel and Microsoft SharePoint Server2013.


Content:

Module 1: Introduction to SQL Server 2014 line line line

SQL Server 2014 Editions and SQL Server 2014 Editions andThis module introduces key features of SQL Components ComponentsServer 2014. Installing SQL Server 2014 Installing SQL Server 2014line Enhancements to SQL Server Enhancements to SQL Server

Overview of SQL Server 2014 Management StudioAfter completing this Management StudioAfter completing thismodule, you will be able to: module, you will be able to:Describe the common workloads for SQL Describe the common workloads for SQL

line Server 2014. Server 2014.SQL Server 2014 Editions and Components Describe the SQL Server 2014 Editions Describe the SQL Server 2014 EditionsInstalling SQL Server 2014 and Components. and Components.Enhancements to SQL Server Management Install SQL Server 2014 Components. Install SQL Server 2014 Components.StudioAfter completing this module, you will Use the new features in SQL Server Use the new features in SQL Serverbe able to: Management Studio. Management Studio.Describe the common workloads for SQL New and Enhanced Transact-SQL New and Enhanced Transact-SQLServer 2014. Functions FunctionsDescribe the SQL Server 2014 Editions and Enhancements to Spatial Data Support Enhancements to Spatial Data SupportComponents. Storing and Querying Documents with Storing and Querying Documents with SQLInstall SQL Server 2014 Components. SQL Server 2014After completing this Server 2014After completing this module,Use the new features in SQL Server module, you will be able to: you will be able to:Management Studio. Describe the enhancements to Describe the enhancements toNew and Enhanced Transact-SQL Functions Transact-SQL. Transact-SQL.Enhancements to Spatial Data Support Describe new and enhanced Describe new and enhancedStoring and Querying Documents with SQL Transact-SQL functions. Transact-SQL functions.Server 2014After completing this module, Describe the enhancements to Spatial Describe the enhancements to Spatialyou will be able to: Data Support. Data Support.Describe the enhancements to Explain how to store and query Explain how to store and query documentsTransact-SQL. documents with SQL Server 2014. with SQL Server 2014.Describe new and enhanced Transact-SQL Columnstore Indexes Columnstore Indexesfunctions. Memory-Optimized TablesAfter Memory-Optimized TablesAfter completingDescribe the enhancements to Spatial Data completing this module, you will be able this module, you will be able to:Support. to: Use the Buffer Pool Extension to improveExplain how to store and query documents Use the Buffer Pool Extension to improve performance for read-heavy OLTPwith SQL Server 2014. performance for read-heavy OLTP workloads.Columnstore Indexes workloads. Use Columnstore Indexes to improveMemory-Optimized TablesAfter completing Use Columnstore Indexes to improve performance in data warehouse querythis module, you will be able to: performance in data warehouse query workloads.Use the Buffer Pool Extension to improve workloads. Use memory-optimized tables to improveperformance for read-heavy OLTP Use memory-optimized tables to improve performance for latch-bound workloads.workloads. performance for latch-bound workloads. Using PowerShell to Manage SQLUse Columnstore Indexes to improve Using PowerShell to Manage SQL ServerAfter completing this module, youperformance in data warehouse query ServerAfter completing this module, you will be able to:workloads. will be able to: Describe new and enhanced dynamicUse memory-optimized tables to improve Describe new and enhanced dynamic management views.performance for latch-bound workloads. management views. Describe how to use PowerShell toUsing PowerShell to Manage SQL Describe how to use PowerShell to Manage SQL Server.ServerAfter completing this module, you will Manage SQL Server. Contained DatabasesAfter completing thisbe able to: Contained DatabasesAfter completing module, you will be able to:Describe new and enhanced dynamic this module, you will be able to: Describe the security enhancements inmanagement views. Describe the security enhancements in SQL Server 2014.Describe how to use PowerShell to Manage SQL Server 2014. Explain how to use contained databases.SQL Server. Explain how to use contained databases. Enhancements to Data RecoveryAfterContained DatabasesAfter completing this Enhancements to Data RecoveryAfter completing this module, you will be able to:module, you will be able to: completing this module, you will be able Describe high availability features in SQLDescribe the security enhancements in SQL to: Server 2014.Server 2014. Describe high availability features in SQL Describe data recovery enhancements inExplain how to use contained databases. Server 2014. SQL Server 2014.Enhancements to Data RecoveryAfter Describe data recovery enhancements in Deploying and Operating SSIScompleting this module, you will be able to: SQL Server 2014. PackagesAfter completing this module,Describe high availability features in SQL Deploying and Operating SSIS you will be able to:Server 2014. PackagesAfter completing this module, Use the CDC Control task to performDescribe data recovery enhancements in you will be able to: incremental data extractions in an ETLSQL Server 2014. Use the CDC Control task to perform solution.


Deploying and Operating SSIS incremental data extractions in an ETL Deploy and operate an SSIS project.PackagesAfter completing this module, you solution. Using Data Quality Services to Cleansewill be able to: Deploy and operate an SSIS project. DataUse the CDC Control task to perform Using Data Quality Services to Cleanse Using Data Quality Services to Matchincremental data extractions in an ETL Data DataAfter completing this module, you willsolution. Using Data Quality Services to Match be able to:Deploy and operate an SSIS project. DataAfter completing this module, you Describe how Data Quality Services canUsing Data Quality Services to Cleanse will be able to: help you manage data quality.Data Describe how Data Quality Services can Use Data Quality Services to cleanse yourUsing Data Quality Services to Match help you manage data quality. data.DataAfter completing this module, you will Use Data Quality Services to cleanse Use Data Quality Services to match data.be able to: your data. Implementing a Master Data ServicesDescribe how Data Quality Services can Use Data Quality Services to match data. Modelhelp you manage data quality. Implementing a Master Data Services Using the Master Data Services Add-in forUse Data Quality Services to cleanse your Model ExcelAfter completing this module, you willdata. Using the Master Data Services Add-in be able to:Use Data Quality Services to match data. for ExcelAfter completing this module, Describe key Master Data ServicesImplementing a Master Data Services Model you will be able to: concepts.Using the Master Data Services Add-in for Describe key Master Data Services Implement a Master Data Services model.ExcelAfter completing this module, you will concepts. Use Master Data Services tools to managebe able to: Implement a Master Data Services master data.Describe key Master Data Services model. Use Master Data Services tools to create aconcepts. Use Master Data Services tools to master data hub.Implement a Master Data Services model. manage master data. Reporting Services and MicrosoftUse Master Data Services tools to manage Use Master Data Services tools to create SharePoint Servermaster data. a master data hub. Introduction to Data AlertsAfter completingUse Master Data Services tools to create a Reporting Services and Microsoft this module, you will be able to:master data hub. SharePoint Server Describe the key capabilities of ReportingReporting Services and Microsoft Introduction to Data AlertsAfter Services.SharePoint Server completing this module, you will be able Install and configure Reporting Services inIntroduction to Data AlertsAfter completing to: SharePoint Mode.this module, you will be able to: Describe the key capabilities of Reporting Use data alerts to notify users of changesDescribe the key capabilities of Reporting Services. to report data.Services. Install and configure Reporting Services Creating a Tabular ModelInstall and configure Reporting Services in in SharePoint Mode. Using an Analysis Services Tabular DataSharePoint Mode. Use data alerts to notify users of changes Model in the EnterpriseAfter completingUse data alerts to notify users of changes to to report data. this module, you will be able to:report data. Creating a Tabular Model Describe Analysis Services tabular dataCreating a Tabular Model Using an Analysis Services Tabular Data model projects.Using an Analysis Services Tabular Data Model in the EnterpriseAfter completing Implement an Analysis Services tabularModel in the EnterpriseAfter completing this this module, you will be able to: data model.module, you will be able to: Describe Analysis Services tabular data Use an Analysis Services tabular dataDescribe Analysis Services tabular data model projects. model.model projects. Implement an Analysis Services tabular PowerPivot for SharePoint ServerImplement an Analysis Services tabular data data model. Power Querymodel. Use an Analysis Services tabular data Power ViewUse an Analysis Services tabular data model. Power Mapmodel. PowerPivot for SharePoint Server Power BI for Office 365After completingPowerPivot for SharePoint Server Power Query this module, you will be able to:Power Query Power View Use PowerPivot to create tabular dataPower View Power Map models in Excel.Power Map Power BI for Office 365After completing Share a PowerPivot workbooks inPower BI for Office 365After completing this this module, you will be able to: SharePoint Server.module, you will be able to: Use PowerPivot to create tabular data Use Power Query to discover and importUse PowerPivot to create tabular data models in Excel. data from multiple data sources into Excel.models in Excel. Share a PowerPivot workbooks in Use Power View to create interactive dataShare a PowerPivot workbooks in SharePoint Server. visualizations in Excel and SharePointSharePoint Server. Use Power Query to discover and import Server.Use Power Query to discover and import data from multiple data sources into Use Power Map to create visualizations ofdata from multiple data sources into Excel. Excel. geographic data.Use Power View to create interactive data Use Power View to create interactive Use Power BI for Office 365 to create avisualizations in Excel and SharePoint data visualizations in Excel and cloud-based collaborative solution forServer. SharePoint Server. self-service BI.Use Power Map to create visualizations of Use Power Map to create visualizations Windows Azure Services for DataAftergeographic data. of geographic data. completing this module, you will be able to:Use Power BI for Office 365 to create a Use Power BI for Office 365 to create a Describe key features and benefits of


cloud-based collaborative solution for cloud-based collaborative solution for cloud computing.self-service BI. self-service BI. Describe Windows Azure service for data.Windows Azure Services for DataAfter Windows Azure Services for DataAfter Windows Azure SQL Database Securitycompleting this module, you will be able to: completing this module, you will be able Implementing and ManagingDescribe key features and benefits of cloud to: DatabasesAfter completing this module,computing. Describe key features and benefits of you will be able to:Describe Windows Azure service for data. cloud computing. Describe key features and benefits ofWindows Azure SQL Database Security Describe Windows Azure service for Windows Azure SQL Database.Implementing and Managing DatabasesAfter data. Implement security for Windows Azurecompleting this module, you will be able to: Windows Azure SQL Database Security SQL Database.Describe key features and benefits of Implementing and Managing Implement and manage databases inWindows Azure SQL Database. DatabasesAfter completing this module, Windows Azure SQL Database.Implement security for Windows Azure SQL you will be able to: Windows Azure Virtual MachineDatabase. Describe key features and benefits of Connectivity and SecurityImplement and manage databases in Windows Azure SQL Database. Creating Databases in a Windows AzureWindows Azure SQL Database. Implement security for Windows Azure Virtual MachineAfter completing thisWindows Azure Virtual Machine Connectivity SQL Database. module, you will be able to:and Security Implement and manage databases in Describe considerations for using VirtualCreating Databases in a Windows Azure Windows Azure SQL Database. Machines in Windows Azure.Virtual MachineAfter completing this Windows Azure Virtual Machine Create and configure Windows Azuremodule, you will be able to: Connectivity and Security virtual machines.Describe considerations for using Virtual Creating Databases in a Windows Azure Create databases in Windows AzureMachines in Windows Azure. Virtual MachineAfter completing this virtual machines.Create and configure Windows Azure virtual module, you will be able to: Windows Azure HDInsightmachines. Describe considerations for using Virtual Consuming HDInsight Results in ExcelCreate databases in Windows Azure virtual Machines in Windows Azure. Obtaining Data from the Windows Azuremachines. Create and configure Windows Azure MarketplaceAfter completing this module,Windows Azure HDInsight virtual machines. you will be able to:Consuming HDInsight Results in Excel Create databases in Windows Azure Describe key features of big data.Obtaining Data from the Windows Azure virtual machines. Process big data with Windows AzureMarketplaceAfter completing this module, Windows Azure HDInsight HDInsight.you will be able to: Consuming HDInsight Results in Excel Consume big data processing results fromDescribe key features of big data. Obtaining Data from the Windows Azure Windows Azure HDInsight in MicrosoftProcess big data with Windows Azure MarketplaceAfter completing this module, Excel.HDInsight. you will be able to:Consume big data processing results from Describe key features of big data.Windows Azure HDInsight in Microsoft Process big data with Windows Azure lineExcel. HDInsight. SQL Server 2014 Editions and

Consume big data processing results Componentsfrom Windows Azure HDInsight in Installing SQL Server 2014

line Microsoft Excel. Enhancements to SQL ServerSQL Server 2014 Editions and Components Management StudioAfter completing thisInstalling SQL Server 2014 Module 7: New and Enhanced Features in module, you will be able to:Enhancements to SQL Server Management SQL Server Integration Services Describe the common workloads for SQLStudioAfter completing this module, you will line Server 2014.be able to: Describe the SQL Server 2014 EditionsDescribe the common workloads for SQL This module describes enhancements to SQL and Components.Server 2014. Server Integration Services since SQL Server Install SQL Server 2014 Components.Describe the SQL Server 2014 Editions and 2008. Use the new features in SQL ServerComponents. line Management Studio.Install SQL Server 2014 Components. Using the CDC Control Task for New and Enhanced Transact-SQLUse the new features in SQL Server Incremental Data Loads FunctionsManagement Studio. Enhancements to Spatial Data SupportNew and Enhanced Transact-SQL Functions Storing and Querying Documents with SQLEnhancements to Spatial Data Support line Server 2014After completing this module,Storing and Querying Documents with SQL SQL Server 2014 Editions and you will be able to:Server 2014After completing this module, Components Describe the enhancements toyou will be able to: Installing SQL Server 2014 Transact-SQL.Describe the enhancements to Enhancements to SQL Server Describe new and enhancedTransact-SQL. Management StudioAfter completing this Transact-SQL functions.Describe new and enhanced Transact-SQL module, you will be able to: Describe the enhancements to Spatialfunctions. Describe the common workloads for SQL Data Support.Describe the enhancements to Spatial Data Server 2014. Explain how to store and query documentsSupport. Describe the SQL Server 2014 Editions with SQL Server 2014.Explain how to store and query documents and Components. Columnstore Indexeswith SQL Server 2014. Install SQL Server 2014 Components. Memory-Optimized TablesAfter completing


Columnstore Indexes Use the new features in SQL Server this module, you will be able to:Memory-Optimized TablesAfter completing Management Studio. Use the Buffer Pool Extension to improvethis module, you will be able to: New and Enhanced Transact-SQL performance for read-heavy OLTPUse the Buffer Pool Extension to improve Functions workloads.performance for read-heavy OLTP Enhancements to Spatial Data Support Use Columnstore Indexes to improveworkloads. Storing and Querying Documents with performance in data warehouse queryUse Columnstore Indexes to improve SQL Server 2014After completing this workloads.performance in data warehouse query module, you will be able to: Use memory-optimized tables to improveworkloads. Describe the enhancements to performance for latch-bound workloads.Use memory-optimized tables to improve Transact-SQL. Using PowerShell to Manage SQLperformance for latch-bound workloads. Describe new and enhanced ServerAfter completing this module, youUsing PowerShell to Manage SQL Transact-SQL functions. will be able to:ServerAfter completing this module, you will Describe the enhancements to Spatial Describe new and enhanced dynamicbe able to: Data Support. management views.Describe new and enhanced dynamic Explain how to store and query Describe how to use PowerShell tomanagement views. documents with SQL Server 2014. Manage SQL Server.Describe how to use PowerShell to Manage Columnstore Indexes Contained DatabasesAfter completing thisSQL Server. Memory-Optimized TablesAfter module, you will be able to:Contained DatabasesAfter completing this completing this module, you will be able Describe the security enhancements inmodule, you will be able to: to: SQL Server 2014.Describe the security enhancements in SQL Use the Buffer Pool Extension to improve Explain how to use contained databases.Server 2014. performance for read-heavy OLTP Enhancements to Data RecoveryAfterExplain how to use contained databases. workloads. completing this module, you will be able to:Enhancements to Data RecoveryAfter Use Columnstore Indexes to improve Describe high availability features in SQLcompleting this module, you will be able to: performance in data warehouse query Server 2014.Describe high availability features in SQL workloads. Describe data recovery enhancements inServer 2014. Use memory-optimized tables to improve SQL Server 2014.Describe data recovery enhancements in performance for latch-bound workloads. Deploying and Operating SSISSQL Server 2014. Using PowerShell to Manage SQL PackagesAfter completing this module,Deploying and Operating SSIS ServerAfter completing this module, you you will be able to:PackagesAfter completing this module, you will be able to: Use the CDC Control task to performwill be able to: Describe new and enhanced dynamic incremental data extractions in an ETLUse the CDC Control task to perform management views. solution.incremental data extractions in an ETL Describe how to use PowerShell to Deploy and operate an SSIS project.solution. Manage SQL Server. Using Data Quality Services to CleanseDeploy and operate an SSIS project. Contained DatabasesAfter completing DataUsing Data Quality Services to Cleanse this module, you will be able to: Using Data Quality Services to MatchData Describe the security enhancements in DataAfter completing this module, you willUsing Data Quality Services to Match SQL Server 2014. be able to:DataAfter completing this module, you will Explain how to use contained databases. Describe how Data Quality Services canbe able to: Enhancements to Data RecoveryAfter help you manage data quality.Describe how Data Quality Services can completing this module, you will be able Use Data Quality Services to cleanse yourhelp you manage data quality. to: data.Use Data Quality Services to cleanse your Describe high availability features in SQL Use Data Quality Services to match data.data. Server 2014. Implementing a Master Data ServicesUse Data Quality Services to match data. Describe data recovery enhancements in ModelImplementing a Master Data Services Model SQL Server 2014. Using the Master Data Services Add-in forUsing the Master Data Services Add-in for Deploying and Operating SSIS ExcelAfter completing this module, you willExcelAfter completing this module, you will PackagesAfter completing this module, be able to:be able to: you will be able to: Describe key Master Data ServicesDescribe key Master Data Services Use the CDC Control task to perform concepts.concepts. incremental data extractions in an ETL Implement a Master Data Services model.Implement a Master Data Services model. solution. Use Master Data Services tools to manageUse Master Data Services tools to manage Deploy and operate an SSIS project. master data.master data. Using Data Quality Services to Cleanse Use Master Data Services tools to create aUse Master Data Services tools to create a Data master data hub.master data hub. Using Data Quality Services to Match Reporting Services and MicrosoftReporting Services and Microsoft DataAfter completing this module, you SharePoint ServerSharePoint Server will be able to: Introduction to Data AlertsAfter completingIntroduction to Data AlertsAfter completing Describe how Data Quality Services can this module, you will be able to:this module, you will be able to: help you manage data quality. Describe the key capabilities of ReportingDescribe the key capabilities of Reporting Use Data Quality Services to cleanse Services.Services. your data. Install and configure Reporting Services inInstall and configure Reporting Services in Use Data Quality Services to match data. SharePoint Mode.SharePoint Mode. Implementing a Master Data Services Use data alerts to notify users of changesUse data alerts to notify users of changes to Model to report data.


report data. Using the Master Data Services Add-in Creating a Tabular ModelCreating a Tabular Model for ExcelAfter completing this module, Using an Analysis Services Tabular DataUsing an Analysis Services Tabular Data you will be able to: Model in the EnterpriseAfter completingModel in the EnterpriseAfter completing this Describe key Master Data Services this module, you will be able to:module, you will be able to: concepts. Describe Analysis Services tabular dataDescribe Analysis Services tabular data Implement a Master Data Services model projects.model projects. model. Implement an Analysis Services tabularImplement an Analysis Services tabular data Use Master Data Services tools to data model.model. manage master data. Use an Analysis Services tabular dataUse an Analysis Services tabular data Use Master Data Services tools to create model.model. a master data hub. PowerPivot for SharePoint ServerPowerPivot for SharePoint Server Reporting Services and Microsoft Power QueryPower Query SharePoint Server Power ViewPower View Introduction to Data AlertsAfter Power MapPower Map completing this module, you will be able Power BI for Office 365After completingPower BI for Office 365After completing this to: this module, you will be able to:module, you will be able to: Describe the key capabilities of Reporting Use PowerPivot to create tabular dataUse PowerPivot to create tabular data Services. models in Excel.models in Excel. Install and configure Reporting Services Share a PowerPivot workbooks inShare a PowerPivot workbooks in in SharePoint Mode. SharePoint Server.SharePoint Server. Use data alerts to notify users of changes Use Power Query to discover and importUse Power Query to discover and import to report data. data from multiple data sources into Excel.data from multiple data sources into Excel. Creating a Tabular Model Use Power View to create interactive dataUse Power View to create interactive data Using an Analysis Services Tabular Data visualizations in Excel and SharePointvisualizations in Excel and SharePoint Model in the EnterpriseAfter completing Server.Server. this module, you will be able to: Use Power Map to create visualizations ofUse Power Map to create visualizations of Describe Analysis Services tabular data geographic data.geographic data. model projects. Use Power BI for Office 365 to create aUse Power BI for Office 365 to create a Implement an Analysis Services tabular cloud-based collaborative solution forcloud-based collaborative solution for data model. self-service BI.self-service BI. Use an Analysis Services tabular data Windows Azure Services for DataAfterWindows Azure Services for DataAfter model. completing this module, you will be able to:completing this module, you will be able to: PowerPivot for SharePoint Server Describe key features and benefits ofDescribe key features and benefits of cloud Power Query cloud computing.computing. Power View Describe Windows Azure service for data.Describe Windows Azure service for data. Power Map Windows Azure SQL Database SecurityWindows Azure SQL Database Security Power BI for Office 365After completing Implementing and ManagingImplementing and Managing DatabasesAfter this module, you will be able to: DatabasesAfter completing this module,completing this module, you will be able to: Use PowerPivot to create tabular data you will be able to:Describe key features and benefits of models in Excel. Describe key features and benefits ofWindows Azure SQL Database. Share a PowerPivot workbooks in Windows Azure SQL Database.Implement security for Windows Azure SQL SharePoint Server. Implement security for Windows AzureDatabase. Use Power Query to discover and import SQL Database.Implement and manage databases in data from multiple data sources into Implement and manage databases inWindows Azure SQL Database. Excel. Windows Azure SQL Database.Windows Azure Virtual Machine Connectivity Use Power View to create interactive Windows Azure Virtual Machineand Security data visualizations in Excel and Connectivity and SecurityCreating Databases in a Windows Azure SharePoint Server. Creating Databases in a Windows AzureVirtual MachineAfter completing this Use Power Map to create visualizations Virtual MachineAfter completing thismodule, you will be able to: of geographic data. module, you will be able to:Describe considerations for using Virtual Use Power BI for Office 365 to create a Describe considerations for using VirtualMachines in Windows Azure. cloud-based collaborative solution for Machines in Windows Azure.Create and configure Windows Azure virtual self-service BI. Create and configure Windows Azuremachines. Windows Azure Services for DataAfter virtual machines.Create databases in Windows Azure virtual completing this module, you will be able Create databases in Windows Azuremachines. to: virtual machines.Windows Azure HDInsight Describe key features and benefits of Windows Azure HDInsightConsuming HDInsight Results in Excel cloud computing. Consuming HDInsight Results in ExcelObtaining Data from the Windows Azure Describe Windows Azure service for Obtaining Data from the Windows AzureMarketplaceAfter completing this module, data. MarketplaceAfter completing this module,you will be able to: Windows Azure SQL Database Security you will be able to:Describe key features of big data. Implementing and Managing Describe key features of big data.Process big data with Windows Azure DatabasesAfter completing this module, Process big data with Windows AzureHDInsight. you will be able to: HDInsight.Consume big data processing results from Describe key features and benefits of Consume big data processing results fromWindows Azure HDInsight in Microsoft Windows Azure SQL Database. Windows Azure HDInsight in Microsoft


Excel. Implement security for Windows Azure Excel.SQL Database.Implement and manage databases in

line Windows Azure SQL Database. lineSQL Server 2014 Editions and Components Windows Azure Virtual Machine SQL Server 2014 Editions andInstalling SQL Server 2014 Connectivity and Security ComponentsEnhancements to SQL Server Management Creating Databases in a Windows Azure Installing SQL Server 2014StudioAfter completing this module, you will Virtual MachineAfter completing this Enhancements to SQL Serverbe able to: module, you will be able to: Management StudioAfter completing thisDescribe the common workloads for SQL Describe considerations for using Virtual module, you will be able to:Server 2014. Machines in Windows Azure. Describe the common workloads for SQLDescribe the SQL Server 2014 Editions and Create and configure Windows Azure Server 2014.Components. virtual machines. Describe the SQL Server 2014 EditionsInstall SQL Server 2014 Components. Create databases in Windows Azure and Components.Use the new features in SQL Server virtual machines. Install SQL Server 2014 Components.Management Studio. Windows Azure HDInsight Use the new features in SQL ServerNew and Enhanced Transact-SQL Functions Consuming HDInsight Results in Excel Management Studio.Enhancements to Spatial Data Support Obtaining Data from the Windows Azure New and Enhanced Transact-SQLStoring and Querying Documents with SQL MarketplaceAfter completing this module, FunctionsServer 2014After completing this module, you will be able to: Enhancements to Spatial Data Supportyou will be able to: Describe key features of big data. Storing and Querying Documents with SQLDescribe the enhancements to Process big data with Windows Azure Server 2014After completing this module,Transact-SQL. HDInsight. you will be able to:Describe new and enhanced Transact-SQL Consume big data processing results Describe the enhancements tofunctions. from Windows Azure HDInsight in Transact-SQL.Describe the enhancements to Spatial Data Microsoft Excel. Describe new and enhancedSupport. Transact-SQL functions.Explain how to store and query documents Describe the enhancements to Spatialwith SQL Server 2014. line Data Support.Columnstore Indexes SQL Server 2014 Editions and Explain how to store and query documentsMemory-Optimized TablesAfter completing Components with SQL Server 2014.this module, you will be able to: Installing SQL Server 2014 Columnstore IndexesUse the Buffer Pool Extension to improve Enhancements to SQL Server Memory-Optimized TablesAfter completingperformance for read-heavy OLTP Management StudioAfter completing this this module, you will be able to:workloads. module, you will be able to: Use the Buffer Pool Extension to improveUse Columnstore Indexes to improve Describe the common workloads for SQL performance for read-heavy OLTPperformance in data warehouse query Server 2014. workloads.workloads. Describe the SQL Server 2014 Editions Use Columnstore Indexes to improveUse memory-optimized tables to improve and Components. performance in data warehouse queryperformance for latch-bound workloads. Install SQL Server 2014 Components. workloads.Using PowerShell to Manage SQL Use the new features in SQL Server Use memory-optimized tables to improveServerAfter completing this module, you will Management Studio. performance for latch-bound workloads.be able to: New and Enhanced Transact-SQL Using PowerShell to Manage SQLDescribe new and enhanced dynamic Functions ServerAfter completing this module, youmanagement views. Enhancements to Spatial Data Support will be able to:Describe how to use PowerShell to Manage Storing and Querying Documents with Describe new and enhanced dynamicSQL Server. SQL Server 2014After completing this management views.Contained DatabasesAfter completing this module, you will be able to: Describe how to use PowerShell tomodule, you will be able to: Describe the enhancements to Manage SQL Server.Describe the security enhancements in SQL Transact-SQL. Contained DatabasesAfter completing thisServer 2014. Describe new and enhanced module, you will be able to:Explain how to use contained databases. Transact-SQL functions. Describe the security enhancements inEnhancements to Data RecoveryAfter Describe the enhancements to Spatial SQL Server 2014.completing this module, you will be able to: Data Support. Explain how to use contained databases.Describe high availability features in SQL Explain how to store and query Enhancements to Data RecoveryAfterServer 2014. documents with SQL Server 2014. completing this module, you will be able to:Describe data recovery enhancements in Columnstore Indexes Describe high availability features in SQLSQL Server 2014. Memory-Optimized TablesAfter Server 2014.Deploying and Operating SSIS completing this module, you will be able Describe data recovery enhancements inPackagesAfter completing this module, you to: SQL Server 2014.will be able to: Use the Buffer Pool Extension to improve Deploying and Operating SSISUse the CDC Control task to perform performance for read-heavy OLTP PackagesAfter completing this module,incremental data extractions in an ETL workloads. you will be able to:solution. Use Columnstore Indexes to improve Use the CDC Control task to performDeploy and operate an SSIS project. performance in data warehouse query incremental data extractions in an ETLUsing Data Quality Services to Cleanse workloads. solution.


Data Use memory-optimized tables to improve Deploy and operate an SSIS project.Using Data Quality Services to Match performance for latch-bound workloads. Using Data Quality Services to CleanseDataAfter completing this module, you will Using PowerShell to Manage SQL Databe able to: ServerAfter completing this module, you Using Data Quality Services to MatchDescribe how Data Quality Services can will be able to: DataAfter completing this module, you willhelp you manage data quality. Describe new and enhanced dynamic be able to:Use Data Quality Services to cleanse your management views. Describe how Data Quality Services candata. Describe how to use PowerShell to help you manage data quality.Use Data Quality Services to match data. Manage SQL Server. Use Data Quality Services to cleanse yourImplementing a Master Data Services Model Contained DatabasesAfter completing data.Using the Master Data Services Add-in for this module, you will be able to: Use Data Quality Services to match data.ExcelAfter completing this module, you will Describe the security enhancements in Implementing a Master Data Servicesbe able to: SQL Server 2014. ModelDescribe key Master Data Services Explain how to use contained databases. Using the Master Data Services Add-in forconcepts. Enhancements to Data RecoveryAfter ExcelAfter completing this module, you willImplement a Master Data Services model. completing this module, you will be able be able to:Use Master Data Services tools to manage to: Describe key Master Data Servicesmaster data. Describe high availability features in SQL concepts.Use Master Data Services tools to create a Server 2014. Implement a Master Data Services model.master data hub. Describe data recovery enhancements in Use Master Data Services tools to manageReporting Services and Microsoft SQL Server 2014. master data.SharePoint Server Deploying and Operating SSIS Use Master Data Services tools to create aIntroduction to Data AlertsAfter completing PackagesAfter completing this module, master data hub.this module, you will be able to: you will be able to: Reporting Services and MicrosoftDescribe the key capabilities of Reporting Use the CDC Control task to perform SharePoint ServerServices. incremental data extractions in an ETL Introduction to Data AlertsAfter completingInstall and configure Reporting Services in solution. this module, you will be able to:SharePoint Mode. Deploy and operate an SSIS project. Describe the key capabilities of ReportingUse data alerts to notify users of changes to Using Data Quality Services to Cleanse Services.report data. Data Install and configure Reporting Services inCreating a Tabular Model Using Data Quality Services to Match SharePoint Mode.Using an Analysis Services Tabular Data DataAfter completing this module, you Use data alerts to notify users of changesModel in the EnterpriseAfter completing this will be able to: to report data.module, you will be able to: Describe how Data Quality Services can Creating a Tabular ModelDescribe Analysis Services tabular data help you manage data quality. Using an Analysis Services Tabular Datamodel projects. Use Data Quality Services to cleanse Model in the EnterpriseAfter completingImplement an Analysis Services tabular data your data. this module, you will be able to:model. Use Data Quality Services to match data. Describe Analysis Services tabular dataUse an Analysis Services tabular data Implementing a Master Data Services model projects.model. Model Implement an Analysis Services tabularPowerPivot for SharePoint Server Using the Master Data Services Add-in data model.Power Query for ExcelAfter completing this module, Use an Analysis Services tabular dataPower View you will be able to: model.Power Map Describe key Master Data Services PowerPivot for SharePoint ServerPower BI for Office 365After completing this concepts. Power Querymodule, you will be able to: Implement a Master Data Services Power ViewUse PowerPivot to create tabular data model. Power Mapmodels in Excel. Use Master Data Services tools to Power BI for Office 365After completingShare a PowerPivot workbooks in manage master data. this module, you will be able to:SharePoint Server. Use Master Data Services tools to create Use PowerPivot to create tabular dataUse Power Query to discover and import a master data hub. models in Excel.data from multiple data sources into Excel. Reporting Services and Microsoft Share a PowerPivot workbooks inUse Power View to create interactive data SharePoint Server SharePoint Server.visualizations in Excel and SharePoint Introduction to Data AlertsAfter Use Power Query to discover and importServer. completing this module, you will be able data from multiple data sources into Excel.Use Power Map to create visualizations of to: Use Power View to create interactive datageographic data. Describe the key capabilities of Reporting visualizations in Excel and SharePointUse Power BI for Office 365 to create a Services. Server.cloud-based collaborative solution for Install and configure Reporting Services Use Power Map to create visualizations ofself-service BI. in SharePoint Mode. geographic data.Windows Azure Services for DataAfter Use data alerts to notify users of changes Use Power BI for Office 365 to create acompleting this module, you will be able to: to report data. cloud-based collaborative solution forDescribe key features and benefits of cloud Creating a Tabular Model self-service BI.computing. Using an Analysis Services Tabular Data Windows Azure Services for DataAfterDescribe Windows Azure service for data. Model in the EnterpriseAfter completing completing this module, you will be able to:Windows Azure SQL Database Security this module, you will be able to: Describe key features and benefits of


Implementing and Managing DatabasesAfter Describe Analysis Services tabular data cloud computing.completing this module, you will be able to: model projects. Describe Windows Azure service for data.Describe key features and benefits of Implement an Analysis Services tabular Windows Azure SQL Database SecurityWindows Azure SQL Database. data model. Implementing and ManagingImplement security for Windows Azure SQL Use an Analysis Services tabular data DatabasesAfter completing this module,Database. model. you will be able to:Implement and manage databases in PowerPivot for SharePoint Server Describe key features and benefits ofWindows Azure SQL Database. Power Query Windows Azure SQL Database.Windows Azure Virtual Machine Connectivity Power View Implement security for Windows Azureand Security Power Map SQL Database.Creating Databases in a Windows Azure Power BI for Office 365After completing Implement and manage databases inVirtual MachineAfter completing this this module, you will be able to: Windows Azure SQL Database.module, you will be able to: Use PowerPivot to create tabular data Windows Azure Virtual MachineDescribe considerations for using Virtual models in Excel. Connectivity and SecurityMachines in Windows Azure. Share a PowerPivot workbooks in Creating Databases in a Windows AzureCreate and configure Windows Azure virtual SharePoint Server. Virtual MachineAfter completing thismachines. Use Power Query to discover and import module, you will be able to:Create databases in Windows Azure virtual data from multiple data sources into Describe considerations for using Virtualmachines. Excel. Machines in Windows Azure.Windows Azure HDInsight Use Power View to create interactive Create and configure Windows AzureConsuming HDInsight Results in Excel data visualizations in Excel and virtual machines.Obtaining Data from the Windows Azure SharePoint Server. Create databases in Windows AzureMarketplaceAfter completing this module, Use Power Map to create visualizations virtual machines.you will be able to: of geographic data. Windows Azure HDInsightDescribe key features of big data. Use Power BI for Office 365 to create a Consuming HDInsight Results in ExcelProcess big data with Windows Azure cloud-based collaborative solution for Obtaining Data from the Windows AzureHDInsight. self-service BI. MarketplaceAfter completing this module,Consume big data processing results from Windows Azure Services for DataAfter you will be able to:Windows Azure HDInsight in Microsoft completing this module, you will be able Describe key features of big data.Excel. to: Process big data with Windows Azure

Describe key features and benefits of HDInsight.cloud computing. Consume big data processing results from

line Describe Windows Azure service for Windows Azure HDInsight in MicrosoftSQL Server 2014 Editions and Components data. Excel.Installing SQL Server 2014 Windows Azure SQL Database SecurityEnhancements to SQL Server Management Implementing and ManagingStudioAfter completing this module, you will DatabasesAfter completing this module, linebe able to: you will be able to: SQL Server 2014 Editions andDescribe the common workloads for SQL Describe key features and benefits of ComponentsServer 2014. Windows Azure SQL Database. Installing SQL Server 2014Describe the SQL Server 2014 Editions and Implement security for Windows Azure Enhancements to SQL ServerComponents. SQL Database. Management StudioAfter completing thisInstall SQL Server 2014 Components. Implement and manage databases in module, you will be able to:Use the new features in SQL Server Windows Azure SQL Database. Describe the common workloads for SQLManagement Studio. Windows Azure Virtual Machine Server 2014.New and Enhanced Transact-SQL Functions Connectivity and Security Describe the SQL Server 2014 EditionsEnhancements to Spatial Data Support Creating Databases in a Windows Azure and Components.Storing and Querying Documents with SQL Virtual MachineAfter completing this Install SQL Server 2014 Components.Server 2014After completing this module, module, you will be able to: Use the new features in SQL Serveryou will be able to: Describe considerations for using Virtual Management Studio.Describe the enhancements to Machines in Windows Azure. New and Enhanced Transact-SQLTransact-SQL. Create and configure Windows Azure FunctionsDescribe new and enhanced Transact-SQL virtual machines. Enhancements to Spatial Data Supportfunctions. Create databases in Windows Azure Storing and Querying Documents with SQLDescribe the enhancements to Spatial Data virtual machines. Server 2014After completing this module,Support. Windows Azure HDInsight you will be able to:Explain how to store and query documents Consuming HDInsight Results in Excel Describe the enhancements towith SQL Server 2014. Obtaining Data from the Windows Azure Transact-SQL.Columnstore Indexes MarketplaceAfter completing this module, Describe new and enhancedMemory-Optimized TablesAfter completing you will be able to: Transact-SQL functions.this module, you will be able to: Describe key features of big data. Describe the enhancements to SpatialUse the Buffer Pool Extension to improve Process big data with Windows Azure Data Support.performance for read-heavy OLTP HDInsight. Explain how to store and query documentsworkloads. Consume big data processing results with SQL Server 2014.Use Columnstore Indexes to improve from Windows Azure HDInsight in Columnstore Indexesperformance in data warehouse query Microsoft Excel. Memory-Optimized TablesAfter completing


workloads. this module, you will be able to:Use memory-optimized tables to improve Module 8: Data Quality Services Use the Buffer Pool Extension to improveperformance for latch-bound workloads. line performance for read-heavy OLTPUsing PowerShell to Manage SQL workloads.ServerAfter completing this module, you will This module explains how to use the SQL Use Columnstore Indexes to improvebe able to: Server 2014 Data Quality Services (DQS) to performance in data warehouse queryDescribe new and enhanced dynamic provide a computer assisted process for workloads.management views. cleansing data values and identifying and Use memory-optimized tables to improveDescribe how to use PowerShell to Manage removing duplicate data entities. performance for latch-bound workloads.SQL Server. line Using PowerShell to Manage SQLContained DatabasesAfter completing this Introduction to Data Quality ServerAfter completing this module, youmodule, you will be able to: will be able to:Describe the security enhancements in SQL Describe new and enhanced dynamicServer 2014. line management views.Explain how to use contained databases. SQL Server 2014 Editions and Describe how to use PowerShell toEnhancements to Data RecoveryAfter Components Manage SQL Server.completing this module, you will be able to: Installing SQL Server 2014 Contained DatabasesAfter completing thisDescribe high availability features in SQL Enhancements to SQL Server module, you will be able to:Server 2014. Management StudioAfter completing this Describe the security enhancements inDescribe data recovery enhancements in module, you will be able to: SQL Server 2014.SQL Server 2014. Describe the common workloads for SQL Explain how to use contained databases.Deploying and Operating SSIS Server 2014. Enhancements to Data RecoveryAfterPackagesAfter completing this module, you Describe the SQL Server 2014 Editions completing this module, you will be able to:will be able to: and Components. Describe high availability features in SQLUse the CDC Control task to perform Install SQL Server 2014 Components. Server 2014.incremental data extractions in an ETL Use the new features in SQL Server Describe data recovery enhancements insolution. Management Studio. SQL Server 2014.Deploy and operate an SSIS project. New and Enhanced Transact-SQL Deploying and Operating SSISUsing Data Quality Services to Cleanse Functions PackagesAfter completing this module,Data Enhancements to Spatial Data Support you will be able to:Using Data Quality Services to Match Storing and Querying Documents with Use the CDC Control task to performDataAfter completing this module, you will SQL Server 2014After completing this incremental data extractions in an ETLbe able to: module, you will be able to: solution.Describe how Data Quality Services can Describe the enhancements to Deploy and operate an SSIS project.help you manage data quality. Transact-SQL. Using Data Quality Services to CleanseUse Data Quality Services to cleanse your Describe new and enhanced Datadata. Transact-SQL functions. Using Data Quality Services to MatchUse Data Quality Services to match data. Describe the enhancements to Spatial DataAfter completing this module, you willImplementing a Master Data Services Model Data Support. be able to:Using the Master Data Services Add-in for Explain how to store and query Describe how Data Quality Services canExcelAfter completing this module, you will documents with SQL Server 2014. help you manage data quality.be able to: Columnstore Indexes Use Data Quality Services to cleanse yourDescribe key Master Data Services Memory-Optimized TablesAfter data.concepts. completing this module, you will be able Use Data Quality Services to match data.Implement a Master Data Services model. to: Implementing a Master Data ServicesUse Master Data Services tools to manage Use the Buffer Pool Extension to improve Modelmaster data. performance for read-heavy OLTP Using the Master Data Services Add-in forUse Master Data Services tools to create a workloads. ExcelAfter completing this module, you willmaster data hub. Use Columnstore Indexes to improve be able to:Reporting Services and Microsoft performance in data warehouse query Describe key Master Data ServicesSharePoint Server workloads. concepts.Introduction to Data AlertsAfter completing Use memory-optimized tables to improve Implement a Master Data Services model.this module, you will be able to: performance for latch-bound workloads. Use Master Data Services tools to manageDescribe the key capabilities of Reporting Using PowerShell to Manage SQL master data.Services. ServerAfter completing this module, you Use Master Data Services tools to create aInstall and configure Reporting Services in will be able to: master data hub.SharePoint Mode. Describe new and enhanced dynamic Reporting Services and MicrosoftUse data alerts to notify users of changes to management views. SharePoint Serverreport data. Describe how to use PowerShell to Introduction to Data AlertsAfter completingCreating a Tabular Model Manage SQL Server. this module, you will be able to:Using an Analysis Services Tabular Data Contained DatabasesAfter completing Describe the key capabilities of ReportingModel in the EnterpriseAfter completing this this module, you will be able to: Services.module, you will be able to: Describe the security enhancements in Install and configure Reporting Services inDescribe Analysis Services tabular data SQL Server 2014. SharePoint Mode.model projects. Explain how to use contained databases. Use data alerts to notify users of changesImplement an Analysis Services tabular data Enhancements to Data RecoveryAfter to report data.


model. completing this module, you will be able Creating a Tabular ModelUse an Analysis Services tabular data to: Using an Analysis Services Tabular Datamodel. Describe high availability features in SQL Model in the EnterpriseAfter completingPowerPivot for SharePoint Server Server 2014. this module, you will be able to:Power Query Describe data recovery enhancements in Describe Analysis Services tabular dataPower View SQL Server 2014. model projects.Power Map Deploying and Operating SSIS Implement an Analysis Services tabularPower BI for Office 365After completing this PackagesAfter completing this module, data model.module, you will be able to: you will be able to: Use an Analysis Services tabular dataUse PowerPivot to create tabular data Use the CDC Control task to perform model.models in Excel. incremental data extractions in an ETL PowerPivot for SharePoint ServerShare a PowerPivot workbooks in solution. Power QuerySharePoint Server. Deploy and operate an SSIS project. Power ViewUse Power Query to discover and import Using Data Quality Services to Cleanse Power Mapdata from multiple data sources into Excel. Data Power BI for Office 365After completingUse Power View to create interactive data Using Data Quality Services to Match this module, you will be able to:visualizations in Excel and SharePoint DataAfter completing this module, you Use PowerPivot to create tabular dataServer. will be able to: models in Excel.Use Power Map to create visualizations of Describe how Data Quality Services can Share a PowerPivot workbooks ingeographic data. help you manage data quality. SharePoint Server.Use Power BI for Office 365 to create a Use Data Quality Services to cleanse Use Power Query to discover and importcloud-based collaborative solution for your data. data from multiple data sources into Excel.self-service BI. Use Data Quality Services to match data. Use Power View to create interactive dataWindows Azure Services for DataAfter Implementing a Master Data Services visualizations in Excel and SharePointcompleting this module, you will be able to: Model Server.Describe key features and benefits of cloud Using the Master Data Services Add-in Use Power Map to create visualizations ofcomputing. for ExcelAfter completing this module, geographic data.Describe Windows Azure service for data. you will be able to: Use Power BI for Office 365 to create aWindows Azure SQL Database Security Describe key Master Data Services cloud-based collaborative solution forImplementing and Managing DatabasesAfter concepts. self-service BI.completing this module, you will be able to: Implement a Master Data Services Windows Azure Services for DataAfterDescribe key features and benefits of model. completing this module, you will be able to:Windows Azure SQL Database. Use Master Data Services tools to Describe key features and benefits ofImplement security for Windows Azure SQL manage master data. cloud computing.Database. Use Master Data Services tools to create Describe Windows Azure service for data.Implement and manage databases in a master data hub. Windows Azure SQL Database SecurityWindows Azure SQL Database. Reporting Services and Microsoft Implementing and ManagingWindows Azure Virtual Machine Connectivity SharePoint Server DatabasesAfter completing this module,and Security Introduction to Data AlertsAfter you will be able to:Creating Databases in a Windows Azure completing this module, you will be able Describe key features and benefits ofVirtual MachineAfter completing this to: Windows Azure SQL Database.module, you will be able to: Describe the key capabilities of Reporting Implement security for Windows AzureDescribe considerations for using Virtual Services. SQL Database.Machines in Windows Azure. Install and configure Reporting Services Implement and manage databases inCreate and configure Windows Azure virtual in SharePoint Mode. Windows Azure SQL Database.machines. Use data alerts to notify users of changes Windows Azure Virtual MachineCreate databases in Windows Azure virtual to report data. Connectivity and Securitymachines. Creating a Tabular Model Creating Databases in a Windows AzureWindows Azure HDInsight Using an Analysis Services Tabular Data Virtual MachineAfter completing thisConsuming HDInsight Results in Excel Model in the EnterpriseAfter completing module, you will be able to:Obtaining Data from the Windows Azure this module, you will be able to: Describe considerations for using VirtualMarketplaceAfter completing this module, Describe Analysis Services tabular data Machines in Windows Azure.you will be able to: model projects. Create and configure Windows AzureDescribe key features of big data. Implement an Analysis Services tabular virtual machines.Process big data with Windows Azure data model. Create databases in Windows AzureHDInsight. Use an Analysis Services tabular data virtual machines.Consume big data processing results from model. Windows Azure HDInsightWindows Azure HDInsight in Microsoft PowerPivot for SharePoint Server Consuming HDInsight Results in ExcelExcel. Power Query Obtaining Data from the Windows Azure

Power View MarketplaceAfter completing this module,Power Map you will be able to:

line Power BI for Office 365After completing Describe key features of big data.SQL Server 2014 Editions and Components this module, you will be able to: Process big data with Windows AzureInstalling SQL Server 2014 Use PowerPivot to create tabular data HDInsight.Enhancements to SQL Server Management models in Excel. Consume big data processing results fromStudioAfter completing this module, you will Share a PowerPivot workbooks in Windows Azure HDInsight in Microsoft


be able to: SharePoint Server. Excel.Describe the common workloads for SQL Use Power Query to discover and importServer 2014. data from multiple data sources intoDescribe the SQL Server 2014 Editions and Excel. lineComponents. Use Power View to create interactive SQL Server 2014 Editions andInstall SQL Server 2014 Components. data visualizations in Excel and ComponentsUse the new features in SQL Server SharePoint Server. Installing SQL Server 2014Management Studio. Use Power Map to create visualizations Enhancements to SQL ServerNew and Enhanced Transact-SQL Functions of geographic data. Management StudioAfter completing thisEnhancements to Spatial Data Support Use Power BI for Office 365 to create a module, you will be able to:Storing and Querying Documents with SQL cloud-based collaborative solution for Describe the common workloads for SQLServer 2014After completing this module, self-service BI. Server 2014.you will be able to: Windows Azure Services for DataAfter Describe the SQL Server 2014 EditionsDescribe the enhancements to completing this module, you will be able and Components.Transact-SQL. to: Install SQL Server 2014 Components.Describe new and enhanced Transact-SQL Describe key features and benefits of Use the new features in SQL Serverfunctions. cloud computing. Management Studio.Describe the enhancements to Spatial Data Describe Windows Azure service for New and Enhanced Transact-SQLSupport. data. FunctionsExplain how to store and query documents Windows Azure SQL Database Security Enhancements to Spatial Data Supportwith SQL Server 2014. Implementing and Managing Storing and Querying Documents with SQLColumnstore Indexes DatabasesAfter completing this module, Server 2014After completing this module,Memory-Optimized TablesAfter completing you will be able to: you will be able to:this module, you will be able to: Describe key features and benefits of Describe the enhancements toUse the Buffer Pool Extension to improve Windows Azure SQL Database. Transact-SQL.performance for read-heavy OLTP Implement security for Windows Azure Describe new and enhancedworkloads. SQL Database. Transact-SQL functions.Use Columnstore Indexes to improve Implement and manage databases in Describe the enhancements to Spatialperformance in data warehouse query Windows Azure SQL Database. Data Support.workloads. Windows Azure Virtual Machine Explain how to store and query documentsUse memory-optimized tables to improve Connectivity and Security with SQL Server 2014.performance for latch-bound workloads. Creating Databases in a Windows Azure Columnstore IndexesUsing PowerShell to Manage SQL Virtual MachineAfter completing this Memory-Optimized TablesAfter completingServerAfter completing this module, you will module, you will be able to: this module, you will be able to:be able to: Describe considerations for using Virtual Use the Buffer Pool Extension to improveDescribe new and enhanced dynamic Machines in Windows Azure. performance for read-heavy OLTPmanagement views. Create and configure Windows Azure workloads.Describe how to use PowerShell to Manage virtual machines. Use Columnstore Indexes to improveSQL Server. Create databases in Windows Azure performance in data warehouse queryContained DatabasesAfter completing this virtual machines. workloads.module, you will be able to: Windows Azure HDInsight Use memory-optimized tables to improveDescribe the security enhancements in SQL Consuming HDInsight Results in Excel performance for latch-bound workloads.Server 2014. Obtaining Data from the Windows Azure Using PowerShell to Manage SQLExplain how to use contained databases. MarketplaceAfter completing this module, ServerAfter completing this module, youEnhancements to Data RecoveryAfter you will be able to: will be able to:completing this module, you will be able to: Describe key features of big data. Describe new and enhanced dynamicDescribe high availability features in SQL Process big data with Windows Azure management views.Server 2014. HDInsight. Describe how to use PowerShell toDescribe data recovery enhancements in Consume big data processing results Manage SQL Server.SQL Server 2014. from Windows Azure HDInsight in Contained DatabasesAfter completing thisDeploying and Operating SSIS Microsoft Excel. module, you will be able to:PackagesAfter completing this module, you Describe the security enhancements inwill be able to: SQL Server 2014.Use the CDC Control task to perform line Explain how to use contained databases.incremental data extractions in an ETL SQL Server 2014 Editions and Enhancements to Data RecoveryAftersolution. Components completing this module, you will be able to:Deploy and operate an SSIS project. Installing SQL Server 2014 Describe high availability features in SQLUsing Data Quality Services to Cleanse Enhancements to SQL Server Server 2014.Data Management StudioAfter completing this Describe data recovery enhancements inUsing Data Quality Services to Match module, you will be able to: SQL Server 2014.DataAfter completing this module, you will Describe the common workloads for SQL Deploying and Operating SSISbe able to: Server 2014. PackagesAfter completing this module,Describe how Data Quality Services can Describe the SQL Server 2014 Editions you will be able to:help you manage data quality. and Components. Use the CDC Control task to performUse Data Quality Services to cleanse your Install SQL Server 2014 Components. incremental data extractions in an ETLdata. Use the new features in SQL Server solution.


Use Data Quality Services to match data. Management Studio. Deploy and operate an SSIS project.Implementing a Master Data Services Model New and Enhanced Transact-SQL Using Data Quality Services to CleanseUsing the Master Data Services Add-in for Functions DataExcelAfter completing this module, you will Enhancements to Spatial Data Support Using Data Quality Services to Matchbe able to: Storing and Querying Documents with DataAfter completing this module, you willDescribe key Master Data Services SQL Server 2014After completing this be able to:concepts. module, you will be able to: Describe how Data Quality Services canImplement a Master Data Services model. Describe the enhancements to help you manage data quality.Use Master Data Services tools to manage Transact-SQL. Use Data Quality Services to cleanse yourmaster data. Describe new and enhanced data.Use Master Data Services tools to create a Transact-SQL functions. Use Data Quality Services to match data.master data hub. Describe the enhancements to Spatial Implementing a Master Data ServicesReporting Services and Microsoft Data Support. ModelSharePoint Server Explain how to store and query Using the Master Data Services Add-in forIntroduction to Data AlertsAfter completing documents with SQL Server 2014. ExcelAfter completing this module, you willthis module, you will be able to: Columnstore Indexes be able to:Describe the key capabilities of Reporting Memory-Optimized TablesAfter Describe key Master Data ServicesServices. completing this module, you will be able concepts.Install and configure Reporting Services in to: Implement a Master Data Services model.SharePoint Mode. Use the Buffer Pool Extension to improve Use Master Data Services tools to manageUse data alerts to notify users of changes to performance for read-heavy OLTP master data.report data. workloads. Use Master Data Services tools to create aCreating a Tabular Model Use Columnstore Indexes to improve master data hub.Using an Analysis Services Tabular Data performance in data warehouse query Reporting Services and MicrosoftModel in the EnterpriseAfter completing this workloads. SharePoint Servermodule, you will be able to: Use memory-optimized tables to improve Introduction to Data AlertsAfter completingDescribe Analysis Services tabular data performance for latch-bound workloads. this module, you will be able to:model projects. Using PowerShell to Manage SQL Describe the key capabilities of ReportingImplement an Analysis Services tabular data ServerAfter completing this module, you Services.model. will be able to: Install and configure Reporting Services inUse an Analysis Services tabular data Describe new and enhanced dynamic SharePoint Mode.model. management views. Use data alerts to notify users of changesPowerPivot for SharePoint Server Describe how to use PowerShell to to report data.Power Query Manage SQL Server. Creating a Tabular ModelPower View Contained DatabasesAfter completing Using an Analysis Services Tabular DataPower Map this module, you will be able to: Model in the EnterpriseAfter completingPower BI for Office 365After completing this Describe the security enhancements in this module, you will be able to:module, you will be able to: SQL Server 2014. Describe Analysis Services tabular dataUse PowerPivot to create tabular data Explain how to use contained databases. model projects.models in Excel. Enhancements to Data RecoveryAfter Implement an Analysis Services tabularShare a PowerPivot workbooks in completing this module, you will be able data model.SharePoint Server. to: Use an Analysis Services tabular dataUse Power Query to discover and import Describe high availability features in SQL model.data from multiple data sources into Excel. Server 2014. PowerPivot for SharePoint ServerUse Power View to create interactive data Describe data recovery enhancements in Power Queryvisualizations in Excel and SharePoint SQL Server 2014. Power ViewServer. Deploying and Operating SSIS Power MapUse Power Map to create visualizations of PackagesAfter completing this module, Power BI for Office 365After completinggeographic data. you will be able to: this module, you will be able to:Use Power BI for Office 365 to create a Use the CDC Control task to perform Use PowerPivot to create tabular datacloud-based collaborative solution for incremental data extractions in an ETL models in Excel.self-service BI. solution. Share a PowerPivot workbooks inWindows Azure Services for DataAfter Deploy and operate an SSIS project. SharePoint Server.completing this module, you will be able to: Using Data Quality Services to Cleanse Use Power Query to discover and importDescribe key features and benefits of cloud Data data from multiple data sources into Excel.computing. Using Data Quality Services to Match Use Power View to create interactive dataDescribe Windows Azure service for data. DataAfter completing this module, you visualizations in Excel and SharePointWindows Azure SQL Database Security will be able to: Server.Implementing and Managing DatabasesAfter Describe how Data Quality Services can Use Power Map to create visualizations ofcompleting this module, you will be able to: help you manage data quality. geographic data.Describe key features and benefits of Use Data Quality Services to cleanse Use Power BI for Office 365 to create aWindows Azure SQL Database. your data. cloud-based collaborative solution forImplement security for Windows Azure SQL Use Data Quality Services to match data. self-service BI.Database. Implementing a Master Data Services Windows Azure Services for DataAfterImplement and manage databases in Model completing this module, you will be able to:Windows Azure SQL Database. Using the Master Data Services Add-in Describe key features and benefits of


Windows Azure Virtual Machine Connectivity for ExcelAfter completing this module, cloud computing.and Security you will be able to: Describe Windows Azure service for data.Creating Databases in a Windows Azure Describe key Master Data Services Windows Azure SQL Database SecurityVirtual MachineAfter completing this concepts. Implementing and Managingmodule, you will be able to: Implement a Master Data Services DatabasesAfter completing this module,Describe considerations for using Virtual model. you will be able to:Machines in Windows Azure. Use Master Data Services tools to Describe key features and benefits ofCreate and configure Windows Azure virtual manage master data. Windows Azure SQL Database.machines. Use Master Data Services tools to create Implement security for Windows AzureCreate databases in Windows Azure virtual a master data hub. SQL Database.machines. Reporting Services and Microsoft Implement and manage databases inWindows Azure HDInsight SharePoint Server Windows Azure SQL Database.Consuming HDInsight Results in Excel Introduction to Data AlertsAfter Windows Azure Virtual MachineObtaining Data from the Windows Azure completing this module, you will be able Connectivity and SecurityMarketplaceAfter completing this module, to: Creating Databases in a Windows Azureyou will be able to: Describe the key capabilities of Reporting Virtual MachineAfter completing thisDescribe key features of big data. Services. module, you will be able to:Process big data with Windows Azure Install and configure Reporting Services Describe considerations for using VirtualHDInsight. in SharePoint Mode. Machines in Windows Azure.Consume big data processing results from Use data alerts to notify users of changes Create and configure Windows AzureWindows Azure HDInsight in Microsoft to report data. virtual machines.Excel. Creating a Tabular Model Create databases in Windows Azure

Using an Analysis Services Tabular Data virtual machines.Model in the EnterpriseAfter completing Windows Azure HDInsight

line this module, you will be able to: Consuming HDInsight Results in ExcelSQL Server 2014 Editions and Components Describe Analysis Services tabular data Obtaining Data from the Windows AzureInstalling SQL Server 2014 model projects. MarketplaceAfter completing this module,Enhancements to SQL Server Management Implement an Analysis Services tabular you will be able to:StudioAfter completing this module, you will data model. Describe key features of big data.be able to: Use an Analysis Services tabular data Process big data with Windows AzureDescribe the common workloads for SQL model. HDInsight.Server 2014. PowerPivot for SharePoint Server Consume big data processing results fromDescribe the SQL Server 2014 Editions and Power Query Windows Azure HDInsight in MicrosoftComponents. Power View Excel.Install SQL Server 2014 Components. Power MapUse the new features in SQL Server Power BI for Office 365After completingManagement Studio. this module, you will be able to: lineNew and Enhanced Transact-SQL Functions Use PowerPivot to create tabular data SQL Server 2014 Editions andEnhancements to Spatial Data Support models in Excel. ComponentsStoring and Querying Documents with SQL Share a PowerPivot workbooks in Installing SQL Server 2014Server 2014After completing this module, SharePoint Server. Enhancements to SQL Serveryou will be able to: Use Power Query to discover and import Management StudioAfter completing thisDescribe the enhancements to data from multiple data sources into module, you will be able to:Transact-SQL. Excel. Describe the common workloads for SQLDescribe new and enhanced Transact-SQL Use Power View to create interactive Server 2014.functions. data visualizations in Excel and Describe the SQL Server 2014 EditionsDescribe the enhancements to Spatial Data SharePoint Server. and Components.Support. Use Power Map to create visualizations Install SQL Server 2014 Components.Explain how to store and query documents of geographic data. Use the new features in SQL Serverwith SQL Server 2014. Use Power BI for Office 365 to create a Management Studio.Columnstore Indexes cloud-based collaborative solution for New and Enhanced Transact-SQLMemory-Optimized TablesAfter completing self-service BI. Functionsthis module, you will be able to: Windows Azure Services for DataAfter Enhancements to Spatial Data SupportUse the Buffer Pool Extension to improve completing this module, you will be able Storing and Querying Documents with SQLperformance for read-heavy OLTP to: Server 2014After completing this module,workloads. Describe key features and benefits of you will be able to:Use Columnstore Indexes to improve cloud computing. Describe the enhancements toperformance in data warehouse query Describe Windows Azure service for Transact-SQL.workloads. data. Describe new and enhancedUse memory-optimized tables to improve Windows Azure SQL Database Security Transact-SQL functions.performance for latch-bound workloads. Implementing and Managing Describe the enhancements to SpatialUsing PowerShell to Manage SQL DatabasesAfter completing this module, Data Support.ServerAfter completing this module, you will you will be able to: Explain how to store and query documentsbe able to: Describe key features and benefits of with SQL Server 2014.Describe new and enhanced dynamic Windows Azure SQL Database. Columnstore Indexesmanagement views. Implement security for Windows Azure Memory-Optimized TablesAfter completing


Describe how to use PowerShell to Manage SQL Database. this module, you will be able to:SQL Server. Implement and manage databases in Use the Buffer Pool Extension to improveContained DatabasesAfter completing this Windows Azure SQL Database. performance for read-heavy OLTPmodule, you will be able to: Windows Azure Virtual Machine workloads.Describe the security enhancements in SQL Connectivity and Security Use Columnstore Indexes to improveServer 2014. Creating Databases in a Windows Azure performance in data warehouse queryExplain how to use contained databases. Virtual MachineAfter completing this workloads.Enhancements to Data RecoveryAfter module, you will be able to: Use memory-optimized tables to improvecompleting this module, you will be able to: Describe considerations for using Virtual performance for latch-bound workloads.Describe high availability features in SQL Machines in Windows Azure. Using PowerShell to Manage SQLServer 2014. Create and configure Windows Azure ServerAfter completing this module, youDescribe data recovery enhancements in virtual machines. will be able to:SQL Server 2014. Create databases in Windows Azure Describe new and enhanced dynamicDeploying and Operating SSIS virtual machines. management views.PackagesAfter completing this module, you Windows Azure HDInsight Describe how to use PowerShell towill be able to: Consuming HDInsight Results in Excel Manage SQL Server.Use the CDC Control task to perform Obtaining Data from the Windows Azure Contained DatabasesAfter completing thisincremental data extractions in an ETL MarketplaceAfter completing this module, module, you will be able to:solution. you will be able to: Describe the security enhancements inDeploy and operate an SSIS project. Describe key features of big data. SQL Server 2014.Using Data Quality Services to Cleanse Process big data with Windows Azure Explain how to use contained databases.Data HDInsight. Enhancements to Data RecoveryAfterUsing Data Quality Services to Match Consume big data processing results completing this module, you will be able to:DataAfter completing this module, you will from Windows Azure HDInsight in Describe high availability features in SQLbe able to: Microsoft Excel. Server 2014.Describe how Data Quality Services can Describe data recovery enhancements inhelp you manage data quality. SQL Server 2014.Use Data Quality Services to cleanse your line Deploying and Operating SSISdata. SQL Server 2014 Editions and PackagesAfter completing this module,Use Data Quality Services to match data. Components you will be able to:Implementing a Master Data Services Model Installing SQL Server 2014 Use the CDC Control task to performUsing the Master Data Services Add-in for Enhancements to SQL Server incremental data extractions in an ETLExcelAfter completing this module, you will Management StudioAfter completing this solution.be able to: module, you will be able to: Deploy and operate an SSIS project.Describe key Master Data Services Describe the common workloads for SQL Using Data Quality Services to Cleanseconcepts. Server 2014. DataImplement a Master Data Services model. Describe the SQL Server 2014 Editions Using Data Quality Services to MatchUse Master Data Services tools to manage and Components. DataAfter completing this module, you willmaster data. Install SQL Server 2014 Components. be able to:Use Master Data Services tools to create a Use the new features in SQL Server Describe how Data Quality Services canmaster data hub. Management Studio. help you manage data quality.Reporting Services and Microsoft New and Enhanced Transact-SQL Use Data Quality Services to cleanse yourSharePoint Server Functions data.Introduction to Data AlertsAfter completing Enhancements to Spatial Data Support Use Data Quality Services to match data.this module, you will be able to: Storing and Querying Documents with Implementing a Master Data ServicesDescribe the key capabilities of Reporting SQL Server 2014After completing this ModelServices. module, you will be able to: Using the Master Data Services Add-in forInstall and configure Reporting Services in Describe the enhancements to ExcelAfter completing this module, you willSharePoint Mode. Transact-SQL. be able to:Use data alerts to notify users of changes to Describe new and enhanced Describe key Master Data Servicesreport data. Transact-SQL functions. concepts.Creating a Tabular Model Describe the enhancements to Spatial Implement a Master Data Services model.Using an Analysis Services Tabular Data Data Support. Use Master Data Services tools to manageModel in the EnterpriseAfter completing this Explain how to store and query master data.module, you will be able to: documents with SQL Server 2014. Use Master Data Services tools to create aDescribe Analysis Services tabular data Columnstore Indexes master data hub.model projects. Memory-Optimized TablesAfter Reporting Services and MicrosoftImplement an Analysis Services tabular data completing this module, you will be able SharePoint Servermodel. to: Introduction to Data AlertsAfter completingUse an Analysis Services tabular data Use the Buffer Pool Extension to improve this module, you will be able to:model. performance for read-heavy OLTP Describe the key capabilities of ReportingPowerPivot for SharePoint Server workloads. Services.Power Query Use Columnstore Indexes to improve Install and configure Reporting Services inPower View performance in data warehouse query SharePoint Mode.Power Map workloads. Use data alerts to notify users of changesPower BI for Office 365After completing this Use memory-optimized tables to improve to report data.


module, you will be able to: performance for latch-bound workloads. Creating a Tabular ModelUse PowerPivot to create tabular data Using PowerShell to Manage SQL Using an Analysis Services Tabular Datamodels in Excel. ServerAfter completing this module, you Model in the EnterpriseAfter completingShare a PowerPivot workbooks in will be able to: this module, you will be able to:SharePoint Server. Describe new and enhanced dynamic Describe Analysis Services tabular dataUse Power Query to discover and import management views. model projects.data from multiple data sources into Excel. Describe how to use PowerShell to Implement an Analysis Services tabularUse Power View to create interactive data Manage SQL Server. data model.visualizations in Excel and SharePoint Contained DatabasesAfter completing Use an Analysis Services tabular dataServer. this module, you will be able to: model.Use Power Map to create visualizations of Describe the security enhancements in PowerPivot for SharePoint Servergeographic data. SQL Server 2014. Power QueryUse Power BI for Office 365 to create a Explain how to use contained databases. Power Viewcloud-based collaborative solution for Enhancements to Data RecoveryAfter Power Mapself-service BI. completing this module, you will be able Power BI for Office 365After completingWindows Azure Services for DataAfter to: this module, you will be able to:completing this module, you will be able to: Describe high availability features in SQL Use PowerPivot to create tabular dataDescribe key features and benefits of cloud Server 2014. models in Excel.computing. Describe data recovery enhancements in Share a PowerPivot workbooks inDescribe Windows Azure service for data. SQL Server 2014. SharePoint Server.Windows Azure SQL Database Security Deploying and Operating SSIS Use Power Query to discover and importImplementing and Managing DatabasesAfter PackagesAfter completing this module, data from multiple data sources into Excel.completing this module, you will be able to: you will be able to: Use Power View to create interactive dataDescribe key features and benefits of Use the CDC Control task to perform visualizations in Excel and SharePointWindows Azure SQL Database. incremental data extractions in an ETL Server.Implement security for Windows Azure SQL solution. Use Power Map to create visualizations ofDatabase. Deploy and operate an SSIS project. geographic data.Implement and manage databases in Using Data Quality Services to Cleanse Use Power BI for Office 365 to create aWindows Azure SQL Database. Data cloud-based collaborative solution forWindows Azure Virtual Machine Connectivity Using Data Quality Services to Match self-service BI.and Security DataAfter completing this module, you Windows Azure Services for DataAfterCreating Databases in a Windows Azure will be able to: completing this module, you will be able to:Virtual MachineAfter completing this Describe how Data Quality Services can Describe key features and benefits ofmodule, you will be able to: help you manage data quality. cloud computing.Describe considerations for using Virtual Use Data Quality Services to cleanse Describe Windows Azure service for data.Machines in Windows Azure. your data. Windows Azure SQL Database SecurityCreate and configure Windows Azure virtual Use Data Quality Services to match data. Implementing and Managingmachines. Implementing a Master Data Services DatabasesAfter completing this module,Create databases in Windows Azure virtual Model you will be able to:machines. Using the Master Data Services Add-in Describe key features and benefits ofWindows Azure HDInsight for ExcelAfter completing this module, Windows Azure SQL Database.Consuming HDInsight Results in Excel you will be able to: Implement security for Windows AzureObtaining Data from the Windows Azure Describe key Master Data Services SQL Database.MarketplaceAfter completing this module, concepts. Implement and manage databases inyou will be able to: Implement a Master Data Services Windows Azure SQL Database.Describe key features of big data. model. Windows Azure Virtual MachineProcess big data with Windows Azure Use Master Data Services tools to Connectivity and SecurityHDInsight. manage master data. Creating Databases in a Windows AzureConsume big data processing results from Use Master Data Services tools to create Virtual MachineAfter completing thisWindows Azure HDInsight in Microsoft a master data hub. module, you will be able to:Excel. Reporting Services and Microsoft Describe considerations for using Virtual

SharePoint Server Machines in Windows Azure.Module 2: What’s New in SQL Server Database Introduction to Data AlertsAfter Create and configure Windows AzureDevelopment completing this module, you will be able virtual machines.line to: Create databases in Windows Azure

Describe the key capabilities of Reporting virtual machines.This module describes enhancements to Services. Windows Azure HDInsightTransact-SQL and other database development Install and configure Reporting Services Consuming HDInsight Results in Excelfeatures since SQL Server 2008. in SharePoint Mode. Obtaining Data from the Windows Azureline Use data alerts to notify users of changes MarketplaceAfter completing this module,

Transact-SQL Enhancements to report data. you will be able to:Creating a Tabular Model Describe key features of big data.Using an Analysis Services Tabular Data Process big data with Windows Azure

line Model in the EnterpriseAfter completing HDInsight.SQL Server 2014 Editions and Components this module, you will be able to: Consume big data processing results fromInstalling SQL Server 2014 Describe Analysis Services tabular data Windows Azure HDInsight in Microsoft


Enhancements to SQL Server Management model projects. Excel.StudioAfter completing this module, you will Implement an Analysis Services tabularbe able to: data model.Describe the common workloads for SQL Use an Analysis Services tabular data lineServer 2014. model. SQL Server 2014 Editions andDescribe the SQL Server 2014 Editions and PowerPivot for SharePoint Server ComponentsComponents. Power Query Installing SQL Server 2014Install SQL Server 2014 Components. Power View Enhancements to SQL ServerUse the new features in SQL Server Power Map Management StudioAfter completing thisManagement Studio. Power BI for Office 365After completing module, you will be able to:New and Enhanced Transact-SQL Functions this module, you will be able to: Describe the common workloads for SQLEnhancements to Spatial Data Support Use PowerPivot to create tabular data Server 2014.Storing and Querying Documents with SQL models in Excel. Describe the SQL Server 2014 EditionsServer 2014After completing this module, Share a PowerPivot workbooks in and Components.you will be able to: SharePoint Server. Install SQL Server 2014 Components.Describe the enhancements to Use Power Query to discover and import Use the new features in SQL ServerTransact-SQL. data from multiple data sources into Management Studio.Describe new and enhanced Transact-SQL Excel. New and Enhanced Transact-SQLfunctions. Use Power View to create interactive FunctionsDescribe the enhancements to Spatial Data data visualizations in Excel and Enhancements to Spatial Data SupportSupport. SharePoint Server. Storing and Querying Documents with SQLExplain how to store and query documents Use Power Map to create visualizations Server 2014After completing this module,with SQL Server 2014. of geographic data. you will be able to:Columnstore Indexes Use Power BI for Office 365 to create a Describe the enhancements toMemory-Optimized TablesAfter completing cloud-based collaborative solution for Transact-SQL.this module, you will be able to: self-service BI. Describe new and enhancedUse the Buffer Pool Extension to improve Windows Azure Services for DataAfter Transact-SQL functions.performance for read-heavy OLTP completing this module, you will be able Describe the enhancements to Spatialworkloads. to: Data Support.Use Columnstore Indexes to improve Describe key features and benefits of Explain how to store and query documentsperformance in data warehouse query cloud computing. with SQL Server 2014.workloads. Describe Windows Azure service for Columnstore IndexesUse memory-optimized tables to improve data. Memory-Optimized TablesAfter completingperformance for latch-bound workloads. Windows Azure SQL Database Security this module, you will be able to:Using PowerShell to Manage SQL Implementing and Managing Use the Buffer Pool Extension to improveServerAfter completing this module, you will DatabasesAfter completing this module, performance for read-heavy OLTPbe able to: you will be able to: workloads.Describe new and enhanced dynamic Describe key features and benefits of Use Columnstore Indexes to improvemanagement views. Windows Azure SQL Database. performance in data warehouse queryDescribe how to use PowerShell to Manage Implement security for Windows Azure workloads.SQL Server. SQL Database. Use memory-optimized tables to improveContained DatabasesAfter completing this Implement and manage databases in performance for latch-bound workloads.module, you will be able to: Windows Azure SQL Database. Using PowerShell to Manage SQLDescribe the security enhancements in SQL Windows Azure Virtual Machine ServerAfter completing this module, youServer 2014. Connectivity and Security will be able to:Explain how to use contained databases. Creating Databases in a Windows Azure Describe new and enhanced dynamicEnhancements to Data RecoveryAfter Virtual MachineAfter completing this management views.completing this module, you will be able to: module, you will be able to: Describe how to use PowerShell toDescribe high availability features in SQL Describe considerations for using Virtual Manage SQL Server.Server 2014. Machines in Windows Azure. Contained DatabasesAfter completing thisDescribe data recovery enhancements in Create and configure Windows Azure module, you will be able to:SQL Server 2014. virtual machines. Describe the security enhancements inDeploying and Operating SSIS Create databases in Windows Azure SQL Server 2014.PackagesAfter completing this module, you virtual machines. Explain how to use contained databases.will be able to: Windows Azure HDInsight Enhancements to Data RecoveryAfterUse the CDC Control task to perform Consuming HDInsight Results in Excel completing this module, you will be able to:incremental data extractions in an ETL Obtaining Data from the Windows Azure Describe high availability features in SQLsolution. MarketplaceAfter completing this module, Server 2014.Deploy and operate an SSIS project. you will be able to: Describe data recovery enhancements inUsing Data Quality Services to Cleanse Describe key features of big data. SQL Server 2014.Data Process big data with Windows Azure Deploying and Operating SSISUsing Data Quality Services to Match HDInsight. PackagesAfter completing this module,DataAfter completing this module, you will Consume big data processing results you will be able to:be able to: from Windows Azure HDInsight in Use the CDC Control task to performDescribe how Data Quality Services can Microsoft Excel. incremental data extractions in an ETLhelp you manage data quality. solution.


Use Data Quality Services to cleanse your Deploy and operate an SSIS project.data. line Using Data Quality Services to CleanseUse Data Quality Services to match data. SQL Server 2014 Editions and DataImplementing a Master Data Services Model Components Using Data Quality Services to MatchUsing the Master Data Services Add-in for Installing SQL Server 2014 DataAfter completing this module, you willExcelAfter completing this module, you will Enhancements to SQL Server be able to:be able to: Management StudioAfter completing this Describe how Data Quality Services canDescribe key Master Data Services module, you will be able to: help you manage data quality.concepts. Describe the common workloads for SQL Use Data Quality Services to cleanse yourImplement a Master Data Services model. Server 2014. data.Use Master Data Services tools to manage Describe the SQL Server 2014 Editions Use Data Quality Services to match data.master data. and Components. Implementing a Master Data ServicesUse Master Data Services tools to create a Install SQL Server 2014 Components. Modelmaster data hub. Use the new features in SQL Server Using the Master Data Services Add-in forReporting Services and Microsoft Management Studio. ExcelAfter completing this module, you willSharePoint Server New and Enhanced Transact-SQL be able to:Introduction to Data AlertsAfter completing Functions Describe key Master Data Servicesthis module, you will be able to: Enhancements to Spatial Data Support concepts.Describe the key capabilities of Reporting Storing and Querying Documents with Implement a Master Data Services model.Services. SQL Server 2014After completing this Use Master Data Services tools to manageInstall and configure Reporting Services in module, you will be able to: master data.SharePoint Mode. Describe the enhancements to Use Master Data Services tools to create aUse data alerts to notify users of changes to Transact-SQL. master data hub.report data. Describe new and enhanced Reporting Services and MicrosoftCreating a Tabular Model Transact-SQL functions. SharePoint ServerUsing an Analysis Services Tabular Data Describe the enhancements to Spatial Introduction to Data AlertsAfter completingModel in the EnterpriseAfter completing this Data Support. this module, you will be able to:module, you will be able to: Explain how to store and query Describe the key capabilities of ReportingDescribe Analysis Services tabular data documents with SQL Server 2014. Services.model projects. Columnstore Indexes Install and configure Reporting Services inImplement an Analysis Services tabular data Memory-Optimized TablesAfter SharePoint Mode.model. completing this module, you will be able Use data alerts to notify users of changesUse an Analysis Services tabular data to: to report data.model. Use the Buffer Pool Extension to improve Creating a Tabular ModelPowerPivot for SharePoint Server performance for read-heavy OLTP Using an Analysis Services Tabular DataPower Query workloads. Model in the EnterpriseAfter completingPower View Use Columnstore Indexes to improve this module, you will be able to:Power Map performance in data warehouse query Describe Analysis Services tabular dataPower BI for Office 365After completing this workloads. model projects.module, you will be able to: Use memory-optimized tables to improve Implement an Analysis Services tabularUse PowerPivot to create tabular data performance for latch-bound workloads. data model.models in Excel. Using PowerShell to Manage SQL Use an Analysis Services tabular dataShare a PowerPivot workbooks in ServerAfter completing this module, you model.SharePoint Server. will be able to: PowerPivot for SharePoint ServerUse Power Query to discover and import Describe new and enhanced dynamic Power Querydata from multiple data sources into Excel. management views. Power ViewUse Power View to create interactive data Describe how to use PowerShell to Power Mapvisualizations in Excel and SharePoint Manage SQL Server. Power BI for Office 365After completingServer. Contained DatabasesAfter completing this module, you will be able to:Use Power Map to create visualizations of this module, you will be able to: Use PowerPivot to create tabular datageographic data. Describe the security enhancements in models in Excel.Use Power BI for Office 365 to create a SQL Server 2014. Share a PowerPivot workbooks incloud-based collaborative solution for Explain how to use contained databases. SharePoint Server.self-service BI. Enhancements to Data RecoveryAfter Use Power Query to discover and importWindows Azure Services for DataAfter completing this module, you will be able data from multiple data sources into Excel.completing this module, you will be able to: to: Use Power View to create interactive dataDescribe key features and benefits of cloud Describe high availability features in SQL visualizations in Excel and SharePointcomputing. Server 2014. Server.Describe Windows Azure service for data. Describe data recovery enhancements in Use Power Map to create visualizations ofWindows Azure SQL Database Security SQL Server 2014. geographic data.Implementing and Managing DatabasesAfter Deploying and Operating SSIS Use Power BI for Office 365 to create acompleting this module, you will be able to: PackagesAfter completing this module, cloud-based collaborative solution forDescribe key features and benefits of you will be able to: self-service BI.Windows Azure SQL Database. Use the CDC Control task to perform Windows Azure Services for DataAfterImplement security for Windows Azure SQL incremental data extractions in an ETL completing this module, you will be able to:Database. solution. Describe key features and benefits of


Implement and manage databases in Deploy and operate an SSIS project. cloud computing.Windows Azure SQL Database. Using Data Quality Services to Cleanse Describe Windows Azure service for data.Windows Azure Virtual Machine Connectivity Data Windows Azure SQL Database Securityand Security Using Data Quality Services to Match Implementing and ManagingCreating Databases in a Windows Azure DataAfter completing this module, you DatabasesAfter completing this module,Virtual MachineAfter completing this will be able to: you will be able to:module, you will be able to: Describe how Data Quality Services can Describe key features and benefits ofDescribe considerations for using Virtual help you manage data quality. Windows Azure SQL Database.Machines in Windows Azure. Use Data Quality Services to cleanse Implement security for Windows AzureCreate and configure Windows Azure virtual your data. SQL Database.machines. Use Data Quality Services to match data. Implement and manage databases inCreate databases in Windows Azure virtual Implementing a Master Data Services Windows Azure SQL Database.machines. Model Windows Azure Virtual MachineWindows Azure HDInsight Using the Master Data Services Add-in Connectivity and SecurityConsuming HDInsight Results in Excel for ExcelAfter completing this module, Creating Databases in a Windows AzureObtaining Data from the Windows Azure you will be able to: Virtual MachineAfter completing thisMarketplaceAfter completing this module, Describe key Master Data Services module, you will be able to:you will be able to: concepts. Describe considerations for using VirtualDescribe key features of big data. Implement a Master Data Services Machines in Windows Azure.Process big data with Windows Azure model. Create and configure Windows AzureHDInsight. Use Master Data Services tools to virtual machines.Consume big data processing results from manage master data. Create databases in Windows AzureWindows Azure HDInsight in Microsoft Use Master Data Services tools to create virtual machines.Excel. a master data hub. Windows Azure HDInsight

Reporting Services and Microsoft Consuming HDInsight Results in ExcelSharePoint Server Obtaining Data from the Windows Azure

line Introduction to Data AlertsAfter MarketplaceAfter completing this module,SQL Server 2014 Editions and Components completing this module, you will be able you will be able to:Installing SQL Server 2014 to: Describe key features of big data.Enhancements to SQL Server Management Describe the key capabilities of Reporting Process big data with Windows AzureStudioAfter completing this module, you will Services. HDInsight.be able to: Install and configure Reporting Services Consume big data processing results fromDescribe the common workloads for SQL in SharePoint Mode. Windows Azure HDInsight in MicrosoftServer 2014. Use data alerts to notify users of changes Excel.Describe the SQL Server 2014 Editions and to report data.Components. Creating a Tabular ModelInstall SQL Server 2014 Components. Using an Analysis Services Tabular Data lineUse the new features in SQL Server Model in the EnterpriseAfter completing SQL Server 2014 Editions andManagement Studio. this module, you will be able to: ComponentsNew and Enhanced Transact-SQL Functions Describe Analysis Services tabular data Installing SQL Server 2014Enhancements to Spatial Data Support model projects. Enhancements to SQL ServerStoring and Querying Documents with SQL Implement an Analysis Services tabular Management StudioAfter completing thisServer 2014After completing this module, data model. module, you will be able to:you will be able to: Use an Analysis Services tabular data Describe the common workloads for SQLDescribe the enhancements to model. Server 2014.Transact-SQL. PowerPivot for SharePoint Server Describe the SQL Server 2014 EditionsDescribe new and enhanced Transact-SQL Power Query and Components.functions. Power View Install SQL Server 2014 Components.Describe the enhancements to Spatial Data Power Map Use the new features in SQL ServerSupport. Power BI for Office 365After completing Management Studio.Explain how to store and query documents this module, you will be able to: New and Enhanced Transact-SQLwith SQL Server 2014. Use PowerPivot to create tabular data FunctionsColumnstore Indexes models in Excel. Enhancements to Spatial Data SupportMemory-Optimized TablesAfter completing Share a PowerPivot workbooks in Storing and Querying Documents with SQLthis module, you will be able to: SharePoint Server. Server 2014After completing this module,Use the Buffer Pool Extension to improve Use Power Query to discover and import you will be able to:performance for read-heavy OLTP data from multiple data sources into Describe the enhancements toworkloads. Excel. Transact-SQL.Use Columnstore Indexes to improve Use Power View to create interactive Describe new and enhancedperformance in data warehouse query data visualizations in Excel and Transact-SQL functions.workloads. SharePoint Server. Describe the enhancements to SpatialUse memory-optimized tables to improve Use Power Map to create visualizations Data Support.performance for latch-bound workloads. of geographic data. Explain how to store and query documentsUsing PowerShell to Manage SQL Use Power BI for Office 365 to create a with SQL Server 2014.ServerAfter completing this module, you will cloud-based collaborative solution for Columnstore Indexesbe able to: self-service BI. Memory-Optimized TablesAfter completing


Describe new and enhanced dynamic Windows Azure Services for DataAfter this module, you will be able to:management views. completing this module, you will be able Use the Buffer Pool Extension to improveDescribe how to use PowerShell to Manage to: performance for read-heavy OLTPSQL Server. Describe key features and benefits of workloads.Contained DatabasesAfter completing this cloud computing. Use Columnstore Indexes to improvemodule, you will be able to: Describe Windows Azure service for performance in data warehouse queryDescribe the security enhancements in SQL data. workloads.Server 2014. Windows Azure SQL Database Security Use memory-optimized tables to improveExplain how to use contained databases. Implementing and Managing performance for latch-bound workloads.Enhancements to Data RecoveryAfter DatabasesAfter completing this module, Using PowerShell to Manage SQLcompleting this module, you will be able to: you will be able to: ServerAfter completing this module, youDescribe high availability features in SQL Describe key features and benefits of will be able to:Server 2014. Windows Azure SQL Database. Describe new and enhanced dynamicDescribe data recovery enhancements in Implement security for Windows Azure management views.SQL Server 2014. SQL Database. Describe how to use PowerShell toDeploying and Operating SSIS Implement and manage databases in Manage SQL Server.PackagesAfter completing this module, you Windows Azure SQL Database. Contained DatabasesAfter completing thiswill be able to: Windows Azure Virtual Machine module, you will be able to:Use the CDC Control task to perform Connectivity and Security Describe the security enhancements inincremental data extractions in an ETL Creating Databases in a Windows Azure SQL Server 2014.solution. Virtual MachineAfter completing this Explain how to use contained databases.Deploy and operate an SSIS project. module, you will be able to: Enhancements to Data RecoveryAfterUsing Data Quality Services to Cleanse Describe considerations for using Virtual completing this module, you will be able to:Data Machines in Windows Azure. Describe high availability features in SQLUsing Data Quality Services to Match Create and configure Windows Azure Server 2014.DataAfter completing this module, you will virtual machines. Describe data recovery enhancements inbe able to: Create databases in Windows Azure SQL Server 2014.Describe how Data Quality Services can virtual machines. Deploying and Operating SSIShelp you manage data quality. Windows Azure HDInsight PackagesAfter completing this module,Use Data Quality Services to cleanse your Consuming HDInsight Results in Excel you will be able to:data. Obtaining Data from the Windows Azure Use the CDC Control task to performUse Data Quality Services to match data. MarketplaceAfter completing this module, incremental data extractions in an ETLImplementing a Master Data Services Model you will be able to: solution.Using the Master Data Services Add-in for Describe key features of big data. Deploy and operate an SSIS project.ExcelAfter completing this module, you will Process big data with Windows Azure Using Data Quality Services to Cleansebe able to: HDInsight. DataDescribe key Master Data Services Consume big data processing results Using Data Quality Services to Matchconcepts. from Windows Azure HDInsight in DataAfter completing this module, you willImplement a Master Data Services model. Microsoft Excel. be able to:Use Master Data Services tools to manage Describe how Data Quality Services canmaster data. Module 9: Master Data Services help you manage data quality.Use Master Data Services tools to create a line Use Data Quality Services to cleanse yourmaster data hub. data.Reporting Services and Microsoft This module introduces Master Data Services Use Data Quality Services to match data.SharePoint Server and describes its key configuration options Implementing a Master Data ServicesIntroduction to Data AlertsAfter completing and how to import and export data. Modelthis module, you will be able to: line Using the Master Data Services Add-in forDescribe the key capabilities of Reporting Introduction to Master Data Services ExcelAfter completing this module, you willServices. be able to:Install and configure Reporting Services in Describe key Master Data ServicesSharePoint Mode. line concepts.Use data alerts to notify users of changes to SQL Server 2014 Editions and Implement a Master Data Services model.report data. Components Use Master Data Services tools to manageCreating a Tabular Model Installing SQL Server 2014 master data.Using an Analysis Services Tabular Data Enhancements to SQL Server Use Master Data Services tools to create aModel in the EnterpriseAfter completing this Management StudioAfter completing this master data hub.module, you will be able to: module, you will be able to: Reporting Services and MicrosoftDescribe Analysis Services tabular data Describe the common workloads for SQL SharePoint Servermodel projects. Server 2014. Introduction to Data AlertsAfter completingImplement an Analysis Services tabular data Describe the SQL Server 2014 Editions this module, you will be able to:model. and Components. Describe the key capabilities of ReportingUse an Analysis Services tabular data Install SQL Server 2014 Components. Services.model. Use the new features in SQL Server Install and configure Reporting Services inPowerPivot for SharePoint Server Management Studio. SharePoint Mode.Power Query New and Enhanced Transact-SQL Use data alerts to notify users of changesPower View Functions to report data.


Power Map Enhancements to Spatial Data Support Creating a Tabular ModelPower BI for Office 365After completing this Storing and Querying Documents with Using an Analysis Services Tabular Datamodule, you will be able to: SQL Server 2014After completing this Model in the EnterpriseAfter completingUse PowerPivot to create tabular data module, you will be able to: this module, you will be able to:models in Excel. Describe the enhancements to Describe Analysis Services tabular dataShare a PowerPivot workbooks in Transact-SQL. model projects.SharePoint Server. Describe new and enhanced Implement an Analysis Services tabularUse Power Query to discover and import Transact-SQL functions. data model.data from multiple data sources into Excel. Describe the enhancements to Spatial Use an Analysis Services tabular dataUse Power View to create interactive data Data Support. model.visualizations in Excel and SharePoint Explain how to store and query PowerPivot for SharePoint ServerServer. documents with SQL Server 2014. Power QueryUse Power Map to create visualizations of Columnstore Indexes Power Viewgeographic data. Memory-Optimized TablesAfter Power MapUse Power BI for Office 365 to create a completing this module, you will be able Power BI for Office 365After completingcloud-based collaborative solution for to: this module, you will be able to:self-service BI. Use the Buffer Pool Extension to improve Use PowerPivot to create tabular dataWindows Azure Services for DataAfter performance for read-heavy OLTP models in Excel.completing this module, you will be able to: workloads. Share a PowerPivot workbooks inDescribe key features and benefits of cloud Use Columnstore Indexes to improve SharePoint Server.computing. performance in data warehouse query Use Power Query to discover and importDescribe Windows Azure service for data. workloads. data from multiple data sources into Excel.Windows Azure SQL Database Security Use memory-optimized tables to improve Use Power View to create interactive dataImplementing and Managing DatabasesAfter performance for latch-bound workloads. visualizations in Excel and SharePointcompleting this module, you will be able to: Using PowerShell to Manage SQL Server.Describe key features and benefits of ServerAfter completing this module, you Use Power Map to create visualizations ofWindows Azure SQL Database. will be able to: geographic data.Implement security for Windows Azure SQL Describe new and enhanced dynamic Use Power BI for Office 365 to create aDatabase. management views. cloud-based collaborative solution forImplement and manage databases in Describe how to use PowerShell to self-service BI.Windows Azure SQL Database. Manage SQL Server. Windows Azure Services for DataAfterWindows Azure Virtual Machine Connectivity Contained DatabasesAfter completing completing this module, you will be able to:and Security this module, you will be able to: Describe key features and benefits ofCreating Databases in a Windows Azure Describe the security enhancements in cloud computing.Virtual MachineAfter completing this SQL Server 2014. Describe Windows Azure service for data.module, you will be able to: Explain how to use contained databases. Windows Azure SQL Database SecurityDescribe considerations for using Virtual Enhancements to Data RecoveryAfter Implementing and ManagingMachines in Windows Azure. completing this module, you will be able DatabasesAfter completing this module,Create and configure Windows Azure virtual to: you will be able to:machines. Describe high availability features in SQL Describe key features and benefits ofCreate databases in Windows Azure virtual Server 2014. Windows Azure SQL Database.machines. Describe data recovery enhancements in Implement security for Windows AzureWindows Azure HDInsight SQL Server 2014. SQL Database.Consuming HDInsight Results in Excel Deploying and Operating SSIS Implement and manage databases inObtaining Data from the Windows Azure PackagesAfter completing this module, Windows Azure SQL Database.MarketplaceAfter completing this module, you will be able to: Windows Azure Virtual Machineyou will be able to: Use the CDC Control task to perform Connectivity and SecurityDescribe key features of big data. incremental data extractions in an ETL Creating Databases in a Windows AzureProcess big data with Windows Azure solution. Virtual MachineAfter completing thisHDInsight. Deploy and operate an SSIS project. module, you will be able to:Consume big data processing results from Using Data Quality Services to Cleanse Describe considerations for using VirtualWindows Azure HDInsight in Microsoft Data Machines in Windows Azure.Excel. Using Data Quality Services to Match Create and configure Windows Azure

DataAfter completing this module, you virtual machines.will be able to: Create databases in Windows Azure

line Describe how Data Quality Services can virtual machines.SQL Server 2014 Editions and Components help you manage data quality. Windows Azure HDInsightInstalling SQL Server 2014 Use Data Quality Services to cleanse Consuming HDInsight Results in ExcelEnhancements to SQL Server Management your data. Obtaining Data from the Windows AzureStudioAfter completing this module, you will Use Data Quality Services to match data. MarketplaceAfter completing this module,be able to: Implementing a Master Data Services you will be able to:Describe the common workloads for SQL Model Describe key features of big data.Server 2014. Using the Master Data Services Add-in Process big data with Windows AzureDescribe the SQL Server 2014 Editions and for ExcelAfter completing this module, HDInsight.Components. you will be able to: Consume big data processing results fromInstall SQL Server 2014 Components. Describe key Master Data Services Windows Azure HDInsight in Microsoft


Use the new features in SQL Server concepts. Excel.Management Studio. Implement a Master Data ServicesNew and Enhanced Transact-SQL Functions model.Enhancements to Spatial Data Support Use Master Data Services tools to lineStoring and Querying Documents with SQL manage master data. SQL Server 2014 Editions andServer 2014After completing this module, Use Master Data Services tools to create Componentsyou will be able to: a master data hub. Installing SQL Server 2014Describe the enhancements to Reporting Services and Microsoft Enhancements to SQL ServerTransact-SQL. SharePoint Server Management StudioAfter completing thisDescribe new and enhanced Transact-SQL Introduction to Data AlertsAfter module, you will be able to:functions. completing this module, you will be able Describe the common workloads for SQLDescribe the enhancements to Spatial Data to: Server 2014.Support. Describe the key capabilities of Reporting Describe the SQL Server 2014 EditionsExplain how to store and query documents Services. and Components.with SQL Server 2014. Install and configure Reporting Services Install SQL Server 2014 Components.Columnstore Indexes in SharePoint Mode. Use the new features in SQL ServerMemory-Optimized TablesAfter completing Use data alerts to notify users of changes Management Studio.this module, you will be able to: to report data. New and Enhanced Transact-SQLUse the Buffer Pool Extension to improve Creating a Tabular Model Functionsperformance for read-heavy OLTP Using an Analysis Services Tabular Data Enhancements to Spatial Data Supportworkloads. Model in the EnterpriseAfter completing Storing and Querying Documents with SQLUse Columnstore Indexes to improve this module, you will be able to: Server 2014After completing this module,performance in data warehouse query Describe Analysis Services tabular data you will be able to:workloads. model projects. Describe the enhancements toUse memory-optimized tables to improve Implement an Analysis Services tabular Transact-SQL.performance for latch-bound workloads. data model. Describe new and enhancedUsing PowerShell to Manage SQL Use an Analysis Services tabular data Transact-SQL functions.ServerAfter completing this module, you will model. Describe the enhancements to Spatialbe able to: PowerPivot for SharePoint Server Data Support.Describe new and enhanced dynamic Power Query Explain how to store and query documentsmanagement views. Power View with SQL Server 2014.Describe how to use PowerShell to Manage Power Map Columnstore IndexesSQL Server. Power BI for Office 365After completing Memory-Optimized TablesAfter completingContained DatabasesAfter completing this this module, you will be able to: this module, you will be able to:module, you will be able to: Use PowerPivot to create tabular data Use the Buffer Pool Extension to improveDescribe the security enhancements in SQL models in Excel. performance for read-heavy OLTPServer 2014. Share a PowerPivot workbooks in workloads.Explain how to use contained databases. SharePoint Server. Use Columnstore Indexes to improveEnhancements to Data RecoveryAfter Use Power Query to discover and import performance in data warehouse querycompleting this module, you will be able to: data from multiple data sources into workloads.Describe high availability features in SQL Excel. Use memory-optimized tables to improveServer 2014. Use Power View to create interactive performance for latch-bound workloads.Describe data recovery enhancements in data visualizations in Excel and Using PowerShell to Manage SQLSQL Server 2014. SharePoint Server. ServerAfter completing this module, youDeploying and Operating SSIS Use Power Map to create visualizations will be able to:PackagesAfter completing this module, you of geographic data. Describe new and enhanced dynamicwill be able to: Use Power BI for Office 365 to create a management views.Use the CDC Control task to perform cloud-based collaborative solution for Describe how to use PowerShell toincremental data extractions in an ETL self-service BI. Manage SQL Server.solution. Windows Azure Services for DataAfter Contained DatabasesAfter completing thisDeploy and operate an SSIS project. completing this module, you will be able module, you will be able to:Using Data Quality Services to Cleanse to: Describe the security enhancements inData Describe key features and benefits of SQL Server 2014.Using Data Quality Services to Match cloud computing. Explain how to use contained databases.DataAfter completing this module, you will Describe Windows Azure service for Enhancements to Data RecoveryAfterbe able to: data. completing this module, you will be able to:Describe how Data Quality Services can Windows Azure SQL Database Security Describe high availability features in SQLhelp you manage data quality. Implementing and Managing Server 2014.Use Data Quality Services to cleanse your DatabasesAfter completing this module, Describe data recovery enhancements indata. you will be able to: SQL Server 2014.Use Data Quality Services to match data. Describe key features and benefits of Deploying and Operating SSISImplementing a Master Data Services Model Windows Azure SQL Database. PackagesAfter completing this module,Using the Master Data Services Add-in for Implement security for Windows Azure you will be able to:ExcelAfter completing this module, you will SQL Database. Use the CDC Control task to performbe able to: Implement and manage databases in incremental data extractions in an ETLDescribe key Master Data Services Windows Azure SQL Database. solution.


concepts. Windows Azure Virtual Machine Deploy and operate an SSIS project.Implement a Master Data Services model. Connectivity and Security Using Data Quality Services to CleanseUse Master Data Services tools to manage Creating Databases in a Windows Azure Datamaster data. Virtual MachineAfter completing this Using Data Quality Services to MatchUse Master Data Services tools to create a module, you will be able to: DataAfter completing this module, you willmaster data hub. Describe considerations for using Virtual be able to:Reporting Services and Microsoft Machines in Windows Azure. Describe how Data Quality Services canSharePoint Server Create and configure Windows Azure help you manage data quality.Introduction to Data AlertsAfter completing virtual machines. Use Data Quality Services to cleanse yourthis module, you will be able to: Create databases in Windows Azure data.Describe the key capabilities of Reporting virtual machines. Use Data Quality Services to match data.Services. Windows Azure HDInsight Implementing a Master Data ServicesInstall and configure Reporting Services in Consuming HDInsight Results in Excel ModelSharePoint Mode. Obtaining Data from the Windows Azure Using the Master Data Services Add-in forUse data alerts to notify users of changes to MarketplaceAfter completing this module, ExcelAfter completing this module, you willreport data. you will be able to: be able to:Creating a Tabular Model Describe key features of big data. Describe key Master Data ServicesUsing an Analysis Services Tabular Data Process big data with Windows Azure concepts.Model in the EnterpriseAfter completing this HDInsight. Implement a Master Data Services model.module, you will be able to: Consume big data processing results Use Master Data Services tools to manageDescribe Analysis Services tabular data from Windows Azure HDInsight in master data.model projects. Microsoft Excel. Use Master Data Services tools to create aImplement an Analysis Services tabular data master data hub.model. Reporting Services and MicrosoftUse an Analysis Services tabular data line SharePoint Servermodel. SQL Server 2014 Editions and Introduction to Data AlertsAfter completingPowerPivot for SharePoint Server Components this module, you will be able to:Power Query Installing SQL Server 2014 Describe the key capabilities of ReportingPower View Enhancements to SQL Server Services.Power Map Management StudioAfter completing this Install and configure Reporting Services inPower BI for Office 365After completing this module, you will be able to: SharePoint Mode.module, you will be able to: Describe the common workloads for SQL Use data alerts to notify users of changesUse PowerPivot to create tabular data Server 2014. to report data.models in Excel. Describe the SQL Server 2014 Editions Creating a Tabular ModelShare a PowerPivot workbooks in and Components. Using an Analysis Services Tabular DataSharePoint Server. Install SQL Server 2014 Components. Model in the EnterpriseAfter completingUse Power Query to discover and import Use the new features in SQL Server this module, you will be able to:data from multiple data sources into Excel. Management Studio. Describe Analysis Services tabular dataUse Power View to create interactive data New and Enhanced Transact-SQL model projects.visualizations in Excel and SharePoint Functions Implement an Analysis Services tabularServer. Enhancements to Spatial Data Support data model.Use Power Map to create visualizations of Storing and Querying Documents with Use an Analysis Services tabular datageographic data. SQL Server 2014After completing this model.Use Power BI for Office 365 to create a module, you will be able to: PowerPivot for SharePoint Servercloud-based collaborative solution for Describe the enhancements to Power Queryself-service BI. Transact-SQL. Power ViewWindows Azure Services for DataAfter Describe new and enhanced Power Mapcompleting this module, you will be able to: Transact-SQL functions. Power BI for Office 365After completingDescribe key features and benefits of cloud Describe the enhancements to Spatial this module, you will be able to:computing. Data Support. Use PowerPivot to create tabular dataDescribe Windows Azure service for data. Explain how to store and query models in Excel.Windows Azure SQL Database Security documents with SQL Server 2014. Share a PowerPivot workbooks inImplementing and Managing DatabasesAfter Columnstore Indexes SharePoint Server.completing this module, you will be able to: Memory-Optimized TablesAfter Use Power Query to discover and importDescribe key features and benefits of completing this module, you will be able data from multiple data sources into Excel.Windows Azure SQL Database. to: Use Power View to create interactive dataImplement security for Windows Azure SQL Use the Buffer Pool Extension to improve visualizations in Excel and SharePointDatabase. performance for read-heavy OLTP Server.Implement and manage databases in workloads. Use Power Map to create visualizations ofWindows Azure SQL Database. Use Columnstore Indexes to improve geographic data.Windows Azure Virtual Machine Connectivity performance in data warehouse query Use Power BI for Office 365 to create aand Security workloads. cloud-based collaborative solution forCreating Databases in a Windows Azure Use memory-optimized tables to improve self-service BI.Virtual MachineAfter completing this performance for latch-bound workloads. Windows Azure Services for DataAftermodule, you will be able to: Using PowerShell to Manage SQL completing this module, you will be able to:Describe considerations for using Virtual ServerAfter completing this module, you Describe key features and benefits of


Machines in Windows Azure. will be able to: cloud computing.Create and configure Windows Azure virtual Describe new and enhanced dynamic Describe Windows Azure service for data.machines. management views. Windows Azure SQL Database SecurityCreate databases in Windows Azure virtual Describe how to use PowerShell to Implementing and Managingmachines. Manage SQL Server. DatabasesAfter completing this module,Windows Azure HDInsight Contained DatabasesAfter completing you will be able to:Consuming HDInsight Results in Excel this module, you will be able to: Describe key features and benefits ofObtaining Data from the Windows Azure Describe the security enhancements in Windows Azure SQL Database.MarketplaceAfter completing this module, SQL Server 2014. Implement security for Windows Azureyou will be able to: Explain how to use contained databases. SQL Database.Describe key features of big data. Enhancements to Data RecoveryAfter Implement and manage databases inProcess big data with Windows Azure completing this module, you will be able Windows Azure SQL Database.HDInsight. to: Windows Azure Virtual MachineConsume big data processing results from Describe high availability features in SQL Connectivity and SecurityWindows Azure HDInsight in Microsoft Server 2014. Creating Databases in a Windows AzureExcel. Describe data recovery enhancements in Virtual MachineAfter completing this

SQL Server 2014. module, you will be able to:Deploying and Operating SSIS Describe considerations for using Virtual

line PackagesAfter completing this module, Machines in Windows Azure.SQL Server 2014 Editions and Components you will be able to: Create and configure Windows AzureInstalling SQL Server 2014 Use the CDC Control task to perform virtual machines.Enhancements to SQL Server Management incremental data extractions in an ETL Create databases in Windows AzureStudioAfter completing this module, you will solution. virtual machines.be able to: Deploy and operate an SSIS project. Windows Azure HDInsightDescribe the common workloads for SQL Using Data Quality Services to Cleanse Consuming HDInsight Results in ExcelServer 2014. Data Obtaining Data from the Windows AzureDescribe the SQL Server 2014 Editions and Using Data Quality Services to Match MarketplaceAfter completing this module,Components. DataAfter completing this module, you you will be able to:Install SQL Server 2014 Components. will be able to: Describe key features of big data.Use the new features in SQL Server Describe how Data Quality Services can Process big data with Windows AzureManagement Studio. help you manage data quality. HDInsight.New and Enhanced Transact-SQL Functions Use Data Quality Services to cleanse Consume big data processing results fromEnhancements to Spatial Data Support your data. Windows Azure HDInsight in MicrosoftStoring and Querying Documents with SQL Use Data Quality Services to match data. Excel.Server 2014After completing this module, Implementing a Master Data Servicesyou will be able to: Model Module 13: Introduction to Cloud DataDescribe the enhancements to Using the Master Data Services Add-in SolutionsTransact-SQL. for ExcelAfter completing this module, lineDescribe new and enhanced Transact-SQL you will be able to:functions. Describe key Master Data Services This module introduces some of the keyDescribe the enhancements to Spatial Data concepts. Microsoft technologies that you can use toSupport. Implement a Master Data Services implement a cloud solution for data.Explain how to store and query documents model. linewith SQL Server 2014. Use Master Data Services tools to Overview of Cloud ComputingColumnstore Indexes manage master data.Memory-Optimized TablesAfter completing Use Master Data Services tools to createthis module, you will be able to: a master data hub. lineUse the Buffer Pool Extension to improve Reporting Services and Microsoft SQL Server 2014 Editions andperformance for read-heavy OLTP SharePoint Server Componentsworkloads. Introduction to Data AlertsAfter Installing SQL Server 2014Use Columnstore Indexes to improve completing this module, you will be able Enhancements to SQL Serverperformance in data warehouse query to: Management StudioAfter completing thisworkloads. Describe the key capabilities of Reporting module, you will be able to:Use memory-optimized tables to improve Services. Describe the common workloads for SQLperformance for latch-bound workloads. Install and configure Reporting Services Server 2014.Using PowerShell to Manage SQL in SharePoint Mode. Describe the SQL Server 2014 EditionsServerAfter completing this module, you will Use data alerts to notify users of changes and Components.be able to: to report data. Install SQL Server 2014 Components.Describe new and enhanced dynamic Creating a Tabular Model Use the new features in SQL Servermanagement views. Using an Analysis Services Tabular Data Management Studio.Describe how to use PowerShell to Manage Model in the EnterpriseAfter completing New and Enhanced Transact-SQLSQL Server. this module, you will be able to: FunctionsContained DatabasesAfter completing this Describe Analysis Services tabular data Enhancements to Spatial Data Supportmodule, you will be able to: model projects. Storing and Querying Documents with SQLDescribe the security enhancements in SQL Implement an Analysis Services tabular Server 2014After completing this module,Server 2014. data model. you will be able to:


Explain how to use contained databases. Use an Analysis Services tabular data Describe the enhancements toEnhancements to Data RecoveryAfter model. Transact-SQL.completing this module, you will be able to: PowerPivot for SharePoint Server Describe new and enhancedDescribe high availability features in SQL Power Query Transact-SQL functions.Server 2014. Power View Describe the enhancements to SpatialDescribe data recovery enhancements in Power Map Data Support.SQL Server 2014. Power BI for Office 365After completing Explain how to store and query documentsDeploying and Operating SSIS this module, you will be able to: with SQL Server 2014.PackagesAfter completing this module, you Use PowerPivot to create tabular data Columnstore Indexeswill be able to: models in Excel. Memory-Optimized TablesAfter completingUse the CDC Control task to perform Share a PowerPivot workbooks in this module, you will be able to:incremental data extractions in an ETL SharePoint Server. Use the Buffer Pool Extension to improvesolution. Use Power Query to discover and import performance for read-heavy OLTPDeploy and operate an SSIS project. data from multiple data sources into workloads.Using Data Quality Services to Cleanse Excel. Use Columnstore Indexes to improveData Use Power View to create interactive performance in data warehouse queryUsing Data Quality Services to Match data visualizations in Excel and workloads.DataAfter completing this module, you will SharePoint Server. Use memory-optimized tables to improvebe able to: Use Power Map to create visualizations performance for latch-bound workloads.Describe how Data Quality Services can of geographic data. Using PowerShell to Manage SQLhelp you manage data quality. Use Power BI for Office 365 to create a ServerAfter completing this module, youUse Data Quality Services to cleanse your cloud-based collaborative solution for will be able to:data. self-service BI. Describe new and enhanced dynamicUse Data Quality Services to match data. Windows Azure Services for DataAfter management views.Implementing a Master Data Services Model completing this module, you will be able Describe how to use PowerShell toUsing the Master Data Services Add-in for to: Manage SQL Server.ExcelAfter completing this module, you will Describe key features and benefits of Contained DatabasesAfter completing thisbe able to: cloud computing. module, you will be able to:Describe key Master Data Services Describe Windows Azure service for Describe the security enhancements inconcepts. data. SQL Server 2014.Implement a Master Data Services model. Windows Azure SQL Database Security Explain how to use contained databases.Use Master Data Services tools to manage Implementing and Managing Enhancements to Data RecoveryAftermaster data. DatabasesAfter completing this module, completing this module, you will be able to:Use Master Data Services tools to create a you will be able to: Describe high availability features in SQLmaster data hub. Describe key features and benefits of Server 2014.Reporting Services and Microsoft Windows Azure SQL Database. Describe data recovery enhancements inSharePoint Server Implement security for Windows Azure SQL Server 2014.Introduction to Data AlertsAfter completing SQL Database. Deploying and Operating SSISthis module, you will be able to: Implement and manage databases in PackagesAfter completing this module,Describe the key capabilities of Reporting Windows Azure SQL Database. you will be able to:Services. Windows Azure Virtual Machine Use the CDC Control task to performInstall and configure Reporting Services in Connectivity and Security incremental data extractions in an ETLSharePoint Mode. Creating Databases in a Windows Azure solution.Use data alerts to notify users of changes to Virtual MachineAfter completing this Deploy and operate an SSIS project.report data. module, you will be able to: Using Data Quality Services to CleanseCreating a Tabular Model Describe considerations for using Virtual DataUsing an Analysis Services Tabular Data Machines in Windows Azure. Using Data Quality Services to MatchModel in the EnterpriseAfter completing this Create and configure Windows Azure DataAfter completing this module, you willmodule, you will be able to: virtual machines. be able to:Describe Analysis Services tabular data Create databases in Windows Azure Describe how Data Quality Services canmodel projects. virtual machines. help you manage data quality.Implement an Analysis Services tabular data Windows Azure HDInsight Use Data Quality Services to cleanse yourmodel. Consuming HDInsight Results in Excel data.Use an Analysis Services tabular data Obtaining Data from the Windows Azure Use Data Quality Services to match data.model. MarketplaceAfter completing this module, Implementing a Master Data ServicesPowerPivot for SharePoint Server you will be able to: ModelPower Query Describe key features of big data. Using the Master Data Services Add-in forPower View Process big data with Windows Azure ExcelAfter completing this module, you willPower Map HDInsight. be able to:Power BI for Office 365After completing this Consume big data processing results Describe key Master Data Servicesmodule, you will be able to: from Windows Azure HDInsight in concepts.Use PowerPivot to create tabular data Microsoft Excel. Implement a Master Data Services model.models in Excel. Use Master Data Services tools to manageShare a PowerPivot workbooks in master data.SharePoint Server. line Use Master Data Services tools to create aUse Power Query to discover and import SQL Server 2014 Editions and master data hub.


data from multiple data sources into Excel. Components Reporting Services and MicrosoftUse Power View to create interactive data Installing SQL Server 2014 SharePoint Servervisualizations in Excel and SharePoint Enhancements to SQL Server Introduction to Data AlertsAfter completingServer. Management StudioAfter completing this this module, you will be able to:Use Power Map to create visualizations of module, you will be able to: Describe the key capabilities of Reportinggeographic data. Describe the common workloads for SQL Services.Use Power BI for Office 365 to create a Server 2014. Install and configure Reporting Services incloud-based collaborative solution for Describe the SQL Server 2014 Editions SharePoint Mode.self-service BI. and Components. Use data alerts to notify users of changesWindows Azure Services for DataAfter Install SQL Server 2014 Components. to report data.completing this module, you will be able to: Use the new features in SQL Server Creating a Tabular ModelDescribe key features and benefits of cloud Management Studio. Using an Analysis Services Tabular Datacomputing. New and Enhanced Transact-SQL Model in the EnterpriseAfter completingDescribe Windows Azure service for data. Functions this module, you will be able to:Windows Azure SQL Database Security Enhancements to Spatial Data Support Describe Analysis Services tabular dataImplementing and Managing DatabasesAfter Storing and Querying Documents with model projects.completing this module, you will be able to: SQL Server 2014After completing this Implement an Analysis Services tabularDescribe key features and benefits of module, you will be able to: data model.Windows Azure SQL Database. Describe the enhancements to Use an Analysis Services tabular dataImplement security for Windows Azure SQL Transact-SQL. model.Database. Describe new and enhanced PowerPivot for SharePoint ServerImplement and manage databases in Transact-SQL functions. Power QueryWindows Azure SQL Database. Describe the enhancements to Spatial Power ViewWindows Azure Virtual Machine Connectivity Data Support. Power Mapand Security Explain how to store and query Power BI for Office 365After completingCreating Databases in a Windows Azure documents with SQL Server 2014. this module, you will be able to:Virtual MachineAfter completing this Columnstore Indexes Use PowerPivot to create tabular datamodule, you will be able to: Memory-Optimized TablesAfter models in Excel.Describe considerations for using Virtual completing this module, you will be able Share a PowerPivot workbooks inMachines in Windows Azure. to: SharePoint Server.Create and configure Windows Azure virtual Use the Buffer Pool Extension to improve Use Power Query to discover and importmachines. performance for read-heavy OLTP data from multiple data sources into Excel.Create databases in Windows Azure virtual workloads. Use Power View to create interactive datamachines. Use Columnstore Indexes to improve visualizations in Excel and SharePointWindows Azure HDInsight performance in data warehouse query Server.Consuming HDInsight Results in Excel workloads. Use Power Map to create visualizations ofObtaining Data from the Windows Azure Use memory-optimized tables to improve geographic data.MarketplaceAfter completing this module, performance for latch-bound workloads. Use Power BI for Office 365 to create ayou will be able to: Using PowerShell to Manage SQL cloud-based collaborative solution forDescribe key features of big data. ServerAfter completing this module, you self-service BI.Process big data with Windows Azure will be able to: Windows Azure Services for DataAfterHDInsight. Describe new and enhanced dynamic completing this module, you will be able to:Consume big data processing results from management views. Describe key features and benefits ofWindows Azure HDInsight in Microsoft Describe how to use PowerShell to cloud computing.Excel. Manage SQL Server. Describe Windows Azure service for data.

Contained DatabasesAfter completing Windows Azure SQL Database Securitythis module, you will be able to: Implementing and Managing

line Describe the security enhancements in DatabasesAfter completing this module,SQL Server 2014 Editions and Components SQL Server 2014. you will be able to:Installing SQL Server 2014 Explain how to use contained databases. Describe key features and benefits ofEnhancements to SQL Server Management Enhancements to Data RecoveryAfter Windows Azure SQL Database.StudioAfter completing this module, you will completing this module, you will be able Implement security for Windows Azurebe able to: to: SQL Database.Describe the common workloads for SQL Describe high availability features in SQL Implement and manage databases inServer 2014. Server 2014. Windows Azure SQL Database.Describe the SQL Server 2014 Editions and Describe data recovery enhancements in Windows Azure Virtual MachineComponents. SQL Server 2014. Connectivity and SecurityInstall SQL Server 2014 Components. Deploying and Operating SSIS Creating Databases in a Windows AzureUse the new features in SQL Server PackagesAfter completing this module, Virtual MachineAfter completing thisManagement Studio. you will be able to: module, you will be able to:New and Enhanced Transact-SQL Functions Use the CDC Control task to perform Describe considerations for using VirtualEnhancements to Spatial Data Support incremental data extractions in an ETL Machines in Windows Azure.Storing and Querying Documents with SQL solution. Create and configure Windows AzureServer 2014After completing this module, Deploy and operate an SSIS project. virtual machines.you will be able to: Using Data Quality Services to Cleanse Create databases in Windows AzureDescribe the enhancements to Data virtual machines.


Transact-SQL. Using Data Quality Services to Match Windows Azure HDInsightDescribe new and enhanced Transact-SQL DataAfter completing this module, you Consuming HDInsight Results in Excelfunctions. will be able to: Obtaining Data from the Windows AzureDescribe the enhancements to Spatial Data Describe how Data Quality Services can MarketplaceAfter completing this module,Support. help you manage data quality. you will be able to:Explain how to store and query documents Use Data Quality Services to cleanse Describe key features of big data.with SQL Server 2014. your data. Process big data with Windows AzureColumnstore Indexes Use Data Quality Services to match data. HDInsight.Memory-Optimized TablesAfter completing Implementing a Master Data Services Consume big data processing results fromthis module, you will be able to: Model Windows Azure HDInsight in MicrosoftUse the Buffer Pool Extension to improve Using the Master Data Services Add-in Excel.performance for read-heavy OLTP for ExcelAfter completing this module,workloads. you will be able to:Use Columnstore Indexes to improve Describe key Master Data Services lineperformance in data warehouse query concepts. SQL Server 2014 Editions andworkloads. Implement a Master Data Services ComponentsUse memory-optimized tables to improve model. Installing SQL Server 2014performance for latch-bound workloads. Use Master Data Services tools to Enhancements to SQL ServerUsing PowerShell to Manage SQL manage master data. Management StudioAfter completing thisServerAfter completing this module, you will Use Master Data Services tools to create module, you will be able to:be able to: a master data hub. Describe the common workloads for SQLDescribe new and enhanced dynamic Reporting Services and Microsoft Server 2014.management views. SharePoint Server Describe the SQL Server 2014 EditionsDescribe how to use PowerShell to Manage Introduction to Data AlertsAfter and Components.SQL Server. completing this module, you will be able Install SQL Server 2014 Components.Contained DatabasesAfter completing this to: Use the new features in SQL Servermodule, you will be able to: Describe the key capabilities of Reporting Management Studio.Describe the security enhancements in SQL Services. New and Enhanced Transact-SQLServer 2014. Install and configure Reporting Services FunctionsExplain how to use contained databases. in SharePoint Mode. Enhancements to Spatial Data SupportEnhancements to Data RecoveryAfter Use data alerts to notify users of changes Storing and Querying Documents with SQLcompleting this module, you will be able to: to report data. Server 2014After completing this module,Describe high availability features in SQL Creating a Tabular Model you will be able to:Server 2014. Using an Analysis Services Tabular Data Describe the enhancements toDescribe data recovery enhancements in Model in the EnterpriseAfter completing Transact-SQL.SQL Server 2014. this module, you will be able to: Describe new and enhancedDeploying and Operating SSIS Describe Analysis Services tabular data Transact-SQL functions.PackagesAfter completing this module, you model projects. Describe the enhancements to Spatialwill be able to: Implement an Analysis Services tabular Data Support.Use the CDC Control task to perform data model. Explain how to store and query documentsincremental data extractions in an ETL Use an Analysis Services tabular data with SQL Server 2014.solution. model. Columnstore IndexesDeploy and operate an SSIS project. PowerPivot for SharePoint Server Memory-Optimized TablesAfter completingUsing Data Quality Services to Cleanse Power Query this module, you will be able to:Data Power View Use the Buffer Pool Extension to improveUsing Data Quality Services to Match Power Map performance for read-heavy OLTPDataAfter completing this module, you will Power BI for Office 365After completing workloads.be able to: this module, you will be able to: Use Columnstore Indexes to improveDescribe how Data Quality Services can Use PowerPivot to create tabular data performance in data warehouse queryhelp you manage data quality. models in Excel. workloads.Use Data Quality Services to cleanse your Share a PowerPivot workbooks in Use memory-optimized tables to improvedata. SharePoint Server. performance for latch-bound workloads.Use Data Quality Services to match data. Use Power Query to discover and import Using PowerShell to Manage SQLImplementing a Master Data Services Model data from multiple data sources into ServerAfter completing this module, youUsing the Master Data Services Add-in for Excel. will be able to:ExcelAfter completing this module, you will Use Power View to create interactive Describe new and enhanced dynamicbe able to: data visualizations in Excel and management views.Describe key Master Data Services SharePoint Server. Describe how to use PowerShell toconcepts. Use Power Map to create visualizations Manage SQL Server.Implement a Master Data Services model. of geographic data. Contained DatabasesAfter completing thisUse Master Data Services tools to manage Use Power BI for Office 365 to create a module, you will be able to:master data. cloud-based collaborative solution for Describe the security enhancements inUse Master Data Services tools to create a self-service BI. SQL Server 2014.master data hub. Windows Azure Services for DataAfter Explain how to use contained databases.Reporting Services and Microsoft completing this module, you will be able Enhancements to Data RecoveryAfterSharePoint Server to: completing this module, you will be able to:


Introduction to Data AlertsAfter completing Describe key features and benefits of Describe high availability features in SQLthis module, you will be able to: cloud computing. Server 2014.Describe the key capabilities of Reporting Describe Windows Azure service for Describe data recovery enhancements inServices. data. SQL Server 2014.Install and configure Reporting Services in Windows Azure SQL Database Security Deploying and Operating SSISSharePoint Mode. Implementing and Managing PackagesAfter completing this module,Use data alerts to notify users of changes to DatabasesAfter completing this module, you will be able to:report data. you will be able to: Use the CDC Control task to performCreating a Tabular Model Describe key features and benefits of incremental data extractions in an ETLUsing an Analysis Services Tabular Data Windows Azure SQL Database. solution.Model in the EnterpriseAfter completing this Implement security for Windows Azure Deploy and operate an SSIS project.module, you will be able to: SQL Database. Using Data Quality Services to CleanseDescribe Analysis Services tabular data Implement and manage databases in Datamodel projects. Windows Azure SQL Database. Using Data Quality Services to MatchImplement an Analysis Services tabular data Windows Azure Virtual Machine DataAfter completing this module, you willmodel. Connectivity and Security be able to:Use an Analysis Services tabular data Creating Databases in a Windows Azure Describe how Data Quality Services canmodel. Virtual MachineAfter completing this help you manage data quality.PowerPivot for SharePoint Server module, you will be able to: Use Data Quality Services to cleanse yourPower Query Describe considerations for using Virtual data.Power View Machines in Windows Azure. Use Data Quality Services to match data.Power Map Create and configure Windows Azure Implementing a Master Data ServicesPower BI for Office 365After completing this virtual machines. Modelmodule, you will be able to: Create databases in Windows Azure Using the Master Data Services Add-in forUse PowerPivot to create tabular data virtual machines. ExcelAfter completing this module, you willmodels in Excel. Windows Azure HDInsight be able to:Share a PowerPivot workbooks in Consuming HDInsight Results in Excel Describe key Master Data ServicesSharePoint Server. Obtaining Data from the Windows Azure concepts.Use Power Query to discover and import MarketplaceAfter completing this module, Implement a Master Data Services model.data from multiple data sources into Excel. you will be able to: Use Master Data Services tools to manageUse Power View to create interactive data Describe key features of big data. master data.visualizations in Excel and SharePoint Process big data with Windows Azure Use Master Data Services tools to create aServer. HDInsight. master data hub.Use Power Map to create visualizations of Consume big data processing results Reporting Services and Microsoftgeographic data. from Windows Azure HDInsight in SharePoint ServerUse Power BI for Office 365 to create a Microsoft Excel. Introduction to Data AlertsAfter completingcloud-based collaborative solution for this module, you will be able to:self-service BI. Describe the key capabilities of ReportingWindows Azure Services for DataAfter line Services.completing this module, you will be able to: SQL Server 2014 Editions and Install and configure Reporting Services inDescribe key features and benefits of cloud Components SharePoint Mode.computing. Installing SQL Server 2014 Use data alerts to notify users of changesDescribe Windows Azure service for data. Enhancements to SQL Server to report data.Windows Azure SQL Database Security Management StudioAfter completing this Creating a Tabular ModelImplementing and Managing DatabasesAfter module, you will be able to: Using an Analysis Services Tabular Datacompleting this module, you will be able to: Describe the common workloads for SQL Model in the EnterpriseAfter completingDescribe key features and benefits of Server 2014. this module, you will be able to:Windows Azure SQL Database. Describe the SQL Server 2014 Editions Describe Analysis Services tabular dataImplement security for Windows Azure SQL and Components. model projects.Database. Install SQL Server 2014 Components. Implement an Analysis Services tabularImplement and manage databases in Use the new features in SQL Server data model.Windows Azure SQL Database. Management Studio. Use an Analysis Services tabular dataWindows Azure Virtual Machine Connectivity New and Enhanced Transact-SQL model.and Security Functions PowerPivot for SharePoint ServerCreating Databases in a Windows Azure Enhancements to Spatial Data Support Power QueryVirtual MachineAfter completing this Storing and Querying Documents with Power Viewmodule, you will be able to: SQL Server 2014After completing this Power MapDescribe considerations for using Virtual module, you will be able to: Power BI for Office 365After completingMachines in Windows Azure. Describe the enhancements to this module, you will be able to:Create and configure Windows Azure virtual Transact-SQL. Use PowerPivot to create tabular datamachines. Describe new and enhanced models in Excel.Create databases in Windows Azure virtual Transact-SQL functions. Share a PowerPivot workbooks inmachines. Describe the enhancements to Spatial SharePoint Server.Windows Azure HDInsight Data Support. Use Power Query to discover and importConsuming HDInsight Results in Excel Explain how to store and query data from multiple data sources into Excel.Obtaining Data from the Windows Azure documents with SQL Server 2014. Use Power View to create interactive data


MarketplaceAfter completing this module, Columnstore Indexes visualizations in Excel and SharePointyou will be able to: Memory-Optimized TablesAfter Server.Describe key features of big data. completing this module, you will be able Use Power Map to create visualizations ofProcess big data with Windows Azure to: geographic data.HDInsight. Use the Buffer Pool Extension to improve Use Power BI for Office 365 to create aConsume big data processing results from performance for read-heavy OLTP cloud-based collaborative solution forWindows Azure HDInsight in Microsoft workloads. self-service BI.Excel. Use Columnstore Indexes to improve Windows Azure Services for DataAfter

performance in data warehouse query completing this module, you will be able to:workloads. Describe key features and benefits of

line Use memory-optimized tables to improve cloud computing.SQL Server 2014 Editions and Components performance for latch-bound workloads. Describe Windows Azure service for data.Installing SQL Server 2014 Using PowerShell to Manage SQL Windows Azure SQL Database SecurityEnhancements to SQL Server Management ServerAfter completing this module, you Implementing and ManagingStudioAfter completing this module, you will will be able to: DatabasesAfter completing this module,be able to: Describe new and enhanced dynamic you will be able to:Describe the common workloads for SQL management views. Describe key features and benefits ofServer 2014. Describe how to use PowerShell to Windows Azure SQL Database.Describe the SQL Server 2014 Editions and Manage SQL Server. Implement security for Windows AzureComponents. Contained DatabasesAfter completing SQL Database.Install SQL Server 2014 Components. this module, you will be able to: Implement and manage databases inUse the new features in SQL Server Describe the security enhancements in Windows Azure SQL Database.Management Studio. SQL Server 2014. Windows Azure Virtual MachineNew and Enhanced Transact-SQL Functions Explain how to use contained databases. Connectivity and SecurityEnhancements to Spatial Data Support Enhancements to Data RecoveryAfter Creating Databases in a Windows AzureStoring and Querying Documents with SQL completing this module, you will be able Virtual MachineAfter completing thisServer 2014After completing this module, to: module, you will be able to:you will be able to: Describe high availability features in SQL Describe considerations for using VirtualDescribe the enhancements to Server 2014. Machines in Windows Azure.Transact-SQL. Describe data recovery enhancements in Create and configure Windows AzureDescribe new and enhanced Transact-SQL SQL Server 2014. virtual machines.functions. Deploying and Operating SSIS Create databases in Windows AzureDescribe the enhancements to Spatial Data PackagesAfter completing this module, virtual machines.Support. you will be able to: Windows Azure HDInsightExplain how to store and query documents Use the CDC Control task to perform Consuming HDInsight Results in Excelwith SQL Server 2014. incremental data extractions in an ETL Obtaining Data from the Windows AzureColumnstore Indexes solution. MarketplaceAfter completing this module,Memory-Optimized TablesAfter completing Deploy and operate an SSIS project. you will be able to:this module, you will be able to: Using Data Quality Services to Cleanse Describe key features of big data.Use the Buffer Pool Extension to improve Data Process big data with Windows Azureperformance for read-heavy OLTP Using Data Quality Services to Match HDInsight.workloads. DataAfter completing this module, you Consume big data processing results fromUse Columnstore Indexes to improve will be able to: Windows Azure HDInsight in Microsoftperformance in data warehouse query Describe how Data Quality Services can Excel.workloads. help you manage data quality.Use memory-optimized tables to improve Use Data Quality Services to cleanse Module 14: Windows Azure SQL Databaseperformance for latch-bound workloads. your data. lineUsing PowerShell to Manage SQL Use Data Quality Services to match data.ServerAfter completing this module, you will Implementing a Master Data Services This module introduces Windows Azure SQLbe able to: Model Database, a Platform-as-a-Service (PaaS)Describe new and enhanced dynamic Using the Master Data Services Add-in solution for cloud-based relational databasemanagement views. for ExcelAfter completing this module, storage.Describe how to use PowerShell to Manage you will be able to: lineSQL Server. Describe key Master Data Services Introduction to Windows Azure SQLContained DatabasesAfter completing this concepts. Databasemodule, you will be able to: Implement a Master Data ServicesDescribe the security enhancements in SQL model.Server 2014. Use Master Data Services tools to lineExplain how to use contained databases. manage master data. SQL Server 2014 Editions andEnhancements to Data RecoveryAfter Use Master Data Services tools to create Componentscompleting this module, you will be able to: a master data hub. Installing SQL Server 2014Describe high availability features in SQL Reporting Services and Microsoft Enhancements to SQL ServerServer 2014. SharePoint Server Management StudioAfter completing thisDescribe data recovery enhancements in Introduction to Data AlertsAfter module, you will be able to:SQL Server 2014. completing this module, you will be able Describe the common workloads for SQLDeploying and Operating SSIS to: Server 2014.


PackagesAfter completing this module, you Describe the key capabilities of Reporting Describe the SQL Server 2014 Editionswill be able to: Services. and Components.Use the CDC Control task to perform Install and configure Reporting Services Install SQL Server 2014 Components.incremental data extractions in an ETL in SharePoint Mode. Use the new features in SQL Serversolution. Use data alerts to notify users of changes Management Studio.Deploy and operate an SSIS project. to report data. New and Enhanced Transact-SQLUsing Data Quality Services to Cleanse Creating a Tabular Model FunctionsData Using an Analysis Services Tabular Data Enhancements to Spatial Data SupportUsing Data Quality Services to Match Model in the EnterpriseAfter completing Storing and Querying Documents with SQLDataAfter completing this module, you will this module, you will be able to: Server 2014After completing this module,be able to: Describe Analysis Services tabular data you will be able to:Describe how Data Quality Services can model projects. Describe the enhancements tohelp you manage data quality. Implement an Analysis Services tabular Transact-SQL.Use Data Quality Services to cleanse your data model. Describe new and enhanceddata. Use an Analysis Services tabular data Transact-SQL functions.Use Data Quality Services to match data. model. Describe the enhancements to SpatialImplementing a Master Data Services Model PowerPivot for SharePoint Server Data Support.Using the Master Data Services Add-in for Power Query Explain how to store and query documentsExcelAfter completing this module, you will Power View with SQL Server 2014.be able to: Power Map Columnstore IndexesDescribe key Master Data Services Power BI for Office 365After completing Memory-Optimized TablesAfter completingconcepts. this module, you will be able to: this module, you will be able to:Implement a Master Data Services model. Use PowerPivot to create tabular data Use the Buffer Pool Extension to improveUse Master Data Services tools to manage models in Excel. performance for read-heavy OLTPmaster data. Share a PowerPivot workbooks in workloads.Use Master Data Services tools to create a SharePoint Server. Use Columnstore Indexes to improvemaster data hub. Use Power Query to discover and import performance in data warehouse queryReporting Services and Microsoft data from multiple data sources into workloads.SharePoint Server Excel. Use memory-optimized tables to improveIntroduction to Data AlertsAfter completing Use Power View to create interactive performance for latch-bound workloads.this module, you will be able to: data visualizations in Excel and Using PowerShell to Manage SQLDescribe the key capabilities of Reporting SharePoint Server. ServerAfter completing this module, youServices. Use Power Map to create visualizations will be able to:Install and configure Reporting Services in of geographic data. Describe new and enhanced dynamicSharePoint Mode. Use Power BI for Office 365 to create a management views.Use data alerts to notify users of changes to cloud-based collaborative solution for Describe how to use PowerShell toreport data. self-service BI. Manage SQL Server.Creating a Tabular Model Windows Azure Services for DataAfter Contained DatabasesAfter completing thisUsing an Analysis Services Tabular Data completing this module, you will be able module, you will be able to:Model in the EnterpriseAfter completing this to: Describe the security enhancements inmodule, you will be able to: Describe key features and benefits of SQL Server 2014.Describe Analysis Services tabular data cloud computing. Explain how to use contained databases.model projects. Describe Windows Azure service for Enhancements to Data RecoveryAfterImplement an Analysis Services tabular data data. completing this module, you will be able to:model. Windows Azure SQL Database Security Describe high availability features in SQLUse an Analysis Services tabular data Implementing and Managing Server 2014.model. DatabasesAfter completing this module, Describe data recovery enhancements inPowerPivot for SharePoint Server you will be able to: SQL Server 2014.Power Query Describe key features and benefits of Deploying and Operating SSISPower View Windows Azure SQL Database. PackagesAfter completing this module,Power Map Implement security for Windows Azure you will be able to:Power BI for Office 365After completing this SQL Database. Use the CDC Control task to performmodule, you will be able to: Implement and manage databases in incremental data extractions in an ETLUse PowerPivot to create tabular data Windows Azure SQL Database. solution.models in Excel. Windows Azure Virtual Machine Deploy and operate an SSIS project.Share a PowerPivot workbooks in Connectivity and Security Using Data Quality Services to CleanseSharePoint Server. Creating Databases in a Windows Azure DataUse Power Query to discover and import Virtual MachineAfter completing this Using Data Quality Services to Matchdata from multiple data sources into Excel. module, you will be able to: DataAfter completing this module, you willUse Power View to create interactive data Describe considerations for using Virtual be able to:visualizations in Excel and SharePoint Machines in Windows Azure. Describe how Data Quality Services canServer. Create and configure Windows Azure help you manage data quality.Use Power Map to create visualizations of virtual machines. Use Data Quality Services to cleanse yourgeographic data. Create databases in Windows Azure data.Use Power BI for Office 365 to create a virtual machines. Use Data Quality Services to match data.cloud-based collaborative solution for Windows Azure HDInsight Implementing a Master Data Services


self-service BI. Consuming HDInsight Results in Excel ModelWindows Azure Services for DataAfter Obtaining Data from the Windows Azure Using the Master Data Services Add-in forcompleting this module, you will be able to: MarketplaceAfter completing this module, ExcelAfter completing this module, you willDescribe key features and benefits of cloud you will be able to: be able to:computing. Describe key features of big data. Describe key Master Data ServicesDescribe Windows Azure service for data. Process big data with Windows Azure concepts.Windows Azure SQL Database Security HDInsight. Implement a Master Data Services model.Implementing and Managing DatabasesAfter Consume big data processing results Use Master Data Services tools to managecompleting this module, you will be able to: from Windows Azure HDInsight in master data.Describe key features and benefits of Microsoft Excel. Use Master Data Services tools to create aWindows Azure SQL Database. master data hub.Implement security for Windows Azure SQL Reporting Services and MicrosoftDatabase. line SharePoint ServerImplement and manage databases in SQL Server 2014 Editions and Introduction to Data AlertsAfter completingWindows Azure SQL Database. Components this module, you will be able to:Windows Azure Virtual Machine Connectivity Installing SQL Server 2014 Describe the key capabilities of Reportingand Security Enhancements to SQL Server Services.Creating Databases in a Windows Azure Management StudioAfter completing this Install and configure Reporting Services inVirtual MachineAfter completing this module, you will be able to: SharePoint Mode.module, you will be able to: Describe the common workloads for SQL Use data alerts to notify users of changesDescribe considerations for using Virtual Server 2014. to report data.Machines in Windows Azure. Describe the SQL Server 2014 Editions Creating a Tabular ModelCreate and configure Windows Azure virtual and Components. Using an Analysis Services Tabular Datamachines. Install SQL Server 2014 Components. Model in the EnterpriseAfter completingCreate databases in Windows Azure virtual Use the new features in SQL Server this module, you will be able to:machines. Management Studio. Describe Analysis Services tabular dataWindows Azure HDInsight New and Enhanced Transact-SQL model projects.Consuming HDInsight Results in Excel Functions Implement an Analysis Services tabularObtaining Data from the Windows Azure Enhancements to Spatial Data Support data model.MarketplaceAfter completing this module, Storing and Querying Documents with Use an Analysis Services tabular datayou will be able to: SQL Server 2014After completing this model.Describe key features of big data. module, you will be able to: PowerPivot for SharePoint ServerProcess big data with Windows Azure Describe the enhancements to Power QueryHDInsight. Transact-SQL. Power ViewConsume big data processing results from Describe new and enhanced Power MapWindows Azure HDInsight in Microsoft Transact-SQL functions. Power BI for Office 365After completingExcel. Describe the enhancements to Spatial this module, you will be able to:

Data Support. Use PowerPivot to create tabular dataModule 3: In-Memory Database Capabilities Explain how to store and query models in Excel.line documents with SQL Server 2014. Share a PowerPivot workbooks in

Columnstore Indexes SharePoint Server.This module describes how SQL server 2014 Memory-Optimized TablesAfter Use Power Query to discover and importenables you to leverage in-memory completing this module, you will be able data from multiple data sources into Excel.technologies to enhance database to: Use Power View to create interactive dataperformance. Use the Buffer Pool Extension to improve visualizations in Excel and SharePointline performance for read-heavy OLTP Server.

The Buffer pool Extension workloads. Use Power Map to create visualizations ofUse Columnstore Indexes to improve geographic data.performance in data warehouse query Use Power BI for Office 365 to create a

line workloads. cloud-based collaborative solution forSQL Server 2014 Editions and Components Use memory-optimized tables to improve self-service BI.Installing SQL Server 2014 performance for latch-bound workloads. Windows Azure Services for DataAfterEnhancements to SQL Server Management Using PowerShell to Manage SQL completing this module, you will be able to:StudioAfter completing this module, you will ServerAfter completing this module, you Describe key features and benefits ofbe able to: will be able to: cloud computing.Describe the common workloads for SQL Describe new and enhanced dynamic Describe Windows Azure service for data.Server 2014. management views. Windows Azure SQL Database SecurityDescribe the SQL Server 2014 Editions and Describe how to use PowerShell to Implementing and ManagingComponents. Manage SQL Server. DatabasesAfter completing this module,Install SQL Server 2014 Components. Contained DatabasesAfter completing you will be able to:Use the new features in SQL Server this module, you will be able to: Describe key features and benefits ofManagement Studio. Describe the security enhancements in Windows Azure SQL Database.New and Enhanced Transact-SQL Functions SQL Server 2014. Implement security for Windows AzureEnhancements to Spatial Data Support Explain how to use contained databases. SQL Database.Storing and Querying Documents with SQL Enhancements to Data RecoveryAfter Implement and manage databases inServer 2014After completing this module, completing this module, you will be able Windows Azure SQL Database.


you will be able to: to: Windows Azure Virtual MachineDescribe the enhancements to Describe high availability features in SQL Connectivity and SecurityTransact-SQL. Server 2014. Creating Databases in a Windows AzureDescribe new and enhanced Transact-SQL Describe data recovery enhancements in Virtual MachineAfter completing thisfunctions. SQL Server 2014. module, you will be able to:Describe the enhancements to Spatial Data Deploying and Operating SSIS Describe considerations for using VirtualSupport. PackagesAfter completing this module, Machines in Windows Azure.Explain how to store and query documents you will be able to: Create and configure Windows Azurewith SQL Server 2014. Use the CDC Control task to perform virtual machines.Columnstore Indexes incremental data extractions in an ETL Create databases in Windows AzureMemory-Optimized TablesAfter completing solution. virtual machines.this module, you will be able to: Deploy and operate an SSIS project. Windows Azure HDInsightUse the Buffer Pool Extension to improve Using Data Quality Services to Cleanse Consuming HDInsight Results in Excelperformance for read-heavy OLTP Data Obtaining Data from the Windows Azureworkloads. Using Data Quality Services to Match MarketplaceAfter completing this module,Use Columnstore Indexes to improve DataAfter completing this module, you you will be able to:performance in data warehouse query will be able to: Describe key features of big data.workloads. Describe how Data Quality Services can Process big data with Windows AzureUse memory-optimized tables to improve help you manage data quality. HDInsight.performance for latch-bound workloads. Use Data Quality Services to cleanse Consume big data processing results fromUsing PowerShell to Manage SQL your data. Windows Azure HDInsight in MicrosoftServerAfter completing this module, you will Use Data Quality Services to match data. Excel.be able to: Implementing a Master Data ServicesDescribe new and enhanced dynamic Modelmanagement views. Using the Master Data Services Add-in lineDescribe how to use PowerShell to Manage for ExcelAfter completing this module, SQL Server 2014 Editions andSQL Server. you will be able to: ComponentsContained DatabasesAfter completing this Describe key Master Data Services Installing SQL Server 2014module, you will be able to: concepts. Enhancements to SQL ServerDescribe the security enhancements in SQL Implement a Master Data Services Management StudioAfter completing thisServer 2014. model. module, you will be able to:Explain how to use contained databases. Use Master Data Services tools to Describe the common workloads for SQLEnhancements to Data RecoveryAfter manage master data. Server 2014.completing this module, you will be able to: Use Master Data Services tools to create Describe the SQL Server 2014 EditionsDescribe high availability features in SQL a master data hub. and Components.Server 2014. Reporting Services and Microsoft Install SQL Server 2014 Components.Describe data recovery enhancements in SharePoint Server Use the new features in SQL ServerSQL Server 2014. Introduction to Data AlertsAfter Management Studio.Deploying and Operating SSIS completing this module, you will be able New and Enhanced Transact-SQLPackagesAfter completing this module, you to: Functionswill be able to: Describe the key capabilities of Reporting Enhancements to Spatial Data SupportUse the CDC Control task to perform Services. Storing and Querying Documents with SQLincremental data extractions in an ETL Install and configure Reporting Services Server 2014After completing this module,solution. in SharePoint Mode. you will be able to:Deploy and operate an SSIS project. Use data alerts to notify users of changes Describe the enhancements toUsing Data Quality Services to Cleanse to report data. Transact-SQL.Data Creating a Tabular Model Describe new and enhancedUsing Data Quality Services to Match Using an Analysis Services Tabular Data Transact-SQL functions.DataAfter completing this module, you will Model in the EnterpriseAfter completing Describe the enhancements to Spatialbe able to: this module, you will be able to: Data Support.Describe how Data Quality Services can Describe Analysis Services tabular data Explain how to store and query documentshelp you manage data quality. model projects. with SQL Server 2014.Use Data Quality Services to cleanse your Implement an Analysis Services tabular Columnstore Indexesdata. data model. Memory-Optimized TablesAfter completingUse Data Quality Services to match data. Use an Analysis Services tabular data this module, you will be able to:Implementing a Master Data Services Model model. Use the Buffer Pool Extension to improveUsing the Master Data Services Add-in for PowerPivot for SharePoint Server performance for read-heavy OLTPExcelAfter completing this module, you will Power Query workloads.be able to: Power View Use Columnstore Indexes to improveDescribe key Master Data Services Power Map performance in data warehouse queryconcepts. Power BI for Office 365After completing workloads.Implement a Master Data Services model. this module, you will be able to: Use memory-optimized tables to improveUse Master Data Services tools to manage Use PowerPivot to create tabular data performance for latch-bound workloads.master data. models in Excel. Using PowerShell to Manage SQLUse Master Data Services tools to create a Share a PowerPivot workbooks in ServerAfter completing this module, youmaster data hub. SharePoint Server. will be able to:


Reporting Services and Microsoft Use Power Query to discover and import Describe new and enhanced dynamicSharePoint Server data from multiple data sources into management views.Introduction to Data AlertsAfter completing Excel. Describe how to use PowerShell tothis module, you will be able to: Use Power View to create interactive Manage SQL Server.Describe the key capabilities of Reporting data visualizations in Excel and Contained DatabasesAfter completing thisServices. SharePoint Server. module, you will be able to:Install and configure Reporting Services in Use Power Map to create visualizations Describe the security enhancements inSharePoint Mode. of geographic data. SQL Server 2014.Use data alerts to notify users of changes to Use Power BI for Office 365 to create a Explain how to use contained databases.report data. cloud-based collaborative solution for Enhancements to Data RecoveryAfterCreating a Tabular Model self-service BI. completing this module, you will be able to:Using an Analysis Services Tabular Data Windows Azure Services for DataAfter Describe high availability features in SQLModel in the EnterpriseAfter completing this completing this module, you will be able Server 2014.module, you will be able to: to: Describe data recovery enhancements inDescribe Analysis Services tabular data Describe key features and benefits of SQL Server 2014.model projects. cloud computing. Deploying and Operating SSISImplement an Analysis Services tabular data Describe Windows Azure service for PackagesAfter completing this module,model. data. you will be able to:Use an Analysis Services tabular data Windows Azure SQL Database Security Use the CDC Control task to performmodel. Implementing and Managing incremental data extractions in an ETLPowerPivot for SharePoint Server DatabasesAfter completing this module, solution.Power Query you will be able to: Deploy and operate an SSIS project.Power View Describe key features and benefits of Using Data Quality Services to CleansePower Map Windows Azure SQL Database. DataPower BI for Office 365After completing this Implement security for Windows Azure Using Data Quality Services to Matchmodule, you will be able to: SQL Database. DataAfter completing this module, you willUse PowerPivot to create tabular data Implement and manage databases in be able to:models in Excel. Windows Azure SQL Database. Describe how Data Quality Services canShare a PowerPivot workbooks in Windows Azure Virtual Machine help you manage data quality.SharePoint Server. Connectivity and Security Use Data Quality Services to cleanse yourUse Power Query to discover and import Creating Databases in a Windows Azure data.data from multiple data sources into Excel. Virtual MachineAfter completing this Use Data Quality Services to match data.Use Power View to create interactive data module, you will be able to: Implementing a Master Data Servicesvisualizations in Excel and SharePoint Describe considerations for using Virtual ModelServer. Machines in Windows Azure. Using the Master Data Services Add-in forUse Power Map to create visualizations of Create and configure Windows Azure ExcelAfter completing this module, you willgeographic data. virtual machines. be able to:Use Power BI for Office 365 to create a Create databases in Windows Azure Describe key Master Data Servicescloud-based collaborative solution for virtual machines. concepts.self-service BI. Windows Azure HDInsight Implement a Master Data Services model.Windows Azure Services for DataAfter Consuming HDInsight Results in Excel Use Master Data Services tools to managecompleting this module, you will be able to: Obtaining Data from the Windows Azure master data.Describe key features and benefits of cloud MarketplaceAfter completing this module, Use Master Data Services tools to create acomputing. you will be able to: master data hub.Describe Windows Azure service for data. Describe key features of big data. Reporting Services and MicrosoftWindows Azure SQL Database Security Process big data with Windows Azure SharePoint ServerImplementing and Managing DatabasesAfter HDInsight. Introduction to Data AlertsAfter completingcompleting this module, you will be able to: Consume big data processing results this module, you will be able to:Describe key features and benefits of from Windows Azure HDInsight in Describe the key capabilities of ReportingWindows Azure SQL Database. Microsoft Excel. Services.Implement security for Windows Azure SQL Install and configure Reporting Services inDatabase. Module 10: SQL Server 2014 Reporting SharePoint Mode.Implement and manage databases in Services Use data alerts to notify users of changesWindows Azure SQL Database. line to report data.Windows Azure Virtual Machine Connectivity Creating a Tabular Modeland Security This module describes new and enhanced Using an Analysis Services Tabular DataCreating Databases in a Windows Azure features in SQL Server Reporting Services. Model in the EnterpriseAfter completingVirtual MachineAfter completing this line this module, you will be able to:module, you will be able to: Reporting Services Overview Describe Analysis Services tabular dataDescribe considerations for using Virtual model projects.Machines in Windows Azure. Implement an Analysis Services tabularCreate and configure Windows Azure virtual line data model.machines. SQL Server 2014 Editions and Use an Analysis Services tabular dataCreate databases in Windows Azure virtual Components model.machines. Installing SQL Server 2014 PowerPivot for SharePoint ServerWindows Azure HDInsight Enhancements to SQL Server Power Query


Consuming HDInsight Results in Excel Management StudioAfter completing this Power ViewObtaining Data from the Windows Azure module, you will be able to: Power MapMarketplaceAfter completing this module, Describe the common workloads for SQL Power BI for Office 365After completingyou will be able to: Server 2014. this module, you will be able to:Describe key features of big data. Describe the SQL Server 2014 Editions Use PowerPivot to create tabular dataProcess big data with Windows Azure and Components. models in Excel.HDInsight. Install SQL Server 2014 Components. Share a PowerPivot workbooks inConsume big data processing results from Use the new features in SQL Server SharePoint Server.Windows Azure HDInsight in Microsoft Management Studio. Use Power Query to discover and importExcel. New and Enhanced Transact-SQL data from multiple data sources into Excel.

Functions Use Power View to create interactive dataEnhancements to Spatial Data Support visualizations in Excel and SharePoint

line Storing and Querying Documents with Server.SQL Server 2014 Editions and Components SQL Server 2014After completing this Use Power Map to create visualizations ofInstalling SQL Server 2014 module, you will be able to: geographic data.Enhancements to SQL Server Management Describe the enhancements to Use Power BI for Office 365 to create aStudioAfter completing this module, you will Transact-SQL. cloud-based collaborative solution forbe able to: Describe new and enhanced self-service BI.Describe the common workloads for SQL Transact-SQL functions. Windows Azure Services for DataAfterServer 2014. Describe the enhancements to Spatial completing this module, you will be able to:Describe the SQL Server 2014 Editions and Data Support. Describe key features and benefits ofComponents. Explain how to store and query cloud computing.Install SQL Server 2014 Components. documents with SQL Server 2014. Describe Windows Azure service for data.Use the new features in SQL Server Columnstore Indexes Windows Azure SQL Database SecurityManagement Studio. Memory-Optimized TablesAfter Implementing and ManagingNew and Enhanced Transact-SQL Functions completing this module, you will be able DatabasesAfter completing this module,Enhancements to Spatial Data Support to: you will be able to:Storing and Querying Documents with SQL Use the Buffer Pool Extension to improve Describe key features and benefits ofServer 2014After completing this module, performance for read-heavy OLTP Windows Azure SQL Database.you will be able to: workloads. Implement security for Windows AzureDescribe the enhancements to Use Columnstore Indexes to improve SQL Database.Transact-SQL. performance in data warehouse query Implement and manage databases inDescribe new and enhanced Transact-SQL workloads. Windows Azure SQL Database.functions. Use memory-optimized tables to improve Windows Azure Virtual MachineDescribe the enhancements to Spatial Data performance for latch-bound workloads. Connectivity and SecuritySupport. Using PowerShell to Manage SQL Creating Databases in a Windows AzureExplain how to store and query documents ServerAfter completing this module, you Virtual MachineAfter completing thiswith SQL Server 2014. will be able to: module, you will be able to:Columnstore Indexes Describe new and enhanced dynamic Describe considerations for using VirtualMemory-Optimized TablesAfter completing management views. Machines in Windows Azure.this module, you will be able to: Describe how to use PowerShell to Create and configure Windows AzureUse the Buffer Pool Extension to improve Manage SQL Server. virtual machines.performance for read-heavy OLTP Contained DatabasesAfter completing Create databases in Windows Azureworkloads. this module, you will be able to: virtual machines.Use Columnstore Indexes to improve Describe the security enhancements in Windows Azure HDInsightperformance in data warehouse query SQL Server 2014. Consuming HDInsight Results in Excelworkloads. Explain how to use contained databases. Obtaining Data from the Windows AzureUse memory-optimized tables to improve Enhancements to Data RecoveryAfter MarketplaceAfter completing this module,performance for latch-bound workloads. completing this module, you will be able you will be able to:Using PowerShell to Manage SQL to: Describe key features of big data.ServerAfter completing this module, you will Describe high availability features in SQL Process big data with Windows Azurebe able to: Server 2014. HDInsight.Describe new and enhanced dynamic Describe data recovery enhancements in Consume big data processing results frommanagement views. SQL Server 2014. Windows Azure HDInsight in MicrosoftDescribe how to use PowerShell to Manage Deploying and Operating SSIS Excel.SQL Server. PackagesAfter completing this module,Contained DatabasesAfter completing this you will be able to:module, you will be able to: Use the CDC Control task to perform lineDescribe the security enhancements in SQL incremental data extractions in an ETL SQL Server 2014 Editions andServer 2014. solution. ComponentsExplain how to use contained databases. Deploy and operate an SSIS project. Installing SQL Server 2014Enhancements to Data RecoveryAfter Using Data Quality Services to Cleanse Enhancements to SQL Servercompleting this module, you will be able to: Data Management StudioAfter completing thisDescribe high availability features in SQL Using Data Quality Services to Match module, you will be able to:Server 2014. DataAfter completing this module, you Describe the common workloads for SQLDescribe data recovery enhancements in will be able to: Server 2014.


SQL Server 2014. Describe how Data Quality Services can Describe the SQL Server 2014 EditionsDeploying and Operating SSIS help you manage data quality. and Components.PackagesAfter completing this module, you Use Data Quality Services to cleanse Install SQL Server 2014 Components.will be able to: your data. Use the new features in SQL ServerUse the CDC Control task to perform Use Data Quality Services to match data. Management Studio.incremental data extractions in an ETL Implementing a Master Data Services New and Enhanced Transact-SQLsolution. Model FunctionsDeploy and operate an SSIS project. Using the Master Data Services Add-in Enhancements to Spatial Data SupportUsing Data Quality Services to Cleanse for ExcelAfter completing this module, Storing and Querying Documents with SQLData you will be able to: Server 2014After completing this module,Using Data Quality Services to Match Describe key Master Data Services you will be able to:DataAfter completing this module, you will concepts. Describe the enhancements tobe able to: Implement a Master Data Services Transact-SQL.Describe how Data Quality Services can model. Describe new and enhancedhelp you manage data quality. Use Master Data Services tools to Transact-SQL functions.Use Data Quality Services to cleanse your manage master data. Describe the enhancements to Spatialdata. Use Master Data Services tools to create Data Support.Use Data Quality Services to match data. a master data hub. Explain how to store and query documentsImplementing a Master Data Services Model Reporting Services and Microsoft with SQL Server 2014.Using the Master Data Services Add-in for SharePoint Server Columnstore IndexesExcelAfter completing this module, you will Introduction to Data AlertsAfter Memory-Optimized TablesAfter completingbe able to: completing this module, you will be able this module, you will be able to:Describe key Master Data Services to: Use the Buffer Pool Extension to improveconcepts. Describe the key capabilities of Reporting performance for read-heavy OLTPImplement a Master Data Services model. Services. workloads.Use Master Data Services tools to manage Install and configure Reporting Services Use Columnstore Indexes to improvemaster data. in SharePoint Mode. performance in data warehouse queryUse Master Data Services tools to create a Use data alerts to notify users of changes workloads.master data hub. to report data. Use memory-optimized tables to improveReporting Services and Microsoft Creating a Tabular Model performance for latch-bound workloads.SharePoint Server Using an Analysis Services Tabular Data Using PowerShell to Manage SQLIntroduction to Data AlertsAfter completing Model in the EnterpriseAfter completing ServerAfter completing this module, youthis module, you will be able to: this module, you will be able to: will be able to:Describe the key capabilities of Reporting Describe Analysis Services tabular data Describe new and enhanced dynamicServices. model projects. management views.Install and configure Reporting Services in Implement an Analysis Services tabular Describe how to use PowerShell toSharePoint Mode. data model. Manage SQL Server.Use data alerts to notify users of changes to Use an Analysis Services tabular data Contained DatabasesAfter completing thisreport data. model. module, you will be able to:Creating a Tabular Model PowerPivot for SharePoint Server Describe the security enhancements inUsing an Analysis Services Tabular Data Power Query SQL Server 2014.Model in the EnterpriseAfter completing this Power View Explain how to use contained databases.module, you will be able to: Power Map Enhancements to Data RecoveryAfterDescribe Analysis Services tabular data Power BI for Office 365After completing completing this module, you will be able to:model projects. this module, you will be able to: Describe high availability features in SQLImplement an Analysis Services tabular data Use PowerPivot to create tabular data Server 2014.model. models in Excel. Describe data recovery enhancements inUse an Analysis Services tabular data Share a PowerPivot workbooks in SQL Server 2014.model. SharePoint Server. Deploying and Operating SSISPowerPivot for SharePoint Server Use Power Query to discover and import PackagesAfter completing this module,Power Query data from multiple data sources into you will be able to:Power View Excel. Use the CDC Control task to performPower Map Use Power View to create interactive incremental data extractions in an ETLPower BI for Office 365After completing this data visualizations in Excel and solution.module, you will be able to: SharePoint Server. Deploy and operate an SSIS project.Use PowerPivot to create tabular data Use Power Map to create visualizations Using Data Quality Services to Cleansemodels in Excel. of geographic data. DataShare a PowerPivot workbooks in Use Power BI for Office 365 to create a Using Data Quality Services to MatchSharePoint Server. cloud-based collaborative solution for DataAfter completing this module, you willUse Power Query to discover and import self-service BI. be able to:data from multiple data sources into Excel. Windows Azure Services for DataAfter Describe how Data Quality Services canUse Power View to create interactive data completing this module, you will be able help you manage data quality.visualizations in Excel and SharePoint to: Use Data Quality Services to cleanse yourServer. Describe key features and benefits of data.Use Power Map to create visualizations of cloud computing. Use Data Quality Services to match data.geographic data. Describe Windows Azure service for Implementing a Master Data Services


Use Power BI for Office 365 to create a data. Modelcloud-based collaborative solution for Windows Azure SQL Database Security Using the Master Data Services Add-in forself-service BI. Implementing and Managing ExcelAfter completing this module, you willWindows Azure Services for DataAfter DatabasesAfter completing this module, be able to:completing this module, you will be able to: you will be able to: Describe key Master Data ServicesDescribe key features and benefits of cloud Describe key features and benefits of concepts.computing. Windows Azure SQL Database. Implement a Master Data Services model.Describe Windows Azure service for data. Implement security for Windows Azure Use Master Data Services tools to manageWindows Azure SQL Database Security SQL Database. master data.Implementing and Managing DatabasesAfter Implement and manage databases in Use Master Data Services tools to create acompleting this module, you will be able to: Windows Azure SQL Database. master data hub.Describe key features and benefits of Windows Azure Virtual Machine Reporting Services and MicrosoftWindows Azure SQL Database. Connectivity and Security SharePoint ServerImplement security for Windows Azure SQL Creating Databases in a Windows Azure Introduction to Data AlertsAfter completingDatabase. Virtual MachineAfter completing this this module, you will be able to:Implement and manage databases in module, you will be able to: Describe the key capabilities of ReportingWindows Azure SQL Database. Describe considerations for using Virtual Services.Windows Azure Virtual Machine Connectivity Machines in Windows Azure. Install and configure Reporting Services inand Security Create and configure Windows Azure SharePoint Mode.Creating Databases in a Windows Azure virtual machines. Use data alerts to notify users of changesVirtual MachineAfter completing this Create databases in Windows Azure to report data.module, you will be able to: virtual machines. Creating a Tabular ModelDescribe considerations for using Virtual Windows Azure HDInsight Using an Analysis Services Tabular DataMachines in Windows Azure. Consuming HDInsight Results in Excel Model in the EnterpriseAfter completingCreate and configure Windows Azure virtual Obtaining Data from the Windows Azure this module, you will be able to:machines. MarketplaceAfter completing this module, Describe Analysis Services tabular dataCreate databases in Windows Azure virtual you will be able to: model projects.machines. Describe key features of big data. Implement an Analysis Services tabularWindows Azure HDInsight Process big data with Windows Azure data model.Consuming HDInsight Results in Excel HDInsight. Use an Analysis Services tabular dataObtaining Data from the Windows Azure Consume big data processing results model.MarketplaceAfter completing this module, from Windows Azure HDInsight in PowerPivot for SharePoint Serveryou will be able to: Microsoft Excel. Power QueryDescribe key features of big data. Power ViewProcess big data with Windows Azure Power MapHDInsight. line Power BI for Office 365After completingConsume big data processing results from SQL Server 2014 Editions and this module, you will be able to:Windows Azure HDInsight in Microsoft Components Use PowerPivot to create tabular dataExcel. Installing SQL Server 2014 models in Excel.

Enhancements to SQL Server Share a PowerPivot workbooks inManagement StudioAfter completing this SharePoint Server.

line module, you will be able to: Use Power Query to discover and importSQL Server 2014 Editions and Components Describe the common workloads for SQL data from multiple data sources into Excel.Installing SQL Server 2014 Server 2014. Use Power View to create interactive dataEnhancements to SQL Server Management Describe the SQL Server 2014 Editions visualizations in Excel and SharePointStudioAfter completing this module, you will and Components. Server.be able to: Install SQL Server 2014 Components. Use Power Map to create visualizations ofDescribe the common workloads for SQL Use the new features in SQL Server geographic data.Server 2014. Management Studio. Use Power BI for Office 365 to create aDescribe the SQL Server 2014 Editions and New and Enhanced Transact-SQL cloud-based collaborative solution forComponents. Functions self-service BI.Install SQL Server 2014 Components. Enhancements to Spatial Data Support Windows Azure Services for DataAfterUse the new features in SQL Server Storing and Querying Documents with completing this module, you will be able to:Management Studio. SQL Server 2014After completing this Describe key features and benefits ofNew and Enhanced Transact-SQL Functions module, you will be able to: cloud computing.Enhancements to Spatial Data Support Describe the enhancements to Describe Windows Azure service for data.Storing and Querying Documents with SQL Transact-SQL. Windows Azure SQL Database SecurityServer 2014After completing this module, Describe new and enhanced Implementing and Managingyou will be able to: Transact-SQL functions. DatabasesAfter completing this module,Describe the enhancements to Describe the enhancements to Spatial you will be able to:Transact-SQL. Data Support. Describe key features and benefits ofDescribe new and enhanced Transact-SQL Explain how to store and query Windows Azure SQL Database.functions. documents with SQL Server 2014. Implement security for Windows AzureDescribe the enhancements to Spatial Data Columnstore Indexes SQL Database.Support. Memory-Optimized TablesAfter Implement and manage databases inExplain how to store and query documents completing this module, you will be able Windows Azure SQL Database.


with SQL Server 2014. to: Windows Azure Virtual MachineColumnstore Indexes Use the Buffer Pool Extension to improve Connectivity and SecurityMemory-Optimized TablesAfter completing performance for read-heavy OLTP Creating Databases in a Windows Azurethis module, you will be able to: workloads. Virtual MachineAfter completing thisUse the Buffer Pool Extension to improve Use Columnstore Indexes to improve module, you will be able to:performance for read-heavy OLTP performance in data warehouse query Describe considerations for using Virtualworkloads. workloads. Machines in Windows Azure.Use Columnstore Indexes to improve Use memory-optimized tables to improve Create and configure Windows Azureperformance in data warehouse query performance for latch-bound workloads. virtual machines.workloads. Using PowerShell to Manage SQL Create databases in Windows AzureUse memory-optimized tables to improve ServerAfter completing this module, you virtual machines.performance for latch-bound workloads. will be able to: Windows Azure HDInsightUsing PowerShell to Manage SQL Describe new and enhanced dynamic Consuming HDInsight Results in ExcelServerAfter completing this module, you will management views. Obtaining Data from the Windows Azurebe able to: Describe how to use PowerShell to MarketplaceAfter completing this module,Describe new and enhanced dynamic Manage SQL Server. you will be able to:management views. Contained DatabasesAfter completing Describe key features of big data.Describe how to use PowerShell to Manage this module, you will be able to: Process big data with Windows AzureSQL Server. Describe the security enhancements in HDInsight.Contained DatabasesAfter completing this SQL Server 2014. Consume big data processing results frommodule, you will be able to: Explain how to use contained databases. Windows Azure HDInsight in MicrosoftDescribe the security enhancements in SQL Enhancements to Data RecoveryAfter Excel.Server 2014. completing this module, you will be ableExplain how to use contained databases. to:Enhancements to Data RecoveryAfter Describe high availability features in SQL linecompleting this module, you will be able to: Server 2014. SQL Server 2014 Editions andDescribe high availability features in SQL Describe data recovery enhancements in ComponentsServer 2014. SQL Server 2014. Installing SQL Server 2014Describe data recovery enhancements in Deploying and Operating SSIS Enhancements to SQL ServerSQL Server 2014. PackagesAfter completing this module, Management StudioAfter completing thisDeploying and Operating SSIS you will be able to: module, you will be able to:PackagesAfter completing this module, you Use the CDC Control task to perform Describe the common workloads for SQLwill be able to: incremental data extractions in an ETL Server 2014.Use the CDC Control task to perform solution. Describe the SQL Server 2014 Editionsincremental data extractions in an ETL Deploy and operate an SSIS project. and Components.solution. Using Data Quality Services to Cleanse Install SQL Server 2014 Components.Deploy and operate an SSIS project. Data Use the new features in SQL ServerUsing Data Quality Services to Cleanse Using Data Quality Services to Match Management Studio.Data DataAfter completing this module, you New and Enhanced Transact-SQLUsing Data Quality Services to Match will be able to: FunctionsDataAfter completing this module, you will Describe how Data Quality Services can Enhancements to Spatial Data Supportbe able to: help you manage data quality. Storing and Querying Documents with SQLDescribe how Data Quality Services can Use Data Quality Services to cleanse Server 2014After completing this module,help you manage data quality. your data. you will be able to:Use Data Quality Services to cleanse your Use Data Quality Services to match data. Describe the enhancements todata. Implementing a Master Data Services Transact-SQL.Use Data Quality Services to match data. Model Describe new and enhancedImplementing a Master Data Services Model Using the Master Data Services Add-in Transact-SQL functions.Using the Master Data Services Add-in for for ExcelAfter completing this module, Describe the enhancements to SpatialExcelAfter completing this module, you will you will be able to: Data Support.be able to: Describe key Master Data Services Explain how to store and query documentsDescribe key Master Data Services concepts. with SQL Server 2014.concepts. Implement a Master Data Services Columnstore IndexesImplement a Master Data Services model. model. Memory-Optimized TablesAfter completingUse Master Data Services tools to manage Use Master Data Services tools to this module, you will be able to:master data. manage master data. Use the Buffer Pool Extension to improveUse Master Data Services tools to create a Use Master Data Services tools to create performance for read-heavy OLTPmaster data hub. a master data hub. workloads.Reporting Services and Microsoft Reporting Services and Microsoft Use Columnstore Indexes to improveSharePoint Server SharePoint Server performance in data warehouse queryIntroduction to Data AlertsAfter completing Introduction to Data AlertsAfter workloads.this module, you will be able to: completing this module, you will be able Use memory-optimized tables to improveDescribe the key capabilities of Reporting to: performance for latch-bound workloads.Services. Describe the key capabilities of Reporting Using PowerShell to Manage SQLInstall and configure Reporting Services in Services. ServerAfter completing this module, youSharePoint Mode. Install and configure Reporting Services will be able to:


Use data alerts to notify users of changes to in SharePoint Mode. Describe new and enhanced dynamicreport data. Use data alerts to notify users of changes management views.Creating a Tabular Model to report data. Describe how to use PowerShell toUsing an Analysis Services Tabular Data Creating a Tabular Model Manage SQL Server.Model in the EnterpriseAfter completing this Using an Analysis Services Tabular Data Contained DatabasesAfter completing thismodule, you will be able to: Model in the EnterpriseAfter completing module, you will be able to:Describe Analysis Services tabular data this module, you will be able to: Describe the security enhancements inmodel projects. Describe Analysis Services tabular data SQL Server 2014.Implement an Analysis Services tabular data model projects. Explain how to use contained databases.model. Implement an Analysis Services tabular Enhancements to Data RecoveryAfterUse an Analysis Services tabular data data model. completing this module, you will be able to:model. Use an Analysis Services tabular data Describe high availability features in SQLPowerPivot for SharePoint Server model. Server 2014.Power Query PowerPivot for SharePoint Server Describe data recovery enhancements inPower View Power Query SQL Server 2014.Power Map Power View Deploying and Operating SSISPower BI for Office 365After completing this Power Map PackagesAfter completing this module,module, you will be able to: Power BI for Office 365After completing you will be able to:Use PowerPivot to create tabular data this module, you will be able to: Use the CDC Control task to performmodels in Excel. Use PowerPivot to create tabular data incremental data extractions in an ETLShare a PowerPivot workbooks in models in Excel. solution.SharePoint Server. Share a PowerPivot workbooks in Deploy and operate an SSIS project.Use Power Query to discover and import SharePoint Server. Using Data Quality Services to Cleansedata from multiple data sources into Excel. Use Power Query to discover and import DataUse Power View to create interactive data data from multiple data sources into Using Data Quality Services to Matchvisualizations in Excel and SharePoint Excel. DataAfter completing this module, you willServer. Use Power View to create interactive be able to:Use Power Map to create visualizations of data visualizations in Excel and Describe how Data Quality Services cangeographic data. SharePoint Server. help you manage data quality.Use Power BI for Office 365 to create a Use Power Map to create visualizations Use Data Quality Services to cleanse yourcloud-based collaborative solution for of geographic data. data.self-service BI. Use Power BI for Office 365 to create a Use Data Quality Services to match data.Windows Azure Services for DataAfter cloud-based collaborative solution for Implementing a Master Data Servicescompleting this module, you will be able to: self-service BI. ModelDescribe key features and benefits of cloud Windows Azure Services for DataAfter Using the Master Data Services Add-in forcomputing. completing this module, you will be able ExcelAfter completing this module, you willDescribe Windows Azure service for data. to: be able to:Windows Azure SQL Database Security Describe key features and benefits of Describe key Master Data ServicesImplementing and Managing DatabasesAfter cloud computing. concepts.completing this module, you will be able to: Describe Windows Azure service for Implement a Master Data Services model.Describe key features and benefits of data. Use Master Data Services tools to manageWindows Azure SQL Database. Windows Azure SQL Database Security master data.Implement security for Windows Azure SQL Implementing and Managing Use Master Data Services tools to create aDatabase. DatabasesAfter completing this module, master data hub.Implement and manage databases in you will be able to: Reporting Services and MicrosoftWindows Azure SQL Database. Describe key features and benefits of SharePoint ServerWindows Azure Virtual Machine Connectivity Windows Azure SQL Database. Introduction to Data AlertsAfter completingand Security Implement security for Windows Azure this module, you will be able to:Creating Databases in a Windows Azure SQL Database. Describe the key capabilities of ReportingVirtual MachineAfter completing this Implement and manage databases in Services.module, you will be able to: Windows Azure SQL Database. Install and configure Reporting Services inDescribe considerations for using Virtual Windows Azure Virtual Machine SharePoint Mode.Machines in Windows Azure. Connectivity and Security Use data alerts to notify users of changesCreate and configure Windows Azure virtual Creating Databases in a Windows Azure to report data.machines. Virtual MachineAfter completing this Creating a Tabular ModelCreate databases in Windows Azure virtual module, you will be able to: Using an Analysis Services Tabular Datamachines. Describe considerations for using Virtual Model in the EnterpriseAfter completingWindows Azure HDInsight Machines in Windows Azure. this module, you will be able to:Consuming HDInsight Results in Excel Create and configure Windows Azure Describe Analysis Services tabular dataObtaining Data from the Windows Azure virtual machines. model projects.MarketplaceAfter completing this module, Create databases in Windows Azure Implement an Analysis Services tabularyou will be able to: virtual machines. data model.Describe key features of big data. Windows Azure HDInsight Use an Analysis Services tabular dataProcess big data with Windows Azure Consuming HDInsight Results in Excel model.HDInsight. Obtaining Data from the Windows Azure PowerPivot for SharePoint ServerConsume big data processing results from MarketplaceAfter completing this module, Power Query


Windows Azure HDInsight in Microsoft you will be able to: Power ViewExcel. Describe key features of big data. Power Map

Process big data with Windows Azure Power BI for Office 365After completingHDInsight. this module, you will be able to:

line Consume big data processing results Use PowerPivot to create tabular dataSQL Server 2014 Editions and Components from Windows Azure HDInsight in models in Excel.Installing SQL Server 2014 Microsoft Excel. Share a PowerPivot workbooks inEnhancements to SQL Server Management SharePoint Server.StudioAfter completing this module, you will Use Power Query to discover and importbe able to: line data from multiple data sources into Excel.Describe the common workloads for SQL SQL Server 2014 Editions and Use Power View to create interactive dataServer 2014. Components visualizations in Excel and SharePointDescribe the SQL Server 2014 Editions and Installing SQL Server 2014 Server.Components. Enhancements to SQL Server Use Power Map to create visualizations ofInstall SQL Server 2014 Components. Management StudioAfter completing this geographic data.Use the new features in SQL Server module, you will be able to: Use Power BI for Office 365 to create aManagement Studio. Describe the common workloads for SQL cloud-based collaborative solution forNew and Enhanced Transact-SQL Functions Server 2014. self-service BI.Enhancements to Spatial Data Support Describe the SQL Server 2014 Editions Windows Azure Services for DataAfterStoring and Querying Documents with SQL and Components. completing this module, you will be able to:Server 2014After completing this module, Install SQL Server 2014 Components. Describe key features and benefits ofyou will be able to: Use the new features in SQL Server cloud computing.Describe the enhancements to Management Studio. Describe Windows Azure service for data.Transact-SQL. New and Enhanced Transact-SQL Windows Azure SQL Database SecurityDescribe new and enhanced Transact-SQL Functions Implementing and Managingfunctions. Enhancements to Spatial Data Support DatabasesAfter completing this module,Describe the enhancements to Spatial Data Storing and Querying Documents with you will be able to:Support. SQL Server 2014After completing this Describe key features and benefits ofExplain how to store and query documents module, you will be able to: Windows Azure SQL Database.with SQL Server 2014. Describe the enhancements to Implement security for Windows AzureColumnstore Indexes Transact-SQL. SQL Database.Memory-Optimized TablesAfter completing Describe new and enhanced Implement and manage databases inthis module, you will be able to: Transact-SQL functions. Windows Azure SQL Database.Use the Buffer Pool Extension to improve Describe the enhancements to Spatial Windows Azure Virtual Machineperformance for read-heavy OLTP Data Support. Connectivity and Securityworkloads. Explain how to store and query Creating Databases in a Windows AzureUse Columnstore Indexes to improve documents with SQL Server 2014. Virtual MachineAfter completing thisperformance in data warehouse query Columnstore Indexes module, you will be able to:workloads. Memory-Optimized TablesAfter Describe considerations for using VirtualUse memory-optimized tables to improve completing this module, you will be able Machines in Windows Azure.performance for latch-bound workloads. to: Create and configure Windows AzureUsing PowerShell to Manage SQL Use the Buffer Pool Extension to improve virtual machines.ServerAfter completing this module, you will performance for read-heavy OLTP Create databases in Windows Azurebe able to: workloads. virtual machines.Describe new and enhanced dynamic Use Columnstore Indexes to improve Windows Azure HDInsightmanagement views. performance in data warehouse query Consuming HDInsight Results in ExcelDescribe how to use PowerShell to Manage workloads. Obtaining Data from the Windows AzureSQL Server. Use memory-optimized tables to improve MarketplaceAfter completing this module,Contained DatabasesAfter completing this performance for latch-bound workloads. you will be able to:module, you will be able to: Using PowerShell to Manage SQL Describe key features of big data.Describe the security enhancements in SQL ServerAfter completing this module, you Process big data with Windows AzureServer 2014. will be able to: HDInsight.Explain how to use contained databases. Describe new and enhanced dynamic Consume big data processing results fromEnhancements to Data RecoveryAfter management views. Windows Azure HDInsight in Microsoftcompleting this module, you will be able to: Describe how to use PowerShell to Excel.Describe high availability features in SQL Manage SQL Server.Server 2014. Contained DatabasesAfter completing Module 15: SQL Server in Windows AzureDescribe data recovery enhancements in this module, you will be able to: Virtual MachinesSQL Server 2014. Describe the security enhancements in lineDeploying and Operating SSIS SQL Server 2014.PackagesAfter completing this module, you Explain how to use contained databases. This module explores how you can usewill be able to: Enhancements to Data RecoveryAfter Windows Azure virtual machines in whichUse the CDC Control task to perform completing this module, you will be able SQL Server is installed to create aincremental data extractions in an ETL to: cloud-based solution for data.solution. Describe high availability features in SQL lineDeploy and operate an SSIS project. Server 2014. Introduction to Windows Azure Virtual


Using Data Quality Services to Cleanse Describe data recovery enhancements in MachinesData SQL Server 2014.Using Data Quality Services to Match Deploying and Operating SSISDataAfter completing this module, you will PackagesAfter completing this module, linebe able to: you will be able to: SQL Server 2014 Editions andDescribe how Data Quality Services can Use the CDC Control task to perform Componentshelp you manage data quality. incremental data extractions in an ETL Installing SQL Server 2014Use Data Quality Services to cleanse your solution. Enhancements to SQL Serverdata. Deploy and operate an SSIS project. Management StudioAfter completing thisUse Data Quality Services to match data. Using Data Quality Services to Cleanse module, you will be able to:Implementing a Master Data Services Model Data Describe the common workloads for SQLUsing the Master Data Services Add-in for Using Data Quality Services to Match Server 2014.ExcelAfter completing this module, you will DataAfter completing this module, you Describe the SQL Server 2014 Editionsbe able to: will be able to: and Components.Describe key Master Data Services Describe how Data Quality Services can Install SQL Server 2014 Components.concepts. help you manage data quality. Use the new features in SQL ServerImplement a Master Data Services model. Use Data Quality Services to cleanse Management Studio.Use Master Data Services tools to manage your data. New and Enhanced Transact-SQLmaster data. Use Data Quality Services to match data. FunctionsUse Master Data Services tools to create a Implementing a Master Data Services Enhancements to Spatial Data Supportmaster data hub. Model Storing and Querying Documents with SQLReporting Services and Microsoft Using the Master Data Services Add-in Server 2014After completing this module,SharePoint Server for ExcelAfter completing this module, you will be able to:Introduction to Data AlertsAfter completing you will be able to: Describe the enhancements tothis module, you will be able to: Describe key Master Data Services Transact-SQL.Describe the key capabilities of Reporting concepts. Describe new and enhancedServices. Implement a Master Data Services Transact-SQL functions.Install and configure Reporting Services in model. Describe the enhancements to SpatialSharePoint Mode. Use Master Data Services tools to Data Support.Use data alerts to notify users of changes to manage master data. Explain how to store and query documentsreport data. Use Master Data Services tools to create with SQL Server 2014.Creating a Tabular Model a master data hub. Columnstore IndexesUsing an Analysis Services Tabular Data Reporting Services and Microsoft Memory-Optimized TablesAfter completingModel in the EnterpriseAfter completing this SharePoint Server this module, you will be able to:module, you will be able to: Introduction to Data AlertsAfter Use the Buffer Pool Extension to improveDescribe Analysis Services tabular data completing this module, you will be able performance for read-heavy OLTPmodel projects. to: workloads.Implement an Analysis Services tabular data Describe the key capabilities of Reporting Use Columnstore Indexes to improvemodel. Services. performance in data warehouse queryUse an Analysis Services tabular data Install and configure Reporting Services workloads.model. in SharePoint Mode. Use memory-optimized tables to improvePowerPivot for SharePoint Server Use data alerts to notify users of changes performance for latch-bound workloads.Power Query to report data. Using PowerShell to Manage SQLPower View Creating a Tabular Model ServerAfter completing this module, youPower Map Using an Analysis Services Tabular Data will be able to:Power BI for Office 365After completing this Model in the EnterpriseAfter completing Describe new and enhanced dynamicmodule, you will be able to: this module, you will be able to: management views.Use PowerPivot to create tabular data Describe Analysis Services tabular data Describe how to use PowerShell tomodels in Excel. model projects. Manage SQL Server.Share a PowerPivot workbooks in Implement an Analysis Services tabular Contained DatabasesAfter completing thisSharePoint Server. data model. module, you will be able to:Use Power Query to discover and import Use an Analysis Services tabular data Describe the security enhancements indata from multiple data sources into Excel. model. SQL Server 2014.Use Power View to create interactive data PowerPivot for SharePoint Server Explain how to use contained databases.visualizations in Excel and SharePoint Power Query Enhancements to Data RecoveryAfterServer. Power View completing this module, you will be able to:Use Power Map to create visualizations of Power Map Describe high availability features in SQLgeographic data. Power BI for Office 365After completing Server 2014.Use Power BI for Office 365 to create a this module, you will be able to: Describe data recovery enhancements incloud-based collaborative solution for Use PowerPivot to create tabular data SQL Server 2014.self-service BI. models in Excel. Deploying and Operating SSISWindows Azure Services for DataAfter Share a PowerPivot workbooks in PackagesAfter completing this module,completing this module, you will be able to: SharePoint Server. you will be able to:Describe key features and benefits of cloud Use Power Query to discover and import Use the CDC Control task to performcomputing. data from multiple data sources into incremental data extractions in an ETLDescribe Windows Azure service for data. Excel. solution.


Windows Azure SQL Database Security Use Power View to create interactive Deploy and operate an SSIS project.Implementing and Managing DatabasesAfter data visualizations in Excel and Using Data Quality Services to Cleansecompleting this module, you will be able to: SharePoint Server. DataDescribe key features and benefits of Use Power Map to create visualizations Using Data Quality Services to MatchWindows Azure SQL Database. of geographic data. DataAfter completing this module, you willImplement security for Windows Azure SQL Use Power BI for Office 365 to create a be able to:Database. cloud-based collaborative solution for Describe how Data Quality Services canImplement and manage databases in self-service BI. help you manage data quality.Windows Azure SQL Database. Windows Azure Services for DataAfter Use Data Quality Services to cleanse yourWindows Azure Virtual Machine Connectivity completing this module, you will be able data.and Security to: Use Data Quality Services to match data.Creating Databases in a Windows Azure Describe key features and benefits of Implementing a Master Data ServicesVirtual MachineAfter completing this cloud computing. Modelmodule, you will be able to: Describe Windows Azure service for Using the Master Data Services Add-in forDescribe considerations for using Virtual data. ExcelAfter completing this module, you willMachines in Windows Azure. Windows Azure SQL Database Security be able to:Create and configure Windows Azure virtual Implementing and Managing Describe key Master Data Servicesmachines. DatabasesAfter completing this module, concepts.Create databases in Windows Azure virtual you will be able to: Implement a Master Data Services model.machines. Describe key features and benefits of Use Master Data Services tools to manageWindows Azure HDInsight Windows Azure SQL Database. master data.Consuming HDInsight Results in Excel Implement security for Windows Azure Use Master Data Services tools to create aObtaining Data from the Windows Azure SQL Database. master data hub.MarketplaceAfter completing this module, Implement and manage databases in Reporting Services and Microsoftyou will be able to: Windows Azure SQL Database. SharePoint ServerDescribe key features of big data. Windows Azure Virtual Machine Introduction to Data AlertsAfter completingProcess big data with Windows Azure Connectivity and Security this module, you will be able to:HDInsight. Creating Databases in a Windows Azure Describe the key capabilities of ReportingConsume big data processing results from Virtual MachineAfter completing this Services.Windows Azure HDInsight in Microsoft module, you will be able to: Install and configure Reporting Services inExcel. Describe considerations for using Virtual SharePoint Mode.

Machines in Windows Azure. Use data alerts to notify users of changesModule 4: Scripting SQL Server 2014 Create and configure Windows Azure to report data.line virtual machines. Creating a Tabular Model

Create databases in Windows Azure Using an Analysis Services Tabular DataThis lesson describes how you can use virtual machines. Model in the EnterpriseAfter completingdynamic management views and PowerShell to Windows Azure HDInsight this module, you will be able to:script administrative tasks in SQL server 2014. Consuming HDInsight Results in Excel Describe Analysis Services tabular dataline Obtaining Data from the Windows Azure model projects.

New and Enhanced Dynamic Management MarketplaceAfter completing this module, Implement an Analysis Services tabularViews you will be able to: data model.

Describe key features of big data. Use an Analysis Services tabular dataProcess big data with Windows Azure model.

line HDInsight. PowerPivot for SharePoint ServerSQL Server 2014 Editions and Components Consume big data processing results Power QueryInstalling SQL Server 2014 from Windows Azure HDInsight in Power ViewEnhancements to SQL Server Management Microsoft Excel. Power MapStudioAfter completing this module, you will Power BI for Office 365After completingbe able to: this module, you will be able to:Describe the common workloads for SQL line Use PowerPivot to create tabular dataServer 2014. SQL Server 2014 Editions and models in Excel.Describe the SQL Server 2014 Editions and Components Share a PowerPivot workbooks inComponents. Installing SQL Server 2014 SharePoint Server.Install SQL Server 2014 Components. Enhancements to SQL Server Use Power Query to discover and importUse the new features in SQL Server Management StudioAfter completing this data from multiple data sources into Excel.Management Studio. module, you will be able to: Use Power View to create interactive dataNew and Enhanced Transact-SQL Functions Describe the common workloads for SQL visualizations in Excel and SharePointEnhancements to Spatial Data Support Server 2014. Server.Storing and Querying Documents with SQL Describe the SQL Server 2014 Editions Use Power Map to create visualizations ofServer 2014After completing this module, and Components. geographic data.you will be able to: Install SQL Server 2014 Components. Use Power BI for Office 365 to create aDescribe the enhancements to Use the new features in SQL Server cloud-based collaborative solution forTransact-SQL. Management Studio. self-service BI.Describe new and enhanced Transact-SQL New and Enhanced Transact-SQL Windows Azure Services for DataAfterfunctions. Functions completing this module, you will be able to:Describe the enhancements to Spatial Data Enhancements to Spatial Data Support Describe key features and benefits of


Support. Storing and Querying Documents with cloud computing.Explain how to store and query documents SQL Server 2014After completing this Describe Windows Azure service for data.with SQL Server 2014. module, you will be able to: Windows Azure SQL Database SecurityColumnstore Indexes Describe the enhancements to Implementing and ManagingMemory-Optimized TablesAfter completing Transact-SQL. DatabasesAfter completing this module,this module, you will be able to: Describe new and enhanced you will be able to:Use the Buffer Pool Extension to improve Transact-SQL functions. Describe key features and benefits ofperformance for read-heavy OLTP Describe the enhancements to Spatial Windows Azure SQL Database.workloads. Data Support. Implement security for Windows AzureUse Columnstore Indexes to improve Explain how to store and query SQL Database.performance in data warehouse query documents with SQL Server 2014. Implement and manage databases inworkloads. Columnstore Indexes Windows Azure SQL Database.Use memory-optimized tables to improve Memory-Optimized TablesAfter Windows Azure Virtual Machineperformance for latch-bound workloads. completing this module, you will be able Connectivity and SecurityUsing PowerShell to Manage SQL to: Creating Databases in a Windows AzureServerAfter completing this module, you will Use the Buffer Pool Extension to improve Virtual MachineAfter completing thisbe able to: performance for read-heavy OLTP module, you will be able to:Describe new and enhanced dynamic workloads. Describe considerations for using Virtualmanagement views. Use Columnstore Indexes to improve Machines in Windows Azure.Describe how to use PowerShell to Manage performance in data warehouse query Create and configure Windows AzureSQL Server. workloads. virtual machines.Contained DatabasesAfter completing this Use memory-optimized tables to improve Create databases in Windows Azuremodule, you will be able to: performance for latch-bound workloads. virtual machines.Describe the security enhancements in SQL Using PowerShell to Manage SQL Windows Azure HDInsightServer 2014. ServerAfter completing this module, you Consuming HDInsight Results in ExcelExplain how to use contained databases. will be able to: Obtaining Data from the Windows AzureEnhancements to Data RecoveryAfter Describe new and enhanced dynamic MarketplaceAfter completing this module,completing this module, you will be able to: management views. you will be able to:Describe high availability features in SQL Describe how to use PowerShell to Describe key features of big data.Server 2014. Manage SQL Server. Process big data with Windows AzureDescribe data recovery enhancements in Contained DatabasesAfter completing HDInsight.SQL Server 2014. this module, you will be able to: Consume big data processing results fromDeploying and Operating SSIS Describe the security enhancements in Windows Azure HDInsight in MicrosoftPackagesAfter completing this module, you SQL Server 2014. Excel.will be able to: Explain how to use contained databases.Use the CDC Control task to perform Enhancements to Data RecoveryAfterincremental data extractions in an ETL completing this module, you will be able linesolution. to: SQL Server 2014 Editions andDeploy and operate an SSIS project. Describe high availability features in SQL ComponentsUsing Data Quality Services to Cleanse Server 2014. Installing SQL Server 2014Data Describe data recovery enhancements in Enhancements to SQL ServerUsing Data Quality Services to Match SQL Server 2014. Management StudioAfter completing thisDataAfter completing this module, you will Deploying and Operating SSIS module, you will be able to:be able to: PackagesAfter completing this module, Describe the common workloads for SQLDescribe how Data Quality Services can you will be able to: Server 2014.help you manage data quality. Use the CDC Control task to perform Describe the SQL Server 2014 EditionsUse Data Quality Services to cleanse your incremental data extractions in an ETL and Components.data. solution. Install SQL Server 2014 Components.Use Data Quality Services to match data. Deploy and operate an SSIS project. Use the new features in SQL ServerImplementing a Master Data Services Model Using Data Quality Services to Cleanse Management Studio.Using the Master Data Services Add-in for Data New and Enhanced Transact-SQLExcelAfter completing this module, you will Using Data Quality Services to Match Functionsbe able to: DataAfter completing this module, you Enhancements to Spatial Data SupportDescribe key Master Data Services will be able to: Storing and Querying Documents with SQLconcepts. Describe how Data Quality Services can Server 2014After completing this module,Implement a Master Data Services model. help you manage data quality. you will be able to:Use Master Data Services tools to manage Use Data Quality Services to cleanse Describe the enhancements tomaster data. your data. Transact-SQL.Use Master Data Services tools to create a Use Data Quality Services to match data. Describe new and enhancedmaster data hub. Implementing a Master Data Services Transact-SQL functions.Reporting Services and Microsoft Model Describe the enhancements to SpatialSharePoint Server Using the Master Data Services Add-in Data Support.Introduction to Data AlertsAfter completing for ExcelAfter completing this module, Explain how to store and query documentsthis module, you will be able to: you will be able to: with SQL Server 2014.Describe the key capabilities of Reporting Describe key Master Data Services Columnstore IndexesServices. concepts. Memory-Optimized TablesAfter completing


Install and configure Reporting Services in Implement a Master Data Services this module, you will be able to:SharePoint Mode. model. Use the Buffer Pool Extension to improveUse data alerts to notify users of changes to Use Master Data Services tools to performance for read-heavy OLTPreport data. manage master data. workloads.Creating a Tabular Model Use Master Data Services tools to create Use Columnstore Indexes to improveUsing an Analysis Services Tabular Data a master data hub. performance in data warehouse queryModel in the EnterpriseAfter completing this Reporting Services and Microsoft workloads.module, you will be able to: SharePoint Server Use memory-optimized tables to improveDescribe Analysis Services tabular data Introduction to Data AlertsAfter performance for latch-bound workloads.model projects. completing this module, you will be able Using PowerShell to Manage SQLImplement an Analysis Services tabular data to: ServerAfter completing this module, youmodel. Describe the key capabilities of Reporting will be able to:Use an Analysis Services tabular data Services. Describe new and enhanced dynamicmodel. Install and configure Reporting Services management views.PowerPivot for SharePoint Server in SharePoint Mode. Describe how to use PowerShell toPower Query Use data alerts to notify users of changes Manage SQL Server.Power View to report data. Contained DatabasesAfter completing thisPower Map Creating a Tabular Model module, you will be able to:Power BI for Office 365After completing this Using an Analysis Services Tabular Data Describe the security enhancements inmodule, you will be able to: Model in the EnterpriseAfter completing SQL Server 2014.Use PowerPivot to create tabular data this module, you will be able to: Explain how to use contained databases.models in Excel. Describe Analysis Services tabular data Enhancements to Data RecoveryAfterShare a PowerPivot workbooks in model projects. completing this module, you will be able to:SharePoint Server. Implement an Analysis Services tabular Describe high availability features in SQLUse Power Query to discover and import data model. Server 2014.data from multiple data sources into Excel. Use an Analysis Services tabular data Describe data recovery enhancements inUse Power View to create interactive data model. SQL Server 2014.visualizations in Excel and SharePoint PowerPivot for SharePoint Server Deploying and Operating SSISServer. Power Query PackagesAfter completing this module,Use Power Map to create visualizations of Power View you will be able to:geographic data. Power Map Use the CDC Control task to performUse Power BI for Office 365 to create a Power BI for Office 365After completing incremental data extractions in an ETLcloud-based collaborative solution for this module, you will be able to: solution.self-service BI. Use PowerPivot to create tabular data Deploy and operate an SSIS project.Windows Azure Services for DataAfter models in Excel. Using Data Quality Services to Cleansecompleting this module, you will be able to: Share a PowerPivot workbooks in DataDescribe key features and benefits of cloud SharePoint Server. Using Data Quality Services to Matchcomputing. Use Power Query to discover and import DataAfter completing this module, you willDescribe Windows Azure service for data. data from multiple data sources into be able to:Windows Azure SQL Database Security Excel. Describe how Data Quality Services canImplementing and Managing DatabasesAfter Use Power View to create interactive help you manage data quality.completing this module, you will be able to: data visualizations in Excel and Use Data Quality Services to cleanse yourDescribe key features and benefits of SharePoint Server. data.Windows Azure SQL Database. Use Power Map to create visualizations Use Data Quality Services to match data.Implement security for Windows Azure SQL of geographic data. Implementing a Master Data ServicesDatabase. Use Power BI for Office 365 to create a ModelImplement and manage databases in cloud-based collaborative solution for Using the Master Data Services Add-in forWindows Azure SQL Database. self-service BI. ExcelAfter completing this module, you willWindows Azure Virtual Machine Connectivity Windows Azure Services for DataAfter be able to:and Security completing this module, you will be able Describe key Master Data ServicesCreating Databases in a Windows Azure to: concepts.Virtual MachineAfter completing this Describe key features and benefits of Implement a Master Data Services model.module, you will be able to: cloud computing. Use Master Data Services tools to manageDescribe considerations for using Virtual Describe Windows Azure service for master data.Machines in Windows Azure. data. Use Master Data Services tools to create aCreate and configure Windows Azure virtual Windows Azure SQL Database Security master data hub.machines. Implementing and Managing Reporting Services and MicrosoftCreate databases in Windows Azure virtual DatabasesAfter completing this module, SharePoint Servermachines. you will be able to: Introduction to Data AlertsAfter completingWindows Azure HDInsight Describe key features and benefits of this module, you will be able to:Consuming HDInsight Results in Excel Windows Azure SQL Database. Describe the key capabilities of ReportingObtaining Data from the Windows Azure Implement security for Windows Azure Services.MarketplaceAfter completing this module, SQL Database. Install and configure Reporting Services inyou will be able to: Implement and manage databases in SharePoint Mode.Describe key features of big data. Windows Azure SQL Database. Use data alerts to notify users of changesProcess big data with Windows Azure Windows Azure Virtual Machine to report data.


HDInsight. Connectivity and Security Creating a Tabular ModelConsume big data processing results from Creating Databases in a Windows Azure Using an Analysis Services Tabular DataWindows Azure HDInsight in Microsoft Virtual MachineAfter completing this Model in the EnterpriseAfter completingExcel. module, you will be able to: this module, you will be able to:

Describe considerations for using Virtual Describe Analysis Services tabular dataMachines in Windows Azure. model projects.

line Create and configure Windows Azure Implement an Analysis Services tabularSQL Server 2014 Editions and Components virtual machines. data model.Installing SQL Server 2014 Create databases in Windows Azure Use an Analysis Services tabular dataEnhancements to SQL Server Management virtual machines. model.StudioAfter completing this module, you will Windows Azure HDInsight PowerPivot for SharePoint Serverbe able to: Consuming HDInsight Results in Excel Power QueryDescribe the common workloads for SQL Obtaining Data from the Windows Azure Power ViewServer 2014. MarketplaceAfter completing this module, Power MapDescribe the SQL Server 2014 Editions and you will be able to: Power BI for Office 365After completingComponents. Describe key features of big data. this module, you will be able to:Install SQL Server 2014 Components. Process big data with Windows Azure Use PowerPivot to create tabular dataUse the new features in SQL Server HDInsight. models in Excel.Management Studio. Consume big data processing results Share a PowerPivot workbooks inNew and Enhanced Transact-SQL Functions from Windows Azure HDInsight in SharePoint Server.Enhancements to Spatial Data Support Microsoft Excel. Use Power Query to discover and importStoring and Querying Documents with SQL data from multiple data sources into Excel.Server 2014After completing this module, Module 11: Implementing an Analysis Use Power View to create interactive datayou will be able to: Services Tabular Data Model visualizations in Excel and SharePointDescribe the enhancements to line Server.Transact-SQL. Use Power Map to create visualizations ofDescribe new and enhanced Transact-SQL This module describes Analysis Services geographic data.functions. tabular data models and explains how to Use Power BI for Office 365 to create aDescribe the enhancements to Spatial Data develop a tabular data model by using the cloud-based collaborative solution forSupport. SQL Server Data Tools for BI add-in for self-service BI.Explain how to store and query documents Visual Studio. Windows Azure Services for DataAfterwith SQL Server 2014. line completing this module, you will be able to:Columnstore Indexes Introduction to Analysis Services Tabular Describe key features and benefits ofMemory-Optimized TablesAfter completing Data Model Projects cloud computing.this module, you will be able to: Describe Windows Azure service for data.Use the Buffer Pool Extension to improve Windows Azure SQL Database Securityperformance for read-heavy OLTP line Implementing and Managingworkloads. SQL Server 2014 Editions and DatabasesAfter completing this module,Use Columnstore Indexes to improve Components you will be able to:performance in data warehouse query Installing SQL Server 2014 Describe key features and benefits ofworkloads. Enhancements to SQL Server Windows Azure SQL Database.Use memory-optimized tables to improve Management StudioAfter completing this Implement security for Windows Azureperformance for latch-bound workloads. module, you will be able to: SQL Database.Using PowerShell to Manage SQL Describe the common workloads for SQL Implement and manage databases inServerAfter completing this module, you will Server 2014. Windows Azure SQL Database.be able to: Describe the SQL Server 2014 Editions Windows Azure Virtual MachineDescribe new and enhanced dynamic and Components. Connectivity and Securitymanagement views. Install SQL Server 2014 Components. Creating Databases in a Windows AzureDescribe how to use PowerShell to Manage Use the new features in SQL Server Virtual MachineAfter completing thisSQL Server. Management Studio. module, you will be able to:Contained DatabasesAfter completing this New and Enhanced Transact-SQL Describe considerations for using Virtualmodule, you will be able to: Functions Machines in Windows Azure.Describe the security enhancements in SQL Enhancements to Spatial Data Support Create and configure Windows AzureServer 2014. Storing and Querying Documents with virtual machines.Explain how to use contained databases. SQL Server 2014After completing this Create databases in Windows AzureEnhancements to Data RecoveryAfter module, you will be able to: virtual machines.completing this module, you will be able to: Describe the enhancements to Windows Azure HDInsightDescribe high availability features in SQL Transact-SQL. Consuming HDInsight Results in ExcelServer 2014. Describe new and enhanced Obtaining Data from the Windows AzureDescribe data recovery enhancements in Transact-SQL functions. MarketplaceAfter completing this module,SQL Server 2014. Describe the enhancements to Spatial you will be able to:Deploying and Operating SSIS Data Support. Describe key features of big data.PackagesAfter completing this module, you Explain how to store and query Process big data with Windows Azurewill be able to: documents with SQL Server 2014. HDInsight.Use the CDC Control task to perform Columnstore Indexes Consume big data processing results fromincremental data extractions in an ETL Memory-Optimized TablesAfter Windows Azure HDInsight in Microsoft


solution. completing this module, you will be able Excel.Deploy and operate an SSIS project. to:Using Data Quality Services to Cleanse Use the Buffer Pool Extension to improveData performance for read-heavy OLTP lineUsing Data Quality Services to Match workloads. SQL Server 2014 Editions andDataAfter completing this module, you will Use Columnstore Indexes to improve Componentsbe able to: performance in data warehouse query Installing SQL Server 2014Describe how Data Quality Services can workloads. Enhancements to SQL Serverhelp you manage data quality. Use memory-optimized tables to improve Management StudioAfter completing thisUse Data Quality Services to cleanse your performance for latch-bound workloads. module, you will be able to:data. Using PowerShell to Manage SQL Describe the common workloads for SQLUse Data Quality Services to match data. ServerAfter completing this module, you Server 2014.Implementing a Master Data Services Model will be able to: Describe the SQL Server 2014 EditionsUsing the Master Data Services Add-in for Describe new and enhanced dynamic and Components.ExcelAfter completing this module, you will management views. Install SQL Server 2014 Components.be able to: Describe how to use PowerShell to Use the new features in SQL ServerDescribe key Master Data Services Manage SQL Server. Management Studio.concepts. Contained DatabasesAfter completing New and Enhanced Transact-SQLImplement a Master Data Services model. this module, you will be able to: FunctionsUse Master Data Services tools to manage Describe the security enhancements in Enhancements to Spatial Data Supportmaster data. SQL Server 2014. Storing and Querying Documents with SQLUse Master Data Services tools to create a Explain how to use contained databases. Server 2014After completing this module,master data hub. Enhancements to Data RecoveryAfter you will be able to:Reporting Services and Microsoft completing this module, you will be able Describe the enhancements toSharePoint Server to: Transact-SQL.Introduction to Data AlertsAfter completing Describe high availability features in SQL Describe new and enhancedthis module, you will be able to: Server 2014. Transact-SQL functions.Describe the key capabilities of Reporting Describe data recovery enhancements in Describe the enhancements to SpatialServices. SQL Server 2014. Data Support.Install and configure Reporting Services in Deploying and Operating SSIS Explain how to store and query documentsSharePoint Mode. PackagesAfter completing this module, with SQL Server 2014.Use data alerts to notify users of changes to you will be able to: Columnstore Indexesreport data. Use the CDC Control task to perform Memory-Optimized TablesAfter completingCreating a Tabular Model incremental data extractions in an ETL this module, you will be able to:Using an Analysis Services Tabular Data solution. Use the Buffer Pool Extension to improveModel in the EnterpriseAfter completing this Deploy and operate an SSIS project. performance for read-heavy OLTPmodule, you will be able to: Using Data Quality Services to Cleanse workloads.Describe Analysis Services tabular data Data Use Columnstore Indexes to improvemodel projects. Using Data Quality Services to Match performance in data warehouse queryImplement an Analysis Services tabular data DataAfter completing this module, you workloads.model. will be able to: Use memory-optimized tables to improveUse an Analysis Services tabular data Describe how Data Quality Services can performance for latch-bound workloads.model. help you manage data quality. Using PowerShell to Manage SQLPowerPivot for SharePoint Server Use Data Quality Services to cleanse ServerAfter completing this module, youPower Query your data. will be able to:Power View Use Data Quality Services to match data. Describe new and enhanced dynamicPower Map Implementing a Master Data Services management views.Power BI for Office 365After completing this Model Describe how to use PowerShell tomodule, you will be able to: Using the Master Data Services Add-in Manage SQL Server.Use PowerPivot to create tabular data for ExcelAfter completing this module, Contained DatabasesAfter completing thismodels in Excel. you will be able to: module, you will be able to:Share a PowerPivot workbooks in Describe key Master Data Services Describe the security enhancements inSharePoint Server. concepts. SQL Server 2014.Use Power Query to discover and import Implement a Master Data Services Explain how to use contained databases.data from multiple data sources into Excel. model. Enhancements to Data RecoveryAfterUse Power View to create interactive data Use Master Data Services tools to completing this module, you will be able to:visualizations in Excel and SharePoint manage master data. Describe high availability features in SQLServer. Use Master Data Services tools to create Server 2014.Use Power Map to create visualizations of a master data hub. Describe data recovery enhancements ingeographic data. Reporting Services and Microsoft SQL Server 2014.Use Power BI for Office 365 to create a SharePoint Server Deploying and Operating SSIScloud-based collaborative solution for Introduction to Data AlertsAfter PackagesAfter completing this module,self-service BI. completing this module, you will be able you will be able to:Windows Azure Services for DataAfter to: Use the CDC Control task to performcompleting this module, you will be able to: Describe the key capabilities of Reporting incremental data extractions in an ETLDescribe key features and benefits of cloud Services. solution.


computing. Install and configure Reporting Services Deploy and operate an SSIS project.Describe Windows Azure service for data. in SharePoint Mode. Using Data Quality Services to CleanseWindows Azure SQL Database Security Use data alerts to notify users of changes DataImplementing and Managing DatabasesAfter to report data. Using Data Quality Services to Matchcompleting this module, you will be able to: Creating a Tabular Model DataAfter completing this module, you willDescribe key features and benefits of Using an Analysis Services Tabular Data be able to:Windows Azure SQL Database. Model in the EnterpriseAfter completing Describe how Data Quality Services canImplement security for Windows Azure SQL this module, you will be able to: help you manage data quality.Database. Describe Analysis Services tabular data Use Data Quality Services to cleanse yourImplement and manage databases in model projects. data.Windows Azure SQL Database. Implement an Analysis Services tabular Use Data Quality Services to match data.Windows Azure Virtual Machine Connectivity data model. Implementing a Master Data Servicesand Security Use an Analysis Services tabular data ModelCreating Databases in a Windows Azure model. Using the Master Data Services Add-in forVirtual MachineAfter completing this PowerPivot for SharePoint Server ExcelAfter completing this module, you willmodule, you will be able to: Power Query be able to:Describe considerations for using Virtual Power View Describe key Master Data ServicesMachines in Windows Azure. Power Map concepts.Create and configure Windows Azure virtual Power BI for Office 365After completing Implement a Master Data Services model.machines. this module, you will be able to: Use Master Data Services tools to manageCreate databases in Windows Azure virtual Use PowerPivot to create tabular data master data.machines. models in Excel. Use Master Data Services tools to create aWindows Azure HDInsight Share a PowerPivot workbooks in master data hub.Consuming HDInsight Results in Excel SharePoint Server. Reporting Services and MicrosoftObtaining Data from the Windows Azure Use Power Query to discover and import SharePoint ServerMarketplaceAfter completing this module, data from multiple data sources into Introduction to Data AlertsAfter completingyou will be able to: Excel. this module, you will be able to:Describe key features of big data. Use Power View to create interactive Describe the key capabilities of ReportingProcess big data with Windows Azure data visualizations in Excel and Services.HDInsight. SharePoint Server. Install and configure Reporting Services inConsume big data processing results from Use Power Map to create visualizations SharePoint Mode.Windows Azure HDInsight in Microsoft of geographic data. Use data alerts to notify users of changesExcel. Use Power BI for Office 365 to create a to report data.

cloud-based collaborative solution for Creating a Tabular ModelModule 5: Implementing Security in Microsoft self-service BI. Using an Analysis Services Tabular DataSQL Server 2014 Windows Azure Services for DataAfter Model in the EnterpriseAfter completingline completing this module, you will be able this module, you will be able to:

to: Describe Analysis Services tabular dataThis module describes the enhancements to Describe key features and benefits of model projects.security features since SQL Server 2008. cloud computing. Implement an Analysis Services tabularline Describe Windows Azure service for data model.

Security Management Enhancements data. Use an Analysis Services tabular dataWindows Azure SQL Database Security model.Implementing and Managing PowerPivot for SharePoint Server

line DatabasesAfter completing this module, Power QuerySQL Server 2014 Editions and Components you will be able to: Power ViewInstalling SQL Server 2014 Describe key features and benefits of Power MapEnhancements to SQL Server Management Windows Azure SQL Database. Power BI for Office 365After completingStudioAfter completing this module, you will Implement security for Windows Azure this module, you will be able to:be able to: SQL Database. Use PowerPivot to create tabular dataDescribe the common workloads for SQL Implement and manage databases in models in Excel.Server 2014. Windows Azure SQL Database. Share a PowerPivot workbooks inDescribe the SQL Server 2014 Editions and Windows Azure Virtual Machine SharePoint Server.Components. Connectivity and Security Use Power Query to discover and importInstall SQL Server 2014 Components. Creating Databases in a Windows Azure data from multiple data sources into Excel.Use the new features in SQL Server Virtual MachineAfter completing this Use Power View to create interactive dataManagement Studio. module, you will be able to: visualizations in Excel and SharePointNew and Enhanced Transact-SQL Functions Describe considerations for using Virtual Server.Enhancements to Spatial Data Support Machines in Windows Azure. Use Power Map to create visualizations ofStoring and Querying Documents with SQL Create and configure Windows Azure geographic data.Server 2014After completing this module, virtual machines. Use Power BI for Office 365 to create ayou will be able to: Create databases in Windows Azure cloud-based collaborative solution forDescribe the enhancements to virtual machines. self-service BI.Transact-SQL. Windows Azure HDInsight Windows Azure Services for DataAfterDescribe new and enhanced Transact-SQL Consuming HDInsight Results in Excel completing this module, you will be able to:functions. Obtaining Data from the Windows Azure Describe key features and benefits of


Describe the enhancements to Spatial Data MarketplaceAfter completing this module, cloud computing.Support. you will be able to: Describe Windows Azure service for data.Explain how to store and query documents Describe key features of big data. Windows Azure SQL Database Securitywith SQL Server 2014. Process big data with Windows Azure Implementing and ManagingColumnstore Indexes HDInsight. DatabasesAfter completing this module,Memory-Optimized TablesAfter completing Consume big data processing results you will be able to:this module, you will be able to: from Windows Azure HDInsight in Describe key features and benefits ofUse the Buffer Pool Extension to improve Microsoft Excel. Windows Azure SQL Database.performance for read-heavy OLTP Implement security for Windows Azureworkloads. SQL Database.Use Columnstore Indexes to improve line Implement and manage databases inperformance in data warehouse query SQL Server 2014 Editions and Windows Azure SQL Database.workloads. Components Windows Azure Virtual MachineUse memory-optimized tables to improve Installing SQL Server 2014 Connectivity and Securityperformance for latch-bound workloads. Enhancements to SQL Server Creating Databases in a Windows AzureUsing PowerShell to Manage SQL Management StudioAfter completing this Virtual MachineAfter completing thisServerAfter completing this module, you will module, you will be able to: module, you will be able to:be able to: Describe the common workloads for SQL Describe considerations for using VirtualDescribe new and enhanced dynamic Server 2014. Machines in Windows Azure.management views. Describe the SQL Server 2014 Editions Create and configure Windows AzureDescribe how to use PowerShell to Manage and Components. virtual machines.SQL Server. Install SQL Server 2014 Components. Create databases in Windows AzureContained DatabasesAfter completing this Use the new features in SQL Server virtual machines.module, you will be able to: Management Studio. Windows Azure HDInsightDescribe the security enhancements in SQL New and Enhanced Transact-SQL Consuming HDInsight Results in ExcelServer 2014. Functions Obtaining Data from the Windows AzureExplain how to use contained databases. Enhancements to Spatial Data Support MarketplaceAfter completing this module,Enhancements to Data RecoveryAfter Storing and Querying Documents with you will be able to:completing this module, you will be able to: SQL Server 2014After completing this Describe key features of big data.Describe high availability features in SQL module, you will be able to: Process big data with Windows AzureServer 2014. Describe the enhancements to HDInsight.Describe data recovery enhancements in Transact-SQL. Consume big data processing results fromSQL Server 2014. Describe new and enhanced Windows Azure HDInsight in MicrosoftDeploying and Operating SSIS Transact-SQL functions. Excel.PackagesAfter completing this module, you Describe the enhancements to Spatialwill be able to: Data Support.Use the CDC Control task to perform Explain how to store and query lineincremental data extractions in an ETL documents with SQL Server 2014. SQL Server 2014 Editions andsolution. Columnstore Indexes ComponentsDeploy and operate an SSIS project. Memory-Optimized TablesAfter Installing SQL Server 2014Using Data Quality Services to Cleanse completing this module, you will be able Enhancements to SQL ServerData to: Management StudioAfter completing thisUsing Data Quality Services to Match Use the Buffer Pool Extension to improve module, you will be able to:DataAfter completing this module, you will performance for read-heavy OLTP Describe the common workloads for SQLbe able to: workloads. Server 2014.Describe how Data Quality Services can Use Columnstore Indexes to improve Describe the SQL Server 2014 Editionshelp you manage data quality. performance in data warehouse query and Components.Use Data Quality Services to cleanse your workloads. Install SQL Server 2014 Components.data. Use memory-optimized tables to improve Use the new features in SQL ServerUse Data Quality Services to match data. performance for latch-bound workloads. Management Studio.Implementing a Master Data Services Model Using PowerShell to Manage SQL New and Enhanced Transact-SQLUsing the Master Data Services Add-in for ServerAfter completing this module, you FunctionsExcelAfter completing this module, you will will be able to: Enhancements to Spatial Data Supportbe able to: Describe new and enhanced dynamic Storing and Querying Documents with SQLDescribe key Master Data Services management views. Server 2014After completing this module,concepts. Describe how to use PowerShell to you will be able to:Implement a Master Data Services model. Manage SQL Server. Describe the enhancements toUse Master Data Services tools to manage Contained DatabasesAfter completing Transact-SQL.master data. this module, you will be able to: Describe new and enhancedUse Master Data Services tools to create a Describe the security enhancements in Transact-SQL functions.master data hub. SQL Server 2014. Describe the enhancements to SpatialReporting Services and Microsoft Explain how to use contained databases. Data Support.SharePoint Server Enhancements to Data RecoveryAfter Explain how to store and query documentsIntroduction to Data AlertsAfter completing completing this module, you will be able with SQL Server 2014.this module, you will be able to: to: Columnstore IndexesDescribe the key capabilities of Reporting Describe high availability features in SQL Memory-Optimized TablesAfter completing


Services. Server 2014. this module, you will be able to:Install and configure Reporting Services in Describe data recovery enhancements in Use the Buffer Pool Extension to improveSharePoint Mode. SQL Server 2014. performance for read-heavy OLTPUse data alerts to notify users of changes to Deploying and Operating SSIS workloads.report data. PackagesAfter completing this module, Use Columnstore Indexes to improveCreating a Tabular Model you will be able to: performance in data warehouse queryUsing an Analysis Services Tabular Data Use the CDC Control task to perform workloads.Model in the EnterpriseAfter completing this incremental data extractions in an ETL Use memory-optimized tables to improvemodule, you will be able to: solution. performance for latch-bound workloads.Describe Analysis Services tabular data Deploy and operate an SSIS project. Using PowerShell to Manage SQLmodel projects. Using Data Quality Services to Cleanse ServerAfter completing this module, youImplement an Analysis Services tabular data Data will be able to:model. Using Data Quality Services to Match Describe new and enhanced dynamicUse an Analysis Services tabular data DataAfter completing this module, you management views.model. will be able to: Describe how to use PowerShell toPowerPivot for SharePoint Server Describe how Data Quality Services can Manage SQL Server.Power Query help you manage data quality. Contained DatabasesAfter completing thisPower View Use Data Quality Services to cleanse module, you will be able to:Power Map your data. Describe the security enhancements inPower BI for Office 365After completing this Use Data Quality Services to match data. SQL Server 2014.module, you will be able to: Implementing a Master Data Services Explain how to use contained databases.Use PowerPivot to create tabular data Model Enhancements to Data RecoveryAftermodels in Excel. Using the Master Data Services Add-in completing this module, you will be able to:Share a PowerPivot workbooks in for ExcelAfter completing this module, Describe high availability features in SQLSharePoint Server. you will be able to: Server 2014.Use Power Query to discover and import Describe key Master Data Services Describe data recovery enhancements indata from multiple data sources into Excel. concepts. SQL Server 2014.Use Power View to create interactive data Implement a Master Data Services Deploying and Operating SSISvisualizations in Excel and SharePoint model. PackagesAfter completing this module,Server. Use Master Data Services tools to you will be able to:Use Power Map to create visualizations of manage master data. Use the CDC Control task to performgeographic data. Use Master Data Services tools to create incremental data extractions in an ETLUse Power BI for Office 365 to create a a master data hub. solution.cloud-based collaborative solution for Reporting Services and Microsoft Deploy and operate an SSIS project.self-service BI. SharePoint Server Using Data Quality Services to CleanseWindows Azure Services for DataAfter Introduction to Data AlertsAfter Datacompleting this module, you will be able to: completing this module, you will be able Using Data Quality Services to MatchDescribe key features and benefits of cloud to: DataAfter completing this module, you willcomputing. Describe the key capabilities of Reporting be able to:Describe Windows Azure service for data. Services. Describe how Data Quality Services canWindows Azure SQL Database Security Install and configure Reporting Services help you manage data quality.Implementing and Managing DatabasesAfter in SharePoint Mode. Use Data Quality Services to cleanse yourcompleting this module, you will be able to: Use data alerts to notify users of changes data.Describe key features and benefits of to report data. Use Data Quality Services to match data.Windows Azure SQL Database. Creating a Tabular Model Implementing a Master Data ServicesImplement security for Windows Azure SQL Using an Analysis Services Tabular Data ModelDatabase. Model in the EnterpriseAfter completing Using the Master Data Services Add-in forImplement and manage databases in this module, you will be able to: ExcelAfter completing this module, you willWindows Azure SQL Database. Describe Analysis Services tabular data be able to:Windows Azure Virtual Machine Connectivity model projects. Describe key Master Data Servicesand Security Implement an Analysis Services tabular concepts.Creating Databases in a Windows Azure data model. Implement a Master Data Services model.Virtual MachineAfter completing this Use an Analysis Services tabular data Use Master Data Services tools to managemodule, you will be able to: model. master data.Describe considerations for using Virtual PowerPivot for SharePoint Server Use Master Data Services tools to create aMachines in Windows Azure. Power Query master data hub.Create and configure Windows Azure virtual Power View Reporting Services and Microsoftmachines. Power Map SharePoint ServerCreate databases in Windows Azure virtual Power BI for Office 365After completing Introduction to Data AlertsAfter completingmachines. this module, you will be able to: this module, you will be able to:Windows Azure HDInsight Use PowerPivot to create tabular data Describe the key capabilities of ReportingConsuming HDInsight Results in Excel models in Excel. Services.Obtaining Data from the Windows Azure Share a PowerPivot workbooks in Install and configure Reporting Services inMarketplaceAfter completing this module, SharePoint Server. SharePoint Mode.you will be able to: Use Power Query to discover and import Use data alerts to notify users of changesDescribe key features of big data. data from multiple data sources into to report data.


Process big data with Windows Azure Excel. Creating a Tabular ModelHDInsight. Use Power View to create interactive Using an Analysis Services Tabular DataConsume big data processing results from data visualizations in Excel and Model in the EnterpriseAfter completingWindows Azure HDInsight in Microsoft SharePoint Server. this module, you will be able to:Excel. Use Power Map to create visualizations Describe Analysis Services tabular data

of geographic data. model projects.Use Power BI for Office 365 to create a Implement an Analysis Services tabular

line cloud-based collaborative solution for data model.SQL Server 2014 Editions and Components self-service BI. Use an Analysis Services tabular dataInstalling SQL Server 2014 Windows Azure Services for DataAfter model.Enhancements to SQL Server Management completing this module, you will be able PowerPivot for SharePoint ServerStudioAfter completing this module, you will to: Power Querybe able to: Describe key features and benefits of Power ViewDescribe the common workloads for SQL cloud computing. Power MapServer 2014. Describe Windows Azure service for Power BI for Office 365After completingDescribe the SQL Server 2014 Editions and data. this module, you will be able to:Components. Windows Azure SQL Database Security Use PowerPivot to create tabular dataInstall SQL Server 2014 Components. Implementing and Managing models in Excel.Use the new features in SQL Server DatabasesAfter completing this module, Share a PowerPivot workbooks inManagement Studio. you will be able to: SharePoint Server.New and Enhanced Transact-SQL Functions Describe key features and benefits of Use Power Query to discover and importEnhancements to Spatial Data Support Windows Azure SQL Database. data from multiple data sources into Excel.Storing and Querying Documents with SQL Implement security for Windows Azure Use Power View to create interactive dataServer 2014After completing this module, SQL Database. visualizations in Excel and SharePointyou will be able to: Implement and manage databases in Server.Describe the enhancements to Windows Azure SQL Database. Use Power Map to create visualizations ofTransact-SQL. Windows Azure Virtual Machine geographic data.Describe new and enhanced Transact-SQL Connectivity and Security Use Power BI for Office 365 to create afunctions. Creating Databases in a Windows Azure cloud-based collaborative solution forDescribe the enhancements to Spatial Data Virtual MachineAfter completing this self-service BI.Support. module, you will be able to: Windows Azure Services for DataAfterExplain how to store and query documents Describe considerations for using Virtual completing this module, you will be able to:with SQL Server 2014. Machines in Windows Azure. Describe key features and benefits ofColumnstore Indexes Create and configure Windows Azure cloud computing.Memory-Optimized TablesAfter completing virtual machines. Describe Windows Azure service for data.this module, you will be able to: Create databases in Windows Azure Windows Azure SQL Database SecurityUse the Buffer Pool Extension to improve virtual machines. Implementing and Managingperformance for read-heavy OLTP Windows Azure HDInsight DatabasesAfter completing this module,workloads. Consuming HDInsight Results in Excel you will be able to:Use Columnstore Indexes to improve Obtaining Data from the Windows Azure Describe key features and benefits ofperformance in data warehouse query MarketplaceAfter completing this module, Windows Azure SQL Database.workloads. you will be able to: Implement security for Windows AzureUse memory-optimized tables to improve Describe key features of big data. SQL Database.performance for latch-bound workloads. Process big data with Windows Azure Implement and manage databases inUsing PowerShell to Manage SQL HDInsight. Windows Azure SQL Database.ServerAfter completing this module, you will Consume big data processing results Windows Azure Virtual Machinebe able to: from Windows Azure HDInsight in Connectivity and SecurityDescribe new and enhanced dynamic Microsoft Excel. Creating Databases in a Windows Azuremanagement views. Virtual MachineAfter completing thisDescribe how to use PowerShell to Manage module, you will be able to:SQL Server. line Describe considerations for using VirtualContained DatabasesAfter completing this SQL Server 2014 Editions and Machines in Windows Azure.module, you will be able to: Components Create and configure Windows AzureDescribe the security enhancements in SQL Installing SQL Server 2014 virtual machines.Server 2014. Enhancements to SQL Server Create databases in Windows AzureExplain how to use contained databases. Management StudioAfter completing this virtual machines.Enhancements to Data RecoveryAfter module, you will be able to: Windows Azure HDInsightcompleting this module, you will be able to: Describe the common workloads for SQL Consuming HDInsight Results in ExcelDescribe high availability features in SQL Server 2014. Obtaining Data from the Windows AzureServer 2014. Describe the SQL Server 2014 Editions MarketplaceAfter completing this module,Describe data recovery enhancements in and Components. you will be able to:SQL Server 2014. Install SQL Server 2014 Components. Describe key features of big data.Deploying and Operating SSIS Use the new features in SQL Server Process big data with Windows AzurePackagesAfter completing this module, you Management Studio. HDInsight.will be able to: New and Enhanced Transact-SQL Consume big data processing results fromUse the CDC Control task to perform Functions Windows Azure HDInsight in Microsoft


incremental data extractions in an ETL Enhancements to Spatial Data Support Excel.solution. Storing and Querying Documents withDeploy and operate an SSIS project. SQL Server 2014After completing this Module 16: Implementing Big Data SolutionsUsing Data Quality Services to Cleanse module, you will be able to: lineData Describe the enhancements toUsing Data Quality Services to Match Transact-SQL. This module describes the main features ofDataAfter completing this module, you will Describe new and enhanced big data, and the Microsoft technologies thatbe able to: Transact-SQL functions. you can use to build big data analyticalDescribe how Data Quality Services can Describe the enhancements to Spatial solutions. In particular, the module focuses onhelp you manage data quality. Data Support. Windows Azure HDInsight and the WindowsUse Data Quality Services to cleanse your Explain how to store and query Azure Marketplace as core elements of thedata. documents with SQL Server 2014. Microsoft solution for big data.Use Data Quality Services to match data. Columnstore Indexes lineImplementing a Master Data Services Model Memory-Optimized TablesAfter Introduction to Big DataUsing the Master Data Services Add-in for completing this module, you will be ableExcelAfter completing this module, you will to:be able to: Use the Buffer Pool Extension to improve lineDescribe key Master Data Services performance for read-heavy OLTP SQL Server 2014 Editions andconcepts. workloads. ComponentsImplement a Master Data Services model. Use Columnstore Indexes to improve Installing SQL Server 2014Use Master Data Services tools to manage performance in data warehouse query Enhancements to SQL Servermaster data. workloads. Management StudioAfter completing thisUse Master Data Services tools to create a Use memory-optimized tables to improve module, you will be able to:master data hub. performance for latch-bound workloads. Describe the common workloads for SQLReporting Services and Microsoft Using PowerShell to Manage SQL Server 2014.SharePoint Server ServerAfter completing this module, you Describe the SQL Server 2014 EditionsIntroduction to Data AlertsAfter completing will be able to: and Components.this module, you will be able to: Describe new and enhanced dynamic Install SQL Server 2014 Components.Describe the key capabilities of Reporting management views. Use the new features in SQL ServerServices. Describe how to use PowerShell to Management Studio.Install and configure Reporting Services in Manage SQL Server. New and Enhanced Transact-SQLSharePoint Mode. Contained DatabasesAfter completing FunctionsUse data alerts to notify users of changes to this module, you will be able to: Enhancements to Spatial Data Supportreport data. Describe the security enhancements in Storing and Querying Documents with SQLCreating a Tabular Model SQL Server 2014. Server 2014After completing this module,Using an Analysis Services Tabular Data Explain how to use contained databases. you will be able to:Model in the EnterpriseAfter completing this Enhancements to Data RecoveryAfter Describe the enhancements tomodule, you will be able to: completing this module, you will be able Transact-SQL.Describe Analysis Services tabular data to: Describe new and enhancedmodel projects. Describe high availability features in SQL Transact-SQL functions.Implement an Analysis Services tabular data Server 2014. Describe the enhancements to Spatialmodel. Describe data recovery enhancements in Data Support.Use an Analysis Services tabular data SQL Server 2014. Explain how to store and query documentsmodel. Deploying and Operating SSIS with SQL Server 2014.PowerPivot for SharePoint Server PackagesAfter completing this module, Columnstore IndexesPower Query you will be able to: Memory-Optimized TablesAfter completingPower View Use the CDC Control task to perform this module, you will be able to:Power Map incremental data extractions in an ETL Use the Buffer Pool Extension to improvePower BI for Office 365After completing this solution. performance for read-heavy OLTPmodule, you will be able to: Deploy and operate an SSIS project. workloads.Use PowerPivot to create tabular data Using Data Quality Services to Cleanse Use Columnstore Indexes to improvemodels in Excel. Data performance in data warehouse queryShare a PowerPivot workbooks in Using Data Quality Services to Match workloads.SharePoint Server. DataAfter completing this module, you Use memory-optimized tables to improveUse Power Query to discover and import will be able to: performance for latch-bound workloads.data from multiple data sources into Excel. Describe how Data Quality Services can Using PowerShell to Manage SQLUse Power View to create interactive data help you manage data quality. ServerAfter completing this module, youvisualizations in Excel and SharePoint Use Data Quality Services to cleanse will be able to:Server. your data. Describe new and enhanced dynamicUse Power Map to create visualizations of Use Data Quality Services to match data. management views.geographic data. Implementing a Master Data Services Describe how to use PowerShell toUse Power BI for Office 365 to create a Model Manage SQL Server.cloud-based collaborative solution for Using the Master Data Services Add-in Contained DatabasesAfter completing thisself-service BI. for ExcelAfter completing this module, module, you will be able to:Windows Azure Services for DataAfter you will be able to: Describe the security enhancements incompleting this module, you will be able to: Describe key Master Data Services SQL Server 2014.


Describe key features and benefits of cloud concepts. Explain how to use contained databases.computing. Implement a Master Data Services Enhancements to Data RecoveryAfterDescribe Windows Azure service for data. model. completing this module, you will be able to:Windows Azure SQL Database Security Use Master Data Services tools to Describe high availability features in SQLImplementing and Managing DatabasesAfter manage master data. Server 2014.completing this module, you will be able to: Use Master Data Services tools to create Describe data recovery enhancements inDescribe key features and benefits of a master data hub. SQL Server 2014.Windows Azure SQL Database. Reporting Services and Microsoft Deploying and Operating SSISImplement security for Windows Azure SQL SharePoint Server PackagesAfter completing this module,Database. Introduction to Data AlertsAfter you will be able to:Implement and manage databases in completing this module, you will be able Use the CDC Control task to performWindows Azure SQL Database. to: incremental data extractions in an ETLWindows Azure Virtual Machine Connectivity Describe the key capabilities of Reporting solution.and Security Services. Deploy and operate an SSIS project.Creating Databases in a Windows Azure Install and configure Reporting Services Using Data Quality Services to CleanseVirtual MachineAfter completing this in SharePoint Mode. Datamodule, you will be able to: Use data alerts to notify users of changes Using Data Quality Services to MatchDescribe considerations for using Virtual to report data. DataAfter completing this module, you willMachines in Windows Azure. Creating a Tabular Model be able to:Create and configure Windows Azure virtual Using an Analysis Services Tabular Data Describe how Data Quality Services canmachines. Model in the EnterpriseAfter completing help you manage data quality.Create databases in Windows Azure virtual this module, you will be able to: Use Data Quality Services to cleanse yourmachines. Describe Analysis Services tabular data data.Windows Azure HDInsight model projects. Use Data Quality Services to match data.Consuming HDInsight Results in Excel Implement an Analysis Services tabular Implementing a Master Data ServicesObtaining Data from the Windows Azure data model. ModelMarketplaceAfter completing this module, Use an Analysis Services tabular data Using the Master Data Services Add-in foryou will be able to: model. ExcelAfter completing this module, you willDescribe key features of big data. PowerPivot for SharePoint Server be able to:Process big data with Windows Azure Power Query Describe key Master Data ServicesHDInsight. Power View concepts.Consume big data processing results from Power Map Implement a Master Data Services model.Windows Azure HDInsight in Microsoft Power BI for Office 365After completing Use Master Data Services tools to manageExcel. this module, you will be able to: master data.

Use PowerPivot to create tabular data Use Master Data Services tools to create aModule 6: High Availability and Data Recovery models in Excel. master data hub.Enhancements Share a PowerPivot workbooks in Reporting Services and Microsoftline SharePoint Server. SharePoint Server

Use Power Query to discover and import Introduction to Data AlertsAfter completingThis module describes enhancements to SQL data from multiple data sources into this module, you will be able to:Server availability and data recovery features Excel. Describe the key capabilities of Reportingsince SQL Server 2008. Use Power View to create interactive Services.line data visualizations in Excel and Install and configure Reporting Services in

AlwaysOn High Availability SharePoint Server. SharePoint Mode.Use Power Map to create visualizations Use data alerts to notify users of changesof geographic data. to report data.

line Use Power BI for Office 365 to create a Creating a Tabular ModelSQL Server 2014 Editions and Components cloud-based collaborative solution for Using an Analysis Services Tabular DataInstalling SQL Server 2014 self-service BI. Model in the EnterpriseAfter completingEnhancements to SQL Server Management Windows Azure Services for DataAfter this module, you will be able to:StudioAfter completing this module, you will completing this module, you will be able Describe Analysis Services tabular databe able to: to: model projects.Describe the common workloads for SQL Describe key features and benefits of Implement an Analysis Services tabularServer 2014. cloud computing. data model.Describe the SQL Server 2014 Editions and Describe Windows Azure service for Use an Analysis Services tabular dataComponents. data. model.Install SQL Server 2014 Components. Windows Azure SQL Database Security PowerPivot for SharePoint ServerUse the new features in SQL Server Implementing and Managing Power QueryManagement Studio. DatabasesAfter completing this module, Power ViewNew and Enhanced Transact-SQL Functions you will be able to: Power MapEnhancements to Spatial Data Support Describe key features and benefits of Power BI for Office 365After completingStoring and Querying Documents with SQL Windows Azure SQL Database. this module, you will be able to:Server 2014After completing this module, Implement security for Windows Azure Use PowerPivot to create tabular datayou will be able to: SQL Database. models in Excel.Describe the enhancements to Implement and manage databases in Share a PowerPivot workbooks inTransact-SQL. Windows Azure SQL Database. SharePoint Server.


Describe new and enhanced Transact-SQL Windows Azure Virtual Machine Use Power Query to discover and importfunctions. Connectivity and Security data from multiple data sources into Excel.Describe the enhancements to Spatial Data Creating Databases in a Windows Azure Use Power View to create interactive dataSupport. Virtual MachineAfter completing this visualizations in Excel and SharePointExplain how to store and query documents module, you will be able to: Server.with SQL Server 2014. Describe considerations for using Virtual Use Power Map to create visualizations ofColumnstore Indexes Machines in Windows Azure. geographic data.Memory-Optimized TablesAfter completing Create and configure Windows Azure Use Power BI for Office 365 to create athis module, you will be able to: virtual machines. cloud-based collaborative solution forUse the Buffer Pool Extension to improve Create databases in Windows Azure self-service BI.performance for read-heavy OLTP virtual machines. Windows Azure Services for DataAfterworkloads. Windows Azure HDInsight completing this module, you will be able to:Use Columnstore Indexes to improve Consuming HDInsight Results in Excel Describe key features and benefits ofperformance in data warehouse query Obtaining Data from the Windows Azure cloud computing.workloads. MarketplaceAfter completing this module, Describe Windows Azure service for data.Use memory-optimized tables to improve you will be able to: Windows Azure SQL Database Securityperformance for latch-bound workloads. Describe key features of big data. Implementing and ManagingUsing PowerShell to Manage SQL Process big data with Windows Azure DatabasesAfter completing this module,ServerAfter completing this module, you will HDInsight. you will be able to:be able to: Consume big data processing results Describe key features and benefits ofDescribe new and enhanced dynamic from Windows Azure HDInsight in Windows Azure SQL Database.management views. Microsoft Excel. Implement security for Windows AzureDescribe how to use PowerShell to Manage SQL Database.SQL Server. Implement and manage databases inContained DatabasesAfter completing this line Windows Azure SQL Database.module, you will be able to: SQL Server 2014 Editions and Windows Azure Virtual MachineDescribe the security enhancements in SQL Components Connectivity and SecurityServer 2014. Installing SQL Server 2014 Creating Databases in a Windows AzureExplain how to use contained databases. Enhancements to SQL Server Virtual MachineAfter completing thisEnhancements to Data RecoveryAfter Management StudioAfter completing this module, you will be able to:completing this module, you will be able to: module, you will be able to: Describe considerations for using VirtualDescribe high availability features in SQL Describe the common workloads for SQL Machines in Windows Azure.Server 2014. Server 2014. Create and configure Windows AzureDescribe data recovery enhancements in Describe the SQL Server 2014 Editions virtual machines.SQL Server 2014. and Components. Create databases in Windows AzureDeploying and Operating SSIS Install SQL Server 2014 Components. virtual machines.PackagesAfter completing this module, you Use the new features in SQL Server Windows Azure HDInsightwill be able to: Management Studio. Consuming HDInsight Results in ExcelUse the CDC Control task to perform New and Enhanced Transact-SQL Obtaining Data from the Windows Azureincremental data extractions in an ETL Functions MarketplaceAfter completing this module,solution. Enhancements to Spatial Data Support you will be able to:Deploy and operate an SSIS project. Storing and Querying Documents with Describe key features of big data.Using Data Quality Services to Cleanse SQL Server 2014After completing this Process big data with Windows AzureData module, you will be able to: HDInsight.Using Data Quality Services to Match Describe the enhancements to Consume big data processing results fromDataAfter completing this module, you will Transact-SQL. Windows Azure HDInsight in Microsoftbe able to: Describe new and enhanced Excel.Describe how Data Quality Services can Transact-SQL functions.help you manage data quality. Describe the enhancements to SpatialUse Data Quality Services to cleanse your Data Support. linedata. Explain how to store and query SQL Server 2014 Editions andUse Data Quality Services to match data. documents with SQL Server 2014. ComponentsImplementing a Master Data Services Model Columnstore Indexes Installing SQL Server 2014Using the Master Data Services Add-in for Memory-Optimized TablesAfter Enhancements to SQL ServerExcelAfter completing this module, you will completing this module, you will be able Management StudioAfter completing thisbe able to: to: module, you will be able to:Describe key Master Data Services Use the Buffer Pool Extension to improve Describe the common workloads for SQLconcepts. performance for read-heavy OLTP Server 2014.Implement a Master Data Services model. workloads. Describe the SQL Server 2014 EditionsUse Master Data Services tools to manage Use Columnstore Indexes to improve and Components.master data. performance in data warehouse query Install SQL Server 2014 Components.Use Master Data Services tools to create a workloads. Use the new features in SQL Servermaster data hub. Use memory-optimized tables to improve Management Studio.Reporting Services and Microsoft performance for latch-bound workloads. New and Enhanced Transact-SQLSharePoint Server Using PowerShell to Manage SQL FunctionsIntroduction to Data AlertsAfter completing ServerAfter completing this module, you Enhancements to Spatial Data Support


this module, you will be able to: will be able to: Storing and Querying Documents with SQLDescribe the key capabilities of Reporting Describe new and enhanced dynamic Server 2014After completing this module,Services. management views. you will be able to:Install and configure Reporting Services in Describe how to use PowerShell to Describe the enhancements toSharePoint Mode. Manage SQL Server. Transact-SQL.Use data alerts to notify users of changes to Contained DatabasesAfter completing Describe new and enhancedreport data. this module, you will be able to: Transact-SQL functions.Creating a Tabular Model Describe the security enhancements in Describe the enhancements to SpatialUsing an Analysis Services Tabular Data SQL Server 2014. Data Support.Model in the EnterpriseAfter completing this Explain how to use contained databases. Explain how to store and query documentsmodule, you will be able to: Enhancements to Data RecoveryAfter with SQL Server 2014.Describe Analysis Services tabular data completing this module, you will be able Columnstore Indexesmodel projects. to: Memory-Optimized TablesAfter completingImplement an Analysis Services tabular data Describe high availability features in SQL this module, you will be able to:model. Server 2014. Use the Buffer Pool Extension to improveUse an Analysis Services tabular data Describe data recovery enhancements in performance for read-heavy OLTPmodel. SQL Server 2014. workloads.PowerPivot for SharePoint Server Deploying and Operating SSIS Use Columnstore Indexes to improvePower Query PackagesAfter completing this module, performance in data warehouse queryPower View you will be able to: workloads.Power Map Use the CDC Control task to perform Use memory-optimized tables to improvePower BI for Office 365After completing this incremental data extractions in an ETL performance for latch-bound workloads.module, you will be able to: solution. Using PowerShell to Manage SQLUse PowerPivot to create tabular data Deploy and operate an SSIS project. ServerAfter completing this module, youmodels in Excel. Using Data Quality Services to Cleanse will be able to:Share a PowerPivot workbooks in Data Describe new and enhanced dynamicSharePoint Server. Using Data Quality Services to Match management views.Use Power Query to discover and import DataAfter completing this module, you Describe how to use PowerShell todata from multiple data sources into Excel. will be able to: Manage SQL Server.Use Power View to create interactive data Describe how Data Quality Services can Contained DatabasesAfter completing thisvisualizations in Excel and SharePoint help you manage data quality. module, you will be able to:Server. Use Data Quality Services to cleanse Describe the security enhancements inUse Power Map to create visualizations of your data. SQL Server 2014.geographic data. Use Data Quality Services to match data. Explain how to use contained databases.Use Power BI for Office 365 to create a Implementing a Master Data Services Enhancements to Data RecoveryAftercloud-based collaborative solution for Model completing this module, you will be able to:self-service BI. Using the Master Data Services Add-in Describe high availability features in SQLWindows Azure Services for DataAfter for ExcelAfter completing this module, Server 2014.completing this module, you will be able to: you will be able to: Describe data recovery enhancements inDescribe key features and benefits of cloud Describe key Master Data Services SQL Server 2014.computing. concepts. Deploying and Operating SSISDescribe Windows Azure service for data. Implement a Master Data Services PackagesAfter completing this module,Windows Azure SQL Database Security model. you will be able to:Implementing and Managing DatabasesAfter Use Master Data Services tools to Use the CDC Control task to performcompleting this module, you will be able to: manage master data. incremental data extractions in an ETLDescribe key features and benefits of Use Master Data Services tools to create solution.Windows Azure SQL Database. a master data hub. Deploy and operate an SSIS project.Implement security for Windows Azure SQL Reporting Services and Microsoft Using Data Quality Services to CleanseDatabase. SharePoint Server DataImplement and manage databases in Introduction to Data AlertsAfter Using Data Quality Services to MatchWindows Azure SQL Database. completing this module, you will be able DataAfter completing this module, you willWindows Azure Virtual Machine Connectivity to: be able to:and Security Describe the key capabilities of Reporting Describe how Data Quality Services canCreating Databases in a Windows Azure Services. help you manage data quality.Virtual MachineAfter completing this Install and configure Reporting Services Use Data Quality Services to cleanse yourmodule, you will be able to: in SharePoint Mode. data.Describe considerations for using Virtual Use data alerts to notify users of changes Use Data Quality Services to match data.Machines in Windows Azure. to report data. Implementing a Master Data ServicesCreate and configure Windows Azure virtual Creating a Tabular Model Modelmachines. Using an Analysis Services Tabular Data Using the Master Data Services Add-in forCreate databases in Windows Azure virtual Model in the EnterpriseAfter completing ExcelAfter completing this module, you willmachines. this module, you will be able to: be able to:Windows Azure HDInsight Describe Analysis Services tabular data Describe key Master Data ServicesConsuming HDInsight Results in Excel model projects. concepts.Obtaining Data from the Windows Azure Implement an Analysis Services tabular Implement a Master Data Services model.MarketplaceAfter completing this module, data model. Use Master Data Services tools to manage


you will be able to: Use an Analysis Services tabular data master data.Describe key features of big data. model. Use Master Data Services tools to create aProcess big data with Windows Azure PowerPivot for SharePoint Server master data hub.HDInsight. Power Query Reporting Services and MicrosoftConsume big data processing results from Power View SharePoint ServerWindows Azure HDInsight in Microsoft Power Map Introduction to Data AlertsAfter completingExcel. Power BI for Office 365After completing this module, you will be able to:

this module, you will be able to: Describe the key capabilities of ReportingUse PowerPivot to create tabular data Services.models in Excel. Install and configure Reporting Services inShare a PowerPivot workbooks in SharePoint Mode.SharePoint Server. Use data alerts to notify users of changesUse Power Query to discover and import to report data.data from multiple data sources into Creating a Tabular ModelExcel. Using an Analysis Services Tabular DataUse Power View to create interactive Model in the EnterpriseAfter completingdata visualizations in Excel and this module, you will be able to:SharePoint Server. Describe Analysis Services tabular dataUse Power Map to create visualizations model projects.of geographic data. Implement an Analysis Services tabularUse Power BI for Office 365 to create a data model.cloud-based collaborative solution for Use an Analysis Services tabular dataself-service BI. model.Windows Azure Services for DataAfter PowerPivot for SharePoint Servercompleting this module, you will be able Power Queryto: Power ViewDescribe key features and benefits of Power Mapcloud computing. Power BI for Office 365After completingDescribe Windows Azure service for this module, you will be able to:data. Use PowerPivot to create tabular dataWindows Azure SQL Database Security models in Excel.Implementing and Managing Share a PowerPivot workbooks inDatabasesAfter completing this module, SharePoint Server.you will be able to: Use Power Query to discover and importDescribe key features and benefits of data from multiple data sources into Excel.Windows Azure SQL Database. Use Power View to create interactive dataImplement security for Windows Azure visualizations in Excel and SharePointSQL Database. Server.Implement and manage databases in Use Power Map to create visualizations ofWindows Azure SQL Database. geographic data.Windows Azure Virtual Machine Use Power BI for Office 365 to create aConnectivity and Security cloud-based collaborative solution forCreating Databases in a Windows Azure self-service BI.Virtual MachineAfter completing this Windows Azure Services for DataAftermodule, you will be able to: completing this module, you will be able to:Describe considerations for using Virtual Describe key features and benefits ofMachines in Windows Azure. cloud computing.Create and configure Windows Azure Describe Windows Azure service for data.virtual machines. Windows Azure SQL Database SecurityCreate databases in Windows Azure Implementing and Managingvirtual machines. DatabasesAfter completing this module,Windows Azure HDInsight you will be able to:Consuming HDInsight Results in Excel Describe key features and benefits ofObtaining Data from the Windows Azure Windows Azure SQL Database.MarketplaceAfter completing this module, Implement security for Windows Azureyou will be able to: SQL Database.Describe key features of big data. Implement and manage databases inProcess big data with Windows Azure Windows Azure SQL Database.HDInsight. Windows Azure Virtual MachineConsume big data processing results Connectivity and Securityfrom Windows Azure HDInsight in Creating Databases in a Windows AzureMicrosoft Excel. Virtual MachineAfter completing this

module, you will be able to:Module 12: Self-Service BI with Microsoft Describe considerations for using VirtualExcel Machines in Windows Azure.line Create and configure Windows Azure


virtual machines.This module introduces the self-service BI Create databases in Windows Azurecapabilities that can be delivered through virtual machines.Microsoft Excel 2013 and related Windows Azure HDInsighttechnologies. Consuming HDInsight Results in Excelline Obtaining Data from the Windows Azure

PowerPivot for Excel MarketplaceAfter completing this module,you will be able to:Describe key features of big data.

line Process big data with Windows AzureSQL Server 2014 Editions and HDInsight.Components Consume big data processing results fromInstalling SQL Server 2014 Windows Azure HDInsight in MicrosoftEnhancements to SQL Server Excel.Management StudioAfter completing thismodule, you will be able to:Describe the common workloads for SQL lineServer 2014. SQL Server 2014 Editions andDescribe the SQL Server 2014 Editions Componentsand Components. Installing SQL Server 2014Install SQL Server 2014 Components. Enhancements to SQL ServerUse the new features in SQL Server Management StudioAfter completing thisManagement Studio. module, you will be able to:New and Enhanced Transact-SQL Describe the common workloads for SQLFunctions Server 2014.Enhancements to Spatial Data Support Describe the SQL Server 2014 EditionsStoring and Querying Documents with and Components.SQL Server 2014After completing this Install SQL Server 2014 Components.module, you will be able to: Use the new features in SQL ServerDescribe the enhancements to Management Studio.Transact-SQL. New and Enhanced Transact-SQLDescribe new and enhanced FunctionsTransact-SQL functions. Enhancements to Spatial Data SupportDescribe the enhancements to Spatial Storing and Querying Documents with SQLData Support. Server 2014After completing this module,Explain how to store and query you will be able to:documents with SQL Server 2014. Describe the enhancements toColumnstore Indexes Transact-SQL.Memory-Optimized TablesAfter Describe new and enhancedcompleting this module, you will be able Transact-SQL functions.to: Describe the enhancements to SpatialUse the Buffer Pool Extension to improve Data Support.performance for read-heavy OLTP Explain how to store and query documentsworkloads. with SQL Server 2014.Use Columnstore Indexes to improve Columnstore Indexesperformance in data warehouse query Memory-Optimized TablesAfter completingworkloads. this module, you will be able to:Use memory-optimized tables to improve Use the Buffer Pool Extension to improveperformance for latch-bound workloads. performance for read-heavy OLTPUsing PowerShell to Manage SQL workloads.ServerAfter completing this module, you Use Columnstore Indexes to improvewill be able to: performance in data warehouse queryDescribe new and enhanced dynamic workloads.management views. Use memory-optimized tables to improveDescribe how to use PowerShell to performance for latch-bound workloads.Manage SQL Server. Using PowerShell to Manage SQLContained DatabasesAfter completing ServerAfter completing this module, youthis module, you will be able to: will be able to:Describe the security enhancements in Describe new and enhanced dynamicSQL Server 2014. management views.Explain how to use contained databases. Describe how to use PowerShell toEnhancements to Data RecoveryAfter Manage SQL Server.completing this module, you will be able Contained DatabasesAfter completing thisto: module, you will be able to:Describe high availability features in SQL Describe the security enhancements inServer 2014. SQL Server 2014.


Describe data recovery enhancements in Explain how to use contained databases.SQL Server 2014. Enhancements to Data RecoveryAfterDeploying and Operating SSIS completing this module, you will be able to:PackagesAfter completing this module, Describe high availability features in SQLyou will be able to: Server 2014.Use the CDC Control task to perform Describe data recovery enhancements inincremental data extractions in an ETL SQL Server 2014.solution. Deploying and Operating SSISDeploy and operate an SSIS project. PackagesAfter completing this module,Using Data Quality Services to Cleanse you will be able to:Data Use the CDC Control task to performUsing Data Quality Services to Match incremental data extractions in an ETLDataAfter completing this module, you solution.will be able to: Deploy and operate an SSIS project.Describe how Data Quality Services can Using Data Quality Services to Cleansehelp you manage data quality. DataUse Data Quality Services to cleanse Using Data Quality Services to Matchyour data. DataAfter completing this module, you willUse Data Quality Services to match data. be able to:Implementing a Master Data Services Describe how Data Quality Services canModel help you manage data quality.Using the Master Data Services Add-in Use Data Quality Services to cleanse yourfor ExcelAfter completing this module, data.you will be able to: Use Data Quality Services to match data.Describe key Master Data Services Implementing a Master Data Servicesconcepts. ModelImplement a Master Data Services Using the Master Data Services Add-in formodel. ExcelAfter completing this module, you willUse Master Data Services tools to be able to:manage master data. Describe key Master Data ServicesUse Master Data Services tools to create concepts.a master data hub. Implement a Master Data Services model.Reporting Services and Microsoft Use Master Data Services tools to manageSharePoint Server master data.Introduction to Data AlertsAfter Use Master Data Services tools to create acompleting this module, you will be able master data hub.to: Reporting Services and MicrosoftDescribe the key capabilities of Reporting SharePoint ServerServices. Introduction to Data AlertsAfter completingInstall and configure Reporting Services this module, you will be able to:in SharePoint Mode. Describe the key capabilities of ReportingUse data alerts to notify users of changes Services.to report data. Install and configure Reporting Services inCreating a Tabular Model SharePoint Mode.Using an Analysis Services Tabular Data Use data alerts to notify users of changesModel in the EnterpriseAfter completing to report data.this module, you will be able to: Creating a Tabular ModelDescribe Analysis Services tabular data Using an Analysis Services Tabular Datamodel projects. Model in the EnterpriseAfter completingImplement an Analysis Services tabular this module, you will be able to:data model. Describe Analysis Services tabular dataUse an Analysis Services tabular data model projects.model. Implement an Analysis Services tabularPowerPivot for SharePoint Server data model.Power Query Use an Analysis Services tabular dataPower View model.Power Map PowerPivot for SharePoint ServerPower BI for Office 365After completing Power Querythis module, you will be able to: Power ViewUse PowerPivot to create tabular data Power Mapmodels in Excel. Power BI for Office 365After completingShare a PowerPivot workbooks in this module, you will be able to:SharePoint Server. Use PowerPivot to create tabular dataUse Power Query to discover and import models in Excel.data from multiple data sources into Share a PowerPivot workbooks inExcel. SharePoint Server.


Use Power View to create interactive Use Power Query to discover and importdata visualizations in Excel and data from multiple data sources into Excel.SharePoint Server. Use Power View to create interactive dataUse Power Map to create visualizations visualizations in Excel and SharePointof geographic data. Server.Use Power BI for Office 365 to create a Use Power Map to create visualizations ofcloud-based collaborative solution for geographic data.self-service BI. Use Power BI for Office 365 to create aWindows Azure Services for DataAfter cloud-based collaborative solution forcompleting this module, you will be able self-service BI.to: Windows Azure Services for DataAfterDescribe key features and benefits of completing this module, you will be able to:cloud computing. Describe key features and benefits ofDescribe Windows Azure service for cloud computing.data. Describe Windows Azure service for data.Windows Azure SQL Database Security Windows Azure SQL Database SecurityImplementing and Managing Implementing and ManagingDatabasesAfter completing this module, DatabasesAfter completing this module,you will be able to: you will be able to:Describe key features and benefits of Describe key features and benefits ofWindows Azure SQL Database. Windows Azure SQL Database.Implement security for Windows Azure Implement security for Windows AzureSQL Database. SQL Database.Implement and manage databases in Implement and manage databases inWindows Azure SQL Database. Windows Azure SQL Database.Windows Azure Virtual Machine Windows Azure Virtual MachineConnectivity and Security Connectivity and SecurityCreating Databases in a Windows Azure Creating Databases in a Windows AzureVirtual MachineAfter completing this Virtual MachineAfter completing thismodule, you will be able to: module, you will be able to:Describe considerations for using Virtual Describe considerations for using VirtualMachines in Windows Azure. Machines in Windows Azure.Create and configure Windows Azure Create and configure Windows Azurevirtual machines. virtual machines.Create databases in Windows Azure Create databases in Windows Azurevirtual machines. virtual machines.Windows Azure HDInsight Windows Azure HDInsightConsuming HDInsight Results in Excel Consuming HDInsight Results in ExcelObtaining Data from the Windows Azure Obtaining Data from the Windows AzureMarketplaceAfter completing this module, MarketplaceAfter completing this module,you will be able to: you will be able to:Describe key features of big data. Describe key features of big data.Process big data with Windows Azure Process big data with Windows AzureHDInsight. HDInsight.Consume big data processing results Consume big data processing results fromfrom Windows Azure HDInsight in Windows Azure HDInsight in MicrosoftMicrosoft Excel. Excel.

lineSQL Server 2014 Editions andComponentsInstalling SQL Server 2014Enhancements to SQL ServerManagement StudioAfter completing thismodule, you will be able to:Describe the common workloads for SQLServer 2014.Describe the SQL Server 2014 Editionsand Components.Install SQL Server 2014 Components.Use the new features in SQL ServerManagement Studio.New and Enhanced Transact-SQLFunctionsEnhancements to Spatial Data Support


Storing and Querying Documents with SQLServer 2014After completing this module,you will be able to:Describe the enhancements toTransact-SQL.Describe new and enhancedTransact-SQL functions.Describe the enhancements to SpatialData Support.Explain how to store and query documentswith SQL Server 2014.Columnstore IndexesMemory-Optimized TablesAfter completingthis module, you will be able to:Use the Buffer Pool Extension to improveperformance for read-heavy OLTPworkloads.Use Columnstore Indexes to improveperformance in data warehouse queryworkloads.Use memory-optimized tables to improveperformance for latch-bound workloads.Using PowerShell to Manage SQLServerAfter completing this module, youwill be able to:Describe new and enhanced dynamicmanagement views.Describe how to use PowerShell toManage SQL Server.Contained DatabasesAfter completing thismodule, you will be able to:Describe the security enhancements inSQL Server 2014.Explain how to use contained databases.Enhancements to Data RecoveryAftercompleting this module, you will be able to:Describe high availability features in SQLServer 2014.Describe data recovery enhancements inSQL Server 2014.Deploying and Operating SSISPackagesAfter completing this module,you will be able to:Use the CDC Control task to performincremental data extractions in an ETLsolution.Deploy and operate an SSIS project.Using Data Quality Services to CleanseDataUsing Data Quality Services to MatchDataAfter completing this module, you willbe able to:Describe how Data Quality Services canhelp you manage data quality.Use Data Quality Services to cleanse yourdata.Use Data Quality Services to match data.Implementing a Master Data ServicesModelUsing the Master Data Services Add-in forExcelAfter completing this module, you willbe able to:Describe key Master Data Servicesconcepts.Implement a Master Data Services model.Use Master Data Services tools to manage


master data.Use Master Data Services tools to create amaster data hub.Reporting Services and MicrosoftSharePoint ServerIntroduction to Data AlertsAfter completingthis module, you will be able to:Describe the key capabilities of ReportingServices.Install and configure Reporting Services inSharePoint Mode.Use data alerts to notify users of changesto report data.Creating a Tabular ModelUsing an Analysis Services Tabular DataModel in the EnterpriseAfter completingthis module, you will be able to:Describe Analysis Services tabular datamodel projects.Implement an Analysis Services tabulardata model.Use an Analysis Services tabular datamodel.PowerPivot for SharePoint ServerPower QueryPower ViewPower MapPower BI for Office 365After completingthis module, you will be able to:Use PowerPivot to create tabular datamodels in Excel.Share a PowerPivot workbooks inSharePoint Server.Use Power Query to discover and importdata from multiple data sources into Excel.Use Power View to create interactive datavisualizations in Excel and SharePointServer.Use Power Map to create visualizations ofgeographic data.Use Power BI for Office 365 to create acloud-based collaborative solution forself-service BI.Windows Azure Services for DataAftercompleting this module, you will be able to:Describe key features and benefits ofcloud computing.Describe Windows Azure service for data.Windows Azure SQL Database SecurityImplementing and ManagingDatabasesAfter completing this module,you will be able to:Describe key features and benefits ofWindows Azure SQL Database.Implement security for Windows AzureSQL Database.Implement and manage databases inWindows Azure SQL Database.Windows Azure Virtual MachineConnectivity and SecurityCreating Databases in a Windows AzureVirtual MachineAfter completing thismodule, you will be able to:Describe considerations for using VirtualMachines in Windows Azure.Create and configure Windows Azure


virtual machines.Create databases in Windows Azurevirtual machines.Windows Azure HDInsightConsuming HDInsight Results in ExcelObtaining Data from the Windows AzureMarketplaceAfter completing this module,you will be able to:Describe key features of big data.Process big data with Windows AzureHDInsight.Consume big data processing results fromWindows Azure HDInsight in MicrosoftExcel.

lineSQL Server 2014 Editions andComponentsInstalling SQL Server 2014Enhancements to SQL ServerManagement StudioAfter completing thismodule, you will be able to:Describe the common workloads for SQLServer 2014.Describe the SQL Server 2014 Editionsand Components.Install SQL Server 2014 Components.Use the new features in SQL ServerManagement Studio.New and Enhanced Transact-SQLFunctionsEnhancements to Spatial Data SupportStoring and Querying Documents with SQLServer 2014After completing this module,you will be able to:Describe the enhancements toTransact-SQL.Describe new and enhancedTransact-SQL functions.Describe the enhancements to SpatialData Support.Explain how to store and query documentswith SQL Server 2014.Columnstore IndexesMemory-Optimized TablesAfter completingthis module, you will be able to:Use the Buffer Pool Extension to improveperformance for read-heavy OLTPworkloads.Use Columnstore Indexes to improveperformance in data warehouse queryworkloads.Use memory-optimized tables to improveperformance for latch-bound workloads.Using PowerShell to Manage SQLServerAfter completing this module, youwill be able to:Describe new and enhanced dynamicmanagement views.Describe how to use PowerShell toManage SQL Server.Contained DatabasesAfter completing thismodule, you will be able to:Describe the security enhancements inSQL Server 2014.


Explain how to use contained databases.Enhancements to Data RecoveryAftercompleting this module, you will be able to:Describe high availability features in SQLServer 2014.Describe data recovery enhancements inSQL Server 2014.Deploying and Operating SSISPackagesAfter completing this module,you will be able to:Use the CDC Control task to performincremental data extractions in an ETLsolution.Deploy and operate an SSIS project.Using Data Quality Services to CleanseDataUsing Data Quality Services to MatchDataAfter completing this module, you willbe able to:Describe how Data Quality Services canhelp you manage data quality.Use Data Quality Services to cleanse yourdata.Use Data Quality Services to match data.Implementing a Master Data ServicesModelUsing the Master Data Services Add-in forExcelAfter completing this module, you willbe able to:Describe key Master Data Servicesconcepts.Implement a Master Data Services model.Use Master Data Services tools to managemaster data.Use Master Data Services tools to create amaster data hub.Reporting Services and MicrosoftSharePoint ServerIntroduction to Data AlertsAfter completingthis module, you will be able to:Describe the key capabilities of ReportingServices.Install and configure Reporting Services inSharePoint Mode.Use data alerts to notify users of changesto report data.Creating a Tabular ModelUsing an Analysis Services Tabular DataModel in the EnterpriseAfter completingthis module, you will be able to:Describe Analysis Services tabular datamodel projects.Implement an Analysis Services tabulardata model.Use an Analysis Services tabular datamodel.PowerPivot for SharePoint ServerPower QueryPower ViewPower MapPower BI for Office 365After completingthis module, you will be able to:Use PowerPivot to create tabular datamodels in Excel.Share a PowerPivot workbooks inSharePoint Server.


Use Power Query to discover and importdata from multiple data sources into Excel.Use Power View to create interactive datavisualizations in Excel and SharePointServer.Use Power Map to create visualizations ofgeographic data.Use Power BI for Office 365 to create acloud-based collaborative solution forself-service BI.Windows Azure Services for DataAftercompleting this module, you will be able to:Describe key features and benefits ofcloud computing.Describe Windows Azure service for data.Windows Azure SQL Database SecurityImplementing and ManagingDatabasesAfter completing this module,you will be able to:Describe key features and benefits ofWindows Azure SQL Database.Implement security for Windows AzureSQL Database.Implement and manage databases inWindows Azure SQL Database.Windows Azure Virtual MachineConnectivity and SecurityCreating Databases in a Windows AzureVirtual MachineAfter completing thismodule, you will be able to:Describe considerations for using VirtualMachines in Windows Azure.Create and configure Windows Azurevirtual machines.Create databases in Windows Azurevirtual machines.Windows Azure HDInsightConsuming HDInsight Results in ExcelObtaining Data from the Windows AzureMarketplaceAfter completing this module,you will be able to:Describe key features of big data.Process big data with Windows AzureHDInsight.Consume big data processing results fromWindows Azure HDInsight in MicrosoftExcel.

Further Information:

For More information, or to book your course, please call us on 0800/84.009

[email protected]

www.globalknowledge.be

http://www.globalknowledge.be