Using SQL ORMs with Node.js Course

Go to class
Write Review

Free Online Course: Using SQL ORMs with Node.js Course provided by Treehouse is a comprehensive online course, which lasts for 1-2 hours worth of material. The course is taught in English and is free of charge. Using SQL ORMs with Node.js Course is taught by Guil Hernandez.

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

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

    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, retrieve, 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