From the course: Databases for Node.js Developers
Join today to access over 25,500 courses taught by industry experts.
Understanding relational databases - Node.js Tutorial
From the course: Databases for Node.js Developers
Understanding relational databases
- [Instructor] When I first started using databases professionally, relational databases were the standard. Back then, MySQL and Postgres dominated the space and they're still widely used today. A relational database is great when data has clear relationships. Imagine building a hiking app that answers questions like which villages are along a trail? Where can a eat in a village? Which trail leads to a specific village? These questions involve relations between data, and that's exactly what relational databases are designed for. Relational databases follow a strict schema, which defines tables, structured storage for data, columns, which define what each record holds, and relationships, how records are linked. Let's look at the few relationship types. We have one-to-one. For instance, a student has one place of birth. We have one-to-many relationships, which would be a college has many students, and we have many-to-many relationships, a subject has many students and the student has…
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.