Duration: 24 hours / 3 days
Knowledge: Intermediate
Trainer: Tomislav Hlupić
Training Methods: Virtual Class

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.

Fill-in all the required fields, provide any optional details and we will contact you back soon.
  • Select preferred training method
  • How many of your employees need the training?
Overview

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).

Audience

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.

What you will learn

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.

Syllabus

In this module you will learn what are views, how to create them and how to use them in typical scenarios.

  • Workshop

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.

  • Workshop

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.

  • Workshop

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.

  • Workshop

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.

  • Workshop

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.

  • Workshop

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.

  • Workshop

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.

  • Workshop

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.

  • Workshop

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.

  • Workshop

Would you like to apply for this education?