Developing Microsoft SQL Server 2012 Databases (exam 70-464)

Course details

In this SQL Server 2012 training course you will learn to design and implement database solution based on SQL Server 2012. You will also learn how to implement tables, views and indexes. In addition the main functions are available so you can learn how to work with XML data, stored procedures and optimizing queries.

Among the topics covered are tables & views, indexes. stored procedures, CLR integration, filestream configuration, manipulating data, XML data, optimizing queries and far more.

Your result

You are independetly able to design and implement database solutions based on SQL Server 2012. You are also prepared for Microsoft exam 70-464.

Audience profile

Data warehouse developers and database administrators who design and implement database solutions as a part of their daily work. This training is also intended for everyone who want to achieve the certification MCSE: Data Platform.

Contents of this SQL Server 2012 training

The training course Developing Microsoft SQL Server 2012 Databases (exam 70-464) is made up of various lessons:

Implementing Tables and Views

Implementing Indexes

Stored Procedures

CLR Integration

Working with Data

Working with XML Data

Tuning and Optimizing Queries

Managing and Troubleshooting

Prerequisites

You have completed the following certification track:

• MCSA SQL Server 2012 (Exams 70-461, 70-462 and 70-463)

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-464 (coming soon!)

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-464: Developing Microsoft SQL Server 2012 Databases

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.