Data Relationships with SQL and Sequelize Course (How To)

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.

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