10337 Updating Your Microsoft SQL Server 2008 BI Skills to SQL Server 2008 R2

Course Categorization:: Microsoft,; Databases,

Course Provider:: New Horizons Computer Learning Centers

Learning Method:: Classroom Learning

Synopsis
What You'll Learn
Dates & Locations

This course focuses on the new features SQL Server 2008 R2 for BI specialists.

Lesson 1: SQL Server 2008 R2 for BI Professionals

Introduction to SQL Server 2008 R2
SQL Server 2008 R2 and SharePoint 2010
Database Server Provisioning by Using SQL Server SysPrep
Application Management by Using Data-Tier Applications
Managing Multiple Servers by Using Utility Control Points
Lab : Managing SQL Server 2008 R2

Lesson 2: Implementing Self-Service BI with PowerPivot

Introduction to PowerPivot
Power Pivot for Excel 2010
Data Analysis Expressions (DAX)
Power Pivot for SharePoint 2010
Lab : Implementing Self-Service BI with PowerPivot

Lesson 3: SQL Server 2008 R2 Reporting Services Tool and API Enhancements

Deploying and Managing Reporting Services
Reporting Services Authoring Tool Enhancements
Enabling Self-Service BI Through Item Re-Use
Developing Custom Reporting Services Solutions
Lab : Working with Reporting Services

Lesson 4: SQL Server 2008 R2 Report Authoring Enhancements

Overview of Report Authoring Enhancements
Visualizing Data
Visualizing Spatial Data with Maps
Lab : Authoring Reports

Lesson 5: Building Complex Event Processing Solutions with StreamInsight

Introduction to StreamInsight
StreamInsight Core Concepts
Developing a StreamInsight Solution
Lab : Building a StreamInsight Solution

Lesson 6: Master Data Services

Introduction to MDS
Key Concepts in Master Data Services
Importing and Browsing Data
Business Rules
Exporting Data to Subscribing Systems
Securing Master Data Services
Lab : Working with Master Data Services

Lesson 7: Enterprise Data Warehousing

SQL Server 2008 R2 Data Warehousing
Overview of Parallel Data Warehouse

Lesson 8: Introduction to SQL Azure

Overview of SQL Azure and Cloud Services
Using SQL Azure
Introduction to “Dallas”

Charleston, SC - June 25, 2012
Columbia, SC - June 25, 2012
Greenville, SC - June 25, 2012
Greensboro, NC - June 25, 2012
Charleston, WV - June 25, 2012
Urbandale, IA - June 25, 2012
Charleston, SC - September 4, 2012
Columbia, SC - September 4, 2012
Greenville, SC - September 4, 2012
Charleston, WV - September 4, 2012
Urbandale, IA - September 5, 2012
Charleston, SC - November 12, 2012
Columbia, SC - November 12, 2012
Greenville, SC - November 12, 2012
Charleston, WV - November 12, 2012
Urbandale, IA - November 19, 2012
Albany, NY - November 19, 2012

People Also Registered For

50429 SharePoint 2010 Business Intelligence

This course explores how to use SharePoint as your platform for Business Intelligence. Journey through the SharePoint Business Intelligence Center, Excel Services, Reporting Services, Analysis...

6236 Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

This course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the development tools to create reports, and how to use the...

SQL Querying - Level 2 Advanced Querying

In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process.

6231 Maintaining a Microsoft SQL Server 2008 R2 Database

This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 R2 product...

Relational Database Design A Practical Approach

In this course, students will design and create a relational database.

2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.

Unix Introduction Level 1

Students will learn the basic skills necessary to understand the structure of the UNIX operating system and to use the available utilities and commands to manage their personal file structures in...

Unix Introduction Level 2

Students will learn more advanced skills to understand the UNIX environment and features.

Keep Up with TechRepublic

Submit a Paper

Get your content listed in our directory!

Our directory is the largest library of vendor-supplied technical content on the Web. It’s also the first place IT decision makers turn to when researching technology solutions. Our members are already finding your competitors’ papers here - shouldn’t they find yours, too? It's FREE so click here and submit your white paper, case study, data sheet, research report, or other document today!

Submit Content