Training advanced SQL Databases for Advanced Users is designed to upgrade existing SQL knowledge with advanced functionality to optimize performance and use advanced SQL functionalities. Training covers the advanced use of SQL services such as views, triggers and stored procedures which improves performance and incorporates automation mechanism.
v2
Choose the type of application, provide any optional details and we will contact you back soon.
Training SQL Databases for Advanced Users is designed to upgrade existing SQL knowledge with more advanced functionality to optimize workflow and use advanced SQL functionalities.
Training covers the advanced use of SQL servers such as views, indexes, and stored procedures enhancing performance and embedding automation mechanisms. After that, the students will go through common table expression, window functions, subqueries, functions and procedures, work with strings, work with date type data, and pivot function.
Workshops will be done on the Microsoft SQL Server database, the market leader in the database market for the last ten years, and the knowledge learned in this training can be applied to any other database (Oracle, MySQL, PostgreSQL, Amazon Redshift, Google Big Query).
Training is designed for all users who have basic knowledge of SQL and database work, and want to improve them to optimally use database and data. Knowledge of content covered in the training SQL Databases Fundamentals for Data Analysis is essential to mastering the contents of this training.
After the training, you will be prepared to work on advanced query query functionalities using SQL query language and use analytic tools (Tableau, Power BI, Excel) over the database.
In this module you will learn what are views, how to create them and how to use them in typical scenarios.
In this module, you will learn what triggers are, where they can be used within a database and various implementation scenarios. All forms of triggers, syntax with them, and typical usage patterns will be covered.
This module covers the use of indexes, how they are created, their purpose and application. There will be an overview of them (B-trees), different index forms, and basic indexing strategies in databases.
Through this module, the students will master the use of subqueries, syntax writing and optimization, and through practical examples to include the principles of support and their typical application.
This module covers the area of use of common table expressions, advanced functionality that allows working with hierarchies and recursions. The module will show the syntax of writing all typical CTE applications and show their parallel with the support.
Through this module the students will master the work with stored procedures and functions, with emphasis on the differences in implementation and use and their application in databases.
In this module, special emphasis is placed on working with strings, their way of writing, built-in functions to work with strings, and typical problems that users can encounter.
The module covers working with date type data, which often creates problems for users during work. In addition to the functions to work with them, special remarks are given to the most common mistakes and problems that occur when using the date type data.
This module includes work with window functions, which allow the data to be distributed to the keys in the panes and to apply functions to them. The participants will master the syntax of the window functions, after which typical examples of usage will be displayed.
Through the module, the student will learn how to use pivot function, one of the most used data analytics principle. The module includes an introduction to the pivot concept, the syntax of writing PIVOT and UNPIVOT queries, the specificity of using the query itself, and the typical usage scenarios.
You can officially register for the training via the registration form at the top of this page. After successfully sending the application, we will get back to you within 24 hours of receiving the application.
Mistakes in communication always happen, and if we don’t answer you, contact us directly at birdacademy@inteligencija.com
We currently do not support payment in multiple installments.
Of course, all our trainings can be followed virtually.
Students are entitled to a 10% discount on the price shown on this page.
BIRD Academy provides a computer, lunch, coffee and water for each participant. We strive to be the best host possible in every segment!
