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.53 (17477 reviews)
91,841
students
28.5 hours
content
Jan 2025
last update
$139.99
regular price
What you will 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
Screenshots
555384
udemy ID
7/15/2015
course created date
6/23/2019
course indexed date
Bot
course submited by