Microsoft SQL Server 2005 Certification Boot Camp 70-445

• Class Scheduling and registration
• Overview
• Course Price
• Exam
• Microsoft Certification
• Textbook
• Instructors
• Course Outline

Class Scheduling

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

Overview

Drawing on decades of practical experience, MHS Enterprises 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 an MHS 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-445 exam.

Course Price

Regular course price: $6000.
Price for TCU's Extended Education Program: $300.

Exam

70-445 exam

Microsoft Certification

Microsoft Certified IT Specialist - Business Intelligence

Textbook

MCTS Self-Paced Training Kit (Exam 70-445): Microsoft SQL Server 2005 Business Intelligence Implementation and Maintenance (Pro - Certification)

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

• Module 1 - Installation
  • Component Installation
  • Updates and Advanced Installation
• Module 2 - Configuration
  • SSRS Configuration
  • SSAS Configuration
• Module 3 - Migration
  • SSAS upgrades
  • Migrating DTS Packages to SSIS
• Module 4 - Designing SSIS Packages
  • Package Creation
  • Data Sources and Connections
  • Control Flow Objects
  • Data Flow Tasks and Transformations
• Module 5 - SSIS Package Debugging and Error Handling
  • Transactions and Checkpoints
  • Package Error Handling
  • Data Flow Errors and Exceptions
• Module 6 - Designing SSAS Cubes
  • Data Sources
  • Creating and Modifying Cubes
  • Dimensions
  • Hierarchies and Dimension Relationships
• Module 7 - SSAS Cube Extension
  • Measures and Groups
  • KPIs
  • Actions, Translations, and Perspectives
  • MDX
• Module 8 - SSAS Storage, Partitions, and Aggregations
  • Measure Group Partitions and Storage
  • Partition Aggregations
• Module 9 - SSAS Data Mining Models
  • Data Preparation
  • Data Mining Structures
  • Data Mining Models
  • Association, Sequence, and Forecasting
  • Cube Sources
  • Data Mining Algorithms
• Module 10 - Developing SSRS Reports
  • Projects
  • Report Objects
  • Advanced Properties
  • Datasets
  • Dataset Filters and Groups
• Module 11 - Formatting and Extending SSRS Reports
  • Parameters
  • Expressions
  • Report Builder Models
• Module 12 - Deploying and Configuring SSIS Packages
  • Package Configurations
  • Package Deployment
• Module 13 - Deploying and Processing SSAS Objects
  • Deployment
  • Processing SSAS Objects
  • Processing Data Mining Objects
• Module 14 - Deploying and Scheduling SSRS Reports
  • Deployment
  • Schedules and Subscriptions
  • Data Driven Subscriptions
  • Rendering Formats
• Module 15 - SSIS Package Security and Execution
  • Roles and Protection Levels
  • Command Line Execution
  • Scheduling
• Module 16 - SSAS Cube Security and Administration
  • User Security Models
  • SSAS Backups
  • Performance Monitoring
• Module 17 - Securing and Querying SSAS Data Mining Models
  • Testing Model Accuracy
  • DMX
  • Securing Mining Models
• Module 18 - SSRS Report Security and Adminstration
  • Roles
  • Assigning Permissions and Site Security
  • Execution Properties and Linked Reports
  • Data Source Credentials