Our E-learning curriculum is specifically designed with the busy professional in mind. All of our programs are produced using advanced learning concepts that encompass learning techniques that are designed for adult learning. E- learning is very popular today for a very good reason – It Works! People everywhere are discovering that they can fulfill their learning objectives conveniently (at their own pace, on their own time) and affordably (online classes start at a fraction of the cost of traditional classroom training).
Our easy-to-use delivery format allows you to concentrate on the lesson at hand and not how to run the delivery software – saving you time and frustration. Our comprehensive course materials are delivered in an easy-to- understand format – allowing you to get the most out of your time online.
The Microsoft Certified IT Professional (MCITP) credential validates that an individual has the comprehensive set of skills necessary to perform a particular job role, such as database administrator or enterprise messaging administrator. MCITP certifications build on the technical proficiency measured in the Microsoft Certified Technology Specialist (MCTS) certifications. Therefore, you will earn one or more MCTS certifications on your way to earning an MCITP credential.
This certification is designed for individuals working with SQL Server 2008 and working with the business intelligence technologies, including Reporting Services, Analysis Services, and Integration Services
The MCITP for Database Administrator requires the following two exams:
Exam 70-448: TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
AND
Exam 70-452: PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008
AUDIENCE PROFILE:
Candidates for this certification are responsible for creating business intelligence (BI) solutions by using Microsoft SQL Server 2008 for their organizations. Candidates typically work with the full suite of BI technologies in SQL Server 2008, including Reporting Services, Analysis Services, and Integration Services. The qualified candidate for this exam typically has:
- One to two years of experience working with the Microsoft .NET Framework
- Two to three years of experience using SQL Server 2005 BI components
- Six months to one year of experience using SQL Server 2008
- Experience using the SQL Server 2008 Business Intelligence Development Studio (BIDS)
- Experience using Microsoft SQL Server Management Studio (SSMS)
- Knowledge of relational and multi-dimensional database schemas
- Experience creating and deploying a cube in SQL Server Analysis Services (SSAS)
- Experience creating and deploying a data mining model in SSAS
- Experience writing relational and multi-dimensional database queries
- Experience creating and deploying SQL Server Reporting Services (SSRS) reports
- Experience authoring and deploying SQL Server Integration Services (SSIS) packages
- Experience debugging, monitoring, and troubleshooting BI solutions
COURSE FEATURES:
- Instructor led training by the industry’s finest experts delivered via streaming video online or DVD
- Software demonstrations where the instructor shows you how to perform a task onscreen.
- Interactive multimedia presentations
- Easy to navigate controls
- Course bookmarking which allows you to resume training where you left off the last session.
- Hands-on activities and labs
- Review Questions
- Practice Exam Simulators with three different training and testing modes. These simulators can also be used for pre- and post-testing.
- Free technology upgrades for one year
- Educational support
COURSE OUTLINE
Microsoft Exam 70-448
Course Overview
Implementing Business Solutions
BI Concepts
Designing an OLAP System
Designing an Architecture
Module Review
Creating SSIS Packages
Creating Packages
Using Control Flow
Implementing Constraints
Module Review
Data Flows
Sources and Destination
Transformations
Transactions
Debugging
Module Review
Package Management
Event Handlers and Logging
Working with Code
Module Review
Deploying SSIS Packages
Deploying Packages
Securing Packages
Executing Packages
Module Review
Implementing Cubes
Data Sources and Data Source Views
Creating Cubes
Configuring Dimensions
Setting Up a Cube
Module Review
Configuring Cubes and Measures
Configuring Measures
MDX
Adding Functionality
Module Review
SSA Solutions
Configuring Security
Configuring Storage
Processing Cubes
Deploying Cubes
Module Review
Data Mining
Data Mining Basics
Building a Data Mining Model
Module Review
Creating Reports
Creating Basic Reports
Interactive Reports
Coding Reports
Module Review
Managing a Report Server
Configuring Reporting Services
Deploying Reports
Controlling Report Execution
Using Subscriptions
Securing Reporting Services
Module Review
Implementing the Report Builder
Report Models
Report Builder
Module Review
Course Review
Exam Preparation
Microsoft Exam 70-452: MCITP: Business Intelligence Developer 2008 Certification Training Course Curriculum:
Instructor Introduction
Course Overview
Module 1: Designing a BI Solution
Module Overview
Data Management
Obtaining Data
BI Clients
Managing Development and Upgrades
Module Review
Module 2: Designing Integration Services
Module Overview
Control Flow
Data Flow
Transactions
Designing Custom Code
Package Design
Server Options
Module Review
Module 3: Designing Analysis Services
Module Overview
Cube Creation
Designing Dimensions and Measures
Enhancing Cubes
Performance
Cube Maintenance
Module Review
Module 4: Designing Data Mining Models
Module Overview
Model Design
Accessing Data and Setting Up a Mining Model
Module Review
Module 5: Designing report Services
Module Overview
Designing Reports
Designing a Report and Setting Up a Template
Designing Servers
Configuring Server Based Reports
Configuring Security
Implementing Report Builder
Module Review
Course Review
Exam Preparation
To order contact Specialized Solutions at:
Specialized Solutions
Corporate Training Division
3727 Jonlen Drive
Cincinnati, OH 45227
Toll Free – 1-877-291-9797
Direct – 513-878-1116