Exam Code: 70-761
Exam Name: Querying Data with Transact-SQL (70-761日本語版)
Certification Provider: Microsoft
Corresponding Certification: MCP
McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams

Over 57017+ Satisfied Customers

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

"Querying Data with Transact-SQL (70-761日本語版)", also known as 70-761 exam, is a Microsoft Certification. With the complete collection of questions and answers, iPassleader has assembled to take you through 205 Q&As to your 70-761 Exam preparation. In the 70-761 exam resources, you will cover every field and category in MCP Certification helping to ready you for your successful Microsoft Certification.

iPassleader offers free demo for 70-761 exam (Querying Data with Transact-SQL (70-761日本語版)). You can check out the interface, question quality and usability of our practice exams before you decide to buy it.

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.)

Custom purchase

Choosing Purchase: "PDF"
Price:$79.98 
  • Three formats are optional
  • 10 years of excellence
  • 365 Days Free Updates
  • Learn anywhere, anytime
  • 100% Safe shopping experience

100% Money Back Guarantee

iPassleader has an unprecedented 99.6% first time pass rate among our customers. We're so confident of our products that we provide no hassle product exchange.

PDF Practice Q&A's $79.98

Download Q&A's Demo
  • Printable 70-761日本語 PDF Format
  • Prepared by VMware Experts
  • Instant Access to Download 70-761日本語 PDF
  • Study Anywhere, Anytime
  • 365 Days Free Updates
  • Free 70-761日本語 PDF Demo Available
  • Updated on: Jul 18, 2026
  • No. of Questions: 205 Questions & Answers
Popular

Online Test Engine $79.98

Try Online Engine Demo
  • Online Tool, Convenient, easy to study.
  • Instant Online Access 70-761日本語 Dumps
  • Supports All Web Browsers
  • 70-761日本語 Practice Online Anytime
  • Test History and Performance Review
  • Supports Windows / Mac / Android / iOS, etc.
  • Updated on: Jul 18, 2026
  • No. of Questions: 205 Questions & Answers

Desktop Test Engine $79.98

Software Screenshots
  • Installable Software Application
  • Simulates Real 70-761日本語 Exam Environment
  • Builds 70-761日本語 Exam Confidence
  • Supports MS Operating System
  • Two Modes For 70-761日本語 Practice
  • Practice Offline Anytime
  • Updated on: Jul 18, 2026
  • No. of Questions: 205 Questions & Answers

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.

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.

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

Download exam skills outline

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

High efficiency

If you want to pass the exam quickly, 70-761日本語 prep guide is your best choice. We know that many users do not have a large amount of time to learn. In response to this, we have scientifically set the content of the data. You can use your piecemeal time to learn, and every minute will have a good effect. In order for you to really absorb the content of 70-761日本語 exam questions, we will tailor a learning plan for you. This study plan may also have a great impact on your work and life. You will definitely get a lot of benefits from it. Of course, the most effective point is that as long as you carefully study the 70-761日本語 study guide for twenty to thirty hours, you can go to the exam. To really learn a skill, sometimes it does not take a lot of time. Come and we teach you how to achieve your goals efficiently.

High quality

In order to ensure the quality of 70-761日本語 actual exam, we have made a lot of efforts. Our company spent a great deal of money on hiring hundreds of experts and they formed a team to write the work. The qualifications of these experts are very high. They have rich knowledge and rich experience on 70-761日本語 study guide. These experts spent a lot of time before the study materials officially met with everyone. They spent a lot of time to collate data and carefully studied the characteristics of the stocks. So the content of 70-761日本語 exam questions you see are very comprehensive, but it is by no means a simple display. In order to ensure your learning efficiency, we have made scientific arrangements for the content of the 70-761日本語 actual exam. Our system is also built by professional IT staff and you will have a very good user experience.

Whether you are a student or a professional who has already taken part in the work, you must feel the pressure of competition now. However, no matter how fierce the competition is, as long as you have the strength, you can certainly stand out. It's not easy to become better. Our 70-761日本語 exam questions can give you some help. After using our study materials, you can pass the exam faster and you can also prove your strength. Of course, our study materials can bring you more than that. Let us now take a look at the advantages of our 70-761日本語 study guide.

DOWNLOAD DEMO

Microsoft 70-761 Exam Syllabus Topics:

TopicDetailsWeights
Program databases by using Transact-SQL

Create database programmability objects by using Transact-SQL
-Create stored procedures, table-valued and scalar-valued user-defined functions, triggers, and views; implement input and output parameters in stored procedures; identify whether to use scalar-valued or table-valued functions; distinguish between deterministic and non-deterministic functions; create indexed views

Implement error handling and transactions
-Determine results of Data Definition Language (DDL) statements based on transaction control statements, implement TRY…CATCH error handling with Transact-SQL, generate error messages with THROW and RAISERROR, implement transaction control in conjunction with error handling in stored procedures

Implement data types and NULLs
-Evaluate results of data type conversions, determine proper data types for given data elements or table columns, identify locations of implicit data type conversions in queries, determine the correct results of joins and functions in the presence of NULL values, identify proper usage of ISNULL and COALESCE functions

25-30%
Manage data with Transact-SQL

Create Transact-SQL SELECT queries
-Identify proper SELECT query structure, write specific queries to satisfy business requirements, construct results from multiple queries using set operators, distinguish between UNION and UNION ALL behaviour, identify the query that would return expected results based on provided table structure and/or data

Query multiple tables by using joins
-Write queries with join statements based on provided tables, data, and requirements; determine proper usage of INNER JOIN, LEFT/RIGHT/FULL OUTER JOIN, and CROSS JOIN; construct multiple JOIN operators using AND and OR; determine the correct results when presented with multi-table SELECT statements and source data; write queries with NULLs on joins

Implement functions and aggregate data
-Construct queries using scalar-valued and table-valued functions; identify the impact of function usage to query performance and WHERE clause sargability; identify the differences between deterministic and non-deterministic functions; use built-in aggregate functions; use arithmetic functions, date-related functions, and system functions

Modify data
-Write INSERT, UPDATE, and DELETE statements; determine which statements can be used to load data to a table based on its structure and constraints; construct Data Manipulation Language (DML) statements using the OUTPUT statement; determine the results of Data Definition Language (DDL) statements on supplied tables and data

40-45%
Query data with advanced Transact-SQL components

Query data by using subqueries and APPLY
-Determine the results of queries using subqueries and table joins, evaluate performance differences between table joins and correlated subqueries based on provided data and query plans, distinguish between the use of CROSS APPLY and OUTER APPLY, write APPLY statements that return a given data set based on supplied data

Query data by using table expressions
-Identify basic components of table expressions, define usage differences between table expressions and temporary tables, construct recursive table expressions to meet business requirements

Group and pivot data by using queries
-Use windowing functions to group and rank the results of a query; distinguish between using windowing functions and GROUP BY; construct complex GROUP BY clauses using GROUPING SETS, and CUBE; construct PIVOT and UNPIVOT statements to return desired results based on supplied data; determine the impact of NULL values in PIVOT and UNPIVOT 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

30-35%

High pass rate

Compared to other products in the industry, 70-761日本語 actual exam have a higher pass rate. If you really want to pass the exam, this must be the one that makes you feel the most. Our company guarantees this pass rate from various aspects such as content and service. Of course, we also consider the needs of users, 70-761日本語 exam questions hope to help every user realize their dreams. The 99% pass rate is a very proud result for us. If you join, you will become one of the 99%. Believe in yourself, you can do it! Buy 70-761日本語 study guide now and we will help you. Believe it won't be long before, you are the one who succeeded!

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.

Skills measured

  • Query data with advanced Transact-SQL components (30-35%)
  • Manage data with Transact-SQL (40-45%)
  • Program databases by using Transact-SQL (25-30%)

Microsoft 70-761日本語 Exam Syllabus Topics:

SectionWeightObjectives
Manage data with Transact-SQL40-45%- Implement functions and aggregate data
  • 1. Use scalar functions
  • 2. Use aggregate functions
  • 3. Use GROUP BY and HAVING
  • 4. Use ranking functions
- Query multiple tables by using joins
  • 1. Handle NULL values in join columns
  • 2. Write queries using outer joins
  • 3. Write queries using inner joins
  • 4. Write queries using cross joins
  • 5. Write queries using self joins
- Create Transact-SQL SELECT queries
  • 1. Construct results from multiple queries using set operators
  • 2. Identify queries that return expected results based on table structure or data
  • 3. Distinguish between UNION and UNION ALL behavior
  • 4. Write queries to satisfy business requirements
  • 5. Identify proper SELECT query structure
- Modify data
  • 1. Write INSERT statements
  • 2. Write UPDATE statements
  • 3. Write DELETE statements
  • 4. Use the OUTPUT statement
Query data with advanced Transact-SQL components30-35%- Query data by using table expressions
  • 1. Use inline table-valued functions
  • 2. Use derived tables
  • 3. Use views
  • 4. Use common table expressions
- Query data by using subqueries and APPLY
  • 1. Use APPLY
  • 2. Use EXISTS and NOT EXISTS
  • 3. Use correlated and non-correlated subqueries
- Query temporal and non-relational data
  • 1. Query temporal tables
  • 2. Query JSON data
  • 3. Output results as XML or JSON
  • 4. Query XML data
- Group and pivot data by using queries
  • 1. Use grouping sets
  • 2. Use PIVOT and UNPIVOT
  • 3. Use ROLLUP and CUBE
Program databases by using Transact-SQL25-30%- Implement error handling and transactions
  • 1. Implement transactions
  • 2. Use THROW and RAISERROR
  • 3. Manage transaction isolation
  • 4. Use TRY...CATCH
- Create database programmability objects by using Transact-SQL
  • 1. Create stored procedures
  • 2. Create views
  • 3. Create user-defined functions
- Implement data types and NULLs
  • 1. Handle NULL values
  • 2. Choose appropriate data types
  • 3. Use implicit and explicit conversions

0 Customer ReviewsCustomers Feedback (* Some similar or old comments have been hidden.)

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Instant Download

After Payment, our system will send you the products you purchase in mailbox in a minute after payment. If not received within 2 hours, please contact us.

365 Days Free Updates

Free update is available within 365 days after your purchase. After 365 days, you will get 50% discounts for updating.

Money Back Guarantee

Full refund if you fail the corresponding exam in 60 days after purchasing. And Free get any another product.

Security & Privacy

We respect customer privacy. We use McAfee's security service to provide you with utmost security for your personal information & peace of mind.