- Duration: 28 hours
Course details
In this SQL Server 2008 training course you will learn to install and manage the business intelligence functionality of SQL Server 2008. You will also learn to produce cubes and reports. On completion of the course you can achieve the certificate Microsoft Certified Technology Specialist (MCTS): SQL Server 2008 Business Intelligence Development and Maintenance.
Among the topics covered are the use of SQL Server Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS). Extensive attention is also devoted to datamining and the various options for distributing reports.
Your result
You will be able to implement and manage the business intelligence functionality of a SQL Server 2008 database.
Audience profile
DBAs, administrators, database designers, BI developers. This training is also a part of the MCTS: SQL Server 2008, Business Intelligence Development certification.
Contents of this SQL Server course
The Microsoft SQL Server 2008 training course: Business Intelligence Development and Maintenance is made up of various lessons:
Implementing SQL Server 2008 Integration Services
Configuring SQL Server 2008 Integration Services Packages
Deploying SQL Server 2008 Integration Services Packages
Managing SSIS Packages in SQL Server 2008
Implementing SQL Server 2008 Reporting Services Solutions
Deploying and Delivering SQL Server 2008 Reporting Services Reports
Maintaining SQL Server 2008 Reporting Services
Implementing SQL Server 2008 Analysis Services Solutions
Querying Cubes and Working with Data Mining in SSAS
Managing SQL Server 2008 Analysis Services Solutions
Prerequisites
You have general knowledge of SQL Server 2005 or 2008. You also have knowledge of SQL, the .Net framework, SQL Server Management Studio and Business Intelligence Development Studio.
We offer several optional training products to enhance your learning experience. If you are planning to use our training course in preperation for an official exam then whe highly recommend using these optional training products to ensure an optimal learning experience. During the order process you will be asked if you want to include these options.
Optional practice exam (trial exam)
To supplement this training course you may add a special practice exam. This practice exam comprises a number of trial exams which are very similar to the real exam, both in terms of form and content. This is the ultimate way to test whether you are ready for the exam. You may order this practice exam as an extra by entering 'Yes' at the top of the 'Practice exam' option. Read more about this practice exam here:
If you order the practice exam directly with your training course you will get an extra discount of $ 30.00 on your practice exam.
Exam via Prometric
On concluding your training you can schedule your exam yourself. As an option you may order an exam voucher immediately, or book your own exam via Prometric.
The advantage of booking your exam via Prometric is that you decide for yourself where and when you will do your exam. With more than 8000 exam locations in 160 countries, there's always one within reach for you. You choose the location, the date and the time you want to do the exam yourself online.
Our exam partner issues an original certificate on behalf of the certification party. So you always receive an official registered Microsoft certificate.
The costs of the exam are not included in the price of the training. Optionally you may order an exam voucher immediately. With an exam voucher you can register for the exam yourself.
Updated on 01 July, 2018
SQL Server Related Questions
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- SQL Programming Complete Bundle NextGen LearningAED 199Duration: Upto 20 Hours
- Microsoft SQL Server Development StudyHubAED 49
AED 955Duration: Upto 6 Hours