General
Text

70-761 Online Practice Test

10 Lessons Easy

About this course

This is for you if... your goal is to pass the Microsoft Querying SQL Server 2016 Certification. This practice exam covers 23 areas of study and includes over 200 questions relevant to exam 70-761.

Course Structure

ONLY FOR LOGGED-IN USERS

Practice Quiz (1 of 10) – Basic Queries

Review Questions for 70-761 Certification – Quiz 1

This quiz assumes you’re familiar with the Adventure Works 2012 database; diagrams are provided where needed.

The following topics are covered in this Quiz:

  • SQL Overview
  • Writing Select Queries
  • Sorting Data
ONLY FOR LOGGED-IN USERS

Practice Quiz (2 of 10) – Data Types

Review Questions for 70-761 Certification – Quiz 2

This quiz assumes you’re familiar with the Adventure Works 2012 database; diagrams are provided where needed.

SQL Data types are covered in this Quiz:

ONLY FOR LOGGED-IN USERS

Practice Quiz (3 of 10) – Built-in Functions

Review Questions for 70-761 Certification – Quiz 1

This quiz assumes you’re familiar with the Adventure Works 2012 database; diagrams are provided where needed.

The Built-in Functions are covered in this Quiz.

ONLY FOR LOGGED-IN USERS

Practice Quiz (4 of 10) – Grouping Data, Set Operators, and Joins

Review Questions for 70-761 Certification – Quiz 4

This quiz assumes you’re familiar with the Adventure Works 2012 database; diagrams are provided where needed.

The following topics are covered in this Quiz:

  • Grouping and Aggregating Data
  • Set Operators
  • Joins
ONLY FOR LOGGED-IN USERS

Practice Quiz (5 of 10) – Subqueries and CTE’s

Review Questions for 70-761 Certification – Quiz 5

This quiz assumes you’re familiar with the Adventure Works 2012 database; diagrams are provided where needed.

The following topics are covered in this Quiz:

  • Subqueries
  • Common Table Expressions
ONLY FOR LOGGED-IN USERS

Practice Quiz (6 of 10) – Data Modification Statements

Review Questions for 70-761 Certification – Quiz 6

This quiz assumes you’re familiar with the Adventure Works 2012 database; diagrams are provided where needed.

The following topics are covered in this Quiz:

  • Modifying Data
  • Windows Functions
  • Pivoting and Grouping
ONLY FOR LOGGED-IN USERS

Practice Quiz (7 of 10) – Stored Procedures

Review Questions for 70-761 Certification – Quiz 7

This quiz assumes you’re familiar with the Adventure Works 2012 database; diagrams are provided where needed.

The following topics are covered in this Quiz:

  • Stored Procedures
  • Error Handling
ONLY FOR LOGGED-IN USERS

Practice Quiz (8 of 10) – Transactions and Isolation Levels

Review Questions for 70-761 Certification – Quiz 8

This quiz assumes you’re familiar with the Adventure Works 2012 database; diagrams are provided where needed.

The following topics are covered in this Quiz:

  • Transactions
  • Isolation Levels
ONLY FOR LOGGED-IN USERS

Practice Quiz (9 of 10) – Creating Tables and Views

Review Questions for 70-761 Certification – Quiz 9

This quiz assumes you’re familiar with the Adventure Works 2012 database; diagrams are provided where needed.

The following topics are covered in this Quiz:

  • Creating Tables and Views
  • Temporal Tables
ONLY FOR LOGGED-IN USERS

Practice Quiz (10 of 10) – XML, JSON and Query Optimization

Review Questions for 70-761 Certification – Quiz 10

This quiz assumes you’re familiar with the Adventure Works 2012 database; diagrams are provided where needed.

The following topics are covered in this Quiz:

  • XML Data
  • JSON
  • Query Optimization
Pen