Practical Web Database Design

Book Summary

See a sample chapter: Core Database Concepts".

Let's cut straight to the chase - this book will take you from knowing what a database is, to knowing how to design one effectively so that it makes good use of storage space, and provides fast and efficient data access. From first principles to implementation, we take the woe from normalization and the worry from stored procedures.
This book doesn't present platform-specific database implementations, but takes you through the steps you need to follow to ensure that your database does the job you want it to do, and does it well.

What's great about this book?

We give you a solid beginning, from which well-designed databases will spring. We'll provide an introduction to databases for those of you who aren't familiar with them, then move swiftly on to look at the core aspects of a database, as well as the basic building blocks of your design. We take you through an example of planning a database, followed by designing and implementing it, before we move on to cover the all-important topic of security. There are sections on advanced techniques and database management to help you get the most out of your new database

Subject Area:

• How to design a database properly
• When to make the database simpler
• How to use Structured Query Langues effectively
• How to optimize your databases for the Web
• How to prepare for the worst - hackers and crashes

Who Is This Book For?

This book is for you if you want to design (and build) databases for use with the Web. This book won't present platform-specific database implementations, but we will take you through the steps you need to follow to ensure that your database does the job you want it to do, and does it well.
This is the book for you, whether you've never really used databases before, but want to start incorporating them into your web sites now or in the future, or you have built database-driven web sites before, but want to learn how to make them work better.