Microsoft SQL Server Training in Belgrade

This instructor-led, live training in Belgrade (online or onsite) is aimed at intermediate-level database administrators who wish to learn the necessary skills and knowledge to effectively manage and administer SQL Server databases using SQL Server Management Studio.

By the end of this training, participants will be able to:

• Understand system requirements and perform installations.
• Create, configure, and manage databases using SSMS.
• Manage logins, users, roles, and permissions.
• Perform various types of backups and restore databases.
• Create, schedule, and manage jobs using SQL Server Agent.
• Implement best practices for efficient and secure SQL Server administration.

The DP-300T00: Administering Microsoft Azure SQL Solutions certification is a testament to an IT professional's skills in managing and implementing database solutions in the cloud on Microsoft Azure. It validates one’s proficiency in managing Azure SQL Server instances, databases, and usage of T-SQL. This certification is pivotal in industries seeking digital transformation as it ensures that the certified professional can efficiently handle data management, migration, and performance tuning in Azure environments. Obtaining the DP-300T00 certification enhances the recipients' credibility, making them a valuable asset in the IT industry, particularly in roles related to database administration and management.

SQL Server is Microsoft’s enterprise-level relational database management system designed to efficiently store, manage, and retrieve data.

This instructor-led, live training (available online or on-site) is aimed at intermediate IT professionals who wish to administer, configure, and maintain SQL Server environments.

By the end of this training, participants will be able to:

• Install and configure SQL Server environments.
• Manage databases, users, and permissions effectively.
• Monitor performance and troubleshoot any issues that arise.
• Automate tasks using jobs and maintenance plans.

Format of the Course

• Interactive lectures and discussions.
• Extensive exercises and practice sessions.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

This instructor-led, live training in Belgrade (online or onsite) is aimed at intermediate-level to advanced-level database administrators who wish to deepen their knowledge of SQL Server for efficient database management, performance tuning, high availability, and advanced troubleshooting.

By the end of this training, participants will be able to:

• Administer and configure SQL Server instances using best practices.
• Optimize performance of queries and databases.
• Implement high availability and disaster recovery strategies.
• Diagnose and resolve complex issues in production environments.A

SQL Server Integration Services (SSIS) is a component of Microsoft SQL Server that offers a platform for data integration and workflow applications. It is commonly used for tasks such as data migration, warehousing, and transformation.

This instructor-led, live training (available online or on-site) is designed for intermediate-level data professionals and developers who aim to enhance their skills in designing advanced SSIS data flows, transformations, and managing Slowly Changing Dimensions (SCD) for data warehousing scenarios.

By the end of this training, participants will be able to:

• Create and implement robust data flows using SSIS.
• Work with various data sources, destinations, and transformations.
• Implement Slowly Changing Dimensions (SCD) to manage historical data changes effectively.
• Deploy, execute, and troubleshoot SSIS packages efficiently.

Format of the Course

• Interactive lectures and discussions.
• Extensive exercises and practice sessions.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

This instructor-led, live training in Belgrade (online or onsite) is aimed at intermediate-level software developers and automation engineers who wish to build applications that communicate with PLCs and interact with SQL databases using Visual Studio.

By the end of this training, participants will be able to:

• Develop .NET applications in Visual Studio for industrial automation.
• Communicate with PLCs using industrial protocols such as OPC UA.
• Implement database interactions with SQL Server for storing and retrieving PLC data.
• Optimize application performance for real-time industrial environments.

This instructor-led, live training in Belgrade (online or onsite) is aimed at beginner-level data professionals who wish to learn how to design, implement, and manage SSIS packages to perform data integration and transformation tasks.

By the end of this training, participants will be able to:

• Understand the architecture and components of SSIS.
• Design and implement ETL processes using SSIS.
• Use SSIS tools to develop, deploy, and manage data integration solutions.
• Troubleshoot and optimize SSIS packages for performance and reliability.

This instructor-led live training in Belgrade (on-site or remote) is aimed at database administrators, SQL developers, and data analysts who wish to deepen their specialized knowledge in SQL. It covers advanced topics related to database management, optimization, and performance tuning.

By the end of this training, participants will be able to:

• Optimize database performance through effective database preparation and DBO.
• Utilize and manage user-defined data types (UDDT) and user-defined types (UDT).
• Effectively handle spatial data types, including geographical and geometric data.
• Improve hierarchical data management, including structural elements, storage methods, and indexing strategies.
• Enhance query performance using advanced techniques such as data indexing, query execution plan analysis, and SQL query execution control.

This SQL training course is designed for individuals who wish to acquire the essential skills needed to extract and analyze data from any database and generate reports. Participants will learn:

• how to write SQL queries
• what relational databases are and how they can be utilized
• the concept of relations and how to establish them
• the structure of data
• the differences between T-SQL and other SQL dialects
• practical techniques for writing effective queries

This SQL course focuses on the Microsoft T-SQL dialect. If you are interested in a more general introduction to SQL, please consider the SQL Fundamentals course.

The goal of this course is to offer a comprehensive understanding of advanced SQL techniques for Microsoft SQL Server, as well as the sophisticated use of Transact-SQL. To delve deeper into these topics, the course can be extended to a three-day format.

Participants will gain an understanding of some of the more advanced features of Transact SQL, as well as being able to accomplish each of the following:

• Use queries to generate complex result sets
• Manage database objects to enhance query performance
• Optimize queries for better efficiency

This course is designed for anyone who currently uses Transact SQL to extract data from a Microsoft SQL Server database and aims to expand their knowledge, particularly in the areas of data analysis and improving query speed.

Participants will gain an understanding of the fundamental principles of Structured Query Language, as well as the ability to perform the following tasks:

• Build queries to retrieve and filter data from an SQL Server database
• Create summarised results
• Modify, derive, and format data to meet specific output requirements
• Update data and manage database components and definitions

This course is designed for anyone who needs to extract information from a Microsoft SQL Server database. It is suitable for both system developers and individuals from other departments who require the use of SQL for data extraction and analysis.

This SQL training course is designed for individuals who wish to develop fundamental skills in working with SQL Server Databases. The course will assist participants in learning:

• How to effectively use SQL Server and SQL Server Management Studio.
• The concepts of databases, SQL, and RDBMS.
• How to create tables and utilize DDL, DML, and DAL commands.
• An overview of the different RDBMS packages available in the market and how they compare.
• An introduction to NoSQL databases and the ways organizations are transitioning to hybrid database systems.

Administering a SQL Database Infrastructure MOC 20764-C course imparts skills and knowledge to manage and maintain SQL Server databases while operating on a SQL database infrastructure.

About This Course

This three-day, instructor-led course is designed for individuals looking to transition into a database professional role or whose job responsibilities are expanding to include database elements. The course covers fundamental database concepts, including types of databases, database languages, and design principles.

Audience Profile

The primary audience for this course includes those who are moving into a database role or whose roles now encompass database technologies.

At Course Completion

Upon completing this course, students will be able to:
• Explain key database concepts in the context of SQL Server 2016
• Identify and describe the database languages used in SQL Server 2016
• Apply data modeling techniques
• Understand normalization and denormalization techniques
• Recognize different relationship types and their impacts on database design
• Evaluate the effects of database design on performance
• Work with commonly used database objects

The course is tailored for administrators, developers, and database developers.

The objectives of the training:

• To acquire and enhance skills in creating and managing databases
• To gain knowledge of SQL syntax and its application in retrieving and modifying data
• To implement security measures within the database
• To utilize advanced features such as replication, automation, and business intelligence (BI)
• To leverage Microsoft SQL Server capabilities for generating complex reports and solutions for developers

This training is focused on the fundamentals of creating a data warehouse environment using MS SQL Server 2008.

Participants in this course will gain a solid foundation in designing and building a data warehouse that operates on MS SQL Server 2008.

They will learn how to construct a basic ETL process using SSIS, followed by designing and implementing a data cube with SSAS.

The participants will also develop the skills needed to manage an OLAP database, including creating and deleting databases, processing partition changes online, and more.

Additionally, they will acquire knowledge of scripting in XML/A and MDX.

This course is designed for participants who are already familiar with SQL in the Microsoft SQL Server Environment 2008/2012. The focus of the course is on set-based querying and query optimization, including working with indexes and analyzing execution plans.

The training also delves into table expressions, ranking functions, and strategies for managing partitioned tables.

This instructor-led, live training in Belgrade (online or onsite) is aimed at beginner to intermediate-level developers and database administrators who wish to gain proficiency in SQL Server 2012 Integration Services.

By the end of this training, participants will be able to:

• Understand the principles of ETL and the role of SSIS.
• Create, deploy, and manage SSIS packages.
• Design and implement Control Flow to define the flow of tasks in a package.
• Implement Workflow and set up constraints for effective task execution.
• Construct Data Flows to extract, transform, and load data.
• Work with Variables and Containers to enhance package flexibility.
• Manage Transactions to ensure data consistency.
• Implement effective error handling and debugging techniques.
• Set up Logging for tracking and monitoring.
• Handle Slowly Changing Dimensions for managing changing data.
• Deploy a Package for production use.
• Implement Security measures to protect sensitive data.
• Utilize Scripting to extend SSIS functionality.
• Apply Best Practices for efficient and maintainable SSIS solutions.

Audience

• Database Administrator
• Developers

This three-day instructor-led course is designed to introduce students transitioning from earlier versions of SQL Server to the new features available in SQL Server 2016.

Skills Gained

• Understand the key capabilities and components of SQL Server 2016
• Explore new and enhanced performance features in SQL Server
• Learn about new and improved security features in SQL Server
• Familiarize yourself with the latest advancements in SQL Server Availability and Scalability
• Discover new and enhanced reporting and PowerBI functionalities in SQL Server 2016
• Gain insights into new and improved data access features
• Explore new and enhanced features in SQL Server OLAP
• Understand the new cloud capabilities of SQL Server

This five-day instructor-led course equips students with the knowledge and skills necessary to manage a Microsoft SQL Server 2014 database effectively. The course emphasizes the practical use of SQL Server 2014 features and tools that are essential for maintaining a robust database environment.

Note: This course is tailored for individuals interested in learning about SQL Server 2012 or SQL Server 2014. It not only highlights the new features introduced in SQL Server 2014 but also covers the critical capabilities across the entire SQL Server data platform.

The SQL 2016 Querying course 20761 aims to impart skills on writing queries for Transact-SQL language.

This five-day instructor-led course equips students who manage and maintain SQL Server databases with the necessary knowledge and skills to effectively administer an SQL Server database infrastructure. It is also beneficial for those who develop applications that retrieve content from SQL Server databases.

This course is designed to instruct students on provisioning SQL Server databases, covering both on-premises environments and SQL Azure.

Serving as the cornerstone of the Microsoft data platform, SQL Server stands out as a premier operational database management system.

This training is designed to introduce participants to a range of advanced solutions for data types and database structures. Participants will learn how to work with spatial type data, hierarchical type data, XML type data, and handle data in JSON format.
Upon completion of the training, the participant:
▪ will be able to utilize various advanced solutions for data types and database structures
▪ will be able to process data from and to JSON format.

This training course is designed to acquaint participants with the security principles of relational databases, learn how to manage backups, and handle user access rights to specific resources. Participants will also gain knowledge on securely storing data and protecting sensitive information, as well as monitoring the database and server for security purposes.

Upon completing the training, the participant:
▪ will be familiar with the security principles of relational databases
▪ will know how to use database backups
▪ will be able to extract useful data from the database
▪ will be capable of managing user access rights to specific resources
▪ will understand how to securely store data
▪ will know how to protect sensitive information
▪ will be able to monitor the database and server for security.

This training is designed to equip you with the knowledge needed to configure the database server according to your specific requirements, create effective procedures for monitoring its various components, and respond promptly to any issues that may arise. Upon completing this training, participants will be able to efficiently diagnose performance problems in SQL Server operations and implement various strategies to eliminate so-called "bottlenecks."

Upon completion of the training, the participant:
▪ will be able to identify and diagnose "bottlenecks" in the database and/or server operation
▪ will be capable of monitoring the performance of SQL Server
▪ will have the knowledge to recommend improvements for enhancing the performance of the database and server.

The course addresses questions such as:

• How to construct a query?
• What opportunities does SQL offer?
• What is a relational database?
• What is the structure and what are the SQL commands?

Microsoft SQL Server is a relational database management system (RDBMS) designed for storing and retrieving data.

In this instructor-led, live training (either onsite or remote), participants will learn the fundamental aspects of the SQL language necessary to query a Microsoft SQL Server database effectively.

By the end of this training, participants will be able to:

• Install and configure Microsoft SQL Server
• Query a Microsoft SQL Server database using Microsoft's Transact-SQL (T-SQL) language
• Grasp the essentials of database design
• Enhance a database through normalization techniques
• Utilize aggregate functions to produce results similar to those from "pivot-tables"
• Connect to Microsoft SQL Server using Excel

Audience

• Data analysts
• Business Intelligence professionals
• Business managers
• Excel experts looking to expand their analytical skills

Format of the Course

• Interactive lectures and discussions
• Numerous exercises and practice sessions
• Hands-on implementation in a live-lab environment

Course Customization Options

• This training is based on the latest version of Microsoft SQL Server
• For customized training for this course, please contact us to arrange.

SSAS (SQL Server Analysis Services) is a Microsoft SQL Server tool designed for transactional processing (OLAP) and data mining, enabling the analysis of data across multiple databases, tables, or files. The semantic data models provided by SSAS are utilized by client applications such as Power BI, Excel, Reporting Services, and other data visualization tools.

In this instructor-led, live training (available both onsite and remotely), participants will learn how to leverage SSAS for analyzing large volumes of data in databases and data warehouses.

By the end of this training, participants will be able to:

• Install and configure SSAS
• Understand the relationship between SSAS, SSIS, and SSRS
• Apply multidimensional data modeling techniques to derive business insights from data
• Design OLAP (Online Analytical Processing) cubes
• Query and manipulate multidimensional data using the MDX (Multidimensional Expressions) query language
• Deploy practical BI solutions using SSAS

Audience

• BI (Business Intelligence) professionals
• Data Analysts
• Database and data warehousing experts

 
Format of the Course

• Interactive lecture and discussion sessions
• Plenty of exercises and hands-on practice
• Hands-on implementation in a live-lab environment

Course Customization Options

• This training is based on the latest version of Microsoft SQL Server and SSAS.
• To request a customized training for this course, please contact us to arrange.

This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.