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