Business Intelligence - Relational Database Systems

• Dauer:
  2 Tage
• Zeit:
  10:00 - 16:00
• Lieferart:
  Online
• Zielgruppe:
  Administrators, project managers, advanced users
• Vorkenntnisse:
  no
• Methode:
  Lecture with examples and exercises.
• Erfahren Sie in der Demo mehr darüber, wie Online-Kurse durchgeführt werden.
• Kursnummer:
  2022850
• 
  Themen:
  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.

Veröffentlichungen

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

Erfahrung: - 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.

Projekte: - 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.

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

Zertifizierung: Marco Skulschus is "Microsoft Certified Trainer", “Oracle Associate” and passed the ComptiaCTT+ examination.

Bei der Anmeldung von mehreren Teilnehmern bieten wir Ihnen attraktive Rabatte an. Ab drei Teilnehmern kann sich ein Inhouse-Seminar bei Ihnen lohnen. Gern erstellen wir Ihnen ein individuelles Angebot.
Alle Preise zuzüglich der gesetzlichen Mehrwertsteuer.