Exploring relational data concepts in Azure
Relational database systems allow us to store and manage transactional and analytical data in organizations of all sizes around the world.
In a relational database, we model collections of entities from the real world as tables. Let’s take the example of a solution for booking an appointment with a selected doctor. We might create a table for patients, doctors, and appointments. Every table will include rows, and each row will represent a single instance of an entity. Each row in a patient table contains the data for a single patient, each row in a doctor table defines a single doctor, and each row in an appointment table represents a patient that booked an appointment with a specific doctor. We will get more information related to the time and date of the appointment.
SQL is used to represent and search for data in a relational database. Common SQL statements used are SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP to accomplish...
