Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

Overview

If you are aspiring to get into the BI industry, this course might be the one for you. This course is set to guide you thoroughly on business intelligence development and maintenance with Microsoft SQL server, to give your dream career the jumpstart it needs. From server implementation, to server maintenance, you will learn everything you need to know from this course to get started with BI.

You will be walked through how to configure and deploy SSIS, SSAS and SSRS of Microsoft SQL server to get you oriented with the database. How SQL server can be used in data analysis, and other topics such as error handling, scheduling deployed reports, extending reports and many more, will also be discussed in detail through this course.

By the end of this course, you will walk away with an outstanding knowledge on Microsoft SQL server 2008 to assist in your BI career. You can also use this course as a foundation to follow up on the other related courses or to demand for a higher pay or job promotion from your employer.

Course Curriculum

1: SSIS Packages

2: Debugging and Error Handling in SSIS

3: Deploying and Configuring SSIS Packages

4: Securing and Executing SSIS Packages; Service Administration

5: Data Analysis

6: Extending SSAS Cubes

7: Extending SSAS Cubes

8: Securing and Administering SSAS

9: Working With SSAS Data Mining

10: Developing SSAS Reports

11: Extending and Deploying SSRS Reports

12: Scheduling Deployed Reports and Data Sources

13: Configuring And Administering the SSRS Server

Learning outcomes

• Learn how to implement, configure, deploy and maintain a SSIS solution
• Understand how to implement, configure, deploy and maintain a SSAS solution
• Explore how to implement, configure, deploy and maintain a SSRS solution

Access duration

The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course.  The course is self-paced and you can complete it in stages, revisiting the lectures at any time.

Who is this course aimed at?

This course is mainly aimed at individuals interested in embarking on a business intelligence career. BI professionals might also find this course worthwhile to progress in their career.

Method of assessment

At the end of the course, you will have one assignment to be submitted (you need a mark of 65% to pass) and you can submit the assignment at any time. You will only need to pay £19 for assessment and certification when you submit the assignment. You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days if you have successfully passed.

Certification and awarding body

Those who successfully complete the course will be awarded the Microsoft SQL Server 2008, Business Intelligence Development and Maintenance certificate by CPD & iAP. The qualification will make you valuable to employers, and your motivation at gaining new skills will be recognised.

Other benefits

• Written and designed by the industry’s finest expert instructors with over 15 years of experience
• Repeat and rewind all your lectures and enjoy a personalised learning experience
• Gain access to quality video tutorials
• Unlimited 12 months access from anywhere, anytime
• Save time and money on travel
• Learn at your convenience and leisure
• Eligible for a NUS discount card
• Free Career Support Service
• 25% Discount on personal Statement and covering letter writing service
• Free Access to Over 150 courses for 2 days (48 hours)
• Free access to course before you purchase (For selected courses only