T-SQL Course (2021)

At this level of the course, you will learn how to use all the most advanced constructions of the language, these are the analytical operators ROLLUP, CUBE, GROUPING SETS, PIVOT, and window functions (aggregate, ranking, analytic and offset functions), and the MERGE construct.

You will learn how to write dynamic SQL statements, use cursors and transactions, and, of course, learn how to create your own functions, stored procedures, and triggers.

In addition, you will learn how to work with XML data, JSON data and the Python language in SQL Server. Learn what In-Memory OLTP is and how to work with this technology.

Note! This course assumes that you have certain knowledge and training, in particular, you should know: how tables, constraints, views and indexes are created, how data is added to tables, how the SELECT statement works, in addition, you should be able to use variables, conditionals constructions and loops, as well as be able to work with system functions.
Source: https://self-learning.ru/course/t-sql-level-3
What will you learn:
1. Use advanced language constructs (ROLLUP, CUBE, GROUPING SETS, PIVOT, MERGE, window functions, cursors).
2. Create your own functions, stored procedures and triggers.
3. Write dynamic SQL statements.
4. Work with transactions, XML and JSON data, and write instructions in Python.
5. Use In-Memory OLTP technology.