CRUD operations with Sequelize in Express - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does CRUD stand for in web development?

CRUD stands for Create, Read, Update, and Delete. These are the four basic operations to manage data in an application.

beginner

How do you create a new record using Sequelize?

Use the Model.create() method with an object containing the data you want to save. For example: User.create({ name: 'Alice', age: 25 }).

beginner

Which Sequelize method is used to find all records matching a condition?

The Model.findAll() method is used to get multiple records. You can pass a where option to filter results, like User.findAll({ where: { age: 25 } }).

intermediate

How do you update a record in Sequelize?

Use Model.update() with the new data and a where condition. For example: User.update({ age: 26 }, { where: { id: 1 } }) updates the user with id 1.

intermediate

What method deletes records in Sequelize and how do you specify which ones?

Use Model.destroy() with a where clause to specify which records to delete. For example: User.destroy({ where: { id: 1 } }) deletes the user with id 1.

Which Sequelize method would you use to add a new user to the database?

A Model.findAll()

B Model.create()

C Model.update()

D Model.destroy()

Model.create() is used to add new records to the database.

How do you retrieve all records from a table using Sequelize?

A Model.findAll()

B Model.findOne()

C Model.update()

D Model.destroy()

Model.findAll() fetches all records from the table.

What parameter do you use to specify which records to update in Sequelize?

A include

B attributes

C where

D order

The 'where' option specifies the condition to find records to update.

Which method removes records from the database?

A Model.create()

B Model.findAll()

C Model.update()

D Model.destroy()

Model.destroy() deletes records matching the condition.

If you want to update a user's email where id equals 5, which Sequelize method and option do you use?

A Model.update({ email: '[e-mail]' }, { where: { id: 5 } })

B Model.destroy({ where: { id: 5 } })

C Model.findAll({ where: { id: 5 } })

D Model.create({ email: '[e-mail]' })

Model.update() with a 'where' clause updates the record with id 5.

Explain how to perform each CRUD operation using Sequelize methods.

Think about how you add, get, change, and remove data.

Describe how you would update a user's information safely using Sequelize in an Express app.

Focus on the update method and filtering the right record.