|
Free ebooks
 Free database ebooks Access Springer Inside Relational Databases with Examples in Access
|
||||||||
 Part 1 – A simple, single-table databasePart 1 concentrates on databases which contain only single tables because this should make some of the basic principles easier to understand. Chapter 2 ?? Introduction to Part 1 Chapter 3 ?? Tables Chapter 4 ?? Queries/Views Chapter 5 ?? Forms Chapter 6 ?? Reports Part 2 – A multi-table database Part 2 explains that when most people start building more complex databases they tend to try and put all of the data into one table. Chapter 8 ?? Introduction to Part 2 Chapter 9 ?? Serious problems with single tables Chapter 10 ?? Multiple tables cure serious problems Chapter 11 ?? Making multiple tables work together Chapter 12 ?? Getting the data into the correct tables Chapter 13 ?? Relationships in the real world Chapter 14 ?? How are relationships modeled? Chapter 15 ?? Revisiting the big four – the synergy begins Chapter 16 ?? Integrity Part 3 – Database Design & Architecture Part 3 discusses, in broad terms, where the components of your database can be located. Chapter 18 ?? Database design Chapter 19 ?? The seven layers of wisdom Chapter 20 ?? Database architecture Part 4 – Related database topics Part 4 is very different from the other parts. Chapter 21 ?? What exactly is a relational database? Chapter 22 ?? Triggers and stored procedures Chapter 23 ?? Transactions, logs, backup, locking and Chapter 24 ?? Codd’s rules Chapter 25 ?? Normalization Chapter 26 ?? More about normalization Chapter 27 ?? The system tables Chapter 28 ?? More on queries: data manipulation Chapter 29 ?? SQL Chapter 30 ?? Domains Chapter 31 ?? What does null mean? Chapter 32 ?? Primary keys Part 5 – Speeding up your database Part 5 is about speeding up your database and a range of techniques is discussed there. Chapter 33 ?? Hardware considerations Chapter 34 ?? Indexing Chapter 35 ?? More??on??optimization Chapter 36 ?? Denormalization Appendix 1 ?? GUIs, macros and control languages Download free pdf ebooks on access:Springer Inside Relational Databases with Examples in Access
|
| More free ebooks | |