Microsoft 70-448: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
This course covers the following topics to prepare students for the 70-448 Microsoft SQL Server 2008 Business Intelligence Development and Maintnance exam: how to implement SSIS, SSAS, and SSRS solutions, as well as how to configure, deploy and maintain SSIS, SSAS, and SSRS solutions.
Course Modules
The Microsoft 70-448: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance course is organized into the following modules.
Module 1: SSIS Packages
- Introduction
- Creating SSIS Packages
- Creating A New Package Lab
- Data Sources Lab
- Connections Lab
- Control Flow
- Creating And Editing Control Flow Lab
- Data Flow
- Data Flow Transformations
- Data Flow Lab
Module 2: Debugging and Error Handling in SSIS
- Debugging And Error Handling in SSIS-Part1
- Enable Transactions And Observe Trans Rollback Lab
- Set Checkpoints In A Package Lab
- Debugging And Error Handling in SSIS-Part2
- Setting Up Constraints Lab
- Turn On Logging Lab
- Debugging And Error Handling in SSIS-Part3
- Identifying Data Flow Errors Lab
Module 3: Deploying and Configuring SSIS Packages
- Lesson1-Part1 Deploying
- Lesson1-Part2 Sharing Ordering And Configuring
- Create An XML Configuration Lab
- Create A SQL Server Configuration Lab
- Use A Property Expression To Update A Connection Lab
- Deploying An SSIS Package
- Create And Deploy An Installer Kit Lab
Module 4: Securing and Executing SSIS Packages; Service Administration
- Lesson1-Part1 Securing And Executing SSIS Packages
- Lesson1-Part2 SSIS Package Security
- Turn On Package Encryption Lab
- Change Security Roles Lab
- Lesson2 Executing And Administration
- Create And Execute A Command-Line Statement Lab
- Execute A Package Through SQL Server Agent Lab
Module 6: Extending SSAS Cubes
- Lesson1 Extending SSAS Cubes-Part1
- Define Attribute Relationships Lab
- Define User Hierarchy Lab
- Lesson2 Extending SSAS Cube-Part3
- Implement The Reseller Sales KPI Lab
- Lesson3 Extending SSAS Cube-Part3
- Turn On Proactive Caching Lab
Module 7: Extending SSAS Cubes
- Lesson1-Part1 SSAS Storage Processing And Deployment
- Lesson1-Part2 Aggregating And Enabling Proactive Caching
- Turning On Proactive Caching Lab
- Lesson2 SSAS Deployment
- Deploy Database With Deployment Wizard Lab
- Lesson3 Processing
- Processing Scripts Using SQL Server Agent Lab
Module 8: Securing and Administering SSAS
- Lesson1 SSAS Security
- Create A Role And Set Security Lab
- Lesson2 Backing Up SSAS
- Backing Up And Maintain Management Studio Lab
- Lesson3 Managing SSAS Turning And Logging
- Turning On Query Logging Lab
- Lesson4 SSAS Administering
- Turn On And Use SQL Server Profiler Lab
- Monitor SSAS Performance Lab
Module 10: Developing SSAS Reports
- Lesson1 Understanding SSRS Reports
- Creating Reports Lab
- Lesson2 Creating A New Report Database
- Generate More Reports Lab
- Lesson3 Advanced Report Object Properties-Part1
- Lesson4 Advanced Report Object Properties-Part2
Module 11: Extending and Deploying SSRS Reports
- Lesson1 SSRS Report Parameters
- Create A Report Without Using Wizard Lab
- Lesson2 Extending SSRS Reports
- Lesson3 Deploying SSRS Reports
Module 12: Scheduling Deployed Reports and Data Sources
- Lesson1 Scheduling Reports And Subscriptions
- Creating A New Role For SSRS Lab
- Lesson2 SSRS And Data Sources
- Set Up Shared Schedule Lab
Module 13: Configuring And Administering the SSRS Server
- Installing And Configuring SSRS Server
- Changing Settings In Configuration Manager Lab
- Lesson2 Administering The SSES Server And Command-Line Utilities
- Backing Up And Restoring Encryption Keys Lab
- Conclusion