70-461, 761: Querying Microsoft SQL Server with Transact-SQL
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
Product Brand: Udemy
4.5
Udemy Coupon Code for 70-461, 761: Querying Microsoft SQL Server with Transact-SQL Course. 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, I Do Data Limited | 28.5 hours on-demand video course | 26 downloadable resources
Microsoft SQL Server Course Overview
70-461, 761: Querying Microsoft SQL Server with Transact-SQL
This 70-461, 761: Querying Microsoft SQL Server with Transact-SQL 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. 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.
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
Recommended Microsoft SQL Server Course
SQL Server Integration Services (SSIS) – An Introduction Best seller
SQL Essentials – Thinking in SQL form Beginners to Pro Hot & NEW
Who this course is for:
- 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.
Instructor
My courses include Power BI, Tableau, SQL Server, Power Platform (Power Apps, Power Automate, etc.), Azure, Microsoft Office, and more. Many of my courses follow requirements for official Microsoft certifications – so with a bit of practice, you could enter the exam and put it on your CV or resume.
I have been a Computing Consultant providing expert services in the development of computer systems and data analysis. I am one of 9 award winning Experts for Experts Exchange’s 11th Annual Expert Awards. My interests are working with data, including Microsoft Power BI, Excel, Access, SQL Server, and the Power Platform.
