70-761: Querying Data with Transact-SQL


SKU: LPL-156 Category:

The 70-761 Practice Lab will provide you with the necessary platform to gain hands on skills 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.

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

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