Course code: NRD« Back

Designing Relational Databases

Students design optimal structure of relational database, find out right number of entities, relations and atributes, they also define constraints (primary keys, foreign keys, unique, check, not null).

 DateDurationCourse priceHandbook priceCourse languageLocation 
GTK 9/19/2019 2 6 600 CZK included in course price Český jazyk GOPAS Praha
 
1/14/2020 2 6 600 CZK included in course price Český jazyk GOPAS Praha
 
5/6/2020 2 6 600 CZK included in course price Český jazyk GOPAS Praha
 
3/26/2020 2 6 000 CZK included in course price Český jazyk GOPAS Brno
 
10/17/2019 2 260,00 EUR included in course price Slovenský jazyk GOPAS Bratislava
 

AffiliateDurationCatalogue priceHandbook priceITB
Praha2 6 600 CZK included in course price 20
Brno2 6 000 CZK included in course price 20
Bratislava2 260,00 EUR included in course price 20

Who is the course for

The course is primary set for users who are responsible for design, administration or querying relational databases.

What we teach you

Students learn design optimal relational database structure and obtain necessary knowledge for administration or querying relational database.

Required skills

None

Teaching methods

Expert instruction with practical examples, computer practice

Teaching materials

Gopas company course handbook, according to the course curriculum.

Course Outline

Introduction to relation database modeling

  • Definition of database
  • Traditional data storage file systems
  • Relational database management systems
  • How to do " a right design "
  • Best Practise in data modeling

    Terminology and database design concepts

  • Basic terms in data models
  • Identification of model objects
  • Entity
  • Attribute
  • Relation
  • Relation properties
  • Primary and foreign key
  • Advanced relations

    E-R diagrams

  • What is E-R diagram
  • Benefits of E-R diagrams in design
  • Creation of E-R Diagram

    Normal forms

  • Benefits of normalized data
  • Normal forms (1-3 Normal Form)
  • Denormalization

    Physical database model

  • Transformation of E-R diagram into physical database
  • Index
  • Data integrity - why to use
  • Benefits and the use of CASE software in database design

  • Tištěné prezentace probírané látky

    Price:
    included in course price
    The prices are without VAT.