Microsoft - IT Courses

Learn how to manage infrastructure, automate tasks and secure environments using Microsoft 365, Azure and Windows Server in practical courses.

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:
07/22/2026 – 07/24/2026   Praha Free date Guaranteed date Discount!

14 160 CZK without VAT

Course detail

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:
08/10/2026 – 08/12/2026   Praha Free date Discount!

14 160 CZK without VAT

Course detail

Windows 10/11 Deployment WIN-D

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.

Supporting and Troubleshooting Windows clients W-TSHOOT

Unfortunately, this course is available only in Czech language. To view information about the course, please switch website into Czech language.

Nearest date:
07/27/2026 – 07/29/2026   Praha Free date Discount!

14 160 CZK without VAT

Course detail

Securing Windows Server 2016/2019 MServer-SEC

This five-day course teaches IT professionals how they can enhance the security of the IT infrastructure that they administer. This course explains how you can use auditing and the Advanced Threat Analysis feature in Windows Server 2016 to identify…

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

Power Query PQuery

New course

Unfortunately, this course is available only in Czech language. To view information about the course, please switch website into Czech language.

Nearest date:
08/12/2026   Praha Free date Discount!

4 720 CZK without VAT

Course detail

Planning and Administering SharePoint Server MSHP-ADM

This 5-day instructor-led course provides you with the skills and knowledge needed to plan, design, support and implement SharePoint Server 2019.

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

Planning and Administering SharePoint Server MSHP-ADMAZ

New course

Unfortunatelly, this course is only available in Czech language. 

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

Performance Tuning and Optimizing SQL Databases DB-TUNING

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

Nearest date:
08/04/2026 – 08/07/2026   Praha Free date Discount!

17 600 CZK without VAT

Course detail

Networking in Windows Server MServer-SI

This 5-day classroom-based course provides the fundamental networking skills required to deploy and support Windows Server 2016/2019 in most organizations. It covers IP fundamentals, remote access technologies, and more advanced content including…

Nearest date:
08/24/2026 – 08/28/2026   Praha Free date Guaranteed date

29 500 CZK without VAT

Course detail

Need some advice?

Do not hesitate to contact us. We are at your disposal and will be happy to help you.

Ing. Michaela Setinská

Ing. Michaela Setinská

More information about courses


+420 731 400 369
setinska@oksystem.cz

Ing. Lumír Vojtěchovský

Ing. Lumír Vojtěchovský

More information about courses


+420 724 332 135
vojtechovsky@oksystem.cz

Prices do not include VAT. OKsystem a.s. reserves the right to change dates and prices of courses.

Zásady ochrany soukromí při použití AI Asistenta:

AI Asistent (chatbot) je softwarová aplikace určená k simulaci konverzace s lidskými uživateli. Chatbot pracuje s informacemi, které do něj uživatel vkládá, včetně osobních nebo důvěrných informací. Proto takové informace do komunikace s chatbotem nikdy nevkládejte.

V konverzaci používejte anonymní příklady místo skutečných informací a nikdy s chatbotem nesdílejte osobní údaje či citlivé dokumenty, jelikož není možné zaručit, že data v nich obsažená nebudou dále zpracována.