70-461, 761: Querying Microsoft SQL Server with Transact-SQL [Udemy Coupon Code]

"When you purchase something through one of the links on our site, we may earn an affiliate commission at no additional cost to you."

Limited offer hurry up

70-461, 761: Querying Microsoft SQL Server with Transact-SQL is a top-rated Udemy course taught by Phillip Burton • 920000+ students so far, I Do Data Limited — with over 92829+ students enrolled since it launched.

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

Don’t wait! This special offer won’t last long.

Click the button below to Get up to 100% OFF the regular price.

(The discount will be applied automatically at checkout — no code needed!)

Hurry — this discount on 70-461, 761: Querying Microsoft SQL Server with Transact-SQL won’t be around forever. Take action now!

100% off Udemy coupon code

Why enroll in the 70-461, 761: Querying Microsoft SQL Server with Transact-SQL Udemy Course?

  • Udemy gives you access to over 250,000 courses and 85,000 expert instructors worldwide.
  • Courses are led by experienced professionals dedicated to delivering a high-quality learning experience.
  • Many of Udemy’s most popular courses have hundreds of thousands of students enrolled.
  • Udemy offers online coupons, promo codes and voucher for the majority of its courses.

70-461, 761: Querying Microsoft SQL Server with Transact-SQL Udemy Promotion code

Course Sections
Session 1 – Let’s begin, and let’s download SQL Server
Session 1 – Starting SQL Server
Session 1 – Creating tables – First pass
Session 1 – Number types and functions
Session 1 – String data types and functions
Session 1 – Date data types and functions
Session 1 – Conclusion
Welcome to Session 2
Session 2 – Creating and querying part of a table
Session 2 – Summarising and ordering data
Session 2 – Adding a second table
Session 2 – Find missing data, and delete and update data
End of Session 2
Session 3 – Introduction
Session 3 – Objective 4 – Create and modify constraints (simple statements)
Session 3 – Objectives 2 and 3: Views
Session 3 – Objective 5: Create and alter DML triggers
Session 3 – Conclusion
Session 4 – Introduction
Session 4 – Objective 13: Combine datasets
Session 4 – Objective 11 – Create and alter stored procedures (simple statements
Session 4 – Objective 18a – Implement try/catch/throw
End of Session 4!
Session 5 – Introduction
Session 5 – Objective 9: Implement aggregate queries
Session 5 – Objective 9d: Ranking functions
Session 5 – Objective 9a: New analytic functions
Section 5 – Objective 9b: Grouping sets
Session 5 – Objective 9c: Spatial aggregates
End of Session 5
Session 6 – Introduction
Session 6 – Objective 7: Sub-queries
Session 6 – Objective 7e: WITH statement
Session 6 – Objective 7b: PIVOTing and UNPIVOTing
Session 6 – Objective 7d: CTE statement
Session 6 – Objective 14: Functions
Session 6 – Objectives 6b and 6c: Synonyms and Dynamics
Session 6 – Objectives 8c: GUIDs; and Sequences
Session 6 – Objective 10: Query and manage XML data – converting tables to XML
Session 6 – Objective 10: Shredding XML data
Session 6 – Objective 10: Other XML considerations
Session 6 – Manipulating JSON data (SQL Server 2016 onwards)
Session 6 – Temporal Tables
Session 6 – Conclusion
Session 7 – Introduction
Session 7 – Manage transactions
Session 7 – Indexes
Session 7 – Optimise queries
Session 7 – Dynamic Management Views and Functions
Session 7 – Evaluate the use of row-based operations vs. set-based operations
Congratulations
Course Description
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.
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?

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.