Course length
Form
In our classroom or online
Filter courses
Microsoft - SQL Server and Databases - IT Courses
Our SQL Server and database courses focus on database design, T‑SQL querying, performance tuning, backup and data security.
Writing Queries Using SQL SQL-Jazyk 1
The three-day course aims to acquaint students with the basics of SQL. Its content is a description of language syntax, definition of data structures, queries, and data manipulation.
Nearest date:17 700 CZK without VAT
Installing, Administering and Maintaining a Microsoft SQL Server and Database Infrastructure DB-ADM
The five-day course is designed for all who need the knowledge to effectively deploy, configure, manage, and maintain the latest version of Microsoft SQL Server 2019. The course focuses on deployment, configuring, administration, maintenance,…
Nearest date:27 500 CZK without VAT
Fundamentals of SQL Language for Users SQL-Jazyk 0
This two day training is designed for those who are starting their journey in SQL. It offers an introduction to relational databases as well as writing simple queries. The purpose of this course is to get you familiar with basic knowledge required…
Nearest date:11 800 CZK without VAT
Implementing a SQL Data Warehouse DB-DW
This 4-day instructor led course provides students how to design and build a data warehouse, how to implement ETL processes, how to validate, clean, consolidate and check data using SQL Server Integration Services (SSIS).
Nearest date:23 600 CZK without VAT
Writing Advanced Queries Using SQL SQL-Jazyk 2
The two-day course aims to acquaint students with SQL. Its content is a description of advanced language syntax, definition of data structures, queries, and data manipulation. It follows the course SQL language.
Nearest date:17 700 CZK without VAT
Administering Relational Databases on Microsoft Azure DP-300
Authorized course
This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally,…
This course has no dates set. If you are interested in setting a new one, please contact skoleni@oksystem.cz.
Analyzing Data with Excel DB-EXCEL
This 2-day instructor led course is intended for anyone responsible for analyzing and reporting data with Microsoft Excel. The course goes beyond the capabilities of tables, Pivot tables, charts and Pivot Charts, the Excel Data Model and DAX…
This course has no dates set. If you are interested in setting a new one, please contact skoleni@oksystem.cz.
Analyzing Data with SQL Server Reporting Services DB-REPORTS
This 4-day instructor led course provides students with analyzing data using Microsoft SQL Server Reporting Services. The course discusses how to use the development tools to create and manage reports, manage, expand Reporting Services and implement…
This course has no dates set. If you are interested in setting a new one, please contact skoleni@oksystem.cz.
Developing Data Models using SQL Server Analysis Services DB-ANALYSIS
This 3-day instructor led course provides students with creating a managing data models in Microsoft SQL Server. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, measure…
This course has no dates set. If you are interested in setting a new one, please contact skoleni@oksystem.cz.
Microsoft Access MACCESS
New course
Unfortunately, this course is available only in Czech language. To view information about the course, please switch website into Czech language.
This course has no dates set. If you are interested in setting a new one, please contact skoleni@oksystem.cz.
Need some advice?
Do not hesitate to contact us. We are at your disposal and will be happy to help you.
Prices do not include VAT. OKsystem a.s. reserves the right to change dates and prices of courses.
