Book Image

Data Modeling for Azure Data Services

By : Peter ter Braake
Book Image

Data Modeling for Azure Data Services

By: Peter ter Braake

Overview of this book

Data is at the heart of all applications and forms the foundation of modern data-driven businesses. With the multitude of data-related use cases and the availability of different data services, choosing the right service and implementing the right design becomes paramount to successful implementation. Data Modeling for Azure Data Services starts with an introduction to databases, entity analysis, and normalizing data. The book then shows you how to design a NoSQL database for optimal performance and scalability and covers how to provision and implement Azure SQL DB, Azure Cosmos DB, and Azure Synapse SQL Pool. As you progress through the chapters, you'll learn about data analytics, Azure Data Lake, and Azure SQL Data Warehouse and explore dimensional modeling, data vault modeling, along with designing and implementing a Data Lake using Azure Storage. You'll also learn how to implement ETL with Azure Data Factory. By the end of this book, you'll have a solid understanding of which Azure data services are the best fit for your model and how to implement the best design for your solution.
Table of Contents (16 chapters)
1
Section 1 – Operational/OLTP Databases
8
Section 2 – Analytics with a Data Lake and Data Warehouse
13
Section 3 – ETL with Azure Data Factory

Chapter 4: Provisioning and Implementing an Azure SQL DB

After creating a conceptual model using normalization techniques (Chapter 3, Normalizing Data), it is time to actually create a database. We first need to transform the conceptual design into a physical design. Some details are still missing. You will learn about all these (technical) details required to implement a database as an Azure SQL database in this chapter. In the second part of the chapter, we will actually provision the database and create the designed schema.

In this chapter, you will learn about the following:

  • SQL Server data types and their relevance
  • Quantifying the data model
  • Provisioning an Azure SQL database
  • Implementing tables and constraints using data definition language