> > > 10977 Detailed outline

Upgrading Your SQL Server Skills to Microsoft SQL Server 2014 (10977)

Course Description Kurs tarihleri Course Outline

Detailed Course Outline

Module 1: Introduction to SQL Server 2014

Lessons

  • Overview of SQL Server 2014
  • SQL Server 2014 Editions and Components
  • Installing SQL Server 2014
  • Enhancements to SQL Server Management Studio

Lab : Exploring SQL Server 2014

  • Reviewing Installed Components
  • Using SQL Server Management Studio

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

Lessons

  • Transact-SQL Enhancements
  • New and Enhanced Transact-SQL Functions
  • Enhancements to Spatial Data Support
  • Storing and Querying Documents with SQL Server 2014

Lab : Developing SQL Server 2014 Databases

  • Using Sequence Objects
  • Using the THROW statement
  • Implementing Paging
  • Querying Documents

Module 3: In-Memory Database Capabilities

Lessons

  • The Buffer pool Extension
  • Columnstore Indexes
  • Memory-Optimized Tables

Lab : Using In-Memory Database Capabilities

  • Enabling the Buffer Pool Extension
  • Creating Columnstore Indexes
  • Working with Memory-Optimized Tables

Module 4: Scripting SQL Server 2014

Lessons

  • New and Enhanced Dynamic Management Views
  • Using PowerShell to Manage SQL Server

Lab : Managing SQL Server with Scripts

  • Using Dynamic Management Views
  • Using PowerShell

Module 5: Implementing Security in Microsoft SQL Server 2014

Lessons

  • Security Management Enhancements
  • Contained Databases

Lab : Implementing Security

  • Implementing User-Defines Server Roles
  • Implementing Contained Databases

Module 6: High Availability and Data Recovery Enhancements

Lessons

  • AlwaysOn High Availability
  • Enhancements to Data Recovery

Lab : Using AlwaysOn Availability Groups

  • Creating an AlwaysOn Availability Group
  • Using an AlwaysOn Availability Group
  • Observing Availability Group Failover Behavior

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

Lessons

  • Using the CDC Control Task for Incremental Data Loads
  • Deploying and Operating SSIS Packages

Lab : Using SQL Server Integration Services

  • Extracting Modified Data
  • Deploying and Operating an SSIS Project

Module 8: Data Quality Services

Lessons

  • Introduction to Data Quality
  • Using Data Quality Services to Cleanse Data
  • Using Data Quality Services to Match Data

Lab : Cleansing Data

  • Creating a DQS Knowledge Base
  • Using a DQS Project to Cleanse Data
  • Using DQS in an SSIS Package

Lab : Deduplicating Data

  • Creating a Matching Policy
  • Using a DQS Project to Match Data

Module 9: Master Data Services

Lessons

  • Introduction to Master Data Services
  • Implementing a Master Data Services Model
  • Using the Master Data Services Add-in for Excel

Lab : Implementing Master Data Services

  • Creating a Basic Model
  • Editing a model by Using the Master Data Services Add-in for Excel
  • Loading Data into a Model
  • Enforcing Business Rules
  • Consuming Master Data Services Data

Module 10: SQL Server 2014 Reporting Services

Lessons

  • Reporting Services Overview
  • Reporting Services and Microsoft SharePoint Server
  • Introduction to Data Alerts

Lab : Using SQL Server 2014 Reporting Services

  • Viewing SharePoint Mode Configuration
  • Authoring, Publishing, and Viewing a Report
  • Creating and Managing Data Alerts

Module 11: Implementing an Analysis Services Tabular Data Model

Lessons

  • Introduction to Analysis Services Tabular Data Model Projects
  • Creating a Tabular Model
  • Using an Analysis Services Tabular Data Model in the Enterprise

Lab : Working with an Analysis Services Tabular Data Model

  • Creating an Analysis Services Tabular Data Model Project
  • Configuring Columns and Relationships
  • Using Custom DAX Expressions
  • Deploying an Analysis Services Tabular Data Model

Module 12: Self-Service BI with Microsoft Excel

Lessons

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

Lab : Self-Service BI with Excel

  • Creating a Data Model with PowerPivot
  • Importing Data with Power Query
  • Visualizing Data with Power View
  • Visualizing Geographic Data with Power Map

Module 13: Introduction to Cloud Data Solutions

Lessons

  • Overview of Cloud Computing
  • Windows Azure Services for Data

Lab : Using Windows Azure

  • Creating a Windows Azure Storage Account
  • Backing Up a Database to Windows Azure

Module 14: Windows Azure SQL Database

Lessons

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

Lab : Using Windows Azure SQL Database

  • Provisioning Windows Azure SQL Database
  • Configuring Windows Azure SQL Database Security
  • Migrating a SQL Server Database to Windows Azure SQL Database

Module 15: SQL Server in Windows Azure Virtual Machines

Lessons

  • Introduction to Windows Azure Virtual Machines
  • Windows Azure Virtual Machine Connectivity and Security
  • Creating Databases in a Windows Azure Virtual Machine

Lab : Using Windows Azure Virtual Machines

  • Creating a Windows Azure Virtual Machine
  • Configuring Virtual Machine Security and Connectivity
  • Creating Databases on a Virtual Machine

Module 16: Implementing Big Data Solutions

Lessons

  • Introduction to Big Data
  • Windows Azure HDInsight
  • Consuming HDInsight Results in Excel
  • Obtaining Data from the Windows Azure Marketplace

Lab : Creating a Big Data Solution

  • Provisioning an HDInsight Cluster
  • Processing Data with HDInsight
  • Analyzing Big Data in Excel
  • Obtaining Data from the Windows Azure Marketplace
 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!