IT / Modelling / Business Intelligence / Relational Database Systems
| ID | 2757718 |
|---|---|
| Classroom | 2 days 9:00-16:30 |
| Webinar | 4 days 9:00-12:30 |
| Method | Lecture with examples and exercises. |
| Prequisite | no |
| Audience | Administrators, project managers, advanced users |
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.
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
Definition of the relational model - Mapping a conceptual schema to a relational schema - Refinement of the relational schema - Relational Algebra - The relational calculus
History - Data types - Schema definition - Schema change - Basic data manipulation - Simple SQL queries - Queries using multiple relations - Aggregate functions and grouping - Nested queries
Referential Integrity - Ensuring referential integrity - Verification of static integrity constraints - Triggers
Functional dependencies - Key - Determination of functional dependencies - Anomalies - Decomposition of relations - Normalization and Normal Forms
Requirements for transaction management - Transaction types - Properties of transactions - Transaction management in SQL - State transitions of a transaction
Discretionary Access Control - Access Control in SQL - Refinement of the authorization model - Mandatory access control - Multilevel databases - Cryptography
Evaluation of relational database systems - Advantages of object-oriented data modeling - Properties of objects - Definition of object types - Modeling the behavior - Type hierarchy
Hierarchical modeling using XML - XML integration in relational databases - Storage models - SQL and XML
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.
- 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.
He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.
