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 5: Data Analysis
- Lesson1 SSAS Cube Development
- Create SSAS Project Lab
- Create A Data Source Lab
- Create A Data Source View Lab
- Lesson2 Creating And Modifying SSAS Cube
- Creating A Cube Lab
- Using Cube Designer To Edit A Cube Structure Lab
- Lesson3 Creating A Dimension
- Create A New Dimension Lab
- Lesson4 Creating Measure Groups And Measures
- Add Measure Groups Lab
- Configure Measure Groups And Measures 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 9: Working With SSAS Data Mining
- Lesson1-Part1 Prepare And Creating Data Mining Structures
- Lesson1-Part2 Data Mining Algorithms And Usage
- Data Mining Wizard Lab
- Lesson2 Mapping Mining Structure Attributes To Source Columns
- Create A Model From A Cube Lab
- Lesson3 Predictive Models
- Lesson4 Data Mining Security
- Managing Permissions 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
