Microsoft SQL Server - Transact-SQL language
Advanced level
Duration
Start hour
Level
The training is designed for anyone who wants to learn the technique of using relational databases. The skills acquired during the training can be useful in performing daily tasks in work of a programmer, database administrator as well as an analyst creating various reports and statements.
During the training course, participants will gain knowledge on the use of advanced functionalities of the T-SQL language, in particular windowing, analytical functions, scripting principles, the use of variables, conditional statements and temporary tables. Additionally, the acquired skills will allow you to enrich your own solutions by processing spatial and hierarchical data types. Knowledge of the application of the discussed T-SQL constructs will allow participants to solve analytical problems with a high degree of complication, requiring the execution of entire sequences of operations for processing data in a variety of formats.
After completing the course, the participant will be able to:
The training is designed for those who want to learn the technique of using relational databases. The skills acquired during the training can be useful in the daily work of a programmer, database administrator as well as an analyst creating various reports and statements.
Participants of the training are required to have knowledge of T-SQL to the extent that they are able to create selection, filtering, grouping and data aggregation queries (T-SQL language training scope - basic level).
The training is conducted in the form of alternating mini lectures and practical exercises. It combines technical expertise with practical examples of its use in the work environment.
3 days, 24 training hours
Window functions - use of the OVER clause.
Ranking functions.
Analytical functions.
Examples of the use of window functions
Full-text Search.
Use of spatial and geographic data
Use of hierarchical type (HierarchyID).
Principles of scripting in T-SQL - batches.
The use of variables
Constructions that control the flow of the program (WHILE, IF).
Use of temporary tables.
Differences and similarities in the use of tabular variables and temporary tables.
Processing data using cursors.