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 ...

Get Data Modeling for Azure Data Services now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.