PDF to download

R Language Fundamentals

R-jazyk

The two-day course aims to acquaint students with the basics of R language. Its content is to learn the basic properties of the R language, data types, variables, basic constructions, objects, exceptions, write scripts, use packages and modules.


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

Data Analysis Using R

R-jazyk 2

The two-day course aims to familiarize students with the possibilities of working with data, to perform data transformations, analysis and visualizations in R. Its content is also to learn how to use packages and modules for work with data and visualizations.


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

Microsoft Azure AI Fundamentals

AI-900

The Azure AI Fundamentals course introduces AI and the Microsoft services students can use to create AI solutions.
This course introduces fundamentals concepts related to artificial intelligence (AI), and the services in Microsoft Azure that can be used to create AI solutions. The course is not designed to teach students to become professional data scientists or software developers, but rather to build awareness of common AI workloads and the ability to identify Azure services to support them.


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

Designing and Implementing an Azure AI Solution

AI-102

Designing and Implementing an Azure AI Solution is intended for software developers wanting to build AI infused applications that leverage Azure Cognitive Services, Azure Cognitive Search, and Microsoft Bot Framework. The course will use C# or Python as the programming language.


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

Migrate SQL Workloads to Azure

DP-050

In this course, the students will explore the objectives of data platform modernization and how it is suitable for given business requirements. The student will learn how to migrate to the three target platforms for SQL based workloads: Azure Virtual Machines, Azure SQL Databases, Azure SQL Database Managed Instances. Student also will learn the benefits and limitations of each target platform, how they can be used to fulfil both business and technical requirements for modern SQL workloads and the available migration tools.


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

Migrate NoSQL Workloads to Azure Cosmos DB

DP-060

This course will teach the students what is Cosmos DB and how you can migrate MongoDB and Cassandra workloads to Cosmos DB.


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

Migrate Open Source Data Workloads to Azure

DP-070

This course will enable the students to understand Azure SQL Database, and educate the students on what is required to migrate Open Source Data workloads to Azure SQL Database.


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 self-service BI solutions.


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

Microsoft Power BI Data Analyst

PL-300

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.

07/20/2022 - 07/22/2022 Prague
21 800 CZK
17 440 CZK

Microsoft Power BI Desktop

PowerBI

This 3-day course will teach users how to use Microsoft Power BI, perform data analysis, create dashboards and reports using Microsoft Power BI Desktop. The course includes import and transformation of data, creation and modification of a data model, use of DAX language for calculations, creation of visualizations and publication of results. The course uses the Power BI Desktop tool, the PowerBI.com service and the Power BI Report Server.

07/20/2022 - 07/22/2022 Prague
16 500 CZK
13 200 CZK

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 language.

08/25/2022 - 08/26/2022 Prague
11 000 CZK
8 800 CZK
10/17/2022 - 10/18/2022 Prague
11 000 CZK
12/05/2022 - 12/06/2022 Prague
11 000 CZK

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 groups and learn how to use MDX and DAX.


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

Basics of Python Language

Python1

The three-day course aims to introduce students to the basics of Python. Its content is to learn basic Python features, data types, variables, basic constructs, exceptions, scripts, OOP, packages and modules.

07/26/2022 - 07/28/2022 Prague
15 600 CZK
12 480 CZK
09/20/2022 - 09/22/2022 Prague
15 600 CZK
11/01/2022 - 11/03/2022 Prague
15 600 CZK

Data Analysis Using Python

Python2

The three-day course aims to familiarize students with the possibilities of working with data, to perform transformations, analysis and visualization in Python. Its content is to learn to use packages and modules for work with data. It focuses mainly on the Pandas, NumPy and Dask libraries and its possibilities in data processing and publication.

08/09/2022 - 08/11/2022 Prague
15 600 CZK
12 480 CZK
10/04/2022 - 10/06/2022 Prague
15 600 CZK
11/22/2022 - 11/24/2022 Prague
15 600 CZK

IT security rules for employees

SEC100

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.

Cryptography Principals

PKI

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

09/12/2022 - 09/12/2022 Prague
5 900 CZK
11/07/2022 - 11/07/2022 Prague
5 900 CZK

Microsoft Public Key Infrastructure

MPKI

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

07/19/2022 - 07/21/2022 Prague
17 700 CZK
14 160 CZK
09/13/2022 - 09/15/2022 Prague
17 700 CZK
11/08/2022 - 11/10/2022 Prague
17 700 CZK

Network Security Fundamentals

NET302

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

08/18/2022 - 08/19/2022 Prague
9 000 CZK
7 200 CZK
10/26/2022 - 10/27/2022 Prague
9 000 CZK
12/21/2022 - 12/22/2022 Prague
9 000 CZK

Microsoft 365 Fundamentals

MS-900

This one-day course provides foundational knowledge on the considerations and benefits of adopting cloud services and the Software as a Service (SaaS) cloud model, with a specific focus on Microsoft 365 cloud service offerings.

07/18/2022 - 07/18/2022 Prague
6 500 CZK
5 200 CZK
09/05/2022 - 09/05/2022 Prague
6 500 CZK
10/25/2022 - 10/25/2022 Prague
6 500 CZK

Microsoft 365 Identity and Services

MS-100

Learn about Microsoft 365 Tenant, Identity and Service Management, including how to plan, manage, and customize your organization’s Microsoft 365 tenant and services, how to manage user security groups and licenses for cloud identities, how to plan and implement identity synchronization, federated identities, applications, and external access, how to move your organization to Microsoft 365, how to configure Microsoft 365, and how to manage Office 365 ProPlus deployments.

07/25/2022 - 07/29/2022 Prague
35 600 CZK
28 480 CZK
09/12/2022 - 09/16/2022 Prague
35 600 CZK
11/07/2022 - 11/11/2022 Prague
35 600 CZK

Microsoft 365 Mobility and Security

MS-101

Learn about Microsoft 365 Security, Compliance and Device Management, including how to manage your security metrics, how to enable Azure AD Identity Protection, how to configure your Microsoft 365 security services, and user Microsoft 365 Threat Intelligence, implementing data retention and data loss prevention solutions in Microsoft 365, archiving and retention in Microsoft 365, implementing and managing data governance, and managing search and investigations, establishing Microsoft Intune, enrolling devices to Intune, monitoring the devices, and controlling what users can do from the enrolled devices by using conditional access policies.

08/29/2022 - 09/02/2022 Prague
35 600 CZK
28 480 CZK
10/03/2022 - 10/07/2022 Prague
35 600 CZK
11/28/2022 - 12/02/2022 Prague
35 600 CZK

Microsoft 365 security

MS-500

In this four-day course you will learn how to secure user access to your organization’s resources, about threat protection technologies that help protect your Microsoft 365 environment, about information protection technologies that help secure your Microsoft 365 environment and about archiving and retention in Microsoft 365 as well as data governance and how to conduct content searches and investigations.


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

Managing Microsoft Teams

MS-700

This four-day course is for the Microsoft 365 teamwork administrator role. Microsoft Teams admins configure, deploy, and manage Office 365 workloads for Microsoft Teams that focus on efficient and effective collaboration and communication in an enterprise environment.

08/30/2022 - 09/02/2022 Prague
30 800 CZK
24 640 CZK
10/17/2022 - 10/20/2022 Prague
30 800 CZK
12/13/2022 - 12/16/2022 Prague
30 800 CZK

Microsoft Teams Voice Engineer

MS-720

In this course, you will learn how to plan, design, configure, maintain, and troubleshoot an integrated communications solution at an organization using Microsoft Teams. The course will cover Teams Phone with Calling Plans, Direct Routing, and Operator Connect, in addition to Teams devices, audio/video conferencing, and voice migration. Students will learn troubleshooting methodologies and how to resolve common telephony and voice problems.


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

Microsoft Office 365 for Users

MO365U

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

07/19/2022 - 07/19/2022 Prague
3 800 CZK
3 040 CZK
09/26/2022 - 09/26/2022 Prague
3 800 CZK
11/14/2022 - 11/14/2022 Prague
3 800 CZK

Microsoft Azure Fundamentals

AZ-900

This course will provide foundational level knowledge of cloud services and how those services are provided with Microsoft Azure. The course can be taken as an optional first step in learning about cloud services and Microsoft Azure, before taking
further Microsoft Azure or Microsoft cloud services courses.

08/29/2022 - 08/29/2022 Prague
6 500 CZK
5 200 CZK
10/24/2022 - 10/24/2022 Prague
6 500 CZK
12/12/2022 - 12/12/2022 Prague
6 500 CZK

Microsoft Azure Administrator

AZ-104

This course teaches IT Professionals how to manage their Azure subscriptions, secure identities, administer the infrastructure, configure virtual networking, connect Azure and on-premises sites, manage network traffic, implement storage solutions, create and scale virtual machines, implement web apps and containers, back up and share data, and monitor your solution.

09/19/2022 - 09/22/2022 Prague
29 500 CZK
10/31/2022 - 11/03/2022 Prague
29 500 CZK
12/13/2022 - 12/16/2022 Prague
29 500 CZK

Configuring and Operating Windows Virtual Desktop on Microsoft Azure

AZ-140

This course teaches Azure administrators how to plan, deliver, and manage virtual desktop experiences and remote apps, for any device, on Azure. Students will learn through a mix of demonstrations and hands-on lab experiences deploying virtual desktop experiences and apps on Windows Virtual Desktop and optimizing them to run in multi-session virtual environments.


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

Designing Microsoft Azure Infrastructure Solutions

AZ-305

This course teaches Azure Solution Architects how to design infrastructure solutions. Course topics cover governance, compute, application architecture, storage, data integration, authentication, networks, business continuity, and migrations. The course combines lecture with case studies to demonstrate basic architect design principles.


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

Designing and Implementing Microsoft DevOps Solutions

AZ-400

This course provides the knowledge and skills to design and implement DevOps processes and practices. Students will learn how to plan for DevOps, use source control, scale Git for an enterprise, consolidate artifacts, design a dependency management strategy, manage secrets, implement continuous integration, implement a container build strategy, design a release strategy, set up a release management workflow, implement a deployment pattern, and optimize feedback mechanisms.


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

Microsoft Azure Security Technologies

AZ-500

In this course students will gain the knowledge and skills needed to implement security controls, maintain the security posture, and identify and remediate vulnerabilities by using a variety of security tools. The course covers scripting and automation, virtualization, and cloud N-tier architecture.


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

Configuring and Operating a Hybrid Cloud with Microsoft Azure Stack Hub

AZ-600

This course teaches Azure administrators and Azure Stack Hub operators how to plan, deploy, package, update, and maintain the Azure Stack Hub infrastructure. Lessons include deploying Azure Stack Hub, managing the Azure Stack Hub Marketplace, offering App Services and Event Hub resource providers, managing Azure Stack Hub registration, and maintaining system health.


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

Designing and Implementing Microsoft Azure Networking Solutions

AZ-700

This course teaches Network Engineers how to design, implement, and maintain Azure networking solutions. This course covers the process of designing, implementing, and managing core Azure networking infrastructure, Hybrid Networking connections, load balancing traffic, network routing, private access to Azure services, network security and monitoring. Learn how to design and implement a secure, reliable, network infrastructure in Azure and how to establish hybrid connectivity, routing, private access to Azure services, and monitoring in Azure.


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

Administering Windows Server Hybrid Core Infrastructure

AZ-800

This course teaches IT Professionals how to manage core Windows Server workloads and services using on-premises, hybrid, and cloud technologies. The course teaches IT Professionals how to implement and manage on-premises and hybrid solutions such as identity, management, compute, networking, and storage in a Windows Server hybrid environment.

09/19/2022 - 09/22/2022 Prague
29 500 CZK
11/07/2022 - 11/10/2022 Prague
29 500 CZK

Configuring Windows Server Hybrid Advanced Services

AZ-801

This course teaches IT Professionals to configure advanced Windows Server services using on-premises, hybrid, and cloud technologies. The course teaches IT Professionals how to leverage the hybrid capabilities of Azure, how to migrate virtual and physical server workloads to Azure IaaS, and how to secure Azure VMs running Windows Server. The course also teaches IT Professionals how to perform tasks related to high availability, troubleshooting, and disaster recovery. The course highlights administrative tools and technologies including Windows Admin Center, PowerShell, Azure Arc, Azure Automation Update Management, Microsoft Defender for Identity, Azure Security Center, Azure Migrate, and Azure Monitor.

07/25/2022 - 07/28/2022 Prague
29 500 CZK
23 600 CZK
10/03/2022 - 10/06/2022 Prague
29 500 CZK
11/28/2022 - 12/01/2022 Prague
29 500 CZK

Implementing a Machine Learning Solution with Microsoft Azure Databricks

DP-090

Azure Databricks is a cloud-scale platform for data analytics and machine learning. In this one-day course, you'll learn how to use Azure Databricks to explore, prepare, and model data; and integrate Databricks machine learning processes with Azure Machine Learning.


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

Microsoft Azure Data Fundamentals

DP-900

In this one-day course, students will learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure.


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

Designing and Implementing a Data Science solution on Azure

DP-100

Gain the necessary knowledge about how to use Azure services to develop, train, and deploy, machine learning solutions. The course starts with an overview of Azure services that support data science. From there, it focuses on using Azure's premier data science service, Azure Machine Learning service, to automate the data science pipeline.


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

Data Engineering on Microsoft Azure

DP-203

In this course, the students will design various data platform technologies into solutions that are in line with business and technical requirements. This can include on-premises, cloud, and hybrid data scenarios which incorporate relational, NoSQL, or Data Warehouse data. They will also learn how to design process architectures using a range of technologies for both streaming and batch data. The students will also explore how to design data security, including data access, data policies, and standards. They will also design Azure data solutions, which includes the optimization, availability, and disaster recovery of big data, batch processing, and streaming data solutions.


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

Administering Relational Databases on Microsoft Azure

DP-300

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, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.


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

Microsoft Power Platform Fundamentals

PL-900

In this one-day course, students will learn the business value and product capabilities of Power Platform. Create simple Power Apps, connect data with Common Data Service, build a Power BI Dashboard, automate a process with Power Automate, and build a chatbot with Power Virtual Agents.


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

Administering Microsoft Exchange Server 2016/2019

EXCH-ADM

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

08/22/2022 - 08/26/2022 Prague
27 500 CZK
22 000 CZK
10/10/2022 - 10/14/2022 Prague
27 500 CZK
12/12/2022 - 12/16/2022 Prague
27 500 CZK

Implementing and Managing Exchange Online Service

EXCH-ONLINE

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

 

08/03/2022 - 08/04/2022 Prague
11 800 CZK
9 440 CZK
10/04/2022 - 10/05/2022 Prague
11 800 CZK
12/19/2022 - 12/20/2022 Prague
11 800 CZK

Microsoft 365 Messaging

MS-203

This course examines the key elements of Microsoft 365 messaging administration, including message transport and mail flow, messaging security, hygiene, and compliance, messaging infrastructure, and hybrid messaging. This course is designed for IT Professionals who deploy and manage the messaging infrastructure for Microsoft 365 in their organization.


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

Microsoft Word - Basic Course

MWORDZ

One-day training is intended for individuals who want to gain the basic knowledge of using MS Word. By working on various exercises, students are going to practise several tools for editing, saving, opening and searching documents. They are going to learn how to insert the header, the footer and the numbering. They are also going to get familiar with proofing and printing documents.


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

Microsoft Word - Advanced Course

MWORDP

Two-day course is intended for all common users who have already worked with MS Office Word and would like to extend their basic knowledge. The course focuses on the most common and the most useful functions, which are generally used while working with MS Office. During the course, the tutor is going to point out several interesting parts of settings and tricks that can help the users and these tricks are also going to make the work faster and much more effective.

Participants of the course are going to learn the way how to save their time while formatting either styles that have already existed or creating their own styles. Then, they are going to get to know how to copy these styles among various documents. Moreover, they are also going to make and use document templates, format and create tables.

While working with longer documents, the users are going to profit from footnotes, endnotes, captions of pictures and tables. They are going to make a table of them and a table of contents of a document. They are also going to learn how to number the pages not from the first one or how to change the orientation of certain pages of a document. In the last part of the course, participants are going to acquire the work dealing with review tools and comparing different versions of a certain file.


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

Microsoft Excel - Basic Course

MEXCELZ

One-day course is intended for all common users who have already worked on computer and who need to learn the use of MS Excel application from the very beginning. In the end of the course, the participants will be capable of creating and formatting tables, calculating the key values and printing the result of their work. They are going to learn how to work with charts. Moreover, they are going to distinguish several types of charts according to the particular situation. The practice is especially stressed during the whole course.


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

Microsoft Excel - Advanced Course

MEXCELP

Two-day course is intended for all common users who have already worked with MS Office Excel application and would like to extend their basic knowledge. The course focuses on the most common and the most useful functions, which are generally used while working with MS Office Excel.


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

Microsoft PowerPoint

MPPOINT

Two-day course is intended for all common users who have already worked on PC and they need to familiarize with MS PowerPoint application from the very beginning.

Participants of the course are going to profit the whole scale of graphic elements. They are supposed to make several presentations according to a unified theme. They are also going to learn how to set up some animations for various objects and single slides. Moreover, they should be able to print the presentation as data for an appointment.

In the end of the course, participants are going to set up their own presentation according to the aim of the particular presentation.


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

Microsoft Outlook

MOUTL

Two-day course is intended for all common users who need to familiarize with principles of working in MS Outlook application from the very beginning. Participants of the course are going to learn especially the principles dealing with writing and sending messages. Then, they are supposed to create and save contacts. Moreover, they are going to get to know how to organize their time according to calendar and tasks.

While discussing the organization of messages, participants are going to familiarize with various principles of automatic rules and classification of messages.

The second day of the course is based on user’s editing. This means that they are going to realize the way how to adapt their working time to their personal needs. In addition to that, they are going to learn how to set up out of office assistant while working out of the office or how to delegate tasks to another person.

Users are also going to become acquainted with several important settings, e.g. archiving, data export (messages, contacts, calendar and many others) and master the basis of message security.


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

Microsoft SharePoint for Users

MSHP

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

07/22/2022 - 07/22/2022 Prague
3 200 CZK
2 560 CZK
09/27/2022 - 09/27/2022 Prague
3 200 CZK
11/15/2022 - 11/15/2022 Prague
3 200 CZK

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.

Introduction to Internetworking

NET101

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

08/01/2022 - 08/02/2022 Prague
9 000 CZK
7 200 CZK
10/03/2022 - 10/04/2022 Prague
9 000 CZK
11/28/2022 - 11/29/2022 Prague
9 000 CZK

LAN Switching

NET201

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

08/03/2022 - 08/04/2022 Prague
9 000 CZK
7 200 CZK
10/05/2022 - 10/06/2022 Prague
9 000 CZK
11/30/2022 - 12/01/2022 Prague
9 000 CZK

IP Routing

NET202

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

08/22/2022 - 08/23/2022 Prague
9 000 CZK
7 200 CZK
10/17/2022 - 10/18/2022 Prague
9 000 CZK
12/12/2022 - 12/13/2022 Prague
9 000 CZK

DNS Administration

DNS

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

08/18/2022 - 08/18/2022 Prague
3 800 CZK
3 040 CZK
10/13/2022 - 10/13/2022 Prague
3 800 CZK
12/22/2022 - 12/22/2022 Prague
3 800 CZK

Deploying and Implementing IPv6

NET203

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

08/24/2022 - 08/25/2022 Prague
9 000 CZK
7 200 CZK
10/19/2022 - 10/20/2022 Prague
9 000 CZK
12/14/2022 - 12/15/2022 Prague
9 000 CZK

Intercepting and Analyzing Network Communication

NET204

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

08/29/2022 - 08/30/2022 Prague
9 000 CZK
7 200 CZK
10/24/2022 - 10/25/2022 Prague
9 000 CZK
12/19/2022 - 12/20/2022 Prague
9 000 CZK

Basic Network Troubleshooting Tools

NET301

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

08/31/2022 - 09/01/2022 Prague
9 000 CZK
7 200 CZK
10/31/2022 - 11/01/2022 Prague
9 000 CZK
12/21/2022 - 12/22/2022 Prague
9 000 CZK

Updating Your Skills to the newest SQL Server

DB-UPGRADE

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


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

Database Introduction

DB-FND

This two-day instructor-led course is focused on beginners in database area. It 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.

09/06/2022 - 09/07/2022 Prague
11 800 CZK
10/24/2022 - 10/25/2022 Prague
11 800 CZK

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 for constructing SQL queries and is aimed for users who need it for writing uncomplicated SELECT statements and who also want to display and filter data or know how to order it. If any extension of the gained knowledge is required, we offer additional courses Writing Queries Using SQL and Writing Advanced Queries Using SQL.
The course uses Microsoft platform with the Transact-SQL dialect.

08/11/2022 - 08/12/2022 Prague
11 800 CZK
9 440 CZK
09/08/2022 - 09/09/2022 Prague
11 800 CZK
10/26/2022 - 10/27/2022 Prague
11 800 CZK

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.

09/19/2022 - 09/21/2022 Prague
17 700 CZK
11/07/2022 - 11/09/2022 Prague
17 700 CZK

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.

08/09/2022 - 08/10/2022 Prague
11 800 CZK
9 440 CZK
09/22/2022 - 09/23/2022 Prague
11 800 CZK
11/10/2022 - 11/11/2022 Prague
11 800 CZK

Developing SQL Databases

DB-DEV

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.

08/15/2022 - 08/19/2022 Prague
27 500 CZK
22 000 CZK
10/17/2022 - 10/21/2022 Prague
27 500 CZK
11/28/2022 - 12/02/2022 Prague
27 500 CZK

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

08/29/2022 - 09/02/2022 Prague
27 500 CZK
22 000 CZK
10/03/2022 - 10/07/2022 Prague
27 500 CZK
12/12/2022 - 12/16/2022 Prague
27 500 CZK

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.

07/12/2022 - 07/15/2022 Prague
22 000 CZK
17 600 CZK
09/12/2022 - 09/15/2022 Prague
22 000 CZK
11/21/2022 - 11/24/2022 Prague
22 000 CZK

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), 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.

High Availability in SQL Server

MSSQL-HA

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

07/26/2022 - 07/28/2022 Prague
16 500 CZK
13 200 CZK
10/18/2022 - 10/20/2022 Prague
16 500 CZK
12/19/2022 - 12/21/2022 Prague
16 500 CZK

Transact-SQL Querying

DP-080

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.

Administering System Center Configuration Manager

SCCM

This five-day course describes how to use Configuration Manager and its associated site systems to efficiently manage network resources. In this five-day course, you will learn day-to-day management tasks, including how to manage applications, client health, hardware and software inventory, operating system deployment, and software updates by using Configuration Manager. You also will learn how to optimize System Center Endpoint Protection, manage compliance, and create management queries and reports.

08/22/2022 - 08/26/2022 Prague
29 500 CZK
23 600 CZK
10/17/2022 - 10/21/2022 Prague
29 500 CZK
12/05/2022 - 12/09/2022 Prague
29 500 CZK

Cloud and Datacenter Monitoring with System Center Operations Manager

SCOM

This five-day course equips students with skills they need to deploy and configure System Center 2019 Operations Manager. 

07/25/2022 - 07/29/2022 Prague
29 500 CZK
23 600 CZK
09/05/2022 - 09/09/2022 Prague
29 500 CZK
10/31/2022 - 11/04/2022 Prague
29 500 CZK

Advance Implementing and Managing Windows Server Hyper-V

MHyper-V

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

08/10/2022 - 08/11/2022 Prague
11 800 CZK
9 440 CZK
09/29/2022 - 09/30/2022 Prague
11 800 CZK
11/28/2022 - 11/29/2022 Prague
11 800 CZK

Automating Administration with Windows PowerShell

PowerShell-1

Learn how with Windows PowerShell 5.1, you can remotely manage single or multiple Windows-based servers and automate day-to-day management and administration tasks. This five day course provides students with the fundamental knowledge and skills to use Windows PowerShell 5.1 for administering and automating administration of Windows based servers.

It focuses on primary Windows PowerShell command-line features and techniques, and will provide prerequisite skills supporting many different Microsoft products. This includes Windows Server,Windows Client, Exchange Server, SharePoint Server, SQL Server, System Center, and more. In keeping with that goal, this course will not focus on any one of those products, although Windows Server (which is the common platform for all of those) will serve as the example for the techniques being taught. In this five day course you will learn to execute and monitor scripts more efficiently through more robust session connectivity, workflow capabilities, improved job scheduling, and Windows PowerShell Web Access. Learn Windows PowerShell with greater ease through improved cmdlet discovery and simplified, consistent syntax across all cmdlets. Write Windows PowerShell scripts quicker and more intuitively through the new Integrated Scripting Environment (ISE) that enables script sharing, which connects IT pros to a larger Windows PowerShell user community. Learn all this and more in this five-day Microsoft Official Course in Windows PowerShell v5.1.

07/11/2022 - 07/14/2022 Prague
22 000 CZK
17 600 CZK
09/12/2022 - 09/15/2022 Prague
22 000 CZK
11/01/2022 - 11/04/2022 Prague
22 000 CZK

Advanced Automated Administration with Windows PowerShell

PowerShell-2

Learn how to automate and streamline day to day management and administration tasks and functions in your Windows Server Infrastructure.

This two-day course is a follow on course from the 10961B: Automating Administration with Windows PowerShell course. It is built on Windows Server 2016 and Windows 10 and while it is specifically focussed on Windows PowerShell v4.0, is also relevant in v2.0 and v3.0 Windows PowerShell environments. Expand and build upon the knowledge already acquired in course 10961B and focus on building more scalable and usable Windows PowerShell scripts for use in your organization by building your own Windows PowerShell tools. Learn about areas such as the creation of advanced functions, script modules, advanced parameters attributes and controller scripts. Also learn how to make your scripts more robust by learning about handling script errors and the analysis and debugging Windows PowerShell scripts. The course will also cover the use of Windows PowerShell cmdlets with .NET Framework as well as teaching how to configure your Windows Servers using Desired State Configuration and providing an understanding of Windows PowerShell workflow. The detailed hands on labs and in depth content and learning will help remove manual tasks that you may currently have to perform as an Administrator, allowing you to make your own Windows PowerShell tools for automated, repeated, accurate management and provisioning of your Windows Server infrastructure.

09/26/2022 - 09/27/2022 Prague
11 800 CZK
11/14/2022 - 11/15/2022 Prague
11 800 CZK

Automating Administration with Windows PowerShell

AZ-040

This course provides students with the fundamental knowledge and skills to use PowerShell for administering and automating administration of Windows servers. This course provides students the skills to identify and build the command they require to perform a specific task. In addition, students learn how to build scripts to accomplish advanced tasks such as automating repetitive tasks and generating reports. 

This course provides prerequisite skills supporting a broad range of Microsoft products, including Windows Server, Windows Client, Microsoft Azure, and Microsoft 365. In keeping with that goal, this course will not focus on any one of those products, although Windows Server, which is the common platform for all of those products, will serve as the example for the techniques this course teaches.


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

Installing, Configuring and Maintaining Windows Client

MD-100

In this course, students will learn how to support the installation and configuration tasks associated with Windows 10.
Students will develop skills that include learning how to install and customize Windows 10 operating systems, application and
managing storage, files, drivers, and printers as well as how to configure network connectivity for Windows 10. Also
Students will be introduced to common methods used for authentication and access control. This course will teach
how to configure file and folder permissions and creating security policies. Students will also be introduced to the
different types of external threats and how to leverage features like encryption and firewalls, as well as tools like
Windows Defender. In this course, students will learn how to manage and troubleshoot Windows 10 too.

08/30/2022 - 09/01/2022 Prague
24 000 CZK
19 200 CZK
10/11/2022 - 10/13/2022 Prague
24 000 CZK
12/06/2022 - 12/08/2022 Prague
24 000 CZK

Deploying, Managing and Protecting Modern Desktops

MD-101

As desktops has evolved, so have methods for deploying and updating them. In this course, you'll learn how to plan and implement an operating system deployment strategy. During this course, you’ll be introduced to key components of modern management strategies. You’ll examine what it takes to incorporate Microsoft Intune into your organization and how to use it to manage modern desktops and devices. You’ll also learn about methods for deployment and management of apps and browser-based applications. Modern environments require the Desktop Administrator be able to manage and support phones, tablets, and computers, whether it be owned by the organization or personally owned by the employee. At the same time, IT must still be able to protect the data that these devices access. In this course, the student will be introduced to the key concepts of security in modern management. This course covers authentication, identities, and access, as well as about how to protect these categories. The student will be introduced to Azure Active Directory and learn how to use Microsoft Intune to protect devices and data with compliance policies. Finally, this course will cover key capabilities of Azure Information Protection and Windows Defender Advanced Threat Protection and how to implement these capabilities.

07/25/2022 - 07/28/2022 Prague
29 900 CZK
23 920 CZK
09/12/2022 - 09/15/2022 Prague
29 900 CZK
11/07/2022 - 11/10/2022 Prague
29 900 CZK
12/19/2022 - 12/22/2022 Prague
29 900 CZK

Supporting and Troubleshooting Windows 10

W10-TSHOOT

This course is designed to provide students with the knowledge and skills required to install and configure Windows 10 desktops and devices in a Windows Server domain corporate environment. These skills include learning how to install and customize Windows 10 operating systems and apps, and configure local and remote network connectivity and storage. Students will also learn how to configure data security, device security, and network security, and maintain, update, and recover Windows 10.

08/09/2022 - 08/11/2022 Prague
17 700 CZK
14 160 CZK
10/04/2022 - 10/06/2022 Prague
17 700 CZK
11/30/2022 - 12/02/2022 Prague
17 700 CZK

Advance Automated Deployment for Small and Mid-size Organizations

MServer-D

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

08/08/2022 - 08/09/2022 Prague
11 800 CZK
9 440 CZK
09/26/2022 - 09/27/2022 Prague
11 800 CZK
11/23/2022 - 11/24/2022 Prague
11 800 CZK

Managing Windows Server 2016/2019

MServer-A

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

07/18/2022 - 07/22/2022 Prague
27 500 CZK
22 000 CZK
09/05/2022 - 09/09/2022 Prague
27 500 CZK
10/31/2022 - 11/04/2022 Prague
27 500 CZK
12/05/2022 - 12/09/2022 Prague
27 500 CZK

Advance Implementing and Managing File Servers, Storages and High Availability in Windows Server 2016/2019

MServer-F-HA

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

08/01/2022 - 08/02/2022 Prague
11 800 CZK
9 440 CZK
09/21/2022 - 09/22/2022 Prague
11 800 CZK
11/14/2022 - 11/15/2022 Prague
11 800 CZK

Advance Administrering of AD DS in Windows Server 2016/2019

MServer-AD

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

08/09/2022 - 08/11/2022 Prague
17 700 CZK
14 160 CZK
10/04/2022 - 10/06/2022 Prague
17 700 CZK
11/29/2022 - 12/01/2022 Prague
17 700 CZK

Advanced Networking in Windows Server 2016/2019

MServer-S

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

09/19/2022 - 09/20/2022 Prague
11 800 CZK
11/21/2022 - 11/22/2022 Prague
11 800 CZK

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