Post Description

release date 12-01-10

Are you ready to design and plan database business solutions for your company? SQL Server 2008 offers database managers lots of built in controls and plenty of great opportunity to enhance their reputations.
In this CBT Nuggets video series you'll learn to plan the design and implementation of your SQL Server 2008 SSIS, SSAS and SSRS projects.

This training maps to Microsoft exam 70-452. After watching this series you'll be fully prepared to take the exam and earn Microsoft PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008
Published certification. It's also your final towards earning SQL Server 2008 Business Intelligence MCITP Certification.

Exam-Pack 70-452: Microsoft SQL Server 2008 includes to following:


SSRS Architecture Overview

SSRS & .NET

SSRS Data Sets & Filters

SSRS Templates, RDL & Advanced Reports

SSRS Deployment & Migration (free video!) video

Scaling SQL Server 2008

SQL Server 2008 Performance

Aggregations & Partitions

Data Mining Design

SQL Server 2008 Advanced Data Mining

SQL Server 2008 Sharepoint Integration

SQL Server 2008 Visualization Tools

SQL Server 2008 Auditing

SSAS -- Moving Packages

SSAS International Considerations
Here's what you'll learn in each video of the Exam-Pack 70-452: Microsoft PRO SQL Server 2008 series:

Video 1 - "SSRS Architecture Overview" - SSRS architecture overview, simple report, SSRS drill-through reports, SSRS drill-down reports, SSRS sub-reports, SSRS subscriptions, SSRS data-driven subscriptions
Video 2 - "SSRS & .NET" - SSRS .NET integration, SSRS web services, SSRS SOAP API, SSRS code-behind, SSRS URL access

Video 3 - "SSRS Data Sets & Filters" - SSRS data sources, SSRS filters, SSRS query parameters, SSAS data source, SSAS filter, SSRS procedure data source

Video 4 - "SSRS Templates, RDL & Advanced Reports" - SSRS templates, generating RDL, SSRS matrix reports, SSRS cross-tab reports, SSRS third-party controls

Video 5 - "SSRS Deployment & Migration" - SSRS deployment scenarios, automating deployment, configuring SSRS deployment

Video 6 - "Scaling SQL Server 2008" - SQL Server editions, SSRS scale-out deployment, scaling SSIS, scaling SSAS

Video 7 - "SQL Server 2008 Performance" - SQL Server 2008 performance, resource governor, performance counters, data management warehouse

Video 8 - "Aggregations & Partitions" - SSAS aggregations, partitions, attribute hierarchies, dimension design

Video 9 - "Data Mining Design" - SSAS data mining, staging data, mining algorithms, Microsoft Excel data mining add-on

Video 10 - "SQL Server 2008 Advanced Data Mining" - SSAS refining testing model, SSAS DMX queries 

Video 11 - "SQL Server 2008 SharePoint Integration" - SSRS SharePoint integration, reporting services SharePoint integration mode, deploying reports to SharePoint

Video 12 - "SQL Server 2008 Visualization Tools" - Integrating SQL Server and SharePoint, SharePoint reports.

Video 13 - "SQL Server 2008 Auditing" - benefits of SQL Server auditing, Setting up SQL Server auditing, auditing objects, database audit specifications, server audit specifications

Video 14 - "SSAS -- Moving Packages" - SSAS Deployment, SSAS security, SSAS scheduling, dtexec

Video 15 - "SSAS International Considerations" - SSAS international considerations, SSAS translations, SSAS currencies