Inside Relational Databases with Examples in Access

1. Introduction

Part 1. A simple, single-table database

2. Introduction to Part 1

3. Tables

4. Queries/Views

5. Forms

6. Reports

7. Summary of Part 1

Part 2. A multi-table database

8. Introduction to Part 2

9. Serious problems with single tables

10. Multiple tables cure serious problems

11. Making multiple tables work together

12. Getting the data into the correct tables

13. Relationships in the real world

14. How are relationships modeled?

15. Revisiting the big four — the synergy begins

16. Integrity

17. Summary of Part 2

Part 3. Database Design & Architecture

18. Database design

19. The seven layers of wisdom

20. Database architecture

Part 4. Related database topics

21. What exactly is a relational database?

22. Chapter 22 Triggers and stored procedures

23. Transactions, logs, backup, locking and concurrency

24. Codd’s rules

25. Normalization

26. More about normalization

27. The system tables

28. More on queries: data manipulation

29. SQL

30. Domains

31. What does null mean?

32. Primary keys

Part 5. Speeding up your database

33. Hardware considerations

34. Indexing

35. More on optimization

36. Denormalization

DRM-restrictions

Printing: not available
Clipboard copying: not available

Keywords: COMPUTERS / Computer Science COM014000