Advanced search

DB-UPGRADE Updating Your Skills to the newest SQL Server

This two-day instructor led training course is aimed at database professionals looking to update their skills to cover SQL Server.

DatePlaceLanguagePrice (without VAT)Availability
01/16/2020 - 01/17/2020 Prague 11 800 CZK
03/26/2020 - 03/27/2020 Prague 11 800 CZK
05/14/2020 - 05/15/2020 Prague 11 800 CZK

DB-DESIGN Introduction, Design and Database Modelling

This two-day instructor-led course provides the knowledge needed for the design and modelling of databases, independent on database platform. Graduates will get acquainted with the procedure of relational database design and analysis, normalization, by designing ER database diagrams, an implementation of databases and SQL basics.

DatePlaceLanguagePrice (without VAT)Availability
01/06/2020 - 01/07/2020 Prague 11 800 CZK
03/09/2020 - 03/10/2020 Prague 11 800 CZK
05/04/2020 - 05/05/2020 Prague 11 800 CZK

SQL-Jazyk Writing Queries Using SQL

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.

DatePlaceLanguagePrice (without VAT)Availability
12/09/2019 - 12/11/2019 Prague 17 700 CZK
13 500 CZK
01/20/2020 - 01/22/2020 Prague 17 700 CZK
03/16/2020 - 03/18/2020 Prague 17 700 CZK
05/18/2020 - 05/20/2020 Prague 17 700 CZK

SQL-Jazyk 2 Writing Advanced Queries Using SQL

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.

DatePlaceLanguagePrice (without VAT)Availability
12/12/2019 - 12/13/2019 Prague 11 800 CZK
9 000 CZK
01/23/2020 - 01/24/2020 Prague 11 800 CZK
03/19/2020 - 03/20/2020 Prague 11 800 CZK
05/21/2020 - 05/22/2020 Prague 11 800 CZK

DB-DEV Developing SQL Databases

This five-day instructor-led course provides students with the knowledge and skills to design and develop Microsoft SQL Server databases, database objects, indexes and use product features and tools related to developing a database. It also deals with performance, transaction processing, error handling, special data types, including work with binary data.

DatePlaceLanguagePrice (without VAT)Availability
02/03/2020 - 02/07/2020 Prague 29 500 CZK
03/30/2020 - 04/03/2020 Prague 29 500 CZK
06/01/2020 - 06/05/2020 Prague 29 500 CZK

DB-ADM Installing, Administering and Maintaining a Microsoft SQL Server and Database Infrastructure

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, tracing, monitoring, use SQL Server services and tools related to database management. The course is an alternative to the authorized courses M20764 and M20765.

DatePlaceLanguagePrice (without VAT)Availability
02/17/2020 - 02/21/2020 Prague 29 500 CZK
04/20/2020 - 04/24/2020 Prague 29 500 CZK
06/15/2020 - 06/19/2020 Prague 29 500 CZK

DB-TUNING Performance Tuning and Optimizing SQL Databases

This 4-day instructor led course provides students to optimize and tune SQL Server and databases with SQL Server tools. The aim is to solve the bottlenecks to increase performance.

DatePlaceLanguagePrice (without VAT)Availability
03/02/2020 - 03/05/2020 Prague 23 600 CZK
05/04/2020 - 05/07/2020 Prague 23 600 CZK
06/22/2020 - 06/25/2020 Prague 23 600 CZK

DB-DW Implementing a SQL Data Warehouse

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), Data Quality Services (DQS), and Master Data Services.

DatePlaceLanguagePrice (without VAT)Availability
01/06/2020 - 01/09/2020 Prague 23 600 CZK
03/16/2020 - 03/19/2020 Prague 23 600 CZK
05/11/2020 - 05/14/2020 Prague 23 600 CZK

MSSQL-HA High Availability in SQL Server

This 3-day instructor led training course describes the design, implementation and maintaining high availability solutions in MS SQL Server.

DatePlaceLanguagePrice (without VAT)Availability
12/16/2019 - 12/18/2019 Prague 17 700 CZK
13 500 CZK
03/09/2020 - 03/11/2020 Prague 17 700 CZK
05/11/2020 - 05/13/2020 Prague 17 700 CZK
06/29/2020 - 07/01/2020 Prague 17 700 CZK

M10998 Updating Your Skills to SQL Server 2017

This two-day instructor led training course is aimed at database professionals looking to update their skills to cover SQL Server 2017.


This course has no dates set. If you are interested in setting a new one, please contact skoleni@oksystem.cz.

M10985 Introduction to SQL Databases

This 3-day instructor led course provides students with introduction to SQL Databases, database design a languages for Microsoft SQL Server.


This course has no dates set. If you are interested in setting a new one, please contact skoleni@oksystem.cz.

M20761 Querying Data with Transact-SQL

This 4-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server.


This course has no dates set. If you are interested in setting a new one, please contact skoleni@oksystem.cz.

M20762 Developing SQL Databases

This five-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database and use product features and tools related to developing a database.


This course has no dates set. If you are interested in setting a new one, please contact skoleni@oksystem.cz.

M20764 Administering a SQL Database Infrastructure

This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additional it will be of use to individuals who develop applications that deliver content from SQL Server databases.

DatePlaceLanguagePrice (without VAT)Availability
12/02/2019 - 12/06/2019 Prague 35 000 CZK
29 500 CZK

M20765 Provisioning SQL Databases

This 4-day course led course provides students to create and manage databases for Microsoft SQL Server including Azure SQL. The course includes installation, deployment, maintenance and configuration of databases and services in both on-premise and cloud environments.

DatePlaceLanguagePrice (without VAT)Availability
12/16/2019 - 12/19/2019 Prague 29 000 CZK
25 000 CZK

M10987 Performance Tuning and Optimizing SQL Databases

This 4-day instructor led course provides students to optimize and tune datatabases with SQL Server tools.


This course has no dates set. If you are interested in setting a new one, please contact skoleni@oksystem.cz.

M20767 Implementing a SQL Data Warehouse

This 5-day instructor led course provides students how to create a data warehouse, how to implement extract, transform, and load (ETL) with SQL Server Integration Services (SSIS), and how to validate and cleanse data with Data Quality Services (DQS) and Master Data Services.


This course has no dates set. If you are interested in setting a new one, please contact skoleni@oksystem.cz.

M10999 SQL Server on Linux

This two-day instructor led training course is aimed at database professionals looking to implement SQL Server on Linux.


This course has no dates set. If you are interested in setting a new one, please contact skoleni@oksystem.cz.

SQL Server

SQL Server

OKsystem a.s. reserves the right to change dates and prices of courses.

OKsystem a.s.
We use cookies to optimize site functionality and deliver best results based on your interests.