Implementing a Data Warehouse with Microsoft SQL Server 2012 (exam 70-463)

Course details

In this SQL Server 2012 training course you will learn to set up data warehouses based on SQL Server 2012. You will also learn what data warehouses are and how they can be used to create reports and (management) information.

Among the topics covered are implementing a data warehouse, ETL solutions, SSIS installation, troubleshooting, DQS and MDS solutions, enhancing packages and far more.

Your result

You are able to create and manage data warehouses based on SQL Server 2012. You are also prepared for MCSA exam 70-463.

Audience profile

Data warehouse developers and database administrators who create and manage business intelligence solutions as a part of their daily work. This training is also intended for everyone who want to achieve the certification MCSA: SQL Server 2012.

Contents of this SQL Server 2012 training

The training course Implementing a Data Warehouse with Microsoft SQL Server 2012 (exam 70-463) is made up of various lessons:

Implementing a Data Warehouse: Design and Deployment

Implementing a Data Warehouse: Create Basic Packages

Implementing a Data Warehouse: ETL Solutions

Implementing a Data Warehouse: Enhancing Packages

Implementing a Data Warehouse: Custom Components

Implementing a Data Warehouse: Installing SSIS

Implementing a Data Warehouse: Troubleshooting

Implementing a Data Warehouse: DQS and MDS Solutions

Prerequisites

You have completed the following training, or you have comparable knowledge:

• Course: Querying Microsoft SQL Server 2012 (exam 70-461)

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:

• Practice Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012

If you order the practice exam directly with your training course you will get an extra discount of $ 30.00 on your practice exam.

Optional LiveLab

To supplement this training course you may add a special LiveLab. You perform the tasks on real hardware and/or software applicable to your Lab. The labs are fully hosted in our cloud. The only thing you need to use our LiveLabs is a web browser. In the LiveLab environment you will find exercises which you can start immediately. The lab enviroment consist of complete networks containing for example, clients, servers, etc. This is the ultimate way to gain extensive hands-on experience. You may order this LiveLab after clicking on the order button and by setting the 'LiveLab' option to 'Yes'. Read more about this LiveLab here:

• LiveLab 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012

When you order a LiveLab combined with your training courses you will get an extra discount of $ 30.00 on your LiveLab.

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.