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.

Code
DB-FND

Course length
2 days (8:30 – 16:00)

Form
In our classroom or online

Main course tutor

Ing. David Kovařovic

Ing. David Kovařovic

Cisco a Linux instructor

More about tutor

List price: 8 900 CZK (without VAT)

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

This course is intended for

  • Developers and database designers
  • Database administrators

Syllabus

Chapter 1: Basic concepts

Chapter 2: Relation database design

  • Database design
  • ER Diagramms
  • Normalization
  • Database models
  • Implementation

Chapter 3: Analytics database design

  • Basic concepts
  • Design
  • Implementation

Chapter 4: SQL Language

  • DDL syntax
  • DML syntax

Students will be able to

  • Database design concepts
  • Design the relational and analytical database
  • Database diagrams modelling and use common ER database tools
  • Perform normalization
  • Implement the database model into a physical database model
  • Basics of SQL

Course requirements

  • No prerequisites

Hardware

Classrooms are equipped with performing computers with Internet access, including wireless access.

Literature

All participants will get OKsystem materials.

PDF to download

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

Similar courses

Take a look at some similar courses from our wide range.

Subsidized course „Jsem v kurzu“

Writing Queries Using SQL SQL-Jazyk 1


17 700 CZK Course detail
Subsidized course „Jsem v kurzu“

Performance Tuning and Optimizing SQL Databases DB-TUNING


22 000 CZK Course detail
Subsidized course „Jsem v kurzu“

Installing, Administering and Maintaining a Microsoft SQL Server and Database Infrastructure DB-ADM


27 500 CZK Course detail

Need some advice?

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

Mgr. Barbora Záhlavová

Mgr. Barbora Záhlavová

More information about courses


+420 734 525 195
zahlavova@oksystem.cz

Ing. Lumír Vojtěchovský

Ing. Lumír Vojtěchovský

More information about courses


+420 724 332 135
vojtechovsky@oksystem.cz

Why OKškolení?

What are the main advantages of our training centre?

About us

Contact us

Do not hesitate to contact us with any questions you may have.

Simona Dianová

Simona Dianová

Training and test organization


+420 236 072 251
dianova@oksystem.cz

Ing. Dana Černá

Ing. Dana Černá

Certification tests


+420 236 072 318
cernad@oksystem.cz

Do you need to know more about us or would you prefer to contact us using the form?

Contact page

OKškolení is part of OKsystem a.s.