Updating Your SQL Server Skills to Microsoft SQL Server 2014 (10977) H8B96S

Download (0)

Full text


HP Education Services course data sheet

Updating Your SQL Server Skills to

Microsoft SQL Server 2014 (10977)


Course Overview

In this course, you will learn how to use SQL Server 2014 product features and other Microsoft

data platform components that have been added since the release of SQL Server 2008.

This course incorporates materials from the Official Microsoft Learning Product 10977.

Special Note

Elements of this syllabus are subject to change.


This course is intended for:

Database and Business Intelligence (BI) professionals familiar with SQL Server 2008 and who want to update their skills to SQL Server 2014


Experience of building and managing database, data warehouse, and Business Intelligence (BI) solutions with SQL Server 2008

Familiarity with Windows Server 2012 operating system and networking Familiarity with Microsoft Excel 2013 and Microsoft SharePoint Server 2013

Course objectives

After completing this course, students will be able to: Key features and capabilities of SQL Server 2014

New and enhanced features to develop database in SQL Server 2014 In-memory database capabilities in SQL Server 2014

Manage SQL Server 2014 by using dynamic management views and PowerShell Implement security in SQL Server 2014

Implement high availability and data recovery techniques in SQL Server 2014

Price USD $2,500 Links to local schedules, pricing and registration US/Canada Course title

Updating Your Server Skills to Microsoft SQL Server (10977)

HP course # H8B96S

Category Microsoft SQL Server



SQL Server 2014 Integration Services, Data Quality Services, and Master Data Services

Manage SQL Server 2012 agent and jobs

Implement a tabular data model in SQL Server 2014 Analysis Services Implement a Self-Service BI solution with Microsoft Excel 2013 Key elements of cloud solutions for data

Implement a database in Windows Azure SQL Databases

Implement a SQL Server database in a Windows Azure virtual machine Implement a Big Data solution with Windows Azure HDInsight and the Windows Azure Marketplace

Course outline

1. Introduction to SQL Server 2014

Overview of SQL Server 2014

SQL Server 2014 Editions and Components Installing SQL Server 2014

Enhancements to SQL Server Management Studio

2. What's New in SQL Server Database Development

Transact-SQL Enhancements and Functions Enhancements to Spatial Data Support

Storing and Querying Documents with SQL Server 2014

3. In-Memory Database Capabilities

The Buffer Pool Extension

Columnstore Indexes and Memory-Optimized Tables

4. Scripting SQL Server 2014

Dynamic Management Views

Manage SQL Server using PowerShell

5. Implementing Security in Microsoft SQL Server 2014

Security Management Enhancements Contained Databases

6. High Availability and Data Recovery Enhancements

AlwaysOn High Availability Enhancements to Data Recovery

7. New and Enhanced Features in SQL Server Integration Services

Use CDC Control Task for Incremental Data Loads Deploy and Operate SSIS Packages

8. Data Quality Services

Introduction to Data Quality

Use Data Quality Services to Cleanse and Match Data

9. Master Data Services


10. SQL Server 2014 Reporting Services

Reporting Services Overview

Reporting Services and Microsoft SharePoint Server Introduction to Data Alerts

11. Implementing an Analysis Services Tabular Data Model

Introduction to Analysis Services Tabular Data Model Projects Creating a Tabular Model

Use an Analysis Services Tabular Data Model in the Enterprise

12. Self-Service Business Intelligence (BI) with Microsoft Excel

PowerPivot for Excel and SharePoint Server Power Query, Power View, and Power Map Power BI for Office 365

13. Introduction to Cloud Data Solutions

Overview of Cloud Computing Windows Azure Services for Data

14. Windows Azure SQL Database

Introduction to Windows Azure SQL Database Windows Azure SQL Database Security Implementing and Managing Databases

15. SQL Server in Windows Azure Virtual Machines

Introduction to Windows Azure Virtual Machines

Windows Azure Virtual Machine Connectivity and Security Creating Databases in a Windows Azure Virtual Machine

16. Implementing Big Data Solutions

Introduction to Big Data Windows Azure HDInsight

Consuming HDInsight Results in Excel

Obtaining Data from the Windows Azure Marketplace


Lab 1: Exploring SQL Server 2014

Reviewing Installed Components Use SQL Server Management Studio

Lab 2: Develop SQL Server 2014 Databases

Use Sequence Objects Use the THROW statement

Implement Paging and Query Documents

Lab 3: Use In-Memory Database Capabilities

Enable the Buffer Pool Extension

Create Columnstore Indexes and work with Memory-Optimized Tables

Lab 4: Manage SQL Server with Scripts



Lab 5: Implement Security

Implement User-Defined Server Roles and implement Contained Databases

Lab 6: Use AlwaysOn Availability Groups

Create and use an AlwaysOn Availability Group Observe Availability Group Failover Behavior

Lab 7: Use SQL Server Integration Services

Extract Modified Data

Deploy and Operate an SSIS Project

Lab 8A: Cleansing Data

Create a DQS Knowledge Base Use a DQS Project to Cleanse Data Use DQS in an SSIS Package

Lab 8B: Deduplicating Data

Create a Matching Policy and use DQS Project to Match Data

Lab 9: Implement Master Data Services

Create a Basic Model

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

Load Data into a Model, Enforce Business Rules, and Consume Master Data Services Data

Lab 10: Using SQL Server 2014 Reporting Services

View SharePoint Mode Configuration Authoring, Publishing, and Viewing a Report Create and Manage Data Alerts

Lab 11: Work with Analysis Services Tabular Data Model

Create an Analysis Services Tabular Data Model Project Configure Columns and Relationships

Use Custom DAX Expressions

Deploy an Analysis Services Tabular Data Model

Lab 12: Self-Service BI with Excel

Create a Data Model with PowerPivot

Import Data with Power Query and Visualize Data with Power View Visualize Geographic Data with Power Map

Lab 13: Use Windows Azure

Create a Windows Azure Storage Account Backup a Database to Windows Azure

Lab 14: Use Windows Azure SQL Database

Provision Windows Azure SQL Database and Configure Security Migrate a SQL Server Database to Windows Azure SQL Database

Lab 15: Use Windows Azure Virtual Machines

Create a Windows Azure Virtual Machine


© Copyright 2015 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice. The only warranties for HP products and services are set forth in the express warranty statements accompanying such products and services. Nothing herein should be construed as constituting an additional warranty. HP shall not be liable for technical or editorial errors or omissions contained herein.

Microsoft and Windows are U.S. registered trademarks of the Microsoft group of companies. H8B96S Ver A.00

c04749301 August 2015

Learn more at

hp.com/us/training/americas Lab 16: Create a Big Data Solution

Provision an HDInsight Cluster Process Data with HDInsight Analyze Big Data in Excel




Related subjects :