Advanced search

DB-DESIGN Introduction, Design and Database Modelling Print

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

Date PlaceLanguagePrice (without VAT)Availability
09/01/2020 - 09/02/2020 Prague cs 11 800 CZK
9 440 CZK
Free date
11/09/2020 - 11/10/2020 Prague cs 11 800 CZK Free date
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
  • Dependencies

    SQL Server

    SQL Server

    Databases

    Databases
OKsystem a.s.
We use cookies to optimize site functionality and deliver best results based on your interests. More info