Microsoft Querying Data with Transact-SQL Exam Certification Details:

Duration	120 mins
Schedule Exam	Pearson VUE
Exam Name	Microsoft Certified Solutions Associate (MCSA) - SQL 2016 Database Development
Passing Score	700 / 1000
Exam Price	$165 (USD)
Sample Questions	Microsoft Querying Data with Transact-SQL Sample Questions
Number of Questions	40-60
Books / Training	20761: Querying Data with Transact-SQL (three days)
Exam Code	70-761

Schedule exam

Languages: English

This exam is intended for SQL Server database administrators, system engineers, and developers with two or more years of experience who are seeking to validate their skills and knowledge in writing queries.

Reference: https://www.microsoft.com/en-us/learning/exam-70-761.aspx

Exam 70-761: Querying Data with Transact-SQL

This exam retired on January 31, 2021. For currently available options, please refer to the Browse Certifications and Exams page.

Part of the requirements for: MCSA: SQL 2016 Database Development

Download exam skills outline

70-761 - Querying Data with Transact-SQL

The 70-761 exam is part of the Database Core Certification. This exam measures your ability to work with SQL and Transact-SQL.

This certification exam is targeted for professional who perform queries over SQL Server database. The certification is for administrators, system engineers, and developers with one or more years of experience who are seeking to validate their skills and knowledge in writing queries.. This is a list of covered topics:

Using subqueries
Create Transact-SQL SELECT queries, query multiple tables by using joins
Error handling and transactions
Group and pivot data by using queries
Implement and design database programmability objects by using Transact-SQL
Data types

We are born in a good time. Everything changes so fast because of the rapid development of technology. As long as you have good ideas and determination, you will finally harvest happiness. Otherwise, you will achieve nothing. Recently, our 70-761日本語 test cram: Querying Data with Transact-SQL (70-761日本語版) gains much attention among job seekers and students. Even if you know nothing about the knowledges of the 70-761日本語 exam guide, you still can learn well through the help of our 70-761日本語 study materials. Please try to broaden the knowledge when you are still young. You will benefit from your past efforts one day.

Highly similar to the real Querying Data with Transact-SQL (70-761日本語版) exam

Every year there will be many model tests flow into market before the real exam of 70-761日本語 test cram: Querying Data with Transact-SQL (70-761日本語版) is pending. So it is hard for candidates to select. Anyway you urgently need a good Microsoft 70-761日本語 exam guide to prepare for the test. According to our investigation, our predication of the real exam questions is the highest. Many questions of our 70-761日本語 study materials deserve your careful learning. You must revise the important questions and answers of our study guide for many times. As we all know, a wise choice of 70-761日本語 test cram: Querying Data with Transact-SQL (70-761日本語版) is of great significance. You will feel relaxed when you are in the testing room because most of the questions are easy for you to answer. Recently, more and more customers have benefited from our 70-761日本語 exam guide, which is our great motivation for our company to keep going on.

Continuous growth of sales volume

After about ten years' development, our company has become the leader in the education industry. The sales volumes of our 70-761日本語 study materials are growing larger and larger. More than half candidates are using our 70-761日本語 test cram: Querying Data with Transact-SQL (70-761日本語版). Our goal is to become the number one in the market. We are still striving for achieve our ambitious goals. It is our great honor that you can trust our 70-761日本語 exam guide. Frankly speaking, we have held the largest share in the market. Of course, we have invested many efforts to comprehensively raise the quality of the 70-761日本語 study materials. Although we have come across many difficulties, we finally win great success. So must believe that you will embrace a promising future under the help of our 70-761日本語 test cram: Querying Data with Transact-SQL (70-761日本語版). Thanks for all the customers.

Stable system

In our daily life, we always run into troubles in software. Many people cannot tolerate such problems. As for our 70-761日本語 exam guide, you will never encounter annoyed breakdown on your computers. Our system of the 70-761日本語 study materials is very stable. We clearly know that a good operation platform is essential for passing the exam. After all, the study must be completed through our 70-761日本語 test cram: Querying Data with Transact-SQL (70-761日本語版). Our skills of developing the 70-761日本語 exam guide is the most advanced. So you can enjoy the best learning environment on our study guide. We will keep up with our special advantages.

Instant Download: Upon successful payment, Our systems will automatically send the product you have purchased to your mailbox by email. (If not received within 12 hours, please contact us. Note: don't forget to check your spam.)

Microsoft 70-761日本語 Exam Syllabus Topics:

Section

Weight

Objectives

Topic 1: Manage data with Transact-SQL

40-45%

- Implement functions and aggregate data

1. Use GROUP BY and HAVING
2. Use ranking functions
3. Use aggregate functions
4. Use scalar functions

- Query multiple tables by using joins

1. Write queries using inner joins
2. Write queries using self joins
3. Handle NULL values in join columns
4. Write queries using outer joins
5. Write queries using cross joins

- Modify data

1. Use the OUTPUT statement
2. Write DELETE statements
3. Write UPDATE statements
4. Write INSERT statements

- Create Transact-SQL SELECT queries

1. Identify queries that return expected results based on table structure or data
2. Identify proper SELECT query structure
3. Write queries to satisfy business requirements
4. Distinguish between UNION and UNION ALL behavior
5. Construct results from multiple queries using set operators

Topic 2: Program databases by using Transact-SQL

25-30%

- Implement data types and NULLs

1. Handle NULL values
2. Choose appropriate data types
3. Use implicit and explicit conversions

- Create database programmability objects by using Transact-SQL

1. Create user-defined functions
2. Create stored procedures
3. Create views

- Implement error handling and transactions

1. Manage transaction isolation
2. Use THROW and RAISERROR
3. Implement transactions
4. Use TRY...CATCH

Topic 3: Query data with advanced Transact-SQL components

30-35%

- Query data by using subqueries and APPLY

1. Use EXISTS and NOT EXISTS
2. Use APPLY
3. Use correlated and non-correlated subqueries

- Group and pivot data by using queries

1. Use grouping sets
2. Use PIVOT and UNPIVOT
3. Use ROLLUP and CUBE

- Query temporal and non-relational data

1. Output results as XML or JSON
2. Query temporal tables
3. Query JSON data
4. Query XML data

- Query data by using table expressions

1. Use views
2. Use derived tables
3. Use inline table-valued functions
4. Use common table expressions

Microsoft Querying Data with Transact-SQL (70-761日本語版) : 70-761日本語

About Microsoft 70-761日本語 Exam