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
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
In-Memory Database Capabilities
- The Buffer pool Extension
- Columnstore Indexes
- Memory-Optimized Tables
- Lab : Using In-Memory Database Capabilities
Scripting SQL Server 2014
- New and Enhanced Dynamic Management Views
- Using PowerShell to Manage SQL Server
- Lab : Managing SQL Server with Scripts
Implementing Security in Microsoft SQL Server 2014
- Security Management Enhancements
- Contained Databases
- Lab : Implementing Security
High Availability and Data Recovery Enhancements
- AlwaysOn High Availability
- Enhancements to Data Recovery
- Lab : Using AlwaysOn Availability Groups
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
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
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
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
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
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
Introduction to Cloud Data Solutions
- Overview of Cloud Computing
- Microsoft Azure Services for Data
- Lab : Using Microsoft Azure
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
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
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