Data Relationships with SQL and Sequelize Course (How To)

About this Course

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