Practice Lab: 70-761 - Querying Data with Transact-SQL

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 70-761 Practice Lab will provide you with the necessary platform to gain hands on skills for Microsoft SQL Server 2016. By completing the lab tasks you will improve your practical skills in managing data with Transact-SQL, querying data with advanced Transact-SQL components and programming databases using Transact-SQL.

These same tasks will help you understand the objectives and competencies required by the Microsoft 70-761 Querying Data with Transact-SQL exam.


Learning Objectives
Learning Time: 16 hours

  • Working with SELECT Queries
  • Working with SET Operators
  • Using Joins
  • Implementing Functions
  • Working with Aggregate Data
  • Working with Built-in Functions
  • Modifying Data
  • Working with Subqueries
  • Working with Apply Operators
  • Working with Table Expressions
  • Grouping and Pivoting Data
  • Working with Temporal Table
  • Working with Non-relational Data
  • Working with Stored Procedures and Views
  • Implementing Error Handling
  • Working with Data Types and Null Values
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