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:

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

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

Skills measured

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

The Strength & Power of Our Company

We have a lot of experienced education staff from Microsoft who are ngaged in IT certification examination more than 8 years. They are familiar with past 70-761 real exam questions and they know update information about the 70-761 exam at first time. Our 70-761 Prep & test bundle or exam cram pdf are shown on the website with the latest version. Our IT staff will check the update every day.

Are you still worried about Microsoft 70-761? I advise you to google "Prep4cram". We provide you 70-761 free demo download for your reference. 70-761 Prep & test bundle is very useful and similar with the real exams. If you are willing to pass exam at first shot you had better purchase exam cram, we will send you the exam cram PDF file. It is very available for reading at all electronics and printing out. The most important is that we guarantee: "No Pass, No Pay". We already help more than 3000 candidates pass this exam. We are proud to say that about passing 70-761 we are the best.

Up-to-date Version, Latest, Valid

We promise 70-761 exam cram all we sold is the latest and valid version. If you have doubt about it, you can contact with us. Also you can compare our version with the other. Normally if it is not the latest version we won't say 100% pass rate, we will say 70%-80% pass rate and advise you waiting the updated version. We hereby specially certify that the 70-761 exam cram we say 100% pass is the latest and valid version. Do not hesitate about it, just buy it

Our Golden Service

Firstly we are 7*24 on-line services, once you contact with us we will reply you in two hours;

Secondly we have one-year warranty service since you buy. We will send you the updated 70-761 exam version within one year if you accept. No matter you have any question you can email us to solve it.

Thirdly we will keep your information safe. Even our service customers can't see your complete information. We have a strict information protection system.

Fourthly we guarantee 70-761 exam 100% pass rate if you study our 70-761 prep material hard. But if you fail the exam please provide the unqualified certification scanned and email to us. Once we confirm it we will full refund to you.

Fifthly if you buy 70-761 exam cram for your company and want to get the latest version in next several years we are free to serve you in one year and you can give 50% discount 70-761 Prep & test bundle in next year. Also after you buy you will have priority to get our holiday discount or sale coupon. If you pass 70-761 exam and want to buy other subject we can give you discount too.

All in all we have confidence about 70-761 exam that we are the best. If you want to pass it successfully please choose our 70-761 exam cram pdf. You will be happy about your choice. It's certainly worth it.

Microsoft 70-761 Exam Syllabus Topics:

Section

Weight

Objectives

Topic 1: Program databases by using Transact-SQL

25-30%

- Create database programmability objects by using Transact-SQL

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

- Implement error handling and transactions

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

- Implement data types and NULLs

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

Topic 2: 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

- Modify data

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

- Query multiple tables by using joins

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

- Create Transact-SQL SELECT queries

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

Topic 3: Query data with advanced Transact-SQL components

30-35%

- Query data by using table expressions