Need to manage relationships between your PostgreSQL, MySQL, MariaDB, SQLite or MSSQL entities in Node.JS? Sequelize provides a clean way to get promise-based ORM in your Node application.

Sequelize is an Object Relational Mapper (ORM), which simplifies interacting with relational databases by abstracting away the need to use SQL directly. This lesson introduces defining models with Sequelize in Node.js.

> You will need the [Postgres database](http://www.postgresql.org/) for this lesson! For Mac users, [postgressapp](http://postgresapp.com/) makes this easy.

Sequelize: Model Definition Basics

Models in the Node.js ORM, Sequelize, can be expanded with both class level and instance level functions. This video will show you how to extend your models to add helpers or business logic, and explain the methods execution scope.

Sequelize: Class & Instance Methods

Sequelize has a powerful query mechanism, this lesson teaches the basics of querying using the `findAll` function.

Sequelize: Querying Basics using findAll

The Node.js ORM, Sequelize, has a powerful system for validating both models and individual columns. This video covers a handful of the more than 30 built-in validators, as well as writing custom validators from scratch. 

Sequelize: Validating Models

Javascript and database systems tend to be at odds with regard to how tables and columns should be named. Sequlize provides all the tools necessary to satisfy naming conventions in both your Node.js code and in your SQL database.

Sequelize: Model & Column Casing

Sequelize attribute getters and setters are a convenient way to encapsulate extra logic for model properties. In this video, we'll cover adding getters and setters to enhance and even virtualize a column.

...learn Node.js ORM With Sequelize

Instructor

Course Content