2025 Training Lineup

SQL Master Academy presents our 2025 training schedule. Our program is designed to provide comprehensive, hands-on learning for Database Administrators, Developers, and BI professionals. Led by certified instructors - Margarita Naumova , Krasi Donchev , Dejan Sarka and Dian Gospodinov , with vast experience in data management and analytics, our courses ensure participants gain both practical skills and a deeper understanding of the technologies they use every day.

Join us and Raise an Expert!

Querying SQL Server Fundamentals

This is an introductory course in the SQL Server relational databases and T-SQL Language. As such it is a good starting point for gaining proficiency and experience in T-SQL (Transact SQL) and a first step in the SQL Server learning path. The main goal of the training is to introduce the use of the SELECT statement for creating simple to complex queries in a SQL Server Database. The training is developed with focus on gathering of hands-on experience.

More info HERE

PL-300: Microsoft Power BI Data Analyst

This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Finally, this course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.

More info HERE

Mastering SQL Server for Database Developers

The class teaches students tips and tricks for writing highly efficient, performant and scalable stored procedures, batches, transactions. Participants will be shown how to properly code functions, joins, sub-queries, CTEs, and modularize their data access layer code for effectiveness. They will learn how to change their code and use specific code constructs to get the best performance and scalability. Attendees will see some untraditional techniques to get the optimal code performance and avoid pitfalls. Additionally, students will learn the root causes of locking, the role of properly written search arguments, the importance of index optimizations, and the stored procedure parameterization benefits and issues. They will understand how to avoid specific pitfalls in logical database design, how to write effective code and avoid code problems. They will be aware of upcoming technologies in new versions.

More info HERE

DP-3012: Implementing a Data Analytics Solution with Azure Synapse Analytics

This is a single day Instructor Lead Course designed to give the learners instruction on the SQL dedicated and serverless Spark pools and providing instruction of data wrangling and the ELT process using Synapse Pipelines which is very similar to those familiar with Azure Data Factory (ADF) to move data into the Synapse dedicated pool database.

More info HERE

SQL Server High Availability and Disaster Recovery Solutions

The course goal is to dive into SQL Server Technologies and solutions that support and provide service and database availability, to understand, maintain and support them in real environments.

It is very important to know the way availability solutions work to design, implement, and maintain critical production systems and align to SLAs. Developing an overall understanding and familiarity of the basic features and different implementations is relatively simple. What is trickier to develop however, is an understanding of the mechanics (or internals) of Clustering, Availability Groups and Log Shipping and gaining experience of how to manage large scale and critical systems.

This training gives you the important aspects to gain a good understanding of how the Clustering, Log Shipping and Availability group technology works so that you can design, build, and manage a reliable availability solution. It covers HADR in hybrd and cloud environments.

More info HERE

DP-603 Implementing Real Time Analytics with Microsoft Fabric

In this learning path, the student is exposed to various ways to: Source streaming data sources into Microsoft Fabric, Use real time Eventstream in Microsoft Fabric, Query data in a KQL database in Microsoft Fabric, Create real time dashboards in Microsoft Fabric.

More info HERE

DP-602: Implementing a Data Warehouse with Microsoft Fabric

Explore the data warehousing process and learn how to load, monitor, secure and query a warehouse in Microsoft Fabric.

More info HERE

SQL Server Development Fundamentals

This five-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server database. It includes the T-SQL language constructs, programming modules and data layer objects creating. This is the main class for DBAs and DB Developers, who want to have a good foundation of their T-SQL skills.

More info HERE

SQL Server Performance Tuning and Optimization

This Masterclass suits Database administrators who are responsible for the proper and reliable operation of one or more SQL Servers. It also suits to Database Developers who want to know how to optimize their code or to isolate performance issues in the data access layer. Participants will learn how to search and detect problems raising in SQL database, the QP and code Execution. This class includes solid theoretical material, part of which comes directly from the programme team, who develops SQL Server in Microsoft, and unpublished tuning techniques for increasing of SQL Server performance.

More info HERE

This is not our complete course portfolio. You can find the full list on our website: www.sqlmasteracademy.com

If you're interested in a course that isn't currently scheduled or require customized training, feel free to reach out to us: