Introducing SQL on Azure

We established from the previous chapters that SQL is used in several types of databases in Azure. Of these, we will use Azure SQL Database and Azure Database for PostgreSQL in this chapter

SQL is used in other Azure database offerings, such as Azure Cosmos DB and Synapse Analytics, which we’ll explore in Chapters 10, 12, and 13 of this book on NoSQL and analytical databases. The knowledge generated by this chapter will be important for your projects with all databases on Azure.

Important note

This is a continuation of Chapter 7, Provisioning and Configuring Relational Database Services in Azure, where we’ll use the databases that were deployed in it. You’d need to provision the databases from that chapter to follow the exercises in this chapter.

Let’s now explore different SQL scenarios applied to Azure’s core relational database services, starting with Azure SQL Database.