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

Treehouse

Data Relationships with SQL and Sequelize Course (How To)

via Treehouse

Overview

As you follow along in this course, you'll define data relationships for a simple Node application that creates and retrieves movie data. You'll define data relationships in Sequelize models, and create related data (like Movie and Person records) using those models. Then you'll retrieve related data with Sequelize queries.

Syllabus

Understand Data Relationships

Explore data relationships in a SQL Database, why they're useful, and the different types of relationships.

Chevron 5 steps
  • Data Relationships

    2:43

  • instruction

    Explore Data Relationships in a SQL Database

  • instruction

    Database Normalization

  • instruction

    Data Relationship Types

  • Data Relationships Review

    5 questions

Data Relationships in Sequelize

Create data relationships using Sequelize by updating a small Node.js application.

Chevron 7 steps
  • Get Started with the Project

    2:00

  • instruction

    Database and Sequelize Configuration

  • instruction

    Connect to the Database

  • instruction

    Define Data Relationships in Sequelize Models

  • instruction

    Define a One-to-Many Relationship Using Sequelize Associations

  • instruction

    Refine Sequelize Associations

  • Data Relationships in Sequelize Review

    5 questions

Create Related Data Using Sequelize Models

Start creating related data and begin interacting with your database by adding seed data.

Chevron 5 steps
  • instruction

    Create Related Movie and Person Data

  • instruction

    Populate the Database with Seed Data

  • instruction

    Create Movie Records

  • instruction

    Test Your Changes

  • Create Related Data Review

    2 questions

Retrieve Related Data in Sequelize Queries

Retrieve related data via a single query method call, learn ways to convey the relationship between your data, and how defining a data relationship from both models' point of view gives you flexibility in retrieving data.

Chevron 5 steps
  • instruction

    Retrieve Data with findAll()

  • instruction

    Customize the Associated Model Property Name

  • instruction

    Take Full Advantage of Your Model Associations

  • instruction

    Next Steps

  • Retrieve Related Data Review

    5 questions

Taught by

Guil Hernandez

Reviews

Start your review of Data Relationships with SQL and Sequelize 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.