Full Description
The second edition of the best-selling Inside Relational Databases is revised and updated to bring you the most reader-friendly explanation of the relational model and its importance to database designers and builders.
Clear explanations make use of examples rather than equations to show you how an understanding of the relational model can make your databases faster, more flexible and thoroughly fit for their purpose.
Dr Mark Whitehorn has an extensive understanding of relational database theory and his popular and long running database column in the UK's "Personal Computer World" has already made database theory accessible to thousands.
Bill Marklyn has an intimate knowledge of relational databases and was the Development Manager who oversaw the entire design of the first two major releases of Microsoft's highly successful database product, Access.
Together they make a great team, illuminating a tricky subject with substance and style.
Reviews from the first edition of Inside Relational Databases:
"Quite simply - superb. By making relational databases understandable, Mark Whitehorn and Bill Marklyn have achieved far more than most. Making the subject interesting and entertaining as well puts these two authors firmly in a class of their own."
- Neil Fawcett, Group Technical Editor, VNU Business Publications
"PCW and Amazon.co.uk contributor Mark Whitehorn is that rare combination - an expert in his field, databases, and a fine writer too, with a talent for honing a complex subject down to its essentials."
- Tamsin Todd, Computer & Internet Editor, Amazon.co.uk
"Inside Relational Databases is excellent. It is clearly and concisely written and full of humorous asides which ease the reader through an otherwise weighty topic. Probably the most engaging technical book I have read."
- Paul McGowan
Contents
Introduction.- Part 1. A Simple, Single-Table Database: Introduction. Tables. Forms. Queries. Reports. Summary.- Part 2. A Multi-Table, Single-User Database: Introduction. Serious Problems with Single Tables. Multiple Tables Cure Serious Problems. Making Multiple Tables Work Together. Getting the Data into the Correct Tables. Relationships in the Real World. How are Relationships Modeled? Revisiting the Big Four - The Synergy Begins. Integrity. Building a Database Application. Summary.- Part 3. Multi-Table Multi-User Databases: Database Architectures. More Complex Database Design. Triggers, Stored Procedures and Views. Transactions, Logs, Bakckup, Locking and Concurrency.- Part 4. Related Database Topics: What Exactly is a Relational Database? Codd's Rules. Normalization. The Data Dictionary. More on Queries: Data Manipulation. Domains. Indexing - Speeding Up Your Database. What Does Null Mean? Primary Keys. Glossary.
