70-464: Developing SQL Server 2012 Databases


SKU: LPL-142 Category:

The 70-464 Practice Lab will provide you with the necessary platform to gain hands on skills in Microsoft SQL Server 2012. By completing the lab tasks you will improve your practical skills in managing tables with complex statements, implementing database security and manage transactions and isolation levels. You will also maintain indexes, implement different data types, modifying constraints and working with XML data. Finally you will create automation scripts, manage views and indexes, tune queries and use estimation plans.

These same tasks will help you understand the objectives and competencies required by the MCSE: Developing Microsoft SQL Server 2012 Databases certification exam.

Who should take this exam?

This exam is intended for database professionals who build and implement databases across organizations and ensure high levels of data availability. Responsibilities include creating database files, data types, and tables; planning, creating, and optimizing indexes; insuring data integrity; implementing views, stored procedures, and functions; and managing transactions and locks.

About Practice Labs

In today’s world of complex computer systems and technologies it’s essential that both those new to IT and seasoned professionals alike gain hands on experience. Our state-of-the-art platform brings training theory to life giving the user greater depth of technology ensuring their ability to demonstrate how to use and understand vendor products and software.

Get the hands on learning you need without spending significant amounts of money on your own equipment. We deliver real equipment with the ease and convenience of your web browser, allowing you to develop real world IT skills.


  • Risk free platform to develop practical IT skills in all the latest technologies
  • Real world and exam related practical tasks
  • Real equipment NOT simulations
  • Simply accessed from a web browser, anytime, anywhere – 24/7

Learning Objectives

Create and alter tables
Design, implement,and troubleshoot security
Design the locking granularity level
Maintain indexes
Implement data types
Create and modify constraints
Work with XML data
Write automation scripts
Design and implement stored procedures
Design T-SQL table-valued and scalar functions
Create, use, and alter user-defined functions (UDFs)
Create and alter views
Create and alter indexes
Optimize and tune queries
Troubleshoot and resolve performance problems
Optimize indexing strategies
Capture and analyze execution plans
Collect performance and system information