Using SQL ORMs with Node.js Course (How To)

In this course, you'll learn how to use the Sequelize ORM to leverage the power of SQL within your Node.js applications.

What you'll learn

• Overview of SQL ORM (object-relational mapping) libraries
• The popular Sequelize ORM
• Defining models
• Connecting to a SQL database
• Creating, reading, updating, and deleting data

Getting Started with Sequelize

Learn what ORMs (Object-Relational Mappers) are, and what Sequelize is, then set up a Node.js project with Sequelize and SQLite.

Chevron 6 steps

• What is an ORM?

  4:02

• instruction

  Install and Configure Sequelize and SQLite

• instruction

  Define a Model

• instruction

  Test the Database

• instruction

  Improve the Project Layout

• ORMs Review

  7 questions

Defining Models

Learn how to further define your model structures with data types, validations, default values, options, and more.

Chevron 6 steps

• instruction

  Go Further with Models

• instruction

  Add Validations to a Model

• instruction

  Handle Validation Errors

• instruction

  Use Options to Adjust Models

• instruction

  Exercise: Add a Person Model

• Defining Models Review

  6 questions

Performing CRUD Operations

Learn the basics of CRUD operations (create, read, update and delete) with Sequelize.

Chevron 7 steps

• instruction

  Create a Record

• instruction

  Retrieve Records

• instruction

  Attributes, Operators and Ordering

• instruction

  Update a Record

• instruction

  Delete a Record

• instruction

  Next Steps

• Performing CRUD Operations Review

  7 questions