Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Updating your Database and Business Intelligence Skills to SQL Server 2012

Refresh your database and business intelligence skills to SQL Server 2012 from SQL Server 2008.

GK# 6425 Vendor# M40008, M40009

$2795 - $2995 CAD

Enroll Request Group Training

Course Overview

TOP

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

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP
  • 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

Outline

TOP
Viewing outline for:

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

Labs

TOP
Viewing labs for:

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

Prerequisites

TOP
  • 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

Who Should Attend

TOP

Database and BI professionals with experience using SQL Server 2008 R2

Training Exclusives

This course comes with 12 months access to the following benefits:

  • Practice Labs
  • 24x7 Mentoring
  • Indexed Class Recordings
  • Unlimited Retakes
  • Digital Courseware
Find out more
Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 5 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 5 day

Virtual Classroom Fit

Attend live, online training sessions for a total of 24 hours spread over four weeks.

Duration: 5 day

Request this course in a different delivery format.
Enroll