What this book covers
Chapter 1, Introduction to Databases, explains what a database is and what it is used for. It also explains the common concepts of databases.
Chapter 2, Entity Analysis, explains how to create and read Entity Relationship Diagrams (ERD) from a top-down perspective.
Chapter 3, Normalizing Data, teaches you how to create a normalized database design and when to use this design technique.
Chapter 4, Provisioning and Implementing an Azure SQL Database, shows hands-on how to create and implement a normalized design in Azure using Microsoft's PaaS offering – Azure SQL Database.
Chapter 5, Designing a NoSQL Database, explains when to choose Cosmos DB over a relational database. It also teaches you how to design different types of NoSQL databases.
Chapter 6, Provisioning and Implementing an Azure Cosmos DB, shows hands-on how to create and implement a Document database in Azure using Microsoft's NoSQL database, Cosmos DB.
Chapter 7, Dimensional Modeling, teaches you how to create a star schema database design according to the rules of dimensional modeling.
Chapter 8, Provisioning and Implementing an Azure Synapse SQL Pool, shows hands-on how to create and implement a star schema database using an Azure Synapse dedicated SQL pool.
Chapter 9, Data Vault Modeling, explains when to use a data vault and how to design a data warehouse using the data vault modeling technique.
Chapter 10, Designing and Implementing a Data Lake Using Azure Storage, discusses when implementing a data lake is a better option than creating a data warehouse. It also shows how to implement a data lake using Azure Storage.
Chapter 11, Implementing ETL Using Azure Data Factory, shows how to create pipelines to automate the process of getting data out of production databases and into data lakes and data marts.
