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

This course is preparation for the 70-448 exam. This exam covers the following topics: Implementing an SSIS solution, Configuring, deploying, and maintaining SSIS, Implementing an SSAS solution, Configuring, deploying, and maintaining SSAS, Implementing an SSRS solution, Configuring, deploying, and maintaining SSRS.

Course Description:

This online training course is comprehensive and designed to cover the key topics listed under the curriculum.

Course Curriculum

1: SSIS PACKAGES

1. Introduction

2. Creating SSIS Packages

3. Creating A New Package Lab

4. Data Sources Lab

5. Connections Lab

6. Control Flow

7. Creating And Editing Control Flow Lab

8. Data Flow

9. Data Flow Transformations

10. Data Flow Lab

2: DEBUGGING AND ERROR HANDLING IN SSIS

1. Debugging And Error Handling in SSIS

2. Enable Transactions And Observe Trans Rollback Lab

3. Set Checkpoints In A Package Lab

4. Setting Up Constraints Lab

5. Turn On Logging Lab

6. Identifying Data Flow Errors Lab

3: DEPLOYING AND CONFIGURING SSIS PACKAGES

1. Deploying

2. Sharing Ordering And Configuring

3. Create An XML Configuration Lab

4. Create A SQL Server Configuration Lab

5. Use A Property Expression To Update A Connection Lab

6. Deploying An SSIS Package

7. Create And Deploy An Installer Kit Lab

4: SECURING AND EXECUTING SSIS PACKAGES; SERVICE ADMINISTRATION

1. Securing And Executing SSIS Packages

2. SSIS Package Security

3. Turn On Package Encryption Lab

4. Change Security Roles Lab

5. Executing And Administration

6. Create And Execute A Command-Line Statement Lab

7. Execute A Package Through SQL Server Agent Lab

5: DATA ANALYSIS

1. SSAS Cube Development

2. Create SSAS Project Lab

3. Create A Data Source Lab

4. Create A Data Source View Lab

5. Creating And Modifying SSAS Cube

6. Creating A Cube Lab

7. Using Cube Designer To Edit A Cube Structure Lab

8. Creating A Dimension

9. Create A New Dimension Lab

10. Creating Measure Groups And Measures

11. Add Measure Groups Lab

12. Configure Measure Groups And Measures Lab

6: EXTENDING SSAS CUBES

1. Extending SSAS Cubes

2. Define Attribute Relationships Lab

3. Define User Hierarchy Lab

4. Extending SSAS Cube

5. Implement The Reseller Sales KPI Lab

6. Lesson3 Extending SSAS Cube

7. Turn On Proactive Caching Lab

7: EXTENDING SSAS CUBES

1. SSAS Storage Processing And Deployment

2. Aggregating And Enabling Proactive Caching

3. Turning On Proactive Caching Lab

4. SSAS Deployment

5. Deploy Database With Deployment Wizard Lab

6. Processing

7. Processing Scripts Using SQL Server Agent Lab

8: SECURING AND ADMINISTERING SSAS

1. SSAS Security

2. Create A Role And Set Security Lab

3. Backing Up SSAS

4. Backing Up And Maintain Management Studio Lab

5. Managing SSAS Turning And Logging

6. Turning On Query Logging Lab

7. SSAS Administering

8. Turn On And Use SQL Server Profiler Lab

9. Monitor SSAS Performance Lab

9: WORKING WITH SSAS DATA MINING

1. Part 1 Prepare And Creating Data Mining Structures

2. Part 2 Data Mining Algorithms And Usage

3. Data Mining Wizard Lab

4. Mapping Mining Structure Attributes To Source Columns

5. Create A Model From A Cube Lab

6. Predictive Models

7. Data Mining Security

8. Managing Permissions Lab

10: DEVELOPING SSAS REPORTS

1. Understanding SSRS Reports

2. Creating Reports Lab

3. Creating A New Report Database

4. Generate More Reports Lab

5. Advanced Report Object Properties

11: EXTENDING AND DEPLOYING SSRS REPORTS

1. SSRS Report Parameters

2. Create A Report Without Using Wizard Lab

3. Extending SSRS Reports

4. Deploying SSRS Reports

12: SCHEDULING DEPLOYED REPORTS AND DATA SOURCES

1. Scheduling Reports And Subscriptions

2. Creating A New Role For SSRS Lab

3. SSRS And Data Sources

4. Set Up Shared Schedule Lab

13: CONFIGURING AND ADMINISTERING THE SSRS SERVER

1. Installing And Configuring SSRS Server

2. Changing Settings In Configuration Manager Lab

3. Administering The SSES Server And Command-Line Utilities

4. Backing Up And Restoring Encryption Keys Lab

5. Conclusion

Course Duration:

You will have 12 Months access to your online study platform from the date you purchased the course. The course is self-paced so you decide how fast or slow the training goes. You can complete the course in stages revisiting the training at any time.

Method of Assessment:

At the end of the course, learners will take an online multiple choice question assessment test (please be aware, this is not the official exam). The online test is marked straight away, so you will know immediately if you have passed the course.

Certification:

Successful candidates will be awarded a certificate for Microsoft SQL Server 2008, Business Intelligence Development and Maintenance.

(This course is not included the official certificate)

Why Choose Us?

• Our courses represent outstanding value for money
• High quality e-learning study materials and mock exams.
• Each course is designed by industry experts, using an innovative interactive learning approach.
• Includes step-by-step guided videos tutorials.
• Benefit of applying NUS extra Discount Card.
• 24/7 Access to the Online Learning Portal.
• Anytime & Anywhere Learning.
• Recognised Accredited Qualification.
• Access Course Content on Mobile, Tablet or Desktop.
• Study in a user friendly, advanced online learning platform.
• Excellent customer service and administrative support.

• School Leavers
• Job Seekers
• Configuration Manager
• Network Analyst

Learners must be age 16 or over and should have a basic understanding of the English Language, numeracy, literacy, and ICT.

This training course will lead you to become a:

• Configuration Manager
• Network Analyst
• Network Administrator
• Network Manager

Currently there are no Q&As for this course. Be the first to ask a question.