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.
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
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…
Nearest date:11 800 CZK without VAT
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
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:22 000 CZK without VAT
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.
Nearest date:14 500 CZK without VAT
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…
Nearest date:27 500 CZK without VAT
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.
Nearest date:16 500 CZK without VAT
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.
