Data Relationships with SQL and Sequelize Course

Understand Data Relationships

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

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

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

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

• 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