Using SQL ORMs with Node.js Course

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, retrieving, updating, and deleting data

Getting Started with Sequelize

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

• 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.

• 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, retrieve, update and delete) with Sequelize.

• 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