Course Modules
The Microsoft 70-448: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance course is organized into the following modules.
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 Transformations and Lab
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
3: Deploying and Configuring SSIS Packages
- Deploying
- 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
4: Securing and Executing SSIS Packages; Service Administration
- Securing And Executing SSIS Packages
- SSIS Package Security
- Turn On Package Encryption Lab
- Change Security Roles Lab
- Executing And Administration
- Create And Execute A Command-Line Statement Lab
- Execute A Package Through SQL Server Agent Lab
6: Extending SSAS Cubes
- Extending SSAS Cubes-Part1
- Define Attribute Relationships Lab
- Define User Hierarchy Lab
- Extending SSAS Cube-Part3
- Implement The Reseller Sales KPI Lab
- Turn On Proactive Caching Lab
7: Extending SSAS Cubes
- SSAS Storage Processing And Deployment
- Aggregating And Enabling Proactive Caching
- Turning On Proactive Caching Lab
- SSAS Deployment
- Deploy Database With Deployment Wizard Lab
- Processing
- Processing Scripts Using SQL Server Agent Lab
8: Securing and Administering SSAS
- SSAS Security
- Create A Role And Set Security Lab
- Backing Up SSAS
- Backing Up And Maintain Management Studio Lab
- Managing SSAS Turning And Logging
- Turning On Query Logging Lab
- SSAS Administering
- Turn On And Use SQL Server Profiler Lab
- Monitor SSAS Performance Lab
10: Developing SSAS Reports
- Understanding SSRS Reports
- Creating Reports Lab
- Creating A New Report Database
- Generate More Reports Lab
- Advanced Report Object Properties-Part1-2
11: Extending and Deploying SSRS Reports
- SSRS Report Parameters
- Create A Report Without Using Wizard Lab
- Extending and Deploying SSRS Reports
12: Scheduling Deployed Reports and Data Sources
- Scheduling Reports And Subscriptions
- Creating A New Role For SSRS Lab
- SSRS And Data Sources
- Set Up Shared Schedule Lab
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