Microsoft 70-448: Microsoft SQL Server 2008, BI Development and Maintenance
Learn how to develop and implement business intelligence within an organisation.
StudyOnline247
Summary
- Exam(s) / assessment(s) not included in price, and must be purchased separately
Overview
This course will teach students the implementation of an SSIS solution, the configuration, deployment and maintenance of SSIS, Implementation of an SSAS solution, the configuration, deployment and maintenance of SSAS, implementation of an SSRS solution, the configuration and the deployment and maintenance of SSRS.
Certification
Microsoft Certified Professional (MCP)
Description
What you will learn:
- Creating a package lab
- Data flow transformations
- Setting up constraints
- Deploying an SSIS package
- Changing security roles
Why study online?
Technological improvements and advances in educational design mean that studying online is no longer just a low cost alternative to traditional training methods. In many respects our online courses offer training which is superior to the majority of available “classroom” options.
Not only is the effectiveness of the training process enhanced, but also the convenience and overall cost efficiency of studying online makes it a compelling option for training. You can learn at your own pace and can repeat each section as many times as required unlike in a classroom environment.
Studying at your own pace, rewinding and going over the material as often as you need improves your long-term memory retention and makes studying more rewarding.
Curriculum for the Microsoft 70-448: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance course:
Module 1: SSIS Packages
Intro
Lesson 1 - Creating SSIS Packages
Creating A New Package Lab
Data Sources Lab
Connections Lab
Lesson 2 - Control Flow
Creating And Editing Control Flow Lab
Lesson 3 - Part 1 - Data Flow
Lesson 3 - Part 2 - Data Flow Transformations
Data Flow Lab
Module 2: Debugging and Error Handling in SSIS
Lesson 1 - Debugging And Error Handling in SSIS Part 1
Enable Transactions And Observe Trans Rollback Lab
Set Checkpoints In A Package Lab
Lesson 2 - Debugging And Error Handling in SSIS Part 2
Setting Up Constraints Lab
Turn On Logging Lab
Lesson 3 - Debugging And Error Handling in SSIS Part 3
Identifying Data Flow Errors Lab
Module 3: Deploying and Configuring SSIS Packages
Lesson 1 - Part 1 - Deploying
Lesson 1 - Part 2 - Sharing Ordering And Configuring
Create An XML Configuration Lab
Create A SQL Server Configuration Lab
Use A Property Expression To Update A Connection Lab
Lesson 2 - Deploying An SSIS Package
Create And Deploy An Installer Kit Lab
Module 4: Securing and Executing SSIS Packages; Service Administration
Lesson 1 - Part 1 - Securing And Executing SSIS Packages
Lesson 1 - Part 2 - SSIS Package Security
Turn On Package Encryption Lab
Change Security Roles Lab
Lesson 2 - Executing And Administration
Create And Execute A Command-Line Statement Lab
Execute A Package Through SQL Server Agent Lab
Module 5: Data Analysis
Lesson 1 - SSAS Cube Development
Create SSAS Project Lab
Create A Data Source Lab
Create A Data Source View Lab
Lesson 2 - Creating And Modifying SSAS Cube
Creating A Cube Lab
Using Cube Designer To Edit A Cube Structure Lab
Lesson 3 - Creating A Dimension
Create A New Dimension Lab
Lesson 4 - Creating Measure Groups And Measures
Add Measure Groups Lab
Configure Measure Groups And Measures Lab
Module 6: Extending SSAS Cubes
Lesson 1 - Extending SSAS Cubes Part 1
Define Attribute Relationships Lab
Define User Hierarchy Lab
Lesson 2 - Extending SSAS Cube Part 2
Implement The Reseller Sales KPI Lab
Lesson 3 - Extending SSAS Cube Part 3
Turn On Proactive Caching Lab
Module 7: Extending SSAS Cubes
Lesson 1 - Part 1 - SSAS Storage Processing And Deployment
Lesson 1 - Part 2 - Aggregating And Enabling Proactive Caching
Turning On Proactive Caching Lab
Lesson 2 - SSAS Deployment
Deploy Database With Deployment Wizard Lab
Lesson 3 - Processing
Processing Scripts Using SQL Server Agent Lab
Module 8: Securing and Administering SSAS
Lesson 1 - SSAS Security
Create A Role and Set Security Lab
Lesson 2 - Backing Up SSAS
Backing Up Data in Management Studio Lab
Lesson 3 - Managing SSAS Turning and Logging
Turning On Query Logging Lab
Lesson 4 - SSAS Administering
Turn On And Use SQL Server Profiler
Monitor SSAS Performance Lab
Module 9: Working With SSAS Data Mining
Lesson 1 - Part 1 - Prepare And Creating Data Mining Structures
Lesson 1 - Part 2 - Data Mining Algorithms And Usage
Data Mining Wizard Lab
Lesson 2 - Mapping Mining Structure Attributes To Source Columns
Create A Model From A Cube Lab
Lesson 3 - Predictive Models
Lesson 4 - Data Mining Security
Managing Permissions Lab
Module 10: Developing SSAS Reports
Lesson 1 - Understanding SSRS Reports
Creating Reports Lab
Lesson 2 - Creating A New Report Database
Generate More Reports Lab
Lesson 3 - Advanced Report Object Properties-Part 1
Lesson 4 - Advanced Report Object Properties-Part 2
Module 11: Extending and Deploying SSRS Reports
Lesson 1 - SSRS Report Parameters
Create A Report Without Using Wizard Lab
Lesson 2 - Extending SSRS Reports
Lesson 3 - Deploying SSRS Reports
Module 12: Scheduling Deployed Reports and Data Sources
Lesson 1 - Scheduling Reports And Subscriptions
Creating A New Role For SSRS Lab
Lesson 2 - SSRS And Data Sources
Set Up Shared Schedule Lab
Module 13: Configuring And Administering the SSRS Server
Lesson 1 - Installing And Configuring SSRS Server
Changing Settings In Configuration Manager Lab
Lesson 2 - Administering The SSES Server And Command-Line Utilities
Backing Up And Restoring Encryption Keys Lab
Outro
Please note that the official exam is not included, however for those who complete the course, they will receive a completion certificate upon request.
Who is this course for?
IT professionals who have an interest in developing and maintaining business intelligence within their organisation.
Requirements
There are no formal prerequisites to studying this course.
Career path
Business Intelligence Analyst
Business Intelligence Architect
Business Intelligence Data Analyst
Business Intelligence Developer
Business Intelligence Consultant
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.