Databases are very important in software. When moving your databases to Azure, you have a few databases to choose from, ranging from traditional SQL databases to NoSQL databases. In this chapter, we're going to look at the various database options that are available to us. When you opt for the Microsoft stack, you'll likely use Azure SQL or Cosmos DB, but databases from other vendors, such as MariaDB and Redis, are also offered as PaaS or IaaS solutions.
The following topics will be covered in this chapter:
- Working with Azure SQL
- Connecting to SQL Server Management Studio
- Connecting to Azure SQL from .NET Core
- Connecting to Azure SQL from Java
- Understanding Cosmos DB
- Working with the MongoDB API
- Working with the Redis cache database
