1) New and enhanced features in SQL Server 2012
2) Install SQL Server 2012
3) Use enhanced tools and PowerShell support to manage SQL Server 2012
4) Use enhanced Transact-SQL and storage capabilities to develop SQL Server 2012 databases
5) Use new and enhanced performance capabilities to optimize a SQL Server 2012 database
6) Use new availability and data recovery technologies to provide high availability
7) Use new and enhanced security capabilities in SQL Server 2012
8) New BI capabilities in SQL Server 2012
9) Use new and enhanced features in SQL Server Integration Services
10) Manage data quality by using SQL Server Data Quality Services
11) Use new and enhanced features of SQL Server Reporting Services
12) Create tabular data models with PowerPivot and DAX
13) Implement a tabular data model in SQL Server Analysis Services
14) Use Power View to create interactive data visualizations
15) Integrate Microsoft cloud technologies into a BI solution using SQL Azure
Database and BI professionals with experience using SQL Server 2008 R2
- 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
- SQL Server 2008 for Administratio
- Classroom Live Outline
- 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
- Classroom Live Labs
- 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
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
Follow-On Courses: None
Training Exclusives
This course comes with 12 months access to the following benefits:
Practice Labs
24x7 Mentoring
Indexed Class Recordings
Unlimited Retakes
Digital Courseware
* Terms and conditions may apply. Learn more about our Microsoft training exclusives by contacting training@dunnsolutions.com
Live Virtual:
Get engaging and impactful live, instructor-led training, regardless of your location.
Our Virtual Classroom Live online training format combines premium skills development technologies and our industry-leading instructors, content, exercises and peer collaboration to ensure that you get the highest quality professional development experience possible. Gain the skills and expertise that matter from the convenience of your home, work or wherever you have an Internet connection.
Engage with your instructor and fellow students via a learning platform and course material designed to ensure a stimulating and productive skills development experience.
Choose from sessions across a variety of time zones for training options that suit your schedule. Save time, money and effort without sacrificing learning quality by accessing our expert-led online training from the convenience of your home, office or anywhere with an Internet connection.
Attend from your PC, Mac or any iOS/Android tablet or smartphone. Connect with the class through your device audio or via toll-free phone number†, depending on available technologies and your interaction preferences.
Refresh your database and business intelligence skills to SQL Server 2012 from SQL Server 2008.
