Rod Stephens

Beginning Database Design Solutions (eBook, PDF)

• Format: PDF

Produktbeschreibung

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.

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.

Produktdetails

• Verlag: Jossey-Bass
• Seitenzahl: 560
• Erscheinungstermin: 15. April 2009
• Englisch
• ISBN-13: 9780470440513
• Artikelnr.: 37292487

Autorenporträt

Rod Stephens is a professional software developer who has built a wide variety of software and database applications in his 20-year career. He is the author of 18 books and more than 250 articles, and is a regular contributor to DevX.com (www.devx.com). Rod's clear, compelling writing makes it easy for less experienced readers to master new material. His current position as an adjunct instructor for ITT Technical institute has given him additional insight into the kinds of discussion, examples, and exercises that students find most helpful.

Inhaltsangabe

I. Introduction to Databases and Database Design.1. Golas of Effective Database Design.2. Database Types.3. Relational Database Fundamentals.II. Database and Design Process Techniques.4. Understanding User Needs.5. Translating User Needs Into Data Models.6. Extracting Business Rules.7. Normalizing Data.8. Designing Databases to Support Software Applications.9. Common Design Patterns.10. Common Design Pitfalls.III. A Detailed Case Study.11. User Needs and Requirements.12. Building a Data Model.13. Building a Relastional Model.14. Extracting Business Rules.15. Normalization and Refinement.16. Microsoft Access.17. MySQL.IV. Advanced Topics.18. Introdution to SQL.19. Building Databases with SQL Scripts.20. Databse Elements.21. Database Security.Appendix A. Exercise Solutions.Appendix B. Sample Database Designs.Appendix C. Glossary.Index.