Part I. Introduction to databases
1. Databases and database users
2. Database system concepts and architecture
Part II. The relational data model and SQL
3. The relational data model and relational database constraints
4. Basic SQL
5. More SQL: complex queries, triggers, views, and schema modification
6. The relational algebra and relational calculus
Part III. Conceptual modeling and database design
7. Data modeling using the entity-relationship (ER) model
8. The enhanced entity-relationship (EER) model
9. Relational databse design by ER- and EER-to-relational mapping
10. Practical database design methodology and use of UML diagrams
Part IV. Object, object-relational, and XML: concepts, models, languages, and standards
11. Object and object-relational databases
12. XML: extensible markup language
Part V. Databases programming techniques
13. Introduction o SQL programming techniques
14. Web database programming using PHP
Part VI. Database design theory and normalization
15. Basics of functional dependencies and normalization for relational databases
16. Relational database design algorithms and further dependencies
Part VII. File structures, indexing, and hashing
17. Disk storae, basic file structures, and hashing
8. Indexing structures for files
Part VIII. Query processing and optimization, and database tuning
19. Algorithms for query processing and optimization
20. Physical database design and tuning
Part IX. Transaction processing, concurrency control, and recovery
21. Introduction to transaction processing concepts and theory
22. Concurrency control techniques
23. Database recovery techniques
Part X. Additional database topics: security and distribution
24. Database security
25. Distributed databases
Part XI. Advanced database models, systems and applications
26. Enhanced data models for advanced applications
27. Introduction to informational retrieval and web search
28. Data mining concepts
29. Overview of data warehousing and OLAP
Appendix A. Alternative diagrammatic notations for ER models
Appendix B. Parameters of disks
Appendix C. Overview of the QBE language
Appendix D. Overview of the hiearchical data model
Appendix E. Overview of the network data model
Selected bibliography
Index