$44.99, 552 pages, 2008
From the back cover:
The database is the foundation on which all other development rests. Make your foundation solid!
This concise introduction teaches database design concepts, methods, and techniques of high-quality database design. You'll explore creating an initial logical design and refining it into a superior database that meets users' requirements. Plus, you'll see how to implement the design using specific types of database platforms and build databases using SQL scripts. Each chapter begins with a list of topics that will be covered, closes with a summary that provides the key points described in the chapter, and includes a list of review questions and a series of helpful exercises.
This book does not require any previous programming or database experience. You can follow most of the material with a simple pencil (or a pen if you're particularly confident in your work) and paper.
A few chapters explain how to use Access and MySQL databases so you'll need those products to get the most out of those chapters. (Note that MySQL is FREE so this provides a nice introduction to a powerful database tool without a lot of expense.)
What you will learn from this book
This book also explains enough SQL (Structured Query Language) to build databases and get you started with SQL programming. (Enough to be dangerous and ask your database administrator pesky questions!-)
- How to decide what kind of database best suits your needs.
- How to study a proposed application to determine its database needs.
- How to convert database needs into different kinds of database models.
- How to normalize and refine the database design to improve performance and robustness.
- How to implement the database in Microsoft Access or MySQL. (Other database products are similar, at least in concepts if not in the details.)
- How to build a database by using SQL scripts.
Who this book is for
This book is for those who need to build, tune, maintain, or consume a database. (By "consume" I mean write a program to manipulate a database, not pour barbecue sauce on a flash drive and swallow it--a procedure that I do NOT recommend.)
This book does not assume you have previous programming or database experience.
Wrox Programmer's References are designed to give the experienced developer straight facts on a new technology, without hype or unnecessary explanations. They deliver hard information with plenty of practical examples to help you apply new tools to your development projects today.