Course Details
Upgrade your database and business intelligence (BI) skills to Microsoft SQL Server 2012. In this course, existing SQL Server database professionals will gain the knowledge and skills to use new and enhanced capabilities in SQL Server 2012, including Database and Business Intelligence features.
This course incorporates material from the Official Microsoft Learning Products (OMLPs):
- 40008: Updating your Database Skills to Microsoft SQL Server 2012
- 40009: Updating your Business Intelligence Skills to Microsoft SQL Server 2012
Course Prerequisites
- Experience creating database solutions in SQL Server, including basic Transact-SQL programming
- Familiarity with data warehousing and BI solutions, including extract, transform, and load (ETL), data modeling, and reporting
Course Agenda
1: SQL Server 2012
- SQL Server 2012 Editions and Components
2: Installing SQL Server 2012
- Installation Options and Requirements
- Installing SQL Server
- Deploying SQL Server in a Private Cloud
3: Managing SQL Server 2012
- Enhancements to SQL Server Management Studio
- New and Enhanced Dynamic Management Views
- Using PowerShell to Manage SQL Server
4: Developing SQL Server 2012 Databases
- Transact-SQL Enhancements
- New and Enhanced Transact-SQL Functions
- Enhancements to Spatial Data Support
- Storing and Querying Documents
5: Performance and Tuning Enhancements
- Performance Optimization Tools
- Enhancements to Indexing
- Columnstore Index
6: High Availability and Data Recovery Enhancements
- AlwaysOn High Availability
- Enhancements to Data Recovery
7: Implementing Security in Microsoft SQL Server 2012
- Security Management Enhancements
- Contained Databases
8: SQL Server 2012 for Business Intelligence
- SQL Server 2012 for Enterprise Integration Management
- SQL Server 2012 for Data Warehousing
- SQL Server 2012 for Data Analysis and Reporting
9: New and Enhanced Features in SQL Server Integration Services
- Using the CDC Control Task for Incremental Data Loads
- Deploying and Operating SSIS Packages
10: Data Quality Services
- Data Quality
- Using Data Quality Services to Cleanse Data
- Using Data Quality Services to Match Data
11: SQL Server 2012 Reporting Services
- Reporting Services
- Reporting Services and Microsoft SharePoint Server
- Data Alerts
12: Creating Tabular Data Models with PowerPivot
- Tabular Data Models and PowerPivot Technologies
- Using PowerPivot
- Using DAX in a PowerPivot Data Model
13: Implementing an Analysis Services Tabular Data Model
- Analysis Services Tabular Data Model Projects
- Developing an Analysis Services Tabular Data Model
14: Creating Data Visualizations with Power View
- Power View
- Visualizing Data with Power View
15: Using Cloud Technologies in a BI Solution
- Cloud Data Sources
- SQL Azure
- SQL Azure Reporting Services
- Windows Azure Marketplace DataMarket