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