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 |
|