1. |
|
OT
|
Orientation |
|
|
|
Chapter 1: Introduction
|
Database System |
|
2. |
|
Chapter 2: Intro to Relational Model
|
Relational Model |
|
|
|
Chapter 2: Intro to Relational Model / Chapter 3: Introduction to SQL
|
Natural Join. SQL |
|
3. |
|
Chapter 3: Introduction to SQL
|
Create tables, Basic Query Structure, Clause |
|
4. |
|
Chapter 3: Introduction to SQL
|
Joins, Operation |
|
5. |
|
Chapter 3: Introduction to SQL
|
Set Operations, Null Values, Aggregate Functions |
|
|
|
Chapter 3: Introduction to SQL
|
Aggregate Functions, Nested Subqueries |
|
6. |
|
Chapter 3: Introduction to SQL
|
Nested Subqueries, Modification of the Database |
|
|
|
Chapter 3: Introduction to SQL
|
MySLQ, Modification of the Database |
|
7. |
|
Chapter 3: Introduction to SQL / Chapter 4: Intermediate SQL
|
MySLQ Server Installation, Join Expressions |
|
8. |
|
Chapter 4: Intermediate SQL
|
Views, Transactions |
|
|
|
Chapter 4: Intermediate SQL
|
Integrity Constraints, SQL Data Types and Schemas, Authorization |
|
9. |
|
Chapter 5: Advanced SQL
|
JDBC |
|
10. |
|
Chapter 5: Advanced SQL
|
JDBC |
|
11. |
|
Chapter 7: Entity-Relationship Model
|
Design Process, Modeling, Constraints, E-R Diagram |
|
12. |
|
Chapter 7: Entity-Relationship Model
|
Design Issues |
|
|
|
Chapter 8: Relational Database Design
|
Features of Good Relational Design, Atomic Domains and First Normal Form |
|
13. |
|
Chapter 8: Relational Database Design
|
|
|
14. |
|
Chapter 5: Advanced SQL
|
ODBC, Embedded SQL, SQL Data Types and Schemas
Functions and Procedural Constructs |
|
|
|
Chapter 5: Advanced SQL
|
SQL Procedures |
|
15. |
|
Chapter 5: Advanced SQL / Chapter 11: Indexing and Hashing
|
Triggers, Advanced Aggregation Features, index file, B+-Tree |
|