Updating your Database and Business Intelligence Skills to SQL Server 2012

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

• New and enhanced features in SQL Server 2012
• Install SQL Server 2012
• Use enhanced tools and PowerShell support to manage SQL Server 2012
• Use enhanced Transact-SQL and storage capabilities to develop SQL Server 2012 databases
• Use new and enhanced performance capabilities to optimize a SQL Server 2012 database
• Use new availability and data recovery technologies to provide high availability
• Use new and enhanced security capabilities in SQL Server 2012
• New BI capabilities in SQL Server 2012
• Use new and enhanced features in SQL Server Integration Services
• Manage data quality by using SQL Server Data Quality Services
• Use new and enhanced features of SQL Server Reporting Services
• Create tabular data models with PowerPivot and DAX
• Implement a tabular data model in SQL Server Analysis Services
• Use Power View to create interactive data visualizations
• Integrate Microsoft cloud technologies into a BI solution using SQL Azure

Lab 1: Install SQL Server 2012 and Use a Data-Tier Application

Lab 2: Manage SQL Server

Lab 3: Develop SQL Server Databases

Lab 4: Optimize SQL Server Performance

Lab 5: Use AlwaysOn Availability Groups

Lab 6: Implement Security

Lab 7: Use SQL Server 2012 Integration Services

Lab 8: Cleanse Data and Deduplicate Data

Lab 9: Use SQL Server 2012 Reporting Services

Lab 10: Use PowerPivot for Excel and Create Calculated Columns and Measures

Lab 11: Work with an Analysis Services Tabular Data Model

Lab 12: Create Data Visualizations with Power View

Lab 13: Use Cloud Data in a BI Solution

• 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

Database and BI professionals with experience using SQL Server 2008 R2