Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Treehouse

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

via Treehouse

Overview

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

Syllabus

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

Taught by

Guil Hernandez

Reviews

Start your review of Using SQL ORMs with Node.js Course (How To)

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.