- Shopping Bag ( 0 items )
Want a NOOK? Explore Now
Beginning Database Design Solutions
Databases play a critical role in the business operations of most organizations; they're the central repository for critical information on products, customers, suppliers, sales, and a host of other essential information. It's no wonder that the majority of all business computing involves database applications.
With so much at stake, you'd expect most IT professionals would have a firm understanding of good database design. But in fact most learn through a painful process of trial and error, with predictably poor results.
This book provides readers with proven methods and tools for designing efficient, reliable, and secure databases. Author Rod Stephens explains how a database should be organized to ensure data integrity without sacrificing performance. He shares procedures for designing robust, flexible, and secure databases that provide a solid foundation for all of your database applications. The methods and techniques in this book can be applied to any database environment, including Oracle®, Microsoft Access®, SQL Server®, and MySQL®. You'll learn the basics of good database design and ultimately discover how to design a real-world database.?
What you will learn from this book
Who this book is for
This book is for anyone interested in learning to design, build, analyze, and understand databases. No previous experience with databases or programs is required.
Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.
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.
Perdedor1030
Posted January 14, 2009
I Also Recommend:
Most database books that I have seen focus on specific database management system software (SQL Server, MySQL, Oracle), SQL syntax, or ADO.NET. This book teaches you the steps to building a solid database, and it does not matter which database software you use. The underlying rules of creating databases are universal. You will, however, need to learn your database software and SQL syntax. I recommend getting familiar with your software and SQL, and then master the steps of building a solid, professional database using this book.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Overview
Beginning Database Design Solutions
Databases play a critical role in the business operations of most organizations; they're the central repository for critical information on products, customers, suppliers, sales, and a host of other essential information. It's no wonder that the majority of all business computing involves database applications.
With so much at stake, you'd expect most IT professionals would have a firm understanding of good ...