T-SQL course The path of a programmer from beginner to professional Level 2

During the course we will take a detailed look at the system data types that exist in the SQL server. You will get acquainted with very interesting and important objects of the SQL server, such as: views, indexes, constraints and sequence. You will learn to write more advanced SELECT queries using various system features, such as built-in functions, common table expressions, and temporary tables. In addition, at this level of the course you will learn how to program in the T-SQL language, in other words, you will learn how to use variables, what packages are, how to use conditionals, loops, and various commands. Thanks to this course, you will significantly improve your skills and learn to work with the T-SQL language at an advanced level.

Note! This course assumes that you have certain knowledge and training, in particularYou must know: what a database is, how tables are created, how data is added to tables, how data is changed, and how it is retrieved, i.e. how the SELECT statement works, including joining multiple tables, grouping and sorting data.

Who is this course for:

• The course is designed for developers with basic knowledge SQL who want to improve their skills.

What you will learn:

• Create, modify and delete views, indexes, constraints and sequence
• Write advanced SELECT queries (using built-in functions, CTE, temporary tables)
• Program in T-SQL (using variables, conditionals, loops, various commands)