There are reasons to use or not to use relational databases. Explore the typical use cases in this video.
- [Instructor] We covered the pros and cons…of document databases versus relational databases…already when we talked about document databases before,…but let me emphasize that again real quick.…You want to use relational databases…when there are multiple different entities…that are in some way related,…and when the database needs to stay in a consistent state…and when the database should also enforce this consistency,…no matter from which application is accessing it.…
In our example now, we will use MySQL to store our orders.…For that we will first transition the basket…that is currently stored in Redis…into an order and we will store…all items inside this order in a table OrderItem.…Then we will delete the contents of the basket…and everything going on here…should run in one transaction.…This means it's either everything or nothing,…and that's a very nice use case…for a relational database, like MySQL.…
- Basics of relational and nonrelational databases
- Preparing your environment
- When to use document databases
- Inserting data into MongoDB
- Basic insert operations for MongoDB
- Querying data from MongoDB with Node.js
- Using key-value stores
- Using relational databases with Node.js
- Adding MySQL and Sequelize to a project
Skill Level Intermediate
1. Get Started with Databases for Node.js
2. Prepare Your Environment
3. Use Document Databases with Node.js
4. Use Key-Value Stores with Node.js
5. Use Relational Databases with Node.js
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.