O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft 70-448: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

Video Description

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.

Table of Contents

  1. Module 1: SSIS Packages
    1. Introduction 00:01:52
    2. Lesson 1 Creating SSIS Packages 00:06:20
    3. Creating A New Package Lab 00:04:25
    4. Data Sources Lab 00:03:06
    5. Connections Lab 00:02:11
    6. Lesson 2 Control Flow 00:10:13
    7. Creating And Editing Control Flow Lab 00:05:11
    8. Lesson 3-Part 1 Data Flow 00:05:58
    9. Lesson 3-Part 2 Data Flow Transformations 00:06:36
    10. Data Flow Lab 00:07:14
  2. Module 2: Debugging and Error Handling in SSIS
    1. Lesson 1 Debugging And Error Handling in SSIS-Part 1 00:04:52
    2. Enable Transactions And Observe Trans Rollback Lab 00:05:03
    3. Set Checkpoints In A Package Lab 00:05:45
    4. Lesson 2 Debugging And Error Handling in SSIS-Part 2 00:10:10
    5. Setting Up Constraints Lab 00:02:42
    6. Turn On Logging Lab 00:03:45
    7. Lesson 3 Debugging And Error Handling in SSIS-Part 3 00:09:33
    8. Identifying Data Flow Errors Lab 00:05:32
  3. Module 3: Deploying and Configuring SSIS Packages
    1. Lesson 1-Part 1 Deploying 00:11:20
    2. Lesson 1-Part 2 Sharing Ordering And Configuring 00:06:17
    3. Create An XML Configuration Lab 00:02:44
    4. Create A SQL Server Configuration Lab 00:03:32
    5. Use A Property Expression To Update A Connection Lab 00:02:12
    6. Lesson 2 Deploying An SSIS Package 00:06:02
    7. Create And Deploy An Installer Kit Lab 00:04:37
  4. Module 4: Securing and Executing SSIS Packages; Service Administration
    1. Lesson 1-Part 1 Securing And Executing SSIS Packages 00:06:02
    2. Lesson 1-Part 2 SSIS Package Security 00:13:01
    3. Turn On Package Encryption Lab 00:02:32
    4. Change Security Roles Lab 00:03:01
    5. Lesson 2 Executing And Administration 00:06:48
    6. Create And Execute A Command-Line Statement Lab 00:03:50
    7. Execute A Package Through SQL Server Agent Lab 00:02:56
  5. Module 5: Data Analysis
    1. Lesson 1 SSAS Cube Development 00:09:58
    2. Create SSAS Project Lab 00:01:26
    3. Create A Data Source Lab 00:02:07
    4. Create A Data Source View Lab 00:04:30
    5. Lesson 2 Creating And Modifying SSAS Cube 00:05:47
    6. Creating A Cube Lab 00:03:52
    7. Using Cube Designer To Edit A Cube Structure Lab 00:05:38
    8. Lesson 3 Creating A Dimension 00:02:32
    9. Create A New Dimension Lab 00:03:08
    10. Lesson 4 Creating Measure Groups And Measures 00:06:25
    11. Add Measure Groups Lab 00:03:44
    12. Configure Measure Groups And Measures Lab 00:02:39
  6. Module 6: Extending SSAS Cubes
    1. Lesson 1 Extending SSAS Cubes Part 1 00:09:39
    2. Define Attribute Relationships Lab 00:02:52
    3. Define User Hierarchy Lab 00:01:36
    4. Lesson 2 Extending SSAS Cube Part 2 00:09:39
    5. Implement The Reseller Sales KPI Lab 00:08:36
    6. Lesson 3 Extending SSAS Cube Part 3 00:06:39
    7. Turn On Proactive Caching Lab 00:04:15
  7. Module 7: Extending SSAS Cubes
    1. Lesson 1-Part 1 SSAS Storage Processing And Deployment 00:11:17
    2. Lesson 1-Part 2 Aggregating And Enabling Proactive Caching 00:08:09
    3. Turning On Proactive Caching Lab 00:01:54
    4. Lesson 2 SSAS Deployment 00:11:31
    5. Deploy Database With Deployment Wizard Lab 00:02:29
    6. Lesson 3 Processing 00:10:07
    7. Processing Scripts Using SQL Server Agent Lab 00:03:45
  8. Module 8: Securing and Administering SSAS
    1. Lesson 1 SSAS Security 00:09:33
    2. Create A Role and Set Security Lab 00:04:22
    3. Lesson 2 Backing Up SSAS 00:07:38
    4. Backing Up Datain Management Studio Lab 00:06:19
    5. Lesson 3 Managing SSAS Turning and Logging 00:07:45
    6. Turning On Query Logging Lab 00:03:17
    7. Lesson 4 SSAS Administering 00:08:20
    8. Turn On And Use SQL Server Profiler 00:02:31
    9. Monitor SSAS Performance Lab 00:02:17
  9. Module 9: Working With SSAS Data Mining
    1. Lesson 1-Part 1 Prepare And Creating Data Mining Structures 00:12:23
    2. Lesson 1-Part 2 Data Mining Algorithms And Usage 00:06:34
    3. Data Mining Wizard Lab 00:03:24
    4. Lesson 2 Mapping Mining Structure Attributes To Source Columns 00:05:15
    5. Create A Model From A Cube Lab 00:03:49
    6. Lesson 3 Predictive Models 00:08:50
    7. Lesson 4 Data Mining Security 00:09:04
    8. Managing Permissions Lab 00:03:59
  10. Module 10: Developing SSAS Reports
    1. Lesson 1 Understanding SSRS Reports 00:08:57
    2. Creating Reports Lab 00:05:33
    3. Lesson 2 Creating A New Report Database 00:05:49
    4. Generate More Reports Lab 00:06:06
    5. Lesson 3 Advanced Report Object Properties-Part 1 00:04:23
    6. Lesson 3 Advanced Report Object Properties-Part 2 00:06:34
  11. Module 11: Extending and Deploying SSRS Reports
    1. Lesson 1 SSRS Report Parameters 00:05:40
    2. Create A Report Without Using Wizard Lab 00:04:38
    3. Lesson 2 Extending SSRS Reports 00:04:03
    4. Lesson 3 Deploying SSRS Reports 00:03:35
  12. Module 12: Scheduling Deployed Reports and Data Sources
    1. Lesson 1 Scheduling Reports And Subscriptions 00:09:23
    2. Creating A New Role For SSRS Lab 00:02:22
    3. Lesson 2 SSRS And Data Sources 00:07:04
    4. Set Up Shared Schedule Lab 00:01:54
  13. Module 13: Configuring And Administering the SSRS Server
    1. Lesson 1 Installing And Configuring SSRS Server 00:08:25
    2. Changing Settings In Configuration Manager Lab 00:03:05
    3. Lesson 2 Administering The SSES Server And Command-Line Utilities 00:08:05
    4. Backing Up And Restoring Encryption Keys Lab 00:07:13
    5. Outro 00:00:37