Manage Databases With Sequelize

👉 Before you start. This course assumes you have prior knowledge of at least one relational database management system such as MySQL or Postgres. If you're new to this, I encourage you to first take the MySQL for Database Storage course then come back to this part.

Sequelize is an object-relational mapping (ORM) library for Node.js that provides an intuitive, object-oriented way to interact with relational databases, including MySQL, PostgreSQL, and more, using JavaScript.

It abstracts the underlying SQL queries and database interactions, allowing developers to use high-level object-oriented code rather than writing raw SQL queries by hand.

Overall, ORMs simplify and speed up development by reducing the amount of boilerplate code and SQL developers need to write.

However, it's important to note that for complex queries, ORMs may not always be as efficient or flexible as raw SQL.

Learning objectives

In this module, you'll learn how to use Sequelize to interact with relational databases using JavaScript, without having to write raw SQL queries for every operation.

After completing this module, you will be able to:

• Connect a Node.js application to a relational database using Sequelize.
• Define and synchronize models that map to database tables.
• Retrieve, filter, group, and aggregate records using Sequelize queries.
• Define one-to-one and one-to-many relationships between models.
• Query related data across multiple tables using eager and lazy loading.