What you will learn from this book
- Basic concepts of relational database modeling
- The components of a relational database model
- Making normalization easier to use
- Advanced relational database modeling
- How to improve relational database model Performance
- Describing tables during using analysis (What needs to be
solved)
- Refining tables and relationships using design (How to provide
solutions)
- How to read and write data with SQL
- Create relational database models by applying business rules
Who this book is for
This book is for new database developers. No prior database or programming experience is required.
Part 1: 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 2: 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 3: 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 4: Advanced Topics
Chapter 13: Advanced Database Structures and Hardware Resources