Querying Microsoft SQL Server 2012 (exam 70-461)

In this 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 the training course

The 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