Microsoft 070-761 : Querying Data with Transact-SQL

  • Exam Code: 070-761
  • Exam Name: Querying Data with Transact-SQL
  • Updated: Jul 29, 2026
  • Q & A: 205 Questions and Answers

Already choose to buy: "PDF"

Total Price: $59.99  

About Microsoft 070-761 Exam Questions

As we all know, certificates are an essential part of one's resume, which can make your resume more prominent than others, making it easier for you to get the job you want. For example, the social acceptance of Microsoft certification now is higher and higher. If you also want to get this certificate to increase your job opportunities, please take a few minutes to see our 070-761 training materials. Carefully written and constantly updated content can make you keep up with the changing direction of the exam, without aimlessly learning and wasting energy. In addition, there are many other advantages of our 070-761 learning guide. Hope you can give it a look.

DOWNLOAD DEMO

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

Easy to understand and suitable for the public

We all know that 070-761 learning guide can help us solve learning problems. But if it is too complex, not only can't we get good results, but also the burden of students' learning process will increase largely. Unlike those complex and esoteric materials, our 070-761 preparation prep is not only of high quality, but also easy to learn. Our study materials do not have the trouble that users can't read or learn because we try our best to present those complex and difficult test sites in a simple way. As long as you learn according to the plan of our 070-761 training materials, normal learning can make you grasp the knowledge points better. Whether you are an experienced top student or a student with poor grades, our 070-761 learning guide can help you get started quickly.

Our 70-761 exam dumps will include those topics:

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

For more info visit: Microsoft Official 70-761 Exam Reference

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

Free trial before purchase

There are three different versions of our 070-761 preparation prep including PDF, App and PC version. Each version has the suitable place and device for customers to learn anytime, anywhere. In order to give you a basic understanding of our various versions, each version offers a free trial. The PDF version of 070-761 training materials supports download and printing, so its trial version also supports. You can learn about the usage and characteristics of our 070-761 learning guide in various trial versions, so as to choose one of your favorite in formal purchase. In fact, all three versions contain the same questions and answers. You can either choose one or all three after payment. I believe you can feel the power of our 070-761 preparation prep in these trial versions.

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
  • Implement and design database programmability objects by using Transact-SQL
  • Create Transact-SQL SELECT queries, query multiple tables by using joins
  • Group and pivot data by using queries
  • Data types
  • Error handling and transactions

Continuous update for question bank

This society is ever – changing and the test content will change with the change of society. You don't have to worry that our 070-761 training materials will be out of date. In order to keep up with the change direction of the exam, our question bank has been constantly updated. We have dedicated IT staff that checks for updates every day and sends them to you automatically once they occur. The update for our 070-761 learning guide will be free for one year and half price concession will be offered one year later. In addition to the constantly update, we have been working hard to improve the quality of our 070-761 preparation prep. I believe that with the help of our study materials, the exam is no longer an annoyance. Hope you can give not only our 070-761 training materials but also yourself a chance.

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 070-761 Exam Syllabus Topics:

SectionWeightObjectives
Query data with advanced Transact-SQL components30-35%- Query temporal and non-relational data
  • 1. Query JSON data
  • 2. Query temporal tables
  • 3. Output results as XML or JSON
  • 4. Query XML data
- Query data by using subqueries and APPLY
  • 1. Use APPLY
  • 2. Use EXISTS and NOT EXISTS
  • 3. Use correlated and non-correlated subqueries
- Query data by using table expressions
  • 1. Use derived tables
  • 2. Use inline table-valued functions
  • 3. Use common table expressions
  • 4. Use views
- 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%- 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
- Implement error handling and transactions
  • 1. Manage transaction isolation
  • 2. Use THROW and RAISERROR
  • 3. Implement transactions
  • 4. Use TRY...CATCH
Manage data with Transact-SQL40-45%- Create Transact-SQL SELECT queries
  • 1. Write queries to satisfy business requirements
  • 2. Identify proper SELECT query structure
  • 3. Identify queries that return expected results based on table structure or data
  • 4. Construct results from multiple queries using set operators
  • 5. Distinguish between UNION and UNION ALL behavior
- Query multiple tables by using joins
  • 1. Write queries using cross joins
  • 2. Handle NULL values in join columns
  • 3. Write queries using outer joins
  • 4. Write queries using inner joins
  • 5. Write queries using self joins
- Implement functions and aggregate data
  • 1. Use ranking functions
  • 2. Use aggregate functions
  • 3. Use scalar functions
  • 4. Use GROUP BY and HAVING
- Modify data
  • 1. Use the OUTPUT statement
  • 2. Write UPDATE statements
  • 3. Write DELETE statements
  • 4. Write INSERT statements

After purchase, 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.)

What Clients Say About Us

The exam cram of BraindumpsPrep is valid. Luckily, I passed. Well begun is half done.

Ada Ada       5 star  

Valid 070-761 exam dumps! It is really helpful! I only used them as my study reference and passed 070-761 exam!

Ursula Ursula       4.5 star  

Passed with only 6 days of studying with the dump file. the question were spot on.

Mandel Mandel       4 star  

That was a huge task based on current scenario of my working hours as well as social activities, but 070-761 study guide let it be a reality within no time.

Ruby Ruby       5 star  

The 070-761 dump questions are exactly the same as the real exam subjects.

Quintion Quintion       5 star  

Pdf exam answers file for 070-761 certification exam is highly recommended for all. I passed the exam with 98% marks. Exam testing engine was also quite helpful.

Baldwin Baldwin       4.5 star  

070-761 dump did my dream come true in a short time. The thing which appeared to be out of the way, BraindumpsPrep made it comfortably accessible. I remain courteously obliged to BraindumpsPrep.

Warner Warner       4 star  

It is really helpful for me who wants to pass 070-761 exam soon. It is valid and accurate. Highly Recommend.

Edward Edward       4 star  

Excellent dumps for 070-761. Valid questions and quite similar to the actual exam. Thank you so much BraindumpsPrep. Cleared my exam yesterday and scored 95%.

Greg Greg       5 star  

Your site is my first choice,with your material i have get 070-761 certification first try.

Murray Murray       4 star  

Thanks a lot for the dumps. I just received my certificate for 070-761 exam after passing my exam well.

Dick Dick       5 star  

I just received the news that I passed the exam. Moreover, I was taken aback by the passing score I received. These 070-761 dumps are really splendid, in my opinion.

Teresa Teresa       4 star  

There was a decent amount of these questions in my exam. Use 070-761 exam cram along which is sufficient to pass.

Bartley Bartley       4 star  

I was very confident on the day of exam and I passed it with magnificent score. The reason of this confidence was my exam preparation that I did using BraindumpsPrep dumps. Best Solution for Passing 070-761 Exam!!!

Matthew Matthew       4.5 star  

BraindumpsPrep pdf file with practise exam software is the best suggestion for all looking to score well. I passed my 070-761 exam with 98% marks. Thank you so much, BraindumpsPrep.

Althea Althea       4.5 star  

LEAVE A REPLY

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

QUALITY AND VALUE

BraindumpsPrep Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.

EASY TO PASS

If you prepare for the exams using our BraindumpsPrep testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.

TESTED AND APPROVED

We are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.

TRY BEFORE BUY

BraindumpsPrep offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.