Home/Deals/IT & Software

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

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

4.6 ★★★★★95,091 studentsCreated by Phillip Burton, I Do Data LimitedLast updated Dec 24, 2025🌐 English

What you'll learn

✓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

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?