IT / Modelling / Business Intelligence / Relational Database Systems

Business Intelligence - Relational Database Systems

Details

ID 2757718
Classroom 2 days
Webinar 4 days
Method Lecture with examples and exercises.
Prequisite no
Audience Administrators, project managers, advanced users

Services:

  • Lunch / Catering
  • Assistance for hotel / travel bookings
  • Comelio certificate
  • Flexible: Free cancellation up until 10 days before the training

Summary

A relational database is a database that has a collection of tables of data items, all of which is formally described and organized according to the relational model. In the relational model of a database, all data is represented in terms of tuples, grouped into relations. Most relational databases use the SQL data definition and query language; these systems implement what can be regarded as an engineering approximation to the relational model. A table in an SQL database schema corresponds to a predicate variable; the contents of a table to a relation; key constraints, other constraints, and SQL queries correspond to predicates. This trainings provides you with an overview of the key concepts of the relational model and relational databases. After completing this course, you will be able to design entities and their relationships in a conceptual model and then create a relational table structure based on this first model.

Training Dates

  • 2020-Oct-19 - Oct-22
  • 2020-Dec-28 - Dec-31
  • 2021-Mar-08 - Mar-11
  • 2021-May-17 - May-20

590 EUR +VAT

Location | Enrollment


Agenda

Database Design

Abstraction levels for good database design - The requirement analysis - Fundamentals of Entity-Relationship Model - Key - Characterization of relationship types - Existence-dependent entity types - Generalization - Aggregation - Combining generalization and aggregation - Consolidation - Conceptual modeling with UML

The Relational Model

Definition of the relational model - Mapping a conceptual schema to a relational schema - Refinement of the relational schema - Relational Algebra - The relational calculus

Relational Query Languages

History - Data types - Schema definition - Schema change - Basic data manipulation - Simple SQL queries - Queries using multiple relations - Aggregate functions and grouping - Nested queries

Data Integrity

Referential Integrity - Ensuring referential integrity - Verification of static integrity constraints - Triggers

Relational design theory

Functional dependencies - Key - Determination of functional dependencies - Anomalies - Decomposition of relations - Normalization and Normal Forms

Transaction Management

Requirements for transaction management - Transaction types - Properties of transactions - Transaction management in SQL - State transitions of a transaction

Security Aspects

Discretionary Access Control - Access Control in SQL - Refinement of the authorization model - Mandatory access control - Multilevel databases - Cryptography

Object-oriented databases

Evaluation of relational database systems - Advantages of object-oriented data modeling - Properties of objects - Definition of object types - Modeling the behavior - Type hierarchy

XML Data Modeling and XML Integration

Hierarchical modeling using XML - XML integration in relational databases - Storage models - SQL and XML

Trainer

Marco Skulschus (born in Germany in 1978) studied economics in Wuppertal (Germany) and Paris (France) and wrote his master´s thesis about semantic data modeling. He started working as a lecturer and consultant in 2002.

Publications
  • Grundlagen empirische Sozialforschung ISBN 978-3-939701-23-1
  • System und Systematik von Fragebögen ISBN 978-3-939701-26-2
  • Oracle PL/SQL ISBN 978-3-939701-40-8
  • MS SQL Server - T-SQL Programmierung und Abfragen ISBN 978-3-939701-69-9
Projects

- He works as an IT-consultant and project manager. He developed various Business Intelligence systems for industry clients and the public sector. For several years now, he is responsible for a BI-team in India which is mainly involved in BI and OLAP projects, reporting systems as well as statistical analysis and Data Mining.

Research

He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.