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