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

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

$49
Instructor
Reviews
Rating

About this course

This course covers the following topics to prepare students for the 70-448 Microsoft SQL Server 2008 Business Intelligence Development and Maintenance exam: how to implement SSIS, SSAS, and SSRS solutions, as well as how to configure, deploy and maintain SSIS, SSAS, and SSRS solutions.

Course Outline

SSIS Packages

  •  1.1 Intro
  •  1.2 Lesson 1 Creating SSIS Packages
  •  1.3 Creating A New Package Lab
  •  1.4 Data Sources Lab
  •  1.5 Connections Lab
  •  1.6 Lesson 2 Control Flow
  • 1.7 Creating And Editing Control Flow Lab
  •  1.8 Lesson 3-Part 1 Data Flow
  •  1.9 Lesson 3-Part 2 Data Flow Transformations
  •  1.10 Data Flow Lab

Debugging and Error Handling in SSIS

  •  2.1 Lesson 1 Debugging And Error Handling in SSIS-Part 1
  •  2.2 Enable Transactions And Observe Trans Rollback Lab
  • 2.3 Set Checkpoints In A Package Lab
  •  2.4 Lesson 2 Debugging And Error Handling in SSIS-Part 2
  •  2.5 Setting Up Constraints Lab
  •  2.6 Turn On Logging Lab
  •  2.7 Lesson 3 Debugging And Error Handling in SSIS-Part 3
  •  2.8 Identifying Data Flow Errors Lab

Deploying and Configuring SSIS Packages

  •  3.1 Lesson 1-Part 1 Deploying
  •  3.2 Lesson 1-Part 2 Sharing Ordering And Configuring
  •  3.3 Create An XML Configuration Lab
  •  3.4 Create A SQL Server Configuration Lab
  •  3.5 Use A Property Expression To Update A Connection Lab
  •  3.6 Lesson 2 Deploying An SSIS Package
  •  3.7 Create And Deploy An Installer Kit Lab

Securing and Executing SSIS Packages; Service Administration

  •  4.1 Lesson 1-Part 1 Securing And Executing SSIS Packages
  •  4.2 Lesson 1-Part 2 SSIS Package Security
  •  4.3 Turn On Package Encryption Lab
  •  4.4 Change Security Roles Lab
  •  4.5 Lesson 2 Executing And Administration
  •  4.6 Create And Execute A Command-Line Statement Lab
  •  4.7 Execute A Package Through SQL Server Agent Lab

Data Analysis

  •  5.1 Lesson 1 SSAS Cube Development
  •  5.2 Create SSAS Project Lab
  •  5.3 Create A Data Source Lab
  •  5.4 Create A Data Source View Lab
  •  5.5 Lesson 2 Creating And Modifying SSAS Cube
  •  5.6 Creating A Cube Lab
  •  5.7 Using Cube Designer To Edit A Cube Structure Lab
  •  5.8 Lesson 3 Creating A Dimension
  •  5.9 Create A New Dimension Lab
  •  5.10 Lesson 4 Creating Measure Groups And Measures
  •  5.11 Add Measure Groups Lab
  •  5.12 Configure Measure Groups And Measures Lab

Extending SSAS Cubes

  •  6.1 Lesson 1 Extending SSAS Cubes Part 1
  •  6.2 Define Attribute Relationships Lab
  •  6.3 Define User Hierarchy Lab
  •  6.4 Lesson 2 Extending SSAS Cube Part 2
  •  6.5 Implement The Reseller Sales KPI Lab
  •  6.6 Lesson 3 Extending SSAS Cube Part 3
  •  6.7 Turn On Proactive Caching Lab

Extending SSAS Cubes

  •  7.1 Lesson 1-Part 1 SSAS Storage Processing And Deployment
  •  7.2 Lesson 1-Part 2 Aggregating And Enabling Proactive Caching
  •  7.3 Turning On Proactive Caching Lab
  •  7.4 Lesson 2 SSAS Deployment
  •  7.5 Deploy Database With Deployment Wizard Lab
  •  7.6 Lesson 3 Processing
  •  7.7 Processing Scripts Using SQL Server Agent Lab

Securing and Administering SSAS

  •  8.1 Lesson 1 SSAS Security
  •  8.2 Create A Role and Set Security Lab
  •  8.3 Lesson 2 Backing Up SSAS
  •  8.4 Backing Up Datain Management Studio Lab
  •  8.5 Lesson 3 Managing SSAS Turning and Logging
  • 8.6 Turning On Query Logging Lab
  • 8.7 Lesson 4 SSAS Administering
  •  8.8 Turn On And Use SQL Server Profiler
  •  8.9 Monitor SSAS Performance Lab

Working With SSAS Data Mining

  •  9.1 Lesson 1-Part 1 Prepare And Creating Data Mining Structures
  •  9.2 Lesson 1-Part 2 Data Mining Algorithms And Usage
  •  9.3 Data Mining Wizard Lab
  •  9.4 Lesson 2 Mapping Mining Structure Attributes To Source Columns
  •  9.5 Create A Model From A Cube Lab
  •  9.6 Lesson 3 Predictive Models
  •  9.7 Lesson 4 Data Mining Security
  •  9.8 Managing Permissions Lab

Developing SSAS Reports

  •  10.1 Lesson 1 Understanding SSRS Reports
  •  10.2 Creating Reports Lab
  •  10.3 Lesson 2 Creating A New Report Database
  •  10.4 Generate More Reports Lab
  •  10.5 Lesson 3 Advanced Report Object Properties-Part 1
  •  10.6 Lesson 4 Advanced Report Object Properties-Part 2

Extending and Deploying SSRS Reports

  •  11.1 Lesson 1 SSRS Report Parameters
  •  11.2 Create A Report Without Using Wizard Lab
  •  11.3 Lesson 2 Extending SSRS Reports
  •  11.4 Lesson 3 Deploying SSRS Reports

Scheduling Deployed Reports and Data Sources

  •  12.1 Lesson 1 Scheduling Reports And Subscriptions
  •  12.2 Creating A New Role For SSRS Lab
  •  12.3 Lesson 2 SSRS And Data Sources
  •  12.4 Set Up Shared Schedule Lab

Configuring And Administering the SSRS Server

  •  13.1 Lesson 1 Installing And Configuring SSRS Server
  •  13.2 Changing Settings In Configuration Manager Lab
  •  13.3 Lesson 2 Administering The SSES Server And Command-Line Utilities
  •  13.4 Backing Up And Restoring Encryption Keys Lab
  •  13.5 Outro

Reviews

0 Rated 0 out of 0 Ratings
5 stars
4 stars
3 stars
2 stars
1 stars