Databases

Database Introduction

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

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.

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.

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.