Introduction, Design and Database Modelling

DB-DESIGN

This two-day instructor-led course 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)

Dates

01/10/2022 - 01/11/2022 Prague cs Free date
11 800 CZK Add to cart
03/01/2022 - 03/02/2022 Prague cs Free date
11 800 CZK Add to cart
05/02/2022 - 05/03/2022 Prague cs Free date
11 800 CZK Add to cart

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.