SQL Server

PDF to download

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.


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

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.

04/29/2024 - 04/30/2024 cs
11 800 CZK Add to cart

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.

05/15/2024 - 05/17/2024 cs
17 700 CZK Add to cart

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.

04/03/2024 - 04/05/2024 cs
17 700 CZK Add to cart
05/27/2024 - 05/29/2024 cs
17 700 CZK Add to cart

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.

05/20/2024 - 05/24/2024 cs
27 500 CZK Add to cart
06/10/2024 - 06/14/2024 cs
27 500 CZK Add to cart

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.

06/17/2024 - 06/21/2024 cs
27 500 CZK Add to cart

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.

05/20/2024 - 05/23/2024 cs
22 000 CZK Add to cart

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.


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

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