Relational Database Design (SQL03)

 

Course Overview

Together with your trainer you will work out the basics, implementations and applications of relational database techniques and DWH structures

Who should attend

DB users who want to get into database creation. Users who want to optimize their queries. People who want to understand and evaluate databases.

Prerequisites

Good SQL knowledge (suggested course SQL Standard Intensive Training (SQL02))

Course Objectives

You will be able to understand database designs, query correctly and efficiently (with the appropriate SQL knowledge). You will be able to design and create simpler databases.

Course Content

Motivation
Basic terms and DB concepts
Data dictionary and meta databases
Data integrity
  • Data consistency
  • Data protection
  • Data security
  • Transactions
Overview: Models
  • Hierarchical model
  • Network model
  • Relational model
  • Object-oriented models
Normalize
  • From the 1st to the 3rd normal form
  • BCNF, 4th, 5th normal form
Overview: Design Methods
  • Objectives, principles of design methods
  • Method according to Zehnder
  • ERD from Chen
The Entity Relationship Diagram (ERD)
  • Formation of entity sets and relationships between entity sets
  • Normalizing an ERD and mapping the ERD to data structures
  • Identification keys, foreign keys, global and local attributes
Definition of consistency conditions
  • Inherent, external consistency conditions
  • Classes of consistency conditions
Reproduction of transactions
Outlook, trend of DBMS and trends
  • Distributed database structures
  • Graph databases (NoSQL)
  • Document databases (NoSQL)
  • Typical cloud data structures

Prices & Delivery methods

Online Training
Modality: L

Duration 2 days

Classroom Training
Modality: C

Duration 2 days

Schedule

German

Time zone: Central European Time (CET)

Online Training This is a FLEX course. Time zone: Central European Time (CET)
Online Training Time zone: Central European Time (CET) Course language: German
Online Training This is a FLEX course. Time zone: Central European Time (CET)
Online Training This is a FLEX course. Time zone: Central European Summer Time (CEST)
Online Training This is a FLEX course. Time zone: Central European Summer Time (CEST)
Online Training This is a FLEX course. Time zone: Central European Summer Time (CEST)
Online Training This is a FLEX course. Time zone: Central European Summer Time (CEST)
Online Training This is a FLEX course. Time zone: Central European Summer Time (CEST)
+ show all dates
Instructor-led Online Training:   This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.
This is a FLEX course, which is delivered both virtually and in the classroom. All FLEX courses are also Instructor-led Online Trainings (ILO).

Europe

Germany

Online Training This is a FLEX course in German language.   Time zone: Europe/Berlin Course language: German Enroll
Online Training This is a FLEX course in German language.   Time zone: Europe/Berlin Course language: German Enroll
Online Training This is a FLEX course in German language.   Time zone: Europe/Berlin Course language: German Enroll
Online Training This is a FLEX course in German language.   Time zone: Europe/Berlin Course language: German Enroll

Switzerland

Basel Course language: German Enroll
Bern Course language: German Enroll
Online Training This is a FLEX course in German language.   Time zone: Europe/Zurich Course language: German Enroll
Basel Course language: German Enroll
Bern Course language: German Enroll
Online Training This is a FLEX course in German language.   Time zone: Europe/Zurich Course language: German Enroll
Basel Course language: German Enroll
Bern Course language: German Enroll
+ show all dates
This is a FLEX course, which is delivered both virtually and in the classroom. All FLEX courses are also Instructor-led Online Trainings (ILO).