MCTS Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

Get MCTS SQL Server 2008 Business Intelligence Development and Maintenance certification classroom based training from MCTS Certified trainer in London

Upcoming Class
24 Sep 2018
10
Day(s) course
18:30 pm - 21:30 pm
1700per person
1,445.00 (when you book any 3 courses *)
This course will take place in 3-4 Kirby Street, London, EC1N 8TS. Find on map
15 %
Discount

when you buy 3 or more courses

The discount will be automatically
applied at the checkout
Looking for a
2-12 months
training?
Choose Database Administrator
Career Programme

Looking for a 2-12 months training?

Choose

Database Administrator career programme

Upcoming dates

Date Day(s) Course Session Time Price
24 Sep 2018 10 Mon & Thu 18:30 - 21:30 £1700 Reserve
08 Oct 2018 5 Mon to Fri 10:00 - 17:00 £1700 Reserve
21 Oct 2018 5 Sun 10:00 - 17:00 £1700 Reserve
06 Nov 2018 10 Tue & Fri 18:30 - 21:30 £1700 Reserve
24 Nov 2018 5 Sat 10:00 - 17:00 £1700 Reserve
24 Sep 2018
Mon to Thu
18pm - 21pm
10 day(s)
£1700.00
08 Oct 2018
Mon to Fri
10am - 17pm
5 day(s)
£1700.00
21 Oct 2018
Sun
10am - 17pm
5 day(s)
£1700.00
06 Nov 2018
Tue to Fri
18pm - 21pm
10 day(s)
£1700.00
24 Nov 2018
Sat
10am - 17pm
5 day(s)
£1700.00

Course Outline

MCTS Microsoft SQL Server 2008, Business Intelligence Development and Maintenance course overview

This fast track MCTS SQL Server 2008 certification course is designed to provide delegates with the necessary knowledge to pursue Microsoft Certified Technology Specialist (MCTS) SQL Server 2008 Business Intelligence Development and Maintenance certification.

Candidates for this exam are responsible for creating business intelligence (BI) solutions by using SQL Server 2008 for their organizations. Candidates typically work with the full suite of BI technologies in SQL Server 2008, including Reporting Services, Analysis Services, and Integration Services.

When you pass Exam 70-448: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance, you complete the requirements for the following certification(s):

Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance*

This short MCTS course is hands-on, instructor-led and classroom based. This training can be taken as a part-time evening course or even on the weekends. A list of all upcoming public MCTS web developer training course is given on training dragon website.


Who is MCTS Microsoft SQL Server 2008, Business Intelligence Development and Maintenance training for?

This is a fast track course and not recommended for beginners. This training course is for you if you are interested in becoming Microsoft Certified Technology Specialist in SQL Server 2008 Business Intelligence Development and Maintenance.


Prerequisites for MCTS Microsoft SQL Server 2008, Business Intelligence Development and Maintenance course

This course is intended for individuals who design and maintain business intelligence solutions for their organization. They should have experience in:-

  • Conceptual understanding of OLAP solutions.
  • Experience navigating the Microsoft Windows Server environment.
  • Experience with Windows services (starting and stopping).
  • Experience creating service accounts and permissions.
  • Experience with Microsoft SQL Server, including: SQL Server Agent, SQL Server query language (SELECT, UPDATE, INSERT, and DELETE), SQL Server System tables and SQL Server accounts (users and permissions).


What will I get?

  • Training from professional MCTS certified trainers:

    Training Dragon consultants have been implementing professional Microsoft SQL Server Database solutions across a range of companies for many years. Those consultants write and teach our MCTS training courses, so their experience directly informs course content.

  • Practical Projects:

    This MCTS training is designed to prepare you not only for MCTS certification, but also to train you for your next job. To do this, next to certification you will also work on real-world practical MCTS related exercises in this MCTS course. This will ensure that you can apply the knowledge gained from this course to your work environment.

  • Course Material and Practice exams:

    MCTS electronic notes are included in this course. You will also take practice exams as part of the course.

  • Course Completion Certificate:

    After completing this training you will receive MCTS course completion certificate.

  • Support and Careers Advice:

    After the course if you have any problems or questions regarding MCTS, do not hesitate to contact us. Training Dragon’s trainers and career consultants are expert in their fields and if you need any help with you career choice, please speak to one of our career consultants.

  • Pass Guarantee and Train again for Free:

    We are sure that you will pass your MCTS certification exam at first attempt. However, if you don’t, you can come back within a year and take the complete course for free.

  • Official Course Curriculum:

    This MCTS certification course is based on the official Microsoft recommended course syllabus.


MCTS Microsoft SQL Server 2008, Business Intelligence Development and Maintenance Course Contents

This MCTS SQL Server 2008 certification course prepares you for following exam.

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

  • Microsoft SQL Server Analysis Services
  • Creating Multidimensional Analysis Solutions
  • Working with Cubes and Dimensions
  • Working with Measures and Measure Groups
  • Querying Multidimensional Analysis Solutions
  • Customizing Cube Functionality
  • Maintaining a Multidimensional Solution
  • Introduction to Data Mining
  • Introduction to SQL Server 2008 Integration Services
  • Developing Integration Services Solutions
  • Implementing Control Flow
  • Implementing Data Flow
  • Implementing Logging
  • Debugging and Error Handling
  • Implementing Checkpoints and Transactions
  • Configuring and Deploying Packages
  • Managing and Securing Packages
  • Introduction to Microsoft SQL Server Reporting Services
  • Authoring Basic Reports
  • Enhancing Basic Reports
  • Manipulating Data Sets
  • Using Report Models
  • Publishing and Executing Reports
  • Using Subscriptions to Distribute Reports
  • Administering Reporting Services
  • Programming Reporting Services

View Complete Course outline

Daily schedule

The scheme below shows what a typical day at Training Dragon looks like.

10:00 11:30 11:45 13:00 14:00 15:30 15:45
Classroom Activity
This course explains how to create web pages from scratch using different techniques, such as
Tea
Break
Classroom Activity
This course explains how to create web pages from scratch using different techniques, such as
Lunch
Break
Classroom Activity
This course explains how to create web pages from scratch using different techniques, such as
Tea
Break
Classroom Activity
This course explains how to create web pages from scratch using different techniques, such as
Video Placeholder

Looking for a
2-12 months
training?

Choose

Database Administrator career programme

Our Trainers

Emiliano
Emiliano
Leads our teaching team with many years of experience in teaching web development.
Ross
Ross
Brings many years of Python and Java software development experience to classrooms.
Olu
Olu
Microsoft and Oracle certified developer with years teaching experience in Android, .NET and databases.

Latest Reviews

Frequently Asked Questions

Have a question?
We are here to answer them