70-461, 761: Querying Microsoft SQL Server with Transact-SQL — 94% OFF Discount Coupon

From Tables and SELECT queries to advanced SQL. SQL Server 2012, 2014, 2016, 2017, 2019, and 2022. Helps with DP-600

★4.6 out of 5
96,234 students
Created by Phillip Burton
English
Updated May 2026

Quick Facts — Course Summary

Here's a quick overview of everything you need to know about 70-461, 761: Querying Microsoft SQL Server with Transact-SQL before you enroll:

•Course Name: 70-461, 761: Querying Microsoft SQL Server with Transact-SQL
•Platform: Udemy
•Instructor: Phillip Burton
•Coupon Last Verified: May 13, 2026
•Level: Advanced
•Topic: IT & Software
•Subtopic: IT Certifications
•Total Time: 28h 30m of video content
•Language: English
•Access Type: Unlimited lifetime access + updates
•Certificate: Included upon completion from Udemy
•Main Skills: create tables in a database and ALTER columns in the table. · Know what data type to use in various situations, and use functions to manipulate date, number and string data values. · retrieve data using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
•Requirements: You need to know how to use a computer, and hopefully know how to use a spreadsheet. · No prior knowledge of SQL Server required.
•Current Price: $11.99 (was $199.99). You save $188.00 with 94% discount.
•How to Apply: Click the coupon button to activate your discount automatically
💡
Tip:For best results, apply the coupon in a regular browser window rather than incognito/private mode.

Skills You'll Master

By the end of 70-461, 761: Querying Microsoft SQL Server with Transact-SQL, you'll have these practical skills:

✓create tables in a database and ALTER columns in the table. .
✓Know what data type to use in various situations, and use functions to manipulate date, number and string data values. .
✓retrieve data using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY. .
✓JOIN two or more tables together, finding missing data. .
✓INSERT new data, UPDATE and DELETE existing data, and export data INTO a new table. .
✓Create constraints, views and triggers .
✓Use UNION, CASE, MERGE, procedures and error checking .
✓Apply ranking and analytic functions, grouping, geography and geometry database .
✓Create subqueries and CTEs, PIVOTs, UDFs, APPLYs, synonyms. .
✓Manipulate XMLs and JSONs. .
✓Learn about transactions, optimise queries and row-based v set-based operations.

What You Need Before Starting

Before enrolling in 70-461, 761: Querying Microsoft SQL Server with Transact-SQL, make sure you have:

•You need to know how to use a computer, and hopefully know how to use a spreadsheet.
•No prior knowledge of SQL Server required.
•SSMS cannot be installed on the Mac OS. You need to have a Windows computer, or use a Mac computer which can dual-boot into Windows or using Parallel Desktop with Windows. (However, it will not work under Windows ARM - for example, a Mac M1 or M3.)
•You don't even need SQL Server installed - I'll show you have to install it on your computer for free!
•There is a 30-day money back guarantee of this Udemy course.
•Why not have a look at the curriculum below and see what you can learn?

About This Udemy Course

The following is the full official course description for 70-461, 761: Querying Microsoft SQL Server with Transact-SQL as published on Udemy by instructor Phillip Burton:

Previously available as seven separate courses, now presented in one big course.

Reviews

"The instructor explain the things in great details. Very easy to follow." - Linda Shen

"Excellent course, valuable lessons, very well taught at a great pace." - Shane Tanberg

"Must get tutorial. Love it" - Hayford I Osumanu

"Perfect step by step guide to learning. Best I've seen." - Charles Schweiger

"This course is very well thought out. Its one of the better 70-461 courses on Udemy." - Isrrael M



This course is the foundation for the Microsoft Certificate 70-461: "Querying Microsoft SQL Server 2012" and 70-761 "Querying Data with Transact-SQL". 

Please note - these certificates are no longer being offered by Microsoft. However, the exam requirements allow you to have a good understanding of T-SQL.

It also will help with the current exams DP-300 (Azure Database Administrator Associate) and DP-600 (Implementing Analytics Solutions Using Microsoft Fabric)

Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.



Session 1

The basics presented are: how to install SQL Server, and how to create and drop tables.

We then try to create a more advanced table, but find that we need to know more about data types - so we go into some detail about data types and data functions, the foundation of T-SQL.

Session 2

We'll create tables which use these, and then INSERT some data into them. Then we'll write queries which will retrieve and summary this data, using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.

We'll then JOIN these tables together to find where we are missing data and where we have inconsistent data. We'll then UPDATE and DELETE data from the tables.

Session 3

We'll now use that data to create views, which enable us to store these SELECT queries for future use, and triggers, which allow for code to be automatically run when INSERTing, DELETEing or UPDATEing data.

We'll look at the database that we developed in session 2, and see what is wrong with it. We'll add some constraints, such as UNIQUE, CHECK, PRIMARY KEY and FOREIGN KEY constraints, to stop erroneous data from being added some data.

Session 4

We will further encapsulate our routines by creating procedures, allowing us to EXECUTE parameterised commands with just one statement, and we'll add some error handling with TRY, CATCH and THROW.

We'll also combine datasets together, by looking at UNION and UNION ALL, INTERSECT and EXCEPT, CASE, ISNULL and Coalesce, and the mighty MERGE statement.

Session 5

We'll will now be creating aggregate queries. We'll be reviewing the ranking functions ROW_NUMBER, RANK, DENSE_RANK and NTILE. We'll look at the 8 analytic functions news to SQL Server 2012, such as LAG, LEAD, FIRST_VALUE and LAST_VALUE.

We'll look at alternative ways of grouping and adding totals, using ROLLUP, CUBE, GROUPING SETS and GROUPING_ID. We'll also look at the geometry and geography data types, plotting locations on a grid, together with functions and aggregates.

Session 6

We'll will now be creating sub-queries and correlated subqueries, where the results of the subquery depend on the main query. We'll be looking at Common Table Expressions using the WITH statement, and we'll be using what we have learned to solve a common business problem.

We'll be looking at functions, including the three different types of User Defined Functions (UDF): scalar functions, inline table functions, and multi-statement table functions. We'll then look at synonyms and dynamic SQL, and the use of GUIDs. We'll also look at sequences.

We'll have a look at XML and, for SQL Server 2016 and later, we'll examine JSON and Temporal Tables.

Session 7

In this session we'll be looking at transactions, seeing how to explicitly start and end them, and finding out how they can block other users in the database. Then we'll see about how to indexes and their role in optimising queries. 

We'll also see how we can use Dynamic Management Views to see how we can improve our use of indexes. We'll then look at how to write a cursor, and when to use this row-based operation, and the impact of using scalar UDFs.

No prior knowledge is required - I'll even show you how to install SQL Server on your computer for free!

There are regular quizzes to help you remember the information.

Once finished, you will know what how to manipulate numbers, strings and dates, and create database and tables, create tables, insert data and create analyses, and have an appreciation of how they can all be used in T-SQL.

Compare Similar Courses

This section allows you to compare the current course with similar options to help you make an informed decision by evaluating prices, ratings, and key features side by side.

Compare prices and features to find the best deal for your learning needs

Is the 70-461, 761: Querying Microsoft SQL Server with Transact-SQL Coupon Worth It?

Expert review by Andrew Derek, Lead Course Analyst at CoursesWyn.•Last updated: May 13, 2026.

Based on analysis of the curriculum structure, student engagement metrics, and verified rating data, 70-461, 761: Querying Microsoft SQL Server with Transact-SQL is a high-value resource for learners seeking to build skills inIT & Software. Taught by Phillip Burton on Udemy, the 28h 30m course provides a structured progression from foundational concepts to advanced techniques— making it suitable for learners at all levels. The current coupon reduces the price by 94%, from $199.99 to $11.99, removing the primary financial barrier to enrollment.

✓What We Like (Pros)

  • Verified 94% price reduction makes this course accessible to learners on any budget.
  • Aggregate student rating of 4.6 out of 5 indicates high learner satisfaction.
  • Strong enrollment base with over 96,234 students demonstrates course popularity and trust.
  • Includes an official Udemy completion certificate and lifetime access to all future content updates.

!Keep in Mind (Cons)

The following limitations should be considered before enrolling in 70-461, 761: Querying Microsoft SQL Server with Transact-SQL:

  • The depth of IT & Software coverage may be challenging for absolute beginners without the listed prerequisites.
  • Lifetime access is contingent on the continued operation of the Udemy platform.
  • Hands-on projects and quizzes require additional time investment beyond video watch time.
Final Verdict: Worth It
This course offers exceptional value with current pricing
✓

Course Rating Summary

70-461, 761: Querying Microsoft SQL Server with Transact-SQL Course holds an aggregate rating of 4.6 out of 5 based on 96,234 student reviews on Udemy.

4.6
★★★★★
96,234 Verified Ratings
5 stars
75%
4 stars
15%
3 stars
6%
2 stars
2%
1 star
2%

* Rating distribution is approximated from the aggregate score. Sourced from Udemy.

Instructor Profile

The following section provides background information on Phillip Burton, the instructor responsible for creating and maintaining 70-461, 761: Querying Microsoft SQL Server with Transact-SQL on Udemy.

70-461, 761: Querying Microsoft SQL Server with Transact-SQL is taught by Phillip Burton, a Udemy instructor specializing in IT & Software. For the full instructor biography, professional credentials, and a complete list of their courses, visit the official instructor profile on Udemy.

•Instructor Name: Phillip Burton
•Subject Area: IT & Software
•Teaching Approach: Practical, project-based instruction focused on real-world application of IT & Software skills.

Frequently Asked Questions

The following questions and answers cover the most common queries about 70-461, 761: Querying Microsoft SQL Server with Transact-SQL, its coupon code, pricing, and enrollment process.

About the Author

AD

Andrew Derek

Lead Course Analyst at CoursesWyn with 8+ years of experience evaluating online learning platforms. I've analyzed 500+ Udemy courses and helped thousands of learners choose the right courses for their career goals.

⭐4.8/5 Rating
✓Trusted by 10K+ Students

Explore More Resources

Discover related content and navigation options for IT & Software:

More IT & Software Courses You Might Like

Similar Udemy courses in IT & Software with verified coupons: