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.

Accredited course for Continuing Education of Pedagogical Staff

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


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.

PDF to download Expand allCollapse all

  • 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
  • This course is intended for

    • Developers and database designers
    • Database administrators
  • Literature

    All participants will get OKsystem materials.

  • Hardware

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

  • 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

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