Module 1: Introduction to SQL Server 2014

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

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

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

Module 3: In-Memory Database Capabilities

• The Buffer pool Extension
• Columnstore Indexes
• Memory-Optimized Tables
• Lab: Using In-Memory Database Capabilities

Module 4: Scripting SQL Server 2014

• New and Enhanced Dynamic Management Views
• Using PowerShell to Manage SQL Server
• Lab: Managing SQL Server with Scripts

Module 5: Implementing Security in Microsoft SQL Server 2014

• Security Management Enhancements
• Contained Databases
• Lab: Implementing Security

Module 6: High Availability and Data Recovery Enhancements

• AlwaysOn High Availability
• Enhancements to Data Recovery
• Lab: Using AlwaysOn Availability Groups

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

• Using the CDC Control Task for Incremental Data Loads
• Deploying and Operating SSIS Packages
• Lab: Using SQL Server Integration Services

Module 8: Data Quality Services

• Introduction to Data Quality
• Using Data Quality Services to Cleanse Data
• Using Data Quality Services to Match Data
• Lab: Cleansing Data
• Lab: Deduplicating Data

Module 9: Master Data Services

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

Module 10: SQL Server 2014 Reporting Services

• Reporting Services Overview
• Reporting Services and Microsoft SharePoint Server
• Introduction to Data Alerts
• Lab: Using SQL Server 2014 Reporting Services

Module 11: Implementing an Analysis Services Tabular Data Model

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

Module 12: Self-Service BI with Microsoft Excel

• PowerPivot for Excel
• PowerPivot for SharePoint Server
• Power Query
• Power View
• Power Map
• Collaborative Analysis with Power BI for Office 365
• Lab: Self-Service BI with Excel

Module 13: Introduction to Cloud Data Solutions

• Overview of Cloud Computing
• Microsoft Azure Services for Data
• Lab: Using Microsoft Azure

Module 14: Microsoft Azure SQL Database

• Introduction to Microsoft Azure SQL Database
• Microsoft Azure SQL Database Security
• Implementing and Managing Databases
• Lab: Using Microsoft Azure SQL Database

Module 15: SQL Server in Microsoft Azure Virtual Machines

• Introduction to Microsoft Azure Virtual Machines
• Microsoft Azure Virtual Machine Connectivity and Security
• Creating Databases in a Microsoft Azure Virtual Machine
• Lab: Using Microsoft Azure Virtual Machines

Module 16: Implementing Big Data Solutions

• Introduction to Big Data
• Microsoft Azure HDInsight
• Consuming HDInsight Results in Excel
• Obtaining Data from the Microsoft Azure Marketplace
• Lab: Creating a Big Data Solution