10 Relational databases
This chapter covers
- Designing a relational database schema for use as an ordering system
- Comparing several relational database options on Azure
- Creating an Azure SQL database
- Handling performance tuning, disaster recovery, and database security
In this chapter, we’ll improve the Banning Books ordering system by implementing a relational database. Relational databases are a fundamental part of modern computing and data management. They provide a way to store and organize large amounts of data in a structured and efficient manner, making the data easy to retrieve, manipulate, and analyze. Whether you’re running a small business or a large enterprise, a relational database can help you manage your data in a way that is scalable, cost effective, and secure.
In cloud computing, relational databases are especially important because they provide a way to manage data in a distributed environment. By using a cloud-based relational database, you can store and access data from anywhere in the world using a variety of devices and applications. This makes it easier to collaborate with others, streamline business processes, and gain insights from your data.