Querying Relational Data in Azure
In this chapter, you’ll learn more about Structured Query Language (SQL), and how you can use it to query, insert, update, and delete data in a relational database.
Now that we have touched on the provisioning of Azure relational databases in the previous chapter, we are ready to explore the structures and data using SQL in these relational databases. This chapter is important for all professionals who will work with data in the market because SQL is most commonly used in relational, non-relational, and analytical databases.
SQL is fundamental for data professionals, and in the DP-900 exam, there are some questions directly related to SQL performing operations.
By the end of this chapter, we will cover the following:
- Introducing SQL on Azure
- Querying relational data in Azure SQL Database
- Querying relational data in Azure Database for PostgreSQL
