Cart
Free Shipping in Australia
Proud to be B-Corp

Beginning Database Design Gavin Powell

Beginning Database Design By Gavin Powell

Beginning Database Design by Gavin Powell


$22.49
Condition - Good
Only 1 left

Summary

Shows how to design and implement robust, scalable databases on various relational database management systems, including Access, SQL Server, IBM DB2, MySQL, and Oracle. This title covers various database design steps including modeling, normalization, SQL, denormalization, object-modeling, data warehousing, and performance.

Beginning Database Design Summary

Beginning Database Design by Gavin Powell

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.

About Gavin Powell

Gavin Powell has a Bachelor of Science degree in Computer Science, with numerous professional accreditations and skills (including Microsoft Word, PowerPoint, Excel, Windows 2000, ERWin, and Paintshop, as well as Microsoft Access, Ingres, and Oracle relational databases, plus a multitude of application development languages). He has almost 20 years of contracting, consulting, and hands-on educating experience in both software development and database administration roles. He has worked with all sorts of tools and languages, on various platforms over the years. He has lived, studied, and worked on three different continents, and is now scratching out a living as a writer, musician, and family man. He can be contacted at [email protected] or [email protected]. His Web site at http://www.oracledbaexpert.com offers information on database modeling, database software, and many development languages. Other titles by this author include Oracle Data Warehouse Tuning for 10g (Burlington, MA: Digital Press, 2005), Oracle 9i: SQL Exam Cram 2 (1Z0-007) (Indianapolis: Que, 2004), Oracle SQL: Jumpstart with Examples (Burlington, MA: Digital Press, 2004), Oracle Performance Tuning for 9i and 10g (Burlington, MA: Digital Press, 2003), ASP Scripting (Stephens City, VA: Virtual Training Company, 2005), Oracle Performance Tuning (Stephens City, VA: Virtual Training Company, 2004), Oracle Database Administration Fundamentals II (Stephens City, VA: Virtual Training Company, 2004), Oracle Database Administration Fundamentals I (Stephens City, VA: Virtual Training Company, 2003), and Introduction to Oracle 9i and Beyond: SQL & PL/SQL (Stephens City, VA: Virtual Training Company, 2003).

Table of Contents

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.

Additional information

GOR002416209
9780764574900
0764574906
Beginning Database Design by Gavin Powell
Used - Good
Paperback
John Wiley & Sons Inc
20050301
504
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in good condition, but if you are not entirely satisfied please get in touch with us

Customer Reviews - Beginning Database Design