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.
Overview
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