A brief chapter explains how to use the database programming language SQL (Structured Query Language), which reads from and writes to a relational database. SQL is fundamental to data modeling because it helps in understanding how the model is used. In addition to the relational model, the last three chapters cover important modern world topics including denormalization that leads into data warehouses and BigData database modeling. The book explains how there is not much to logical data modeling in BigData databases because as they are often schema-less, which means that BigData databases do not have schemas embedded into the database itself, they have no metadata and thus not much of a logical data model.
Chapter 2. The Pieces of the Relational Data Model
Chapter 3. Intuitive Relational Data Modeling and Normalization
Chapter 4. Reading and Writing Relational Data with SQL
Chapter 5. Advanced Relational Database Modeling
Chapter 6. Understanding Data Warehouse Database Modeling
Chapter 7. Modeling for BigData Databases
Download Database Modeling Step by Step PDF or ePUB format free