Databases for Node.js Developers

Introduction

• Learn to create real database applications with Node.js
• What you should know

1. Getting Started

• Getting your tools ready
• Loading the exercise files from GitHub
• Set up and understand the maxcoin sample app
• Set up and understand the shopper sample app

2. Understanding Databases

• Database basics
• Understand relational databases
• Understand NoSQL databases and key-value stores

3. Use Document Databases with Node.js

• When to use and not to use document databases
• Set up MongoDB
• Connect to MongoDB
• Insert data into MongoDB
• Query data from MongoDB
• Introduction to Mongoose
• Add MongoDB and Mongoose to your project
• Define your first schema and model
• Prepare the item management system
• Implement all database methods
• Implement the user management system
• Encrypting passwords

4. Use Key-Value Stores with Node.js

• Introduction to key-value stores
• Set up Redis
• Use Node.js with Redis
• Add Redis to your project
• Session management in Express
• Add Redis sessions to your project
• Implement a basket service
• Add the basket to the page

5. Use Relational Databases with Node.js

• When to use relational databases
• Set up MySQL
• Create a database schema
• Use Node.js with MySQL
• Introduction to Sequelize
• Add MySQL and Sequelize to your project
• Review the database design
• Create sequelize models
• Review the auto-generated database structure
• Implement an order service
• Add order management

Conclusion

• Next steps