Upgrading Your SQL Server Skills to Microsoft SQL Server 2014
Varighed: 5 Days Kursus Kode: M10977
Beskrivelse:
This five-day instructor-led course teaches students how to use the enhancements and new features that have been added to SQL Server and the Microsoft data platform since the release of SQL Server 2008. The course focuses on teaching individuals how to use SQL Server 2014 product features and other Microsoft data platform components.
Målgruppe:
The primary audience for this course is database and business intelligence (BI) professionals who are familiar with SQL Server 2008 and want to update their skills to SQL Server 2014, and become familiar with related Microsoft data technologies.
Agenda:
After completing this course, students will be able to: Use SQL Server 2014 Master Data Services. Describe key features and capabilities of SQL Server 2014. Manage SQL Server 2012 Agent and Jobs.
Leverage new and enhanced features to develop database in Implement a tabular data model in SQL Server 2014 Analysis
SQL Server 2014. Services.
Use in-memory database capabilities in SQL Server 2014. Implement a Self-Service BI solution with Microsoft Excel 2013. Manage SQL Server 2014 by using dynamic management views Describe key elements of cloud solutions for data.
and PowerShell.
Implement a database in Windows Azure SQL Database. Implement security in SQL Server 2014.
Implement a SQL Server database in a Windows Azure virtual Implement high-availability and data recovery techniques in SQL machine.
Server 2014.
Implement a Big Data solution with Windows Azure HDInsight and Use SQL Server 2014 Integration Services. the Windows Azure Marketplace.
Use SQL Server 2014 Data Quality Services.
Forudsætninger:
Before attending this course, students must have:
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.
Indhold:
Module 1: Introduction to SQL Server 2014 Lessons Lab : Working with an Analysis Services
line line Tabular Data Model
Transact-SQL Enhancements line
This module introduces key features of SQL New and Enhanced Transact-SQL Creating an Analysis Services Tabular
Server 2014. Functions Data Model Project
line Enhancements to Spatial Data Support Configuring Columns and Relationships Storing and Querying Documents with Using Custom DAX Expressions Lessons SQL Server 2014 Deploying an Analysis Services Tabular
line AlwaysOn High Availability Data Model
Overview of SQL Server 2014 Enhancements to Data Recovery
SQL Server 2014 Editions and Components Introduction to Windows Azure SQL After completing this module, you will be Installing SQL Server 2014 Database able to:
Enhancements to SQL Server Management Windows Azure SQL Database Security line
Studio Implementing and Managing Databases Describe the common workloads for SQL Introduction to Windows Azure Virtual Server 2014.
Lab : Exploring SQL Server 2014 Machines Describe the SQL Server 2014 Editions line Windows Azure Virtual Machine and Components.
Reviewing Installed Components Connectivity and Security Install SQL Server 2014 Components. Using SQL Server Management Studio Creating Databases in a Windows Azure Use the new features in SQL Server
Virtual Machine Management Studio.
After completing this module, you will be Describe the enhancements to able to: Lab : Using AlwaysOn Availability Groups Transact-SQL.
line line Describe new and enhanced
Describe the common workloads for SQL Creating an AlwaysOn Availability Group Transact-SQL functions.
Server 2014. Using an AlwaysOn Availability Group Describe the enhancements to Spatial Describe the SQL Server 2014 Editions and Observing Availability Group Failover Data Support.
Components. Behavior Explain how to store and query documents Install SQL Server 2014 Components. with SQL Server 2014.
Use the new features in SQL Server After completing this module, you will be Use the Buffer Pool Extension to improve Management Studio. able to: performance for read-heavy OLTP
Describe the enhancements to line workloads.
Transact-SQL. Describe the common workloads for SQL Use Columnstore Indexes to improve Describe new and enhanced Transact-SQL Server 2014. performance in data warehouse query functions. Describe the SQL Server 2014 Editions workloads.
Describe the enhancements to Spatial Data and Components. Use memory-optimized tables to improve Support. Install SQL Server 2014 Components. performance for latch-bound workloads. Explain how to store and query documents Use the new features in SQL Server Describe new and enhanced dynamic with SQL Server 2014. Management Studio. management views.
Use the Buffer Pool Extension to improve Describe the enhancements to Describe how to use PowerShell to performance for read-heavy OLTP Transact-SQL. Manage SQL Server.
workloads. Describe new and enhanced Describe the security enhancements in Use Columnstore Indexes to improve Transact-SQL functions. SQL Server 2014.
performance in data warehouse query Describe the enhancements to Spatial Explain how to use contained databases. workloads. Data Support. Describe high availability features in SQL Use memory-optimized tables to improve Explain how to store and query Server 2014.
performance for latch-bound workloads. documents with SQL Server 2014. Describe data recovery enhancements in Describe new and enhanced dynamic Use the Buffer Pool Extension to improve SQL Server 2014.
management views. performance for read-heavy OLTP Use the CDC Control task to perform Describe how to use PowerShell to Manage workloads. incremental data extractions in an ETL SQL Server. Use Columnstore Indexes to improve solution.
Describe the security enhancements in SQL performance in data warehouse query Deploy and operate an SSIS project Server 2014. workloads. Describe how Data Quality Services can Explain how to use contained databases. Use memory-optimized tables to improve help you manage data quality.
Describe high availability features in SQL performance for latch-bound workloads. Use Data Quality Services to cleanse your Server 2014. Describe new and enhanced dynamic data.
Describe data recovery enhancements in management views. Use Data Quality Services to match data. SQL Server 2014. Describe how to use PowerShell to Describe key Master Data Services Use the CDC Control task to perform Manage SQL Server. concepts.
incremental data extractions in an ETL Describe the security enhancements in Implement a Master Data Services model. solution. SQL Server 2014. Use Master Data Services tools to manage Deploy and operate an SSIS project Explain how to use contained databases. master data.
Describe how Data Quality Services can Describe high availability features in SQL Use Master Data Services tools to create a help you manage data quality. Server 2014. master data hub.
data. SQL Server 2014. Services.
Use Data Quality Services to match data. Use the CDC Control task to perform Install and configure Reporting Services in Describe key Master Data Services incremental data extractions in an ETL SharePoint Mode.
concepts. solution. Use data alerts to notify users of changes Implement a Master Data Services model. Deploy and operate an SSIS project to report data.
Use Master Data Services tools to manage Describe how Data Quality Services can Describe Analysis Services tabular data master data. help you manage data quality. model projects.
Use Master Data Services tools to create a Use Data Quality Services to cleanse Implement an Analysis Services tabular
master data hub. your data. data model.
Describe the key capabilities of Reporting Use Data Quality Services to match data. Use an Analysis Services tabular data Services. Describe key Master Data Services model.
Install and configure Reporting Services in concepts. Use PowerPivot to create tabular data SharePoint Mode. Implement a Master Data Services models in Excel.
Use data alerts to notify users of changes to model. Share a PowerPivot workbooks in report data. Use Master Data Services tools to SharePoint Server.
Describe Analysis Services tabular data manage master data. Use Power Query to discover and import model projects. Use Master Data Services tools to create data from multiple data sources into Excel. Implement an Analysis Services tabular data a master data hub. Use Power View to create interactive data model. Describe the key capabilities of Reporting visualizations in Excel and SharePoint Use an Analysis Services tabular data Services. Server.
model. Install and configure Reporting Services Use Power Map to create visualizations of Use PowerPivot to create tabular data in SharePoint Mode. geographic data.
models in Excel. Use data alerts to notify users of changes Use Power BI for Office 365 to create a Share a PowerPivot workbooks in to report data. cloud-based collaborative solution for SharePoint Server. Describe Analysis Services tabular data self-service BI.
Use Power Query to discover and import model projects. Describe key features and benefits of data from multiple data sources into Excel. Implement an Analysis Services tabular cloud computing.
Use Power View to create interactive data data model. Describe Windows Azure service for data. visualizations in Excel and SharePoint Use an Analysis Services tabular data Describe key features and benefits of
Server. model. Windows Azure SQL Database.
Use Power Map to create visualizations of Use PowerPivot to create tabular data Implement security for Windows Azure geographic data. models in Excel. SQL Database.
Use Power BI for Office 365 to create a Share a PowerPivot workbooks in Implement and manage databases in cloud-based collaborative solution for SharePoint Server. Windows Azure SQL Database. self-service BI. Use Power Query to discover and import Describe considerations for using Virtual Describe key features and benefits of cloud data from multiple data sources into Machines in Windows Azure.
computing. Excel. Create and configure Windows Azure
Describe Windows Azure service for data. Use Power View to create interactive virtual machines.
Describe key features and benefits of data visualizations in Excel and Create databases in Windows Azure Windows Azure SQL Database. SharePoint Server. virtual machines.
Implement security for Windows Azure SQL Use Power Map to create visualizations Describe key features of big data. Database. of geographic data. Process big data with Windows Azure Implement and manage databases in Use Power BI for Office 365 to create a HDInsight.
Windows Azure SQL Database. cloud-based collaborative solution for Consume big data processing results from Describe considerations for using Virtual self-service BI. Windows Azure HDInsight in Microsoft Machines in Windows Azure. Describe key features and benefits of Excel.
Create and configure Windows Azure virtual cloud computing.
machines. Describe Windows Azure service for Module 12: Self-Service BI with Microsoft Create databases in Windows Azure virtual data. Excel
machines. Describe key features and benefits of line Describe key features of big data. Windows Azure SQL Database.
Process big data with Windows Azure Implement security for Windows Azure This module introduces the self-service BI HDInsight. SQL Database. capabilities that can be delivered through Consume big data processing results from Implement and manage databases in Microsoft Excel 2013 and related Windows Azure HDInsight in Microsoft Windows Azure SQL Database. technologies.
Excel. Describe considerations for using Virtual line Machines in Windows Azure.
Module 2: What’s New in SQL Server Create and configure Windows Azure Lessons Database Development virtual machines. line
line Create databases in Windows Azure The Buffer pool Extension virtual machines. Columnstore Indexes This module describes enhancements to Describe key features of big data. Memory-Optimized Tables
Transact-SQL and other database development Process big data with Windows Azure New and Enhanced Dynamic Management features since SQL Server 2008. HDInsight. Views
Lessons Microsoft Excel. Contained Databases
line Using the CDC Control Task for
Transact-SQL Enhancements Module 7: New and Enhanced Features in Incremental Data Loads
New and Enhanced Transact-SQL Functions SQL Server Integration Services Deploying and Operating SSIS Packages Enhancements to Spatial Data Support line Introduction to Data Quality
Storing and Querying Documents with SQL Using Data Quality Services to Cleanse Server 2014 This module describes enhancements to SQL Data
AlwaysOn High Availability Server Integration Services since SQL Server •Using Data Quality Services to Match
Enhancements to Data Recovery 2008. Data
Introduction to Windows Azure SQL line Introduction to Master Data Services
Database Implementing a Master Data Services
Windows Azure SQL Database Security Lessons Model
Implementing and Managing Databases line Using the Master Data Services Add-in for Introduction to Windows Azure Virtual The Buffer pool Extension Excel
Machines Columnstore Indexes Reporting Services Overview Windows Azure Virtual Machine Connectivity Memory-Optimized Tables Reporting Services and Microsoft and Security New and Enhanced Dynamic SharePoint Server
Creating Databases in a Windows Azure Management Views Introduction to Data Alerts
Virtual Machine Using PowerShell to Manage SQL Server Introduction to Analysis Services Tabular Security Management Enhancements Data Model Projects
Lab : Developing SQL Server 2014 Contained Databases Creating a Tabular Model
Databases Using the CDC Control Task for Using an Analysis Services Tabular Data line Incremental Data Loads Model in the Enterprise
Using Sequence Objects Deploying and Operating SSIS Packages PowerPivot for Excel
Using the THROW statement Introduction to Data Quality PowerPivot for SharePoint Server Implementing Paging Using Data Quality Services to Cleanse Power Query
Querying Documents Data Power View
•Using Data Quality Services to Match Power Map
After completing this module, you will be Data Power BI for Office 365 able to: Introduction to Master Data Services Overview of Cloud Computing line Implementing a Master Data Services Windows Azure Services for Data
Describe the common workloads for SQL Model Introduction to Big Data Server 2014. Using the Master Data Services Add-in Windows Azure HDInsight
Describe the SQL Server 2014 Editions and for Excel Consuming HDInsight Results in Excel Components. Reporting Services Overview Obtaining Data from the Windows Azure Install SQL Server 2014 Components. Reporting Services and Microsoft Marketplace
Use the new features in SQL Server SharePoint Server
Management Studio. Introduction to Data Alerts Lab : Self-Service BI with Excel Describe the enhancements to Introduction to Analysis Services Tabular line
Transact-SQL. Data Model Projects Creating a Data Model with PowerPivot Describe new and enhanced Transact-SQL Creating a Tabular Model Importing Data with Power Query functions. Using an Analysis Services Tabular Data Visualizing Data with Power View Describe the enhancements to Spatial Data Model in the Enterprise Visualizing Geographic Data with Power
Support. PowerPivot for Excel Map
Explain how to store and query documents PowerPivot for SharePoint Server
with SQL Server 2014. Power Query After completing this module, you will be Use the Buffer Pool Extension to improve Power View able to:
performance for read-heavy OLTP Power Map line
workloads. Power BI for Office 365 Describe the common workloads for SQL Use Columnstore Indexes to improve Overview of Cloud Computing Server 2014.
performance in data warehouse query Windows Azure Services for Data Describe the SQL Server 2014 Editions workloads. Introduction to Big Data and Components.
Use memory-optimized tables to improve Windows Azure HDInsight Install SQL Server 2014 Components. performance for latch-bound workloads. Consuming HDInsight Results in Excel Use the new features in SQL Server Describe new and enhanced dynamic Obtaining Data from the Windows Azure Management Studio.
management views. Marketplace Describe the enhancements to Describe how to use PowerShell to Manage Transact-SQL.
SQL Server. Lab : Using SQL Server Integration Describe new and enhanced Describe the security enhancements in SQL Services Transact-SQL functions.
Server 2014. line Describe the enhancements to Spatial
Explain how to use contained databases. Extracting Modified Data Data Support.
Describe high availability features in SQL Deploying and Operating an SSIS Project Explain how to store and query documents
Server 2014. with SQL Server 2014.
incremental data extractions in an ETL Describe the common workloads for SQL Use Columnstore Indexes to improve solution. Server 2014. performance in data warehouse query Deploy and operate an SSIS project Describe the SQL Server 2014 Editions workloads.
Describe how Data Quality Services can and Components. Use memory-optimized tables to improve help you manage data quality. Install SQL Server 2014 Components. performance for latch-bound workloads. Use Data Quality Services to cleanse your Use the new features in SQL Server Describe new and enhanced dynamic
data. Management Studio. management views.
Use Data Quality Services to match data. Describe the enhancements to Describe how to use PowerShell to Describe key Master Data Services Transact-SQL. Manage SQL Server.
concepts. Describe new and enhanced Describe the security enhancements in Implement a Master Data Services model. Transact-SQL functions. SQL Server 2014.
Use Master Data Services tools to manage Describe the enhancements to Spatial Explain how to use contained databases. master data. Data Support. Describe high availability features in SQL Use Master Data Services tools to create a Explain how to store and query Server 2014.
master data hub. documents with SQL Server 2014. Describe data recovery enhancements in Describe the key capabilities of Reporting Use the Buffer Pool Extension to improve SQL Server 2014.
Services. performance for read-heavy OLTP Use the CDC Control task to perform Install and configure Reporting Services in workloads. incremental data extractions in an ETL SharePoint Mode. Use Columnstore Indexes to improve solution.
Use data alerts to notify users of changes to performance in data warehouse query Deploy and operate an SSIS project report data. workloads. Describe how Data Quality Services can Describe Analysis Services tabular data Use memory-optimized tables to improve help you manage data quality.
model projects. performance for latch-bound workloads. Use Data Quality Services to cleanse your Implement an Analysis Services tabular data Describe new and enhanced dynamic data.
model. management views. Use Data Quality Services to match data. Use an Analysis Services tabular data Describe how to use PowerShell to Describe key Master Data Services
model. Manage SQL Server. concepts.
Use PowerPivot to create tabular data Describe the security enhancements in Implement a Master Data Services model. models in Excel. SQL Server 2014. Use Master Data Services tools to manage Share a PowerPivot workbooks in Explain how to use contained databases. master data.
SharePoint Server. Describe high availability features in SQL Use Master Data Services tools to create a Use Power Query to discover and import Server 2014. master data hub.
data from multiple data sources into Excel. Describe data recovery enhancements in Describe the key capabilities of Reporting Use Power View to create interactive data SQL Server 2014. Services.
visualizations in Excel and SharePoint Use the CDC Control task to perform Install and configure Reporting Services in Server. incremental data extractions in an ETL SharePoint Mode.
Use Power Map to create visualizations of solution. Use data alerts to notify users of changes geographic data. Deploy and operate an SSIS project to report data.
Use Power BI for Office 365 to create a Describe how Data Quality Services can Describe Analysis Services tabular data cloud-based collaborative solution for help you manage data quality. model projects.
self-service BI. Use Data Quality Services to cleanse Implement an Analysis Services tabular Describe key features and benefits of cloud your data. data model.
computing. Use Data Quality Services to match data. Use an Analysis Services tabular data Describe Windows Azure service for data. Describe key Master Data Services model.
Describe key features and benefits of concepts. Use PowerPivot to create tabular data Windows Azure SQL Database. Implement a Master Data Services models in Excel.
Implement security for Windows Azure SQL model. Share a PowerPivot workbooks in Database. Use Master Data Services tools to SharePoint Server.
Implement and manage databases in manage master data. Use Power Query to discover and import Windows Azure SQL Database. Use Master Data Services tools to create data from multiple data sources into Excel. Describe considerations for using Virtual a master data hub. Use Power View to create interactive data Machines in Windows Azure. Describe the key capabilities of Reporting visualizations in Excel and SharePoint Create and configure Windows Azure virtual Services. Server.
machines. Install and configure Reporting Services Use Power Map to create visualizations of Create databases in Windows Azure virtual in SharePoint Mode. geographic data.
machines. Use data alerts to notify users of changes Use Power BI for Office 365 to create a Describe key features of big data. to report data. cloud-based collaborative solution for Process big data with Windows Azure Describe Analysis Services tabular data self-service BI.
HDInsight. model projects. Describe key features and benefits of Consume big data processing results from Implement an Analysis Services tabular cloud computing.
Windows Azure HDInsight in Microsoft data model. Describe Windows Azure service for data. Excel. Use an Analysis Services tabular data Describe key features and benefits of
model. Windows Azure SQL Database. Module 3: In-Memory Database Capabilities Use PowerPivot to create tabular data Implement security for Windows Azure
line models in Excel. SQL Database.
This module describes how SQL server 2014 SharePoint Server. Windows Azure SQL Database. enables you to leverage in-memory Use Power Query to discover and import Describe considerations for using Virtual technologies to enhance database data from multiple data sources into Machines in Windows Azure.
performance. Excel. Create and configure Windows Azure
line Use Power View to create interactive virtual machines.
data visualizations in Excel and Create databases in Windows Azure
Lessons SharePoint Server. virtual machines.
line Use Power Map to create visualizations Describe key features of big data. The Buffer pool Extension of geographic data. Process big data with Windows Azure Columnstore Indexes Use Power BI for Office 365 to create a HDInsight.
Memory-Optimized Tables cloud-based collaborative solution for Consume big data processing results from New and Enhanced Dynamic Management self-service BI. Windows Azure HDInsight in Microsoft Views Describe key features and benefits of Excel.
Using PowerShell to Manage SQL Server cloud computing.
Security Management Enhancements Describe Windows Azure service for Module 13: Introduction to Cloud Data
Contained Databases data. Solutions
Using the CDC Control Task for Incremental Describe key features and benefits of line Data Loads Windows Azure SQL Database.
Deploying and Operating SSIS Packages Implement security for Windows Azure This module introduces some of the key Introduction to Data Quality SQL Database. Microsoft technologies that you can use to Using Data Quality Services to Cleanse Implement and manage databases in implement a cloud solution for data.
Data Windows Azure SQL Database. line
•Using Data Quality Services to Match Data Describe considerations for using Virtual
Introduction to Master Data Services Machines in Windows Azure. Lessons Implementing a Master Data Services Model Create and configure Windows Azure line
Using the Master Data Services Add-in for virtual machines. The Buffer pool Extension Excel Create databases in Windows Azure Columnstore Indexes Reporting Services Overview virtual machines. Memory-Optimized Tables
Reporting Services and Microsoft Describe key features of big data. New and Enhanced Dynamic Management SharePoint Server Process big data with Windows Azure Views
Introduction to Data Alerts HDInsight. Using PowerShell to Manage SQL Server Introduction to Analysis Services Tabular Consume big data processing results Security Management Enhancements Data Model Projects from Windows Azure HDInsight in Contained Databases
Creating a Tabular Model Microsoft Excel. Using the CDC Control Task for Using an Analysis Services Tabular Data Incremental Data Loads
Model in the Enterprise Module 8: Data Quality Services Deploying and Operating SSIS Packages PowerPivot for Excel line Introduction to Data Quality
PowerPivot for SharePoint Server Using Data Quality Services to Cleanse Power Query This module explains how to use the SQL Data
Power View Server 2014 Data Quality Services (DQS) to •Using Data Quality Services to Match Power Map provide a computer assisted process for Data
Power BI for Office 365 cleansing data values and identifying and Introduction to Master Data Services Overview of Cloud Computing removing duplicate data entities. Implementing a Master Data Services
Windows Azure Services for Data line Model
Introduction to Big Data Using the Master Data Services Add-in for
Windows Azure HDInsight Lessons Excel
Consuming HDInsight Results in Excel line Reporting Services Overview Obtaining Data from the Windows Azure The Buffer pool Extension Reporting Services and Microsoft Marketplace Columnstore Indexes SharePoint Server
Memory-Optimized Tables Introduction to Data Alerts
Lab : Using In-Memory Database New and Enhanced Dynamic Introduction to Analysis Services Tabular Capabilities Management Views Data Model Projects
line Using PowerShell to Manage SQL Server Creating a Tabular Model
Enabling the Buffer Pool Extension Security Management Enhancements Using an Analysis Services Tabular Data Creating Columnstore Indexes Contained Databases Model in the Enterprise
Working with Memory-Optimized Tables Using the CDC Control Task for PowerPivot for Excel
Incremental Data Loads PowerPivot for SharePoint Server After completing this module, you will be Deploying and Operating SSIS Packages Power Query
able to: Introduction to Data Quality Power View line Using Data Quality Services to Cleanse Power Map
Describe the common workloads for SQL Data Power BI for Office 365 Server 2014. •Using Data Quality Services to Match Overview of Cloud Computing Describe the SQL Server 2014 Editions and Data Windows Azure Services for Data Components. Introduction to Master Data Services Introduction to Big Data
Install SQL Server 2014 Components. Implementing a Master Data Services Windows Azure HDInsight
Management Studio. Using the Master Data Services Add-in Obtaining Data from the Windows Azure Describe the enhancements to for Excel Marketplace
Transact-SQL. Reporting Services Overview
Describe new and enhanced Transact-SQL Reporting Services and Microsoft Lab : Using Windows Azure
functions. SharePoint Server line
Describe the enhancements to Spatial Data Introduction to Data Alerts Creating a Windows Azure Storage Support. Introduction to Analysis Services Tabular Account
Explain how to store and query documents Data Model Projects Backing Up a Database to Windows Azure with SQL Server 2014. Creating a Tabular Model
Use the Buffer Pool Extension to improve Using an Analysis Services Tabular Data After completing this module, you will be performance for read-heavy OLTP Model in the Enterprise able to:
workloads. PowerPivot for Excel line
Use Columnstore Indexes to improve PowerPivot for SharePoint Server Describe the common workloads for SQL performance in data warehouse query Power Query Server 2014.
workloads. Power View Describe the SQL Server 2014 Editions Use memory-optimized tables to improve Power Map and Components.
performance for latch-bound workloads. Power BI for Office 365 Install SQL Server 2014 Components. Describe new and enhanced dynamic Overview of Cloud Computing Use the new features in SQL Server management views. Windows Azure Services for Data Management Studio.
Describe how to use PowerShell to Manage Introduction to Big Data Describe the enhancements to SQL Server. Windows Azure HDInsight Transact-SQL.
Describe the security enhancements in SQL Consuming HDInsight Results in Excel Describe new and enhanced Server 2014. Obtaining Data from the Windows Azure Transact-SQL functions.
Explain how to use contained databases. Marketplace Describe the enhancements to Spatial Describe high availability features in SQL Data Support.
Server 2014. Lab : Cleansing Data Explain how to store and query documents Describe data recovery enhancements in line with SQL Server 2014.
SQL Server 2014. Creating a DQS Knowledge Base Use the Buffer Pool Extension to improve Use the CDC Control task to perform Using a DQS Project to Cleanse Data performance for read-heavy OLTP incremental data extractions in an ETL Using DQS in an SSIS Package workloads.
solution. Use Columnstore Indexes to improve
Deploy and operate an SSIS project Lab : Deduplicating Data performance in data warehouse query Describe how Data Quality Services can line workloads.
help you manage data quality. Creating a Matching Policy Use memory-optimized tables to improve Use Data Quality Services to cleanse your Using a DQS Project to Match Data performance for latch-bound workloads.
data. Describe new and enhanced dynamic
Use Data Quality Services to match data. After completing this module, you will be management views.
Describe key Master Data Services able to: Describe how to use PowerShell to
concepts. line Manage SQL Server.
Implement a Master Data Services model. Describe the common workloads for SQL Describe the security enhancements in Use Master Data Services tools to manage Server 2014. SQL Server 2014.
master data. Describe the SQL Server 2014 Editions Explain how to use contained databases. Use Master Data Services tools to create a and Components. Describe high availability features in SQL master data hub. Install SQL Server 2014 Components. Server 2014.
Describe the key capabilities of Reporting Use the new features in SQL Server Describe data recovery enhancements in
Services. Management Studio. SQL Server 2014.
Install and configure Reporting Services in Describe the enhancements to Use the CDC Control task to perform SharePoint Mode. Transact-SQL. incremental data extractions in an ETL Use data alerts to notify users of changes to Describe new and enhanced solution.
report data. Transact-SQL functions. Deploy and operate an SSIS project Describe Analysis Services tabular data Describe the enhancements to Spatial Describe how Data Quality Services can model projects. Data Support. help you manage data quality.
Implement an Analysis Services tabular data Explain how to store and query Use Data Quality Services to cleanse your model. documents with SQL Server 2014. data.
Use an Analysis Services tabular data Use the Buffer Pool Extension to improve Use Data Quality Services to match data. model. performance for read-heavy OLTP Describe key Master Data Services Use PowerPivot to create tabular data workloads. concepts.
models in Excel. Use Columnstore Indexes to improve Implement a Master Data Services model. Share a PowerPivot workbooks in performance in data warehouse query Use Master Data Services tools to manage
SharePoint Server. workloads. master data.
Use Power Query to discover and import Use memory-optimized tables to improve Use Master Data Services tools to create a data from multiple data sources into Excel. performance for latch-bound workloads. master data hub.
Use Power View to create interactive data Describe new and enhanced dynamic Describe the key capabilities of Reporting visualizations in Excel and SharePoint management views. Services.
geographic data. Describe the security enhancements in Use data alerts to notify users of changes Use Power BI for Office 365 to create a SQL Server 2014. to report data.
cloud-based collaborative solution for Explain how to use contained databases. Describe Analysis Services tabular data self-service BI. Describe high availability features in SQL model projects.
Describe key features and benefits of cloud Server 2014. Implement an Analysis Services tabular computing. Describe data recovery enhancements in data model.
Describe Windows Azure service for data. SQL Server 2014. Use an Analysis Services tabular data Describe key features and benefits of Use the CDC Control task to perform model.
Windows Azure SQL Database. incremental data extractions in an ETL Use PowerPivot to create tabular data Implement security for Windows Azure SQL solution. models in Excel.
Database. Deploy and operate an SSIS project Share a PowerPivot workbooks in Implement and manage databases in Describe how Data Quality Services can SharePoint Server.
Windows Azure SQL Database. help you manage data quality. Use Power Query to discover and import Describe considerations for using Virtual Use Data Quality Services to cleanse data from multiple data sources into Excel. Machines in Windows Azure. your data. Use Power View to create interactive data Create and configure Windows Azure virtual Use Data Quality Services to match data. visualizations in Excel and SharePoint machines. Describe key Master Data Services Server.
Create databases in Windows Azure virtual concepts. Use Power Map to create visualizations of machines. Implement a Master Data Services geographic data.
Describe key features of big data. model. Use Power BI for Office 365 to create a Process big data with Windows Azure Use Master Data Services tools to cloud-based collaborative solution for HDInsight. manage master data. self-service BI.
Consume big data processing results from Use Master Data Services tools to create Describe key features and benefits of Windows Azure HDInsight in Microsoft a master data hub. cloud computing.
Excel. Describe the key capabilities of Reporting Describe Windows Azure service for data. Services. Describe key features and benefits of Module 4: Scripting SQL Server 2014 Install and configure Reporting Services Windows Azure SQL Database. line in SharePoint Mode. Implement security for Windows Azure
Use data alerts to notify users of changes SQL Database.
This lesson describes how you can use to report data. Implement and manage databases in dynamic management views and PowerShell to Describe Analysis Services tabular data Windows Azure SQL Database. script administrative tasks in SQL server 2014. model projects. Describe considerations for using Virtual line Implement an Analysis Services tabular Machines in Windows Azure.
data model. Create and configure Windows Azure Lessons Use an Analysis Services tabular data virtual machines.
line model. Create databases in Windows Azure
The Buffer pool Extension Use PowerPivot to create tabular data virtual machines.
Columnstore Indexes models in Excel. Describe key features of big data. Memory-Optimized Tables Share a PowerPivot workbooks in Process big data with Windows Azure New and Enhanced Dynamic Management SharePoint Server. HDInsight.
Views Use Power Query to discover and import Consume big data processing results from Using PowerShell to Manage SQL Server data from multiple data sources into Windows Azure HDInsight in Microsoft Security Management Enhancements Excel. Excel.
Contained Databases Use Power View to create interactive
Using the CDC Control Task for Incremental data visualizations in Excel and Module 14: Windows Azure SQL Database
Data Loads SharePoint Server. line
Deploying and Operating SSIS Packages Use Power Map to create visualizations
Introduction to Data Quality of geographic data. This module introduces Windows Azure SQL Using Data Quality Services to Cleanse Use Power BI for Office 365 to create a Database, a Platform-as-a-Service (PaaS) Data cloud-based collaborative solution for solution for cloud-based relational database •Using Data Quality Services to Match Data self-service BI. storage.
Introduction to Master Data Services Describe key features and benefits of line Implementing a Master Data Services Model cloud computing.
Using the Master Data Services Add-in for Describe Windows Azure service for Lessons
Excel data. line
Reporting Services Overview Describe key features and benefits of Transact-SQL Enhancements Reporting Services and Microsoft Windows Azure SQL Database. New and Enhanced Transact-SQL SharePoint Server Implement security for Windows Azure Functions
Introduction to Data Alerts SQL Database. Enhancements to Spatial Data Support Introduction to Analysis Services Tabular Implement and manage databases in Storing and Querying Documents with SQL Data Model Projects Windows Azure SQL Database. Server 2014
Creating a Tabular Model Describe considerations for using Virtual AlwaysOn High Availability Using an Analysis Services Tabular Data Machines in Windows Azure. Enhancements to Data Recovery Model in the Enterprise Create and configure Windows Azure Introduction to Windows Azure SQL PowerPivot for Excel virtual machines. Database
Power Query virtual machines. Implementing and Managing Databases Power View Describe key features of big data. Introduction to Windows Azure Virtual Power Map Process big data with Windows Azure Machines
Power BI for Office 365 HDInsight. Windows Azure Virtual Machine Overview of Cloud Computing Consume big data processing results Connectivity and Security
Windows Azure Services for Data from Windows Azure HDInsight in Creating Databases in a Windows Azure Introduction to Big Data Microsoft Excel. Virtual Machine
Windows Azure HDInsight
Consuming HDInsight Results in Excel Module 9: Master Data Services Lab : Using Windows Azure SQL Database Obtaining Data from the Windows Azure line line
Marketplace Provisioning Windows Azure SQL
This module introduces Master Data Services Database
Lab : Managing SQL Server with Scripts and describes its key configuration options Configuring Windows Azure SQL line and how to import and export data. Database Security
Using Dynamic Management Views line Migrating a SQL Server Database to
Using PowerShell Windows Azure SQL Database
Lessons
After completing this module, you will be line After completing this module, you will be able to: The Buffer pool Extension able to:
line Columnstore Indexes line
Describe the common workloads for SQL Memory-Optimized Tables Describe the common workloads for SQL Server 2014. New and Enhanced Dynamic Server 2014.
Describe the SQL Server 2014 Editions and Management Views Describe the SQL Server 2014 Editions Components. Using PowerShell to Manage SQL Server and Components.
Install SQL Server 2014 Components. Security Management Enhancements Install SQL Server 2014 Components. Use the new features in SQL Server Contained Databases Use the new features in SQL Server Management Studio. Using the CDC Control Task for Management Studio.
Describe the enhancements to Incremental Data Loads Describe the enhancements to Transact-SQL. Deploying and Operating SSIS Packages Transact-SQL.
Describe new and enhanced Transact-SQL Introduction to Data Quality Describe new and enhanced functions. Using Data Quality Services to Cleanse Transact-SQL functions.
Describe the enhancements to Spatial Data Data Describe the enhancements to Spatial Support. •Using Data Quality Services to Match Data Support.
Explain how to store and query documents Data Explain how to store and query documents with SQL Server 2014. Introduction to Master Data Services with SQL Server 2014.
Use the Buffer Pool Extension to improve Implementing a Master Data Services Use the Buffer Pool Extension to improve performance for read-heavy OLTP Model performance for read-heavy OLTP workloads. Using the Master Data Services Add-in workloads.
Use Columnstore Indexes to improve for Excel Use Columnstore Indexes to improve performance in data warehouse query Reporting Services Overview performance in data warehouse query workloads. Reporting Services and Microsoft workloads.
Use memory-optimized tables to improve SharePoint Server Use memory-optimized tables to improve performance for latch-bound workloads. Introduction to Data Alerts performance for latch-bound workloads. Describe new and enhanced dynamic Introduction to Analysis Services Tabular Describe new and enhanced dynamic management views. Data Model Projects management views.
Describe how to use PowerShell to Manage Creating a Tabular Model Describe how to use PowerShell to SQL Server. Using an Analysis Services Tabular Data Manage SQL Server.
Describe the security enhancements in SQL Model in the Enterprise Describe the security enhancements in Server 2014. PowerPivot for Excel SQL Server 2014.
Explain how to use contained databases. PowerPivot for SharePoint Server Explain how to use contained databases. Describe high availability features in SQL Power Query Describe high availability features in SQL
Server 2014. Power View Server 2014.
Describe data recovery enhancements in Power Map Describe data recovery enhancements in SQL Server 2014. Power BI for Office 365 SQL Server 2014.
Use the CDC Control task to perform Overview of Cloud Computing Use the CDC Control task to perform incremental data extractions in an ETL Windows Azure Services for Data incremental data extractions in an ETL solution. Introduction to Big Data solution.
Deploy and operate an SSIS project Windows Azure HDInsight Deploy and operate an SSIS project Describe how Data Quality Services can Consuming HDInsight Results in Excel Describe how Data Quality Services can help you manage data quality. Obtaining Data from the Windows Azure help you manage data quality.
Use Data Quality Services to cleanse your Marketplace Use Data Quality Services to cleanse your
data. data.
Use Data Quality Services to match data. Lab : Implementing Master Data Services Use Data Quality Services to match data. Describe key Master Data Services line Describe key Master Data Services
concepts. Creating a Basic Model concepts.
Use Master Data Services tools to manage Services Add-in for Excel Use Master Data Services tools to manage master data. Loading Data into a Model master data.
Use Master Data Services tools to create a Enforcing Business Rules Use Master Data Services tools to create a master data hub. Consuming Master Data Services Data master data hub.
Describe the key capabilities of Reporting Describe the key capabilities of Reporting Services. After completing this module, you will be Services.
Install and configure Reporting Services in able to: Install and configure Reporting Services in
SharePoint Mode. line SharePoint Mode.
Use data alerts to notify users of changes to Describe the common workloads for SQL Use data alerts to notify users of changes
report data. Server 2014. to report data.
Describe Analysis Services tabular data Describe the SQL Server 2014 Editions Describe Analysis Services tabular data model projects. and Components. model projects.
Implement an Analysis Services tabular data Install SQL Server 2014 Components. Implement an Analysis Services tabular model. Use the new features in SQL Server data model.
Use an Analysis Services tabular data Management Studio. Use an Analysis Services tabular data
model. Describe the enhancements to model.
Use PowerPivot to create tabular data Transact-SQL. Use PowerPivot to create tabular data models in Excel. Describe new and enhanced models in Excel.
Share a PowerPivot workbooks in Transact-SQL functions. Share a PowerPivot workbooks in SharePoint Server. Describe the enhancements to Spatial SharePoint Server.
Use Power Query to discover and import Data Support. Use Power Query to discover and import data from multiple data sources into Excel. Explain how to store and query data from multiple data sources into Excel. Use Power View to create interactive data documents with SQL Server 2014. Use Power View to create interactive data visualizations in Excel and SharePoint Use the Buffer Pool Extension to improve visualizations in Excel and SharePoint Server. performance for read-heavy OLTP Server.
Use Power Map to create visualizations of workloads. Use Power Map to create visualizations of geographic data. Use Columnstore Indexes to improve geographic data.
Use Power BI for Office 365 to create a performance in data warehouse query Use Power BI for Office 365 to create a cloud-based collaborative solution for workloads. cloud-based collaborative solution for self-service BI. Use memory-optimized tables to improve self-service BI.
Describe key features and benefits of cloud performance for latch-bound workloads. Describe key features and benefits of computing. Describe new and enhanced dynamic cloud computing.
Describe Windows Azure service for data. management views. Describe Windows Azure service for data. Describe key features and benefits of Describe how to use PowerShell to Describe key features and benefits of Windows Azure SQL Database. Manage SQL Server. Windows Azure SQL Database. Implement security for Windows Azure SQL Describe the security enhancements in Implement security for Windows Azure
Database. SQL Server 2014. SQL Database.
Implement and manage databases in Explain how to use contained databases. Implement and manage databases in Windows Azure SQL Database. Describe high availability features in SQL Windows Azure SQL Database. Describe considerations for using Virtual Server 2014. Describe considerations for using Virtual Machines in Windows Azure. Describe data recovery enhancements in Machines in Windows Azure.
Create and configure Windows Azure virtual SQL Server 2014. Create and configure Windows Azure machines. Use the CDC Control task to perform virtual machines.
Create databases in Windows Azure virtual incremental data extractions in an ETL Create databases in Windows Azure
machines. solution. virtual machines.
Describe key features of big data. Deploy and operate an SSIS project Describe key features of big data. Process big data with Windows Azure Describe how Data Quality Services can Process big data with Windows Azure HDInsight. help you manage data quality. HDInsight.
Consume big data processing results from Use Data Quality Services to cleanse Consume big data processing results from Windows Azure HDInsight in Microsoft your data. Windows Azure HDInsight in Microsoft Excel. Use Data Quality Services to match data. Excel.
Describe key Master Data Services
Module 5: Implementing Security in concepts. Module 15: SQL Server in Windows Azure Microsoft SQL Server 2014 Implement a Master Data Services Virtual Machines
line model. line
Use Master Data Services tools to
This module describes the enhancements to manage master data. This module explores how you can use security features since SQL Server 2008. Use Master Data Services tools to create Windows Azure virtual machines in which line a master data hub. SQL Server is installed to create a
Describe the key capabilities of Reporting cloud-based solution for data.
Lessons Services. line
line Install and configure Reporting Services
The Buffer pool Extension in SharePoint Mode. Lessons Columnstore Indexes Use data alerts to notify users of changes line
Views model projects. Functions
Using PowerShell to Manage SQL Server Implement an Analysis Services tabular Enhancements to Spatial Data Support Security Management Enhancements data model. Storing and Querying Documents with SQL Contained Databases Use an Analysis Services tabular data Server 2014
Using the CDC Control Task for Incremental model. AlwaysOn High Availability Data Loads Use PowerPivot to create tabular data Enhancements to Data Recovery Deploying and Operating SSIS Packages models in Excel. Introduction to Windows Azure SQL Introduction to Data Quality Share a PowerPivot workbooks in Database
Using Data Quality Services to Cleanse SharePoint Server. Windows Azure SQL Database Security Data Use Power Query to discover and import Implementing and Managing Databases •Using Data Quality Services to Match Data data from multiple data sources into Introduction to Windows Azure Virtual Introduction to Master Data Services Excel. Machines
Implementing a Master Data Services Model Use Power View to create interactive Windows Azure Virtual Machine Using the Master Data Services Add-in for data visualizations in Excel and Connectivity and Security
Excel SharePoint Server. Creating Databases in a Windows Azure Reporting Services Overview Use Power Map to create visualizations Virtual Machine
Reporting Services and Microsoft of geographic data.
SharePoint Server Use Power BI for Office 365 to create a Lab : Using Windows Azure Virtual Introduction to Data Alerts cloud-based collaborative solution for Machines
Introduction to Analysis Services Tabular self-service BI. line
Data Model Projects Describe key features and benefits of Creating a Windows Azure Virtual Machine Creating a Tabular Model cloud computing. Configuring Virtual Machine Security and Using an Analysis Services Tabular Data Describe Windows Azure service for Connectivity
Model in the Enterprise data. Creating Databases on a Virtual Machine PowerPivot for Excel Describe key features and benefits of
PowerPivot for SharePoint Server Windows Azure SQL Database. After completing this module, you will be Power Query Implement security for Windows Azure able to:
Power View SQL Database. line
Power Map Implement and manage databases in Describe the common workloads for SQL Power BI for Office 365 Windows Azure SQL Database. Server 2014.
Overview of Cloud Computing Describe considerations for using Virtual Describe the SQL Server 2014 Editions Windows Azure Services for Data Machines in Windows Azure. and Components.
Introduction to Big Data Create and configure Windows Azure Install SQL Server 2014 Components. Windows Azure HDInsight virtual machines. Use the new features in SQL Server Consuming HDInsight Results in Excel Create databases in Windows Azure Management Studio.
Obtaining Data from the Windows Azure virtual machines. Describe the enhancements to Marketplace Describe key features of big data. Transact-SQL.
Process big data with Windows Azure Describe new and enhanced Lab : Implementing Security HDInsight. Transact-SQL functions.
line Consume big data processing results Describe the enhancements to Spatial Implementing User-Defines Server Roles from Windows Azure HDInsight in Data Support.
Implementing Contained Databases Microsoft Excel. Explain how to store and query documents with SQL Server 2014.
After completing this module, you will be Module 10: SQL Server 2014 Reporting Use the Buffer Pool Extension to improve
able to: Services performance for read-heavy OLTP
line line workloads.
Describe the common workloads for SQL Use Columnstore Indexes to improve Server 2014. This module describes new and enhanced performance in data warehouse query Describe the SQL Server 2014 Editions and features in SQL Server Reporting Services. workloads.
Components. line Use memory-optimized tables to improve
Install SQL Server 2014 Components. performance for latch-bound workloads. Use the new features in SQL Server Lessons Describe new and enhanced dynamic
Management Studio. line management views.
Describe the enhancements to The Buffer pool Extension Describe how to use PowerShell to Transact-SQL. Columnstore Indexes Manage SQL Server.
Describe new and enhanced Transact-SQL Memory-Optimized Tables Describe the security enhancements in functions. New and Enhanced Dynamic SQL Server 2014.
Describe the enhancements to Spatial Data Management Views Explain how to use contained databases. Support. Using PowerShell to Manage SQL Server Describe high availability features in SQL Explain how to store and query documents Security Management Enhancements Server 2014.
with SQL Server 2014. Contained Databases Describe data recovery enhancements in Use the Buffer Pool Extension to improve Using the CDC Control Task for SQL Server 2014.
performance for read-heavy OLTP Incremental Data Loads Use the CDC Control task to perform workloads. Deploying and Operating SSIS Packages incremental data extractions in an ETL Use Columnstore Indexes to improve Introduction to Data Quality solution.
workloads. Data Describe how Data Quality Services can Use memory-optimized tables to improve •Using Data Quality Services to Match help you manage data quality.
performance for latch-bound workloads. Data Use Data Quality Services to cleanse your Describe new and enhanced dynamic Introduction to Master Data Services data.
management views. Implementing a Master Data Services Use Data Quality Services to match data. Describe how to use PowerShell to Manage Model Describe key Master Data Services SQL Server. Using the Master Data Services Add-in concepts.
Describe the security enhancements in SQL for Excel Implement a Master Data Services model. Server 2014. Reporting Services Overview Use Master Data Services tools to manage Explain how to use contained databases. Reporting Services and Microsoft master data.
Describe high availability features in SQL SharePoint Server Use Master Data Services tools to create a Server 2014. Introduction to Data Alerts master data hub.
Describe data recovery enhancements in Introduction to Analysis Services Tabular Describe the key capabilities of Reporting SQL Server 2014. Data Model Projects Services.
Use the CDC Control task to perform Creating a Tabular Model Install and configure Reporting Services in incremental data extractions in an ETL Using an Analysis Services Tabular Data SharePoint Mode.
solution. Model in the Enterprise Use data alerts to notify users of changes Deploy and operate an SSIS project PowerPivot for Excel to report data.
Describe how Data Quality Services can PowerPivot for SharePoint Server Describe Analysis Services tabular data help you manage data quality. Power Query model projects.
Use Data Quality Services to cleanse your Power View Implement an Analysis Services tabular
data. Power Map data model.
Use Data Quality Services to match data. Power BI for Office 365 Use an Analysis Services tabular data Describe key Master Data Services Overview of Cloud Computing model.
concepts. Windows Azure Services for Data Use PowerPivot to create tabular data Implement a Master Data Services model. Introduction to Big Data models in Excel.
Use Master Data Services tools to manage Windows Azure HDInsight Share a PowerPivot workbooks in master data. Consuming HDInsight Results in Excel SharePoint Server.
Use Master Data Services tools to create a Obtaining Data from the Windows Azure Use Power Query to discover and import master data hub. Marketplace data from multiple data sources into Excel. Describe the key capabilities of Reporting Use Power View to create interactive data Services. Lab : Using SQL Server 2014 Reporting visualizations in Excel and SharePoint Install and configure Reporting Services in Services Server.
SharePoint Mode. line Use Power Map to create visualizations of Use data alerts to notify users of changes to Viewing SharePoint Mode Configuration geographic data.
report data. Authoring, Publishing, and Viewing a Use Power BI for Office 365 to create a Describe Analysis Services tabular data Report cloud-based collaborative solution for model projects. Creating and Managing Data Alerts self-service BI.
Implement an Analysis Services tabular data Describe key features and benefits of model. After completing this module, you will be cloud computing.
Use an Analysis Services tabular data able to: Describe Windows Azure service for data.
model. line Describe key features and benefits of
Use PowerPivot to create tabular data Describe the common workloads for SQL Windows Azure SQL Database. models in Excel. Server 2014. Implement security for Windows Azure Share a PowerPivot workbooks in Describe the SQL Server 2014 Editions SQL Database.
SharePoint Server. and Components. Implement and manage databases in Use Power Query to discover and import Install SQL Server 2014 Components. Windows Azure SQL Database. data from multiple data sources into Excel. Use the new features in SQL Server Describe considerations for using Virtual Use Power View to create interactive data Management Studio. Machines in Windows Azure.
visualizations in Excel and SharePoint Describe the enhancements to Create and configure Windows Azure
Server. Transact-SQL. virtual machines.
Use Power Map to create visualizations of Describe new and enhanced Create databases in Windows Azure geographic data. Transact-SQL functions. virtual machines.
Use Power BI for Office 365 to create a Describe the enhancements to Spatial Describe key features of big data. cloud-based collaborative solution for Data Support. Process big data with Windows Azure self-service BI. Explain how to store and query HDInsight.
Describe key features and benefits of cloud documents with SQL Server 2014. Consume big data processing results from computing. Use the Buffer Pool Extension to improve Windows Azure HDInsight in Microsoft Describe Windows Azure service for data. performance for read-heavy OLTP Excel.
Describe key features and benefits of workloads.
Windows Azure SQL Database. Use Columnstore Indexes to improve Module 16: Implementing Big Data Implement security for Windows Azure SQL performance in data warehouse query Solutions
Database. workloads. line
Implement and manage databases in Use memory-optimized tables to improve
Machines in Windows Azure. management views. you can use to build big data analytical Create and configure Windows Azure virtual Describe how to use PowerShell to solutions. In particular, the module focuses on machines. Manage SQL Server. Windows Azure HDInsight and the Windows Create databases in Windows Azure virtual Describe the security enhancements in Azure Marketplace as core elements of the machines. SQL Server 2014. Microsoft solution for big data.
Describe key features of big data. Explain how to use contained databases. line Process big data with Windows Azure Describe high availability features in SQL
HDInsight. Server 2014. Lessons
Consume big data processing results from Describe data recovery enhancements in line
Windows Azure HDInsight in Microsoft SQL Server 2014. The Buffer pool Extension Excel. Use the CDC Control task to perform Columnstore Indexes
incremental data extractions in an ETL Memory-Optimized Tables
Module 6: High Availability and Data solution. New and Enhanced Dynamic Management Recovery Enhancements Deploy and operate an SSIS project Views
line Describe how Data Quality Services can Using PowerShell to Manage SQL Server help you manage data quality. Security Management Enhancements This module describes enhancements to SQL Use Data Quality Services to cleanse Contained Databases
Server availability and data recovery features your data. Using the CDC Control Task for since SQL Server 2008. Use Data Quality Services to match data. Incremental Data Loads
line Describe key Master Data Services Deploying and Operating SSIS Packages concepts. Introduction to Data Quality
Implement a Master Data Services Using Data Quality Services to Cleanse
model. Data
Use Master Data Services tools to •Using Data Quality Services to Match manage master data. Data
Use Master Data Services tools to create Introduction to Master Data Services a master data hub. Implementing a Master Data Services Describe the key capabilities of Reporting Model
Services. Using the Master Data Services Add-in for Install and configure Reporting Services Excel
in SharePoint Mode. Reporting Services Overview Use data alerts to notify users of changes Reporting Services and Microsoft to report data. SharePoint Server
Describe Analysis Services tabular data Introduction to Data Alerts
model projects. Introduction to Analysis Services Tabular Implement an Analysis Services tabular Data Model Projects
data model. Creating a Tabular Model
Use an Analysis Services tabular data Using an Analysis Services Tabular Data model. Model in the Enterprise
Use PowerPivot to create tabular data PowerPivot for Excel
models in Excel. PowerPivot for SharePoint Server Share a PowerPivot workbooks in Power Query
SharePoint Server. Power View Use Power Query to discover and import Power Map
data from multiple data sources into Power BI for Office 365 Excel. Overview of Cloud Computing Use Power View to create interactive Windows Azure Services for Data data visualizations in Excel and Introduction to Big Data
SharePoint Server. Windows Azure HDInsight
Use Power Map to create visualizations Consuming HDInsight Results in Excel of geographic data. Obtaining Data from the Windows Azure Use Power BI for Office 365 to create a Marketplace
cloud-based collaborative solution for
self-service BI. Lab : Creating a Big Data Solution Describe key features and benefits of line
cloud computing. Provisioning an HDInsight Cluster Describe Windows Azure service for Processing Data with HDInsight data. Analyzing Big Data in Excel
Describe key features and benefits of Obtaining Data from the Windows Azure Windows Azure SQL Database. Marketplace
Implement security for Windows Azure
SQL Database. After completing this module, you will be Implement and manage databases in able to:
Windows Azure SQL Database. line
Create and configure Windows Azure Describe the SQL Server 2014 Editions virtual machines. and Components.
Create databases in Windows Azure Install SQL Server 2014 Components. virtual machines. Use the new features in SQL Server Describe key features of big data. Management Studio.
Process big data with Windows Azure Describe the enhancements to
HDInsight. Transact-SQL.
Consume big data processing results Describe new and enhanced from Windows Azure HDInsight in Transact-SQL functions.
Microsoft Excel. Describe the enhancements to Spatial Data Support.
Module 11: Implementing an Analysis Explain how to store and query documents Services Tabular Data Model with SQL Server 2014.
line Use the Buffer Pool Extension to improve performance for read-heavy OLTP This module describes Analysis Services workloads.
tabular data models and explains how to Use Columnstore Indexes to improve develop a tabular data model by using the performance in data warehouse query SQL Server Data Tools for BI add-in for workloads.
Visual Studio. Use memory-optimized tables to improve line performance for latch-bound workloads.
Describe new and enhanced dynamic
Lessons management views.
line Describe how to use PowerShell to The Buffer pool Extension Manage SQL Server.
Columnstore Indexes Describe the security enhancements in Memory-Optimized Tables SQL Server 2014.
New and Enhanced Dynamic Explain how to use contained databases. Management Views Describe high availability features in SQL Using PowerShell to Manage SQL Server Server 2014.
Security Management Enhancements Describe data recovery enhancements in Contained Databases SQL Server 2014.
Using the CDC Control Task for Use the CDC Control task to perform Incremental Data Loads incremental data extractions in an ETL Deploying and Operating SSIS Packages solution.
Introduction to Data Quality Deploy and operate an SSIS project Using Data Quality Services to Cleanse Describe how Data Quality Services can Data help you manage data quality.
•Using Data Quality Services to Match Use Data Quality Services to cleanse your
Data data.
Introduction to Master Data Services Use Data Quality Services to match data. Implementing a Master Data Services Describe key Master Data Services
Model concepts.
Using the Master Data Services Add-in Implement a Master Data Services model. for Excel Use Master Data Services tools to manage Reporting Services Overview master data.
Reporting Services and Microsoft Use Master Data Services tools to create a SharePoint Server master data hub.
Introduction to Data Alerts Describe the key capabilities of Reporting Introduction to Analysis Services Tabular Services.
Data Model Projects Install and configure Reporting Services in Creating a Tabular Model SharePoint Mode.
Using an Analysis Services Tabular Data Use data alerts to notify users of changes Model in the Enterprise to report data.
PowerPivot for Excel Describe Analysis Services tabular data PowerPivot for SharePoint Server model projects.
Power Query Implement an Analysis Services tabular
Power View data model.
Power Map Use an Analysis Services tabular data Power BI for Office 365 model.
Overview of Cloud Computing Use PowerPivot to create tabular data Windows Azure Services for Data models in Excel.
Introduction to Big Data Share a PowerPivot workbooks in Windows Azure HDInsight SharePoint Server.
Marketplace Use Power View to create interactive data visualizations in Excel and SharePoint Server.
Use Power Map to create visualizations of geographic data.
Use Power BI for Office 365 to create a cloud-based collaborative solution for self-service BI.
Describe key features and benefits of cloud computing.
Describe Windows Azure service for data. Describe key features and benefits of Windows Azure SQL Database. Implement security for Windows Azure SQL Database.
Implement and manage databases in Windows Azure SQL Database. Describe considerations for using Virtual Machines in Windows Azure.
Create and configure Windows Azure virtual machines.
Create databases in Windows Azure virtual machines.
Describe key features of big data. Process big data with Windows Azure HDInsight.
Consume big data processing results from Windows Azure HDInsight in Microsoft Excel.
Flere Informationer:
For yderligere informationer eller booking af kursus, kontakt os på tlf.nr.: 44 88 18 00
[email protected] www.globalknowledge.dk
