Querying Microsoft SQL Server 2012 (exam 70-461)

Course details

In this SQL Server 2012 training course you will learn the Transact-SQL query language for Microsoft SQL Server 2012. With Transact-SQL you can request data and manipulate it in a SQL Server database. On completion of the course you are prepared for the MCSA exam 70-461.

Among the topics covered are creating database objects, querying basics and modifying data, manipulate data using operators and functions, creating functions and triggers, creating programming objects, optimizing queries, managing XML data and much more.

Your result

You can work with Transact-SQL for Microsoft SQL Server 2012. You can manipulate data and are familiar with a database environment, using Transact-SQL.

Audience profile

DBAs, administrators, database designers, support engineers wanting to learn the basis of Microsoft Transact-SQL for SQL Server 2012. Also this training is for everybody who want to achieve the certification MCSA: SQL Server.

Contents of this SQL Server 2012 course

The Querying Microsoft SQL Server 2012 (exam 70-461) training course is comprised of a number of lessons:

Creating Database Objects

Querying Basics and Modifying Data

Manipulate Data Using Operators and Functions

Creating Functions and Triggers

Creating Programming Objects and Optimizing Queries

Managing XML Data

Prerequisites

You have some experience with Microsoft SQL Server. You also have a basic knowledge of relational database concepts and you are familiar with the role of a database administrator.

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-461: Querying 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-461: Querying Microsoft SQL Server 2012

If you order the LiveLab directly with your training course 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.