This book focuses on the relational database model from the perspective of the data modeling novice, and thus the title Database Modeling from 0 to 60 in 4 Seconds. The objective is to provide an alternative and easy to understand, step-by-step, simple explanation of designing and building relational database models. There are lots of examples and exercises, as well as a multiple chapter case study. People who would benefit from reading this book would be anyone involved with database technology including database administrators, developers, NOVICE data modelers, systems or network administrators, technical managers, marketers, advertisers, forecasters, planners, executives – anyone who doesn’t know something about data modeling – and wants to. If You want some kind of clarity to the funny diagrams You see in Your Access database, perhaps built by a programmer, then this book might help You. If You want to know what all that complicated stuff is in the company MySQL, SQL-Server or Oracle database then this book might be a terrific place to start. This book will give enough of an understanding without completely blowing Your mind - and when there are words You’ve never seen before there is a glossary of terms to explain those words to You.
FULL DISCLOSURE: this is a book that is a seriously reworked self-publishing exercise of a book previously printed by a big publisher - this book deserves another attempt. The one thing to remember about this topic is that it’s not an exact science and the what and how of data modeling depends upon the application and the circumstances; and I might even tell You sometimes to think about undoing things You’ve already worked so hard to create and to make Your database perform a little better. So if You’re looking for a definitive set of rules You might not like this book. My overall objective in this book is to help people understand data modeling as both a science as well as and an art, by way of tutorial, assuming that after 25 years in the IT field that I might have actually learned a thing or two.
This book covers these topics:
- The History of Database Modeling
- Databases and Applications
- The Art of Database Design
- The Pieces of the Relational Data Model
- Intuitive Data Modeling and Normalization
- Reading and Writing Data with SQL
- Advanced Relational Database Modeling
- Understanding Data Warehouse Database Modeling
- Building Faster Performing Database Models
- Case Study Chapters:
- Planning and Preparation
- Creating and Refining Tables
- Details in Columns and Datatypes
Yes this book can be expanded upon in the future but it took about 2 years to get it to this point so let’s see how people like this one first.
