• About the Course
• Chapter List
• White Papers
• Links
• Presentation Schedule
• Presentations

Chapter List
 

1. Introduction to Database 
2. Database Environment 
3. The Relational Model 
4. Database Planning, Design and Administration 
5. Entity Relationship Modeling 
6. Normalization 
7. Conceptual Database Design Methodology 
8. Logical Database Design Methodology 
9. Physical Database Design Methodology (Zip File) 
10. Conceptual Database Design Methodology - Worked Example 
11. Conceptual Database Design Methodology - Worked Example(Zip File) 
12. Physical Databases Design Methodology - Worked Example (Zip File) 
13. Structured Query Language (SQL) - (Zip File) 
14. Advanced SQL - (Zip File) 
15. Query-by-Example (Zip File) 
16. Data Warehousing Transperancies
17. Data Mining
18. Metadata

White Papers

1. An Introductory Overview of Logical Data Modeling 
2. An Introductory Overview of Conceptual Data Modeling 

Go to Top
 
 
 
 
 
 
 

Presentations:

Part Two : Planning the Data Warehouse
Chapter 7 : Technical Architecture for Data Warehousing
Chapter 8 : Creating a Business Case
Chapter 9 : A Flexible Approach to Developing a Data Warehouse

Part Three : The Critical Issue
Chapter 11 : Metadata
Chapter 12 : Role of a Directory Catalog
Chapter 13 : Data Transformation

Part Four : Design and Implementation
Chapter 14 : Physical Design
Chapter 17 : VLDBS and Parallelism
Chapter 19 : MiddleWare: Gluing the Warehouse Together
Chapter 21 : The Virtual Data Warehouse
Chapter 22 : Operational Data Stores: Developing An Effective Strategy
Chapter 23 : Data Mining

Part Five : Data Warehouse Administration
Chapter 24 : Systems Administration
Chapter 27 : Selecting End-User Tools
Part Six : Trends
Chapter 28 : Trends in Data Warehouse
 

Go to Top
Presentation contents based on the text -Data Warehouse: Practical
Advice From The Experts by Joyce Bischoff and Ted Alexander