Sequelize Tutorial: Episode 4 - Model Querying

Показать описание

In this Sequelize tutorial series we will learn everything there is to learn about Sequelize. In this video we will learn the basics of querying a model.

Become a Better Developer

My Software

Download Code

⌛ Timestamps
0:00 - Intro
0:24 - Select Rows with FindAll()
2:06 - Select Specific Columns with FindAll()
2:39 - Selecting Columns with an Alias
5:25 - Excluding Specific Columns with FindAll()
6:10 - Selecting Rows with Where Filter
8:35 - Limiting Amount of Returned Rows
9:07 - Grouping and Ordering Returned Rows
12:43 - Selecting Rows with Operators
17:19 - Functions in Where Clause
19:24 - Updating Rows with Update()
21:42 - Deleting Rows with Destroy()
22:33 - Deleting Every Row with Truncate
23:00 - Utility Methods

Рекомендации по теме

Комментарии

I have to say this tutorial is the best in Youtube so far. Well done

chef_david

Thank you so much. This tutorial came as a savior for me as there is not much of good Sequelize content on youtube. I really is what I wanted. Kudos

UsamaAbdulMoeed

this playlist is awesome and i think you are so underrated :)

TechTalksgroup

Another excellent series started by you which isn't covered properly anywhere else on youtube.

AB-slbg

Great job, thank's, never seen a complete guide like this...

HakanGalip

Againl, super, awesome tutorials on Sequelize! surprised to see so low viewership. Is Sequelize not so popular as SQL ORM?

RajeshJaswalPune

Amazing tutorial! Thanks for the info :)

LikeProGamer

Congratulations on 1k subs...
@wittcode
Wish you all the best to you and also to your channel.

subhashgn

you explained in the best way possible and one the best but you everything in the index file which I find not a good practice please follow industrial standards thank anyway

Kamranali

i got a problem using where clause with string data type in 8:41 cant we change the value 'soccer' to a variable which we can change time to time? i tried this but it return null please help me thanks

MHonRomero

Is there any option to query select data from tables of two different tables

hablu

in findAll and find one how many conditon we can add like we need attribute, where condition, find,ordeBy,limit,skip so how to write queery for that ?

bhojakrahul

Hi, Question, on UPDATE Sequelize (Is there a way if there is no value from frontend do not update table with value undefiend, just update only the field that we received value from frontend !) Thanks

VixtusSilver

Hello. And Thank you.
I have a problem with my code because 2 events fire the same function to create a record with the same primary key. I get an error from the second executed.
Is it possible to ask sequelize to be totally async in transactions ?

nanstv

Hey friend, I've got a question. Is it possible to cast a column into an integer? I wanted to use [Op.between] however since the column is a string it would only take the first character. It's basically a price range search query but the price column is string and I wanted it to be an integer when I'm searching.

monotoneguy

If using SqLite, use 'length' NOT 'char_length'

robertbourton

Sequelize Tutorial: Episode 4 - Model Querying

Sequelize Tutorial: Episode 4 - Model Querying

Sequelize Tutorial: Episode 5 - Test Your Knowledge

Sequelize: Validation (4/TBD)

Why use Sequelize? - Volume Fixed

Sequelize Tutorial: Episode 11 - Associations (hasOne, belongsTo, hasMany, belongsToMany)

4. Typescript Sequelize Express | Making a User Model - Pay Tracker App (English)

Fullstack App Tutorial Part 3 - Sequelize DB

Sequelize ORM - Sequelize as Promise based library #05

Introduction | Sequelize Tutorial | Learning Points

Hapi JS Tutorial 8 - Using Sequelize Models with MySQL

Sequelize Tutorial: Episode 3 - Model Instances

ORM with Sequelize: Lazy or Eager load? You NEED to you when to use one or the other? Otherwise...

Sequelize Tutorial: Episode 10 - Paranoid Tables

4. Sequelize and Dotenv Files - Overview and Implementation

Sequelize ORM Tutorial (all in one video)

NodeJS : Using sequelize.js to interface against existing database?

NodeJS : How to use an include with attributes with sequelize?

Install Sequelize and connect with database | Sequelize Tutorial | Learning Points

SQL : How does group by works in sequelize?

Sequelize Tutorial: Episode 7 - Setters, Getters, and Virtual Fields

Sequelize ORM Lecture 11 | Update and Delete Operations in sequelize

Sequelize Tutorial: Episode 9 - SQL Injection and Raw Queries

Sequelize Tutorial: Episode 1 - Introduction and Connecting to a Database

Sequelize Tutorial: Episode 6 - Finder Methods