| LearningGoal | key | qKey | id | chapter | chapterKey | subChapter | subChapterKey | relevance | keywords | since | until |
|---|
| Lg/Intro-History | History | Intro-History | 1.1 | 1 | Intro | 1.1 | Intro-History | R3 | Abstraction | | |
| Lg/Intro-Filesystems | Filesystems | Intro-Filesystems | 1.2 | 1 | Intro | 1.2 | Intro-Filesystems | R3 | DBMS, Filesystem | | |
| Lg/Intro-Content | Content | Intro-Content | 1.3 | 1 | Intro | 1.3 | Intro-Content | R3 | intensional, metadata, schema, schema evolution, extensional, structure | | |
| Lg/Intro-Architecture | Architecture | Intro-Architecture | 1.4 | 1 | Intro | 1.4 | Intro-Architecture | R3 | conceptual model, analysis, design, logical schema, conceptual schema, external schema | | |
| Lg/ERM-Design-DatabaseModeling | DatabaseModeling | ERM-Design-DatabaseModeling | 2.1.1 | 2 | ERM | 2.1 | ERM-Design | R2 | Model, logical schema, ERM, Schema, conceptual schema | | |
| Lg/ERM-Design-Lifecycle | Lifecycle | ERM-Design-Lifecycle | 2.1.3 | 2 | ERM | 2.1 | ERM-Design | R2 | information system | | |
| Lg/ERM-Design | Design | ERM-Design | 2.1 | 2 | ERM | 2.1 | ERM-Design | R2 | ERM, database | | |
| Lg/ERM-Design-Quality | Quality | ERM-Design-Quality | 2.1.4 | 2 | ERM | 2.1 | ERM-Design | R3 | data quality | | |
| Lg/ERM-Design-Definition | Definition | ERM-Design-Definition | 2.1.2 | 2 | ERM | 2.1 | ERM-Design | R2 | ERM, logical schema, Schema | | |
| Lg/ERM-ERM-Entity | Entity | ERM-ERM-Entity | 2.2.3 | 2 | ERM | 2.2 | ERM-ERM | R1 | ERM, entity, ERD | | |
| Lg/ERM-ERM-isA | isA | ERM-ERM-isA | 2.2.14 | 2 | ERM | 2.2 | ERM-ERM | R2 | Inheritance, isA | | |
| Lg/ERM-ERM-Diagram | Diagram | ERM-ERM-Diagram | 2.2.2 | 2 | ERM | 2.2 | ERM-ERM | R1 | ERM, ERD, entity | | |
| Lg/ERM-ERM-CompositeAttribute | CompositeAttribute | ERM-ERM-CompositeAttribute | 2.2.5 | 2 | ERM | 2.2 | ERM-ERM | R2 | composite attribute | | |
| Lg/ERM-ERM-Cardinality | Cardinality | ERM-ERM-Cardinality | 2.2.11 | 2 | ERM | 2.2 | ERM-ERM | R1 | n:m relation | | |
| Lg/ERM-ERM-RecursiveRelationship | RecursiveRelationship | ERM-ERM-RecursiveRelationship | 2.2.8 | 2 | ERM | 2.2 | ERM-ERM | R1 | ERM | | |
| Lg/ERM-ERM-n-digit-Relationship | n-digit-Relationship | ERM-ERM-n-digit-Relationship | 2.2.9 | 2 | ERM | 2.2 | ERM-ERM | R2 | binary relation, ternary relation, n:m relation | | |
| Lg/ERM-ERM-Relationship | Relationship | ERM-ERM-Relationship | 2.2.7 | 2 | ERM | 2.2 | ERM-ERM | R1 | Relationship, Entity Type | | |
| Lg/ERM-ERM-MinMaxNotation | MinMaxNotation | ERM-ERM-MinMaxNotation | 2.2.12 | 2 | ERM | 2.2 | ERM-ERM | R2 | Cardinality | | |
| Lg/ERM-ERM-WeakEntity | WeakEntity | ERM-ERM-WeakEntity | 2.2.13 | 2 | ERM | 2.2 | ERM-ERM | R2 | Weak entity | | |
| Lg/ERM-ERM-MultivaluedAttribute | MultivaluedAttribute | ERM-ERM-MultivaluedAttribute | 2.2.6 | 2 | ERM | 2.2 | ERM-ERM | R2 | ERM | | |
| Lg/ERM-ERM-Attribute | Attribute | ERM-ERM-Attribute | 2.2.4 | 2 | ERM | 2.2 | ERM-ERM | R1 | Attribute | | |
| Lg/ERM-ERM-FormalRelationship | FormalRelationship | ERM-ERM-FormalRelationship | 2.2.10 | 2 | ERM | 2.2 | ERM-ERM | R3 | ERM | | |
| Lg/ERM-ERM | ERM | ERM-ERM | 2.2 | 2 | ERM | 2.2 | ERM-ERM | R1 | ERM | | |
| Lg/ERM-ERM-Schematic | Schematic | ERM-ERM-Schematic | 2.2.1 | 2 | ERM | 2.2 | ERM-ERM | R3 | ERM, scope statement, ERD, relational model | | |
| Lg/ERM-ConceptualDesign-Abstraction | Abstraction | ERM-ConceptualDesign-Abstraction | 2.3.1 | 2 | ERM | 2.3 | ERM-ConceptualDesign | R2 | ERM | | |
| Lg/ERM-ConceptualDesign-UML | UML | ERM-ConceptualDesign-UML | 2.3.3 | 2 | ERM | 2.3 | ERM-ConceptualDesign | R3 | ERD, UML | | |
| Lg/ERM-ConceptualDesign | ConceptualDesign | ERM-ConceptualDesign | 2.3 | 2 | ERM | 2.3 | ERM-ConceptualDesign | R1 | ERM, conceptual design | | |
| Lg/ERM-ConceptualDesign-Guidelines | Guidelines | ERM-ConceptualDesign-Guidelines | 2.3.2 | 2 | ERM | 2.3 | ERM-ConceptualDesign | R2 | conceptual design | | |
| Lg/RelData-Datamodel | Datamodel | RelData-Datamodel | 3.1 | 3 | RelData | 3.1 | RelData-Datamodel | R2 | data model, relational database, relational model | | |
| Lg/RelData-ERD2RM | ERD2RM | RelData-ERD2RM | 3.2 | 3 | RelData | 3.2 | RelData-ERD2RM | R1 | ERD, relational model | | |
| Lg/RelData-RelationalAlgebra | RelationalAlgebra | RelData-RelationalAlgebra | 3.3 | 3 | RelData | 3.3 | RelData-RelationalAlgebra | R1 | relational algebra | | |
| Lg/RelData-RelationalCalculus | RelationalCalculus | RelData-RelationalCalculus | 3.4 | 3 | RelData | 3.4 | RelData-RelationalCalculus | R1 | relational calculus | | |
| Lg/RelData-RelationalCalculus-TupelCalculus | TupelCalculus | RelData-RelationalCalculus-TupelCalculus | 3.4.1 | 3 | RelData | 3.4 | RelData-RelationalCalculus | R1 | tupel calculus | | |
| Lg/RelData-RelationalCalculus-DomainCalculus | DomainCalculus | RelData-RelationalCalculus-DomainCalculus | 3.4.2 | 3 | RelData | 3.4 | RelData-RelationalCalculus | R1 | domain calculus | | |
| Lg/SQL-DML-WhereClause | WhereClause | SQL-DML-WhereClause | 4.1.2 | 4 | SQL | 4.1 | SQL-DML | R1 | Between, Like, Null, And, Or, Not, All, Any, Exists | | |
| Lg/SQL-DML-BasicRelationalOperators | BasicRelationalOperators | SQL-DML-BasicRelationalOperators | 4.1.5 | 4 | SQL | 4.1 | SQL-DML | R1 | Union, Except, Cross Join, Where, Distinct, As, Vereinigung, Differenz, Kreuzprodukt, Selektion, Projektion, Umbenennung | | |
| Lg/SQL-DML-WhereClauseExtensions | WhereClauseExtensions | SQL-DML-WhereClauseExtensions | 4.1.3 | 4 | SQL | 4.1 | SQL-DML | R1 | Is Null, Arithmetic Expressions, Like | | |
| Lg/SQL-DML-SqlVsCalculus | SqlVsCalculus | SQL-DML-SqlVsCalculus | 4.1.4 | 4 | SQL | 4.1 | SQL-DML | R1 | Distinct, Select, From | | |
| Lg/SQL-DML | DML | SQL-DML | 4.1 | 4 | SQL | 4.1 | SQL-DML | R1 | DML | | |
| Lg/SQL-DML-FurtherRelationalOperators | FurtherRelationalOperators | SQL-DML-FurtherRelationalOperators | 4.1.6 | 4 | SQL | 4.1 | SQL-DML | R2 | Theta Join, Natural Join | | |
| Lg/SQL-DML-Select | Select | SQL-DML-Select | 4.1.1 | 4 | SQL | 4.1 | SQL-DML | R1 | Select, From, Where | | |
| Lg/SQL-DML-NestedQueries | NestedQueries | SQL-DML-NestedQueries | 4.1.7 | 4 | SQL | 4.1 | SQL-DML | R2 | Subquery, Nested query, Exists, In, All, Any | | |
| Lg/SQL-DDL | DDL | SQL-DDL | 4.2 | 4 | SQL | 4.2 | SQL-DDL | R1 | DDL | | |
| Lg/SQL-DDL-AlterDropTable | AlterDropTable | SQL-DDL-AlterDropTable | 4.2.3 | 4 | SQL | 4.2 | SQL-DDL | R2 | Table, Alter, Drop | | |
| Lg/SQL-DDL-CreateIndex | CreateIndex | SQL-DDL-CreateIndex | 4.2.4 | 4 | SQL | 4.2 | SQL-DDL | R2 | Index, Create, Drop, Unique | | |
| Lg/SQL-DDL-PrimaryKey | PrimaryKey | SQL-DDL-PrimaryKey | 4.2.2 | 4 | SQL | 4.2 | SQL-DDL | R2 | Primary Key | | |
| Lg/SQL-DDL-CreateTable | CreateTable | SQL-DDL-CreateTable | 4.2.1 | 4 | SQL | 4.2 | SQL-DDL | R2 | Table, Create | | |
| Lg/SQL-DDL-CreateView | CreateView | SQL-DDL-CreateView | 4.2.5 | 4 | SQL | 4.2 | SQL-DDL | R2 | View, Create | | |
| Lg/SQL-ReportAndModify-AggregateFunctions | AggregateFunctions | SQL-ReportAndModify-AggregateFunctions | 4.3.1 | 4 | SQL | 4.3 | SQL-ReportAndModify | R1 | Count, Min, Max, Sum, Avg, StdDev, Variance | | |
| Lg/SQL-ReportAndModify | ReportAndModify | SQL-ReportAndModify | 4.3 | 4 | SQL | 4.3 | SQL-ReportAndModify | R1 | DML | | |
| Lg/SQL-ReportAndModify-GroupBy | GroupBy | SQL-ReportAndModify-GroupBy | 4.3.2 | 4 | SQL | 4.3 | SQL-ReportAndModify | R2 | Group By, Having | | |
| Lg/SQL-DCL | DCL | SQL-DCL | 4.4 | 4 | SQL | 4.4 | SQL-DCL | R2 | GRANT, REVOKE | | |
| Lg/SQL-TCL | TCL | SQL-TCL | 4.5 | 4 | SQL | 4.5 | SQL-TCL | R2 | COMMIT, ROLLBACK | | |
| Lg/RelQuery-OptimizeQuery-SQL2RA | SQL2RA | RelQuery-OptimizeQuery-SQL2RA | 5.1.1 | 5 | RelQuery | 5.1 | RelQuery-OptimizeQuery | R3 | Auswertungsplan, SQL, rel algebra | | |
| Lg/RelQuery-OptimizeQuery | OptimizeQuery | RelQuery-OptimizeQuery | 5.1 | 5 | RelQuery | 5.1 | RelQuery-OptimizeQuery | R2 | deklarative sprache, prozeduale sprache | | |
| Lg/RelQuery-OptimizeQuery-logAndPyis | logAndPyis | RelQuery-OptimizeQuery-logAndPyis | 5.1.3 | 5 | RelQuery | 5.1 | RelQuery-OptimizeQuery | R3 | Optimierungsgründe | | |
| Lg/RelQuery-OptimizeQuery-RuleBased | RuleBased | RelQuery-OptimizeQuery-RuleBased | 5.1.4 | 5 | RelQuery | 5.1 | RelQuery-OptimizeQuery | R2 | Regelbasiert | | |
| Lg/RelQuery-OptimizeQuery-RAOrder | RAOrder | RelQuery-OptimizeQuery-RAOrder | 5.1.2 | 5 | RelQuery | 5.1 | RelQuery-OptimizeQuery | R3 | Auswertungsplan | | |
| Lg/RelQuery-OptimizeQuery-CostBased | CostBased | RelQuery-OptimizeQuery-CostBased | 5.1.5 | 5 | RelQuery | 5.1 | RelQuery-OptimizeQuery | R2 | Kostenbasiert | | |
| Lg/RelQuery-BasicOperations-HashJ | HashJ | RelQuery-BasicOperations-HashJ | 5.2.4 | 5 | RelQuery | 5.2 | RelQuery-BasicOperations | R2 | Hash Join | | |
| Lg/RelQuery-BasicOperations-SMJ | SMJ | RelQuery-BasicOperations-SMJ | 5.2.5 | 5 | RelQuery | 5.2 | RelQuery-BasicOperations | R2 | Sort-Merge Join | | |
| Lg/RelQuery-BasicOperations | BasicOperations | RelQuery-BasicOperations | 5.2 | 5 | RelQuery | 5.2 | RelQuery-BasicOperations | R2 | Basis operationen, Join | | |
| Lg/RelQuery-BasicOperations-IndexJ | IndexJ | RelQuery-BasicOperations-IndexJ | 5.2.3 | 5 | RelQuery | 5.2 | RelQuery-BasicOperations | R2 | Index Join | | |
| Lg/RelQuery-BasicOperations-NBLJ | NBLJ | RelQuery-BasicOperations-NBLJ | 5.2.2 | 5 | RelQuery | 5.2 | RelQuery-BasicOperations | R2 | Nested Block Loop Join | | |
| Lg/RelQuery-BasicOperations-NLJ | NLJ | RelQuery-BasicOperations-NLJ | 5.2.1 | 5 | RelQuery | 5.2 | RelQuery-BasicOperations | R2 | Nested Loop Join | | |
| Lg/RelQuery-IndexStructure | IndexStructure | RelQuery-IndexStructure | 5.3 | 5 | RelQuery | 5.3 | RelQuery-IndexStructure | R2 | Indexstrukturen | | |
| Lg/RelQuery-IndexStructure-BPlusTree | BPlusTree | RelQuery-IndexStructure-BPlusTree | 5.3.2 | 5 | RelQuery | 5.3 | RelQuery-IndexStructure | R2 | B+ Baum | | |
| Lg/RelQuery-IndexStructure-BTree | BTree | RelQuery-IndexStructure-BTree | 5.3.1 | 5 | RelQuery | 5.3 | RelQuery-IndexStructure | R1 | BBaum, B-Baum, B Baum | | |
| Lg/RelQuery-IndexStructure-NDim | NDim | RelQuery-IndexStructure-NDim | 5.3.3 | 5 | RelQuery | 5.3 | RelQuery-IndexStructure | R2 | mehrdimensionale Daten | | |
| Lg/RelDesign-FunctDependencies | FunctDependencies | RelDesign-FunctDependencies | 6.1 | 6 | RelDesign | 6.1 | RelDesign-FunctDependencies | R1 | FD, FDSet | | |
| Lg/RelDesign-Armstrong-CanonicalCover | CanonicalCover | RelDesign-Armstrong-CanonicalCover | 6.2.2 | 6 | RelDesign | 6.2 | RelDesign-Armstrong | R2 | canonical cover | | |
| Lg/RelDesign-Armstrong | Armstrong | RelDesign-Armstrong | 6.2 | 6 | RelDesign | 6.2 | RelDesign-Armstrong | R2 | Armstrong Axiome, Attributhülle, kanonische Überdeckung | | |
| Lg/RelDesign-Armstrong-AttributeClosure | AttributeClosure | RelDesign-Armstrong-AttributeClosure | 6.2.1 | 6 | RelDesign | 6.2 | RelDesign-Armstrong | R2 | Attributhülle | | |
| Lg/RelDesign-DecompositionOfRelations | DecompositionOfRelations | RelDesign-DecompositionOfRelations | 6.3 | 6 | RelDesign | 6.3 | RelDesign-DecompositionOfRelations | R2 | Anomalie, Verlustlosigkeit, Abhängigkeitserhaltung | | |
| Lg/RelDesign-Normalform-1NF | 1NF | RelDesign-Normalform-1NF | 6.4.1 | 6 | RelDesign | 6.4 | RelDesign-Normalform | R2 | 1NF | | |
| Lg/RelDesign-Normalform | Normalform | RelDesign-Normalform | 6.4 | 6 | RelDesign | 6.4 | RelDesign-Normalform | R2 | 1NF, 2NF, 3NF, BCNF | | |
| Lg/RelDesign-Normalform-DecompositionAlg | DecompositionAlg | RelDesign-Normalform-DecompositionAlg | 6.4.4 | 6 | RelDesign | 6.4 | RelDesign-Normalform | R1 | functional dependency, Boyce-Codd normal form, database normalisation, Candidate Key | | |
| Lg/RelDesign-Normalform-2NF | 2NF | RelDesign-Normalform-2NF | 6.4.2 | 6 | RelDesign | 6.4 | RelDesign-Normalform | R2 | 2NF | | |
| Lg/RelDesign-Normalform-SynthesisAlg | SynthesisAlg | RelDesign-Normalform-SynthesisAlg | 6.4.3 | 6 | RelDesign | 6.4 | RelDesign-Normalform | R1 | synthesis algorithm | | |
| Lg/AltDM-XML-Schema | Schema | AltDM-XML-Schema | 7.1.1 | 7 | AltDM | 7.1 | AltDM-XML | R1 | XML, semi-structured data, HTML, W3C, XML Schema, XML validation, Document Type Definition, RELAX NG | | |
| Lg/AltDM-XML | XML | AltDM-XML | 7.1 | 7 | AltDM | 7.1 | AltDM-XML | R2 | XML, semi-structured data, HTML, W3C | | |
| Lg/AltDM-XML-XPath | XPath | AltDM-XML-XPath | 7.1.2 | 7 | AltDM | 7.1 | AltDM-XML | R1 | XML, XPath, XML Information Set, XML tree | | |
| Lg/AltDM-RDF-Graph | Graph | AltDM-RDF-Graph | 7.2.2 | 7 | AltDM | 7.2 | AltDM-RDF | R1 | Turtle | | |
| Lg/AltDM-RDF-SPARQL | SPARQL | AltDM-RDF-SPARQL | 7.2.3 | 7 | AltDM | 7.2 | AltDM-RDF | R1 | SPARQL | | |
| Lg/AltDM-RDF | RDF | AltDM-RDF | 7.2 | 7 | AltDM | 7.2 | AltDM-RDF | R2 | RDF | | |
| Lg/AltDM-RDF-Datamodel | Datamodel | AltDM-RDF-Datamodel | 7.2.1 | 7 | AltDM | 7.2 | AltDM-RDF | R1 | URI | | |
| Lg/AltDM-GraphDB | GraphDatabases | AltDM-GraphDB | 7.3 | 7 | AltDM | 7.3 | AltDM-GraphDB | R1 | graph database, RDF, LPG, node, edge | | |
| Lg/TM-DataSecurity | DataSecurity | TM-DataSecurity | 8.1 | 8 | TM | 8.1 | TM-DataSecurity | R2 | information security | | |
| Lg/TM-TransactionConcept | TransactionConcept | TM-TransactionConcept | 8.2 | 8 | TM | 8.2 | TM-TransactionConcept | R2 | ACID, Transaction | | |
| Lg/TM-Synchronisation | Synchronisation | TM-Synchronisation | 8.3 | 8 | TM | 8.3 | TM-Synchronisation | R2 | Synchronisation | | |
| Lg/TM-Synchronisation-Serialisabilty | Serialisabilty | TM-Synchronisation-Serialisabilty | 8.3.1 | 8 | TM | 8.3 | TM-Synchronisation | R1 | Serialisability | | |
| Lg/TM-Scheduler | Scheduler | TM-Scheduler | 8.4 | 8 | TM | 8.4 | TM-Scheduler | R1 | Scheduler | | |
| Lg/TM-Recovery | Recovery | TM-Recovery | 8.5 | 8 | TM | 8.5 | TM-Recovery | R1 | Recovery | | |
