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

Free demo download

After our introductions, if you still have a skeptical attitude towards our Querying Data with Transact-SQL exam study material, please put it down. Now you can download free demo any time 070-761 valid training material for you reference, which provided for your consideration. You just find the target "download for free" that in your website. Then we will send you the demo to email within 10 minutes. We hope that you can find your favorite Microsoft Querying Data with Transact-SQL valid study questions which lead you to success.

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

Skills measured

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

High passing rate with reasonable price

We always believed that the premium content is the core competitiveness of MCP Querying Data with Transact-SQL valid training material, and it also is the fundamental of passing rate. High passing rate is always our preponderance compared with other congeneric products. According to the feedbacks of previous customers who bought our 070-761 exam study material , the passing rate of our study material reaches up to 98%, even to 100%, please be assured the purchase. If you haven't passed the Querying Data with Transact-SQL exam, you can get full refund without any reasons. Secondly, you needn't worry about the price of our Microsoft Querying Data with Transact-SQL latest study guide. The price of our study material is the most reasonable compared with the others in the market. In addition, we will hold irregularly preferential activities and discounts for you on occasion.

Thanks for browsing our website and the attention you pay to our Querying Data with Transact-SQL exam practice questions. It is really the greatest choice that choosing our MCP latest study notes as your partner on the path of learning. Our company has been specializing in Querying Data with Transact-SQL valid study questions and its researches since many years ago. In order to provide the high-quality Querying Data with Transact-SQL valid study questions and high-efficiency learning methods, we hired large numbers of experts who used to be authoritative engineers with many years' experience and educator in this area. So, with the help of experts and hard work of our staffs, we finally developed the entire Querying Data with Transact-SQL exam study material which is the most suitable versions for you. At the meanwhile, we try our best to be your faithful cooperator in your future development, in addition that our 070-761 Querying Data with Transact-SQL exam study materials have quality guarantee and reasonable after-sales service. Here are some details of our Querying Data with Transact-SQL exam study material for your reference.

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:

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

Multi-version choice

We always advanced with time, so we have developed three versions of Querying Data with Transact-SQL exam study material for your reference. If you are full-time learner, the PDF version must be your best choice. It has a large number of actual questions. Furthermore, this version of MCP Querying Data with Transact-SQL exam study material allows you to take notes when met with difficulties. In this way, you can easily notice the misunderstanding in the process of reviewing. We suggest that the PDF version of Querying Data with Transact-SQL exam study material combined with the PC test engine (which provides simulative exam system) will be more effective. If you don't have enough time to study, the APP version of Querying Data with Transact-SQL updated study material undoubtedly is your better choice. This version can be installed in your phone, so that you can learn it everywhere. It is very convenient for you.

High level topics covered by our practice test

This Web Simulator is for Candidates with experience in SQL data queries with relevant work experience in SQL databases. The candidates should also be familiar with the SQL and Transact-SQL.

The Web Simulator will also help candidates who take this exam to find the most appropriate SQL queries to accomplish their goals.

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

Microsoft 070-761 Exam Syllabus Topics:

Section

Weight

Objectives

Topic 1: Manage data with Transact-SQL

40-45%

- Query multiple tables by using joins

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

- Create Transact-SQL SELECT queries

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

- Modify data

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

- Implement functions and aggregate data

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

Topic 2: Program databases by using Transact-SQL

25-30%

- Create database programmability objects by using Transact-SQL

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

- Implement data types and NULLs

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

- Implement error handling and transactions

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

Topic 3: Query data with advanced Transact-SQL components

30-35%

- 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 XML data
3. Query JSON data
4. Output results as XML or JSON

- Group and pivot data by using queries

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

- Query data by using table expressions

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