Use cases
An RDBMS uses SQL as its default language. In general, use cases that can be applied to Azure SQL Database can also be applied to Azure Database for MySQL, PostgreSQL, and MariaDB, depending on which technology you want to use or what your application has already been developed on.
Therefore, instead of showing use cases of each of these technologies, in this section, I will present the reasons for opting for Azure SQL Database.
Important note
Whether you use a SQL or NoSQL database for a particular use case is one of the most important questions for a data architect. You will complete your knowledge in Chapter 9, Exploring Non-Relational Data Offerings in Azure, where we will discuss Azure NoSQL databases and list the main reasons for using a NoSQL database.
The big difference between a relational database and a non-relational database is the schema definition, which is defined at the beginning of the project on the relational database.
Before you start using...