T-SQL course. The programmer's path from beginner to professional Level 3 - Expert

At this level of the course you will learn to use all the most advanced language constructsthese are analytical operators ROLLUP, CUBE, GROUPING SETS, PIVOT, and window functions (aggregate, ranking, analytical and offset functions) , and the MERGE construct. You will learn 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 Python 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 particularYou must know: how tables, constraints, views and indexes are created, how data is added to tables, how the SELECT statement works, in addition, you must be able to use variables, conditional constructs and loops, as well as be able to work with system functions.

Who is this course for:

1. The course is designed for developers who want to learn T-SQL at a professional level

What you will 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