From the course: SQL for Data Analysis
Join today to access over 23,200 courses taught by industry experts.
What is a relational database? - SQL Tutorial
From the course: SQL for Data Analysis
What is a relational database?
- A relational database is a type of database that stores and provides access to data points that are related to one another. In most instances, tables are organized by entities. An entity is a single object, like a person, place, or thing. This could be a customer, a store, an employee, or a product. The key is that each entity is unique. We infer relationships between the different entities to gain insights into our data. Let's use a cake example. Who doesn't like cake? Topsy Turvy Baking Company sells beautiful custom cakes that ship all across the United States. They have many customers, and I'm one of them. I want to order a birthday cake for my friend. They ship me a cake, and it's so good. I think I'll order another one for me too. So I place a different order. So we can see the relationship between customer and orders. Each customer can make more than one order. A cake can also have many different flavors. The…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.