ExamsTrainer

Microsoft 70-761 Exam Preparation

Exam Name: Querying Data with Transact-SQL

191 Total Questions
Aug 19, 2019 updated
  • Exam Code: 70-761
  • Certification Provider: Microsoft
$100

Purchase Individually

Practice Test
$75
191 Total Question Aug 19, 2019 Updated
|
Questions & Answers (PDF)
$69
191 Total Question Aug 19, 2019 Updated
|
Microsoft Querying Data with Transact-SQL Exam Details
Technology SQL Server
Audience IT professionals
Related Certification(s) Microsoft MCSA: SQL 2016 Database Development, Microsoft MCSA: SQL Server 2012/2014 Certifications
Additional Microsoft 70-761 Exam Information
Certification Track Data
Certification Technologies SQL Server
Audience Database Administrator, Database Developer

Discount
Packages

Free 3 month
Product Updates

100% Money Back
Guarantee

100% Real
Questions

User-friendly
Interface

Microsoft 70-761 Exam Major Topics

  • Create Transact-SQL SELECT Queries/ Identify Proper SELECT Query Structure, Write Specific Queries to Satisfy Business Requirements
  • Determine Proper Usage of INNER JOIN, LEFT/RIGHT/FULL OUTER JOIN, and CROSS JOIN
  • Implement Functions and Aggregate Data/ Construct Queries Using Scalar-Valued and Table-Valued Functions
  • Modify Data/ Write INSERT, UPDATE, and DELETE Statements/ Construct Data Manipulation Language (DML) Statements Using the OUTPUT Statement
  • Query Data with Advance Transact-SQL Components/ Query data by Using Subqueries, Table Expressions/ Group and Pivot Data by Using Queries
  • Query Temporal Data and Non-Relational Data/ Query Historic Data by Using Temporal Tables/ Query and Output JSON Data/ Query and Output XML Data
  • Program Databases by Using Transact-SQL/ Create Database Programmability Objects by Using Transact-SQL
  • Implement Error Handling and Transactions/ Implement Data Types and NULLs

Latest Preparation Material by ExamsTrainer

Corporate / Trainer License Program