Practice Lab: Microsoft 70-461 Querying Microsoft SQL Server 2012

Practice Lab
Online Practice Labs, easily accessed from anywhere at any time, are the foundation to practical hands-on skills development enabling users to access real live equipment in a safe test environment.
$149
The MeasureUp Practice Lab for the Microsoft certification exam 70-461 Querying Microsoft SQL Server 2012 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 Create and alter tables, Querying data by using SELECT statements, Implement sub-queries, Design views, Implement data types, modifying data (INSERT, UPDATE, and DELETE statements), Combine datasets, Work with functions and Manage transactions.

These same tasks will help you understand the objectives and competencies required by the Microsoft 70-461 Querying Microsoft SQL Server 2012 certification exam.


Learning Objectives
Learning Time: 16 hours

  • Create and alter tables using Transact SQL syntax
  • Create and alter views
  • Create and modify constraints
  • Create and alter DML triggers
  • Query data by using SELECT statements
  • Implementing Sub queries
  • Implementing Data Types
  • Implementing Aggregate Queries
  • Query and Manage XML Data
  • Modifying Data
  • Working with Functions
  • Optimizing Queries
  • Troubleshooting Queries
PlatformOperating SystemBrowser
Chrome 39 Firefox 34 Internet Explorer 10 and 11 Safari 8
PC W7 x86 X X X
W7 x64 X X X
W8.1 x86 X X X
W8.1 x64 X X X
MAC OSX 10.9 X X X
OSX 10.10 X X X
LINUX Linux x86 X X
Linux x64 X X
Surface Pro Windows 8 X X X
PlatformOperating SystemBrowser
Safari 8 Android Chrome 39 Internet Explorer RT Internet Explorer 11
iPad* IOS 8 X X
iPhone 5 or higher* IOS 8 X X
iPhone 4* IOS 7 X X
Android Tablet* 4.0 or higher X X
Android Phone* 4.0 or higher X X
Lumia 920 or higher* Windows Phone 8.1 X
Surface Windows RT X

*Online use only with these devices


Download System Requeriments

  • Win7, Win8.1, Linux 64 bits, MAC OSX 10.9 and 10.10
  • We no longer support XP