70-446 Designing a Business Intelligence Infrastructure by Using Microsoft® SQL Server™ 2005

 

70-446 Designing a Business Intelligence Infrastructure by Using Microsoft® SQL Server™ 2005

Sa: 9am – 6 pm / Sun 1 – 5pm

TCU: Sid Richardson – Lecture Hall 4

4/12/2008 – 4/26/2008

 

 

Microsoft SQL Server 2005 Certification Boot Camp 70-446

 

Class Scheduling

Register for this course: TCU’s Extended Education Program.

Overview

Drawing on decades of practical experience, Champion Valley Software courses are a leap forward in content creation and delivery. Each Mentor teaching a course brings years of past and ongoing practical experience on the subject into the classroom to provide a unique perspective on the content delivered. Based on that practical experience, each mentor is equipped to answer any question which should arise and ensure that each delegate attending the class will leave with skills that can be applied immediately in their environment. Only the best content available coupled with the best instructors possible and utilizing the most current knowledge make it into a Champion Valley Course course.

Certification Boot Camps cover the subject matter for an exam, however, they are not taught directly to the exam. All of the other test prepartion courses focus on students memorizing large amounts of material for the sole purpose of taking a particular exam. Once the exam is completed, most of the knowledge memorized is either forgotten or not useful in the IT world. These courses are designed to teach the subject matter while not teaching specifically to an exam. At the conclusion of the training, attendees come away with a large volume of knowledge which can be immediately applied to their jobs. If a student decides to subsequently take an exam, they are prepared for the material, but first and foremost, they are prepared for the demands of a job working with SQL Server.

This course covers the entire subject matter encompassed by the 70-446 exam.

Course Price

Regular course price: $6000.

Price for TCU’s Extended Education Program: $300.

Exam

70-446 exam

Microsoft Certification

Microsoft Certified IT Professional – Business Intelligence Developer

Textbook

Microsoft SQL Server(TM) 2005 Analysis Services Step by Step (Step by Step (Microsoft))

Microsoft® SQL Server(TM) 2005 Reporting Services Step by Step (Step by Step (Microsoft))

Microsoft SQL Server(TM) 2005 Integration Services Step by Step

Instructors

The primary author and primary instructor of this course, Michael Hotek, brings over a decade and a half of SQL Server experience in some of the largest and most complicated environments in the world. Mike is an accomplished speaker and trainer having delivered over 200 sessions across dozens of training events spanning more than 8 years with more than 2000 people having attended training from him. Mike is certified in both SQL Server 2005 as well as being a Microsoft Certified Trainer.

Course Outline

  • Analysis Services
    • Module 1 – Business Intelligence and Data Warehousing
      • Business Intelligence
      • Facts and Dimensions
    • Module 2 – OLAP Principles
      • OLAP Principles
      • SSAS Principles
    • Module 3 – Building a Cube
      • Analyzing Requirements
      • Building a Cube
      • Schemas
      • Processing and Browsing
    • Module 4 – Dimensions
      • Standard Dimensions
      • Time Dimensions
      • Parent-Child Dimensions
    • Module 5 – Measure Groups and Measures
      • Adding Measure Groups
      • Aggegating
      • Distinct Counts
      • Calculations
    • Module 6 – Finance Measure Group
      • Unary operators
      • Nonadditive Dimensions
    • Module 7 – Aggregations and Hierarchies
      • Desiging Aggregations
      • Building Hierachies
      • Optimization
    • Module 8 – MDX
      • Tuples
      • Querying
      • Custom Members
      • MDX scripts
      • KPIs
    • Module 9 – Special Features
      • Dimension Relationship
      • Currency Conversion
      • Localization
      • Folders and Perspectives
    • Module 10 – Cube Interaction
      • Actions
      • Writeback
    • Module 11 – Security
      • Roles
      • Dimension Security
      • Cell Security
      • Administration Security
    • Module 12 – Partitions and Processing
      • VLDBs
      • Storage
      • OLAP Processing
      • Monitoring Activity
    • Module 13 – Deployment
      • Deployment Options
      • XMLA
      • Automating Processing
      • Scheduling
      • Disaster Recovery
  • Reporting Services
    • Module 1 – Overview
      • Scenarios
      • Lifecycle
      • Components
    • Module 2 – Installation
      • Preparation
      • Deployment Considerations
      • Component Installation
    • Module 3 – Building a Report
      • Report Authoring
      • Report Managment
      • Report Access
    • Module 4 – Basic Reports
      • Report Definition File
      • Report Designer
      • Structure
      • Formatting
    • Module 5 – Expressions
      • Basic Calculations
      • Aggregations
      • Conditional Formatting
    • Module 6 – Data Organization
      • Data Regions
      • Matrix
      • Charts
      • Lists
    • Module 7 – Advanced Reports
      • Parameters
      • Interactive Features
      • Hierarchies
    • Module 8 – Building Report Models
      • Creating a Report Model
      • Modifying a Report Model
      • Managing Report Models
    • Module 9 – Content Management
      • Publishing
      • Organizing Content
      • Report Properties
      • Report Execution
    • Module 10 – Security
      • Report Server Security
      • Data Security
    • Module 11 – Managing Server Components
      • Configuring Reporting Services
      • Managing the Report Server
      • Reporting Services Databases
    • Module 12 – Accessing Reports
      • Finding and Viewing Reports
      • Saving Reports
      • Report Snapshots
    • Module 13 – Rendering Reports
      • MHTML
      • Document Management
      • Data Exchange
    • Module 14 – Subscriptions
      • Standard Subscriptions
      • Data-Driven Subscriptions
      • Managing Subscriptions
    • Module 15 – Report Builder
      • Building Basic Reports
      • Enhancing Reports
    • Module 16 – Custom Reporting
      • Custom Code
      • Data Processing Extensions
      • Report Definition Language – RDL
    • Module 17 – Programming Management
      • Web Services
      • Custom Applications
      • WMI
    • Module 18 – Custom Reporting Tools
      • URLs
      • Web Services
  • Integration Services
    • Module 1 – Introduction
      • Components
      • Process Control
      • DTS Migration
    • Module 2 – Building a Package
      • Business Intelligence Development Studio
      • Import Export Wizard
      • Package Elements
      • Testing
    • Module 3 – Extracting and Loading Data
      • Connection Managers
      • Data Sources
      • Data Source Views
    • Module 4 – Data Flow Transformations
      • Data Flow
      • Transformations
      • Expressions
      • Error Output
    • Module 5 – Control Flow
      • Components
      • Containers
      • Constraints
    • Module 6 – Scripting
      • Creating Scripts
      • Script Component
      • ActiveX Scripts
    • Module 7 – Debugging
      • Control Flow
      • Data Flow
      • Script Tasks
    • Module 8 – Package Execution
      • Package Configurations
      • XML Configuration File
      • Multiple Configuration Files
      • Configuration Order
      • Execution Options
      • Package Logging
    • Module 9 – Error Handling
      • Error Detection
      • Event Handlers
      • Transactions
      • Checkpoints
    • Module 10 – Security and Deployment
      • Deployment Utility
      • Package Security
      • Roles
      • Deployment Options
      • Configurations
    • Module 11 – Optimizing Packages
      • Memory Buffers
      • Execution Trees
      • Synchronous and Asynchronous Processing
      • Data Blocking
      • Non-blocking Transformations
      • Buffer Settings
      • Parallelism
      • Data Sources
      • Performance Management
      • Iterative Design
    • Module 12 – Data Warehouse Concepts
      • Objectives
      • Characteristics
      • Fundamentals
      • Data Warehouse Design
      • Data Warehouse Schema
    • Module 13 – Populating Data Warehouses
      • Staging
      • Managing Dimensions
      • Managing Fact Tables
    • Module 14 – General Principles
      • Package Design

 

 

Tags »

Author:
Date: Saturday, 16. February 2008 3:25
Trackback: Trackback-URL Category: Training

Feed for the post RSS 2.0 Comment this post

Submit comment