Książki

This is the perfect reference for programmers, administrators, or Web designers who are new to database development and are uncertain as to how to design and structure a database efficiently. It shows how to design and implement robust, scalable databases on any of the major relational database management systems, including Access, SQL Server, IBM DB2, MySQL, and Oracle. It covers all the key database design steps including modeling, normalization, SQL, denormalization, object-modeling, data warehousing, and performance. It provides plenty of real-world examples and a complete beginning-to-end case study of creating a database that includes the analysis and planning, tables and data structures, business rules, and hardware requirements.

Beginning Database Design

Introduction.Part I: Approaching Relational Database Modeling.Chapter 1: Database Modeling Past and Present.Chapter 2: Database Modeling in the Workplace.Chapter 3: Database Modeling Building Blocks.Part II: Designing Relational Database Models.Chapter 4: Understanding Normalization.Chapter 5: Reading and Writing Data with SQL.Chapter 6: Advanced Relational Database Modeling.Chapter 7: Understanding Data Warehouse Database Modeling.Chapter 8: Building Fast-Performing Database Models.Part III: A Case Study in Relational Database Modeling.Chapter 9: Planning and Preparation Through Analysis.Chapter 10: Creating and Refining Tables During the Design Phase.Chapter 11: Filling in the Details with a Detailed Design.Chapter 12: Business Rules and Field Settings.Part IV: Advanced Topics.Chapter 13: Advanced Database Structures and Hardware Resources.Glossary.Appendix A: Exercise Answers.Appendix B: Sample Databases.Index.