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

Created by: Phillip Burton • 850,000+ students so far
Best Selling Instructor - over 850,000 students so far

Created by: I Do Data Limited
Improve your skills in SQL, Office, Tableau, Power BI + more

What Will I 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. If you wish to install it on a Mac, you will need either to dual boot into Windows or be running Parallel Desktop.
• 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?

Target audience

• This SQL course is meant for you, if you have not used SQL Server much (or at all), and want to learn T-SQL.
• This course is also for you if you want a refresher on SQL. However, no prior SQL Server knowledge is required.