Beginning Database Design Solutions (Google eBook)

Rod Stephens

John Wiley & Sons, Dec 30, 2010 - Computers - 400 pages

The vast majority of software applications use relational databases that virtually every application developer must work with. This book introduces you to database design, whether you're a DBA or database developer. You'll discover what databases are, their goals, and why proper design is necessary to achieve those goals. Additionally, you'll master how to structure the database so it gives good performance while minimizing the chance for error. You will learn how to decide what should be in a database to meet the application's requirements.

What people are saying

Review: Beginning Database Design Solutions

User Review  - Terri Jones - Goodreads

Database Concepts course

Review: Beginning Database Design Solutions

User Review  - Vahid - Goodreads

This book is good for the one who has never heard of Tables, Columns or Rows! If you know these stuff, you can read the book in 1-2 days in a fast speed. Chapters 8,9 (DB Design Patterns & Pitfalls ...

Contents

• Database Design Process and Techniques: ii
• Translating User Needs into Data Models: xxi
• Extracting Business Rules: xlix
• Normalizing Data: lxi
• Designing Databases to Support Software Applications: 7-31
• Common Design Patterns: 7-39
• Common Design Pitfalls: 7-58
• Obsession with: 7-66
• User Needs and Requirements: 7-72
• Building a Data Model: 12-1
• Extracting Business Rules: 12-18
• Normalization and Refinement: 12-26
• Implementing Databases with Examples in Access: 12-36
• MySQL: 15-27
• Advanced Topics: 16-26
• DROP: 16-35
• Summary: 16-43
• Database Maintenance: 16-54
• Database Security: 16-61
• Too Much Security: 16-68
• Chapter 2: 16-77
• Chapter 15: A-17
• Sample Database Designs: B-1
• Glossary: B-26

About the author

In a previous incarnation, Rod Stephens was a mathematician. During his stint at MIT, he discovered the joys of algorithms and graphics, and has been programming professionally ever since. During his career, he has worked on an eclectic assortment of applications spanning such topics as repair dispatch, telephone switch programming, tax processing, and training for professional football players. Rod has written more than a dozen books that have been translated into half a dozen different languages, and more than 200 magazine articles covering Visual Basic, Visual Basic for Applications, Delphi, and Java. He is a columnist for Hardcore Visual Basic. Rod's popular website, VB Helper ( http: //www.vb-helper.com) receives several million hits per month and contains more than a thousand pages of tips, tricks, and example code for Visual Basic programmers.

Bibliographic information

• Title: Beginning Database Design Solutions
• Author: Rod Stephens
• Publisher: John Wiley & Sons, 2010
• ISBN: 047044052X, 9780470440520
• Length: 400 pages
• Subjects: Computers / Databases / Data Warehousing