Databases Introduction for Full-Stack Developers🔥

Thapa Technical
63 followers
Jan 17, 2025
Hello what's up guys today in this video
we will see introduction to database in our
node series yes guys so today's video is going to be
very awesome and
we are going to introduce database, I
would like to tell you that this node of ours This
is a series about express, this is going to be a part of this,
this is also fine and
I am including this in the Q database, I will
tell you, look carefully, if you want to become a
full stack developer, obviously you
want to become one so that your salary is good So
right, you know, what is a full stack
developer? Who do we call a full stack developer? First of all,
if you look, we have a
front end developer. Okay, what is the job of a front end developer
who knows how to work with HTML, CSS and
JavaScript? Those who
make awesome websites, right, so this was
earlier in my time, like when I was
working back in like 2017, 2018, 201718,
then this was in use and there was a B step,
but today people want This is a series about express, this is going to be a part of this, this is also fine and I am including this in the Q database, I will tell you, look carefully, if you want to become a full stack developer, obviously you want to become one so that your salary is good So right, you know, what is a full stack developer? Who do we call a full stack developer? First of all, if you look, we have a front end developer. Okay, what is the job of a front end developer who knows how to work with HTML, CSS and JavaScript? Those who make awesome websites, right, so this was earlier in my time, like when I was working back in like 2017, 2018, 201718, then this was in use and there was a B step, but today people want View Angular
React, now even React has come up,
Next JS, I don't know what all has come,
people of today's time
want this and many people think that guys, this is a
child's work, this is for professional people,
actually this You might be working on it but
in reality guys they are masters in it
only then they can work on it,
so both of these are important, basically
front end where you are creating the user interface
and then guys we have a back And
okay, in which you can see that right
now we are looking at Node and Express,
those things which we can use as a back end,
okay, basically it is a language
in which you can fill any form,
okay, so we What do they do first? They pass it to the back end. And
our purpose of passing it to the back end is that the
user is filling in the data, you have to
store it somewhere. So whatever you
store, you do that.
Where do you do it in your database, in the database,
we have read the back end, so I You might be working on it but in reality guys they are masters in it only then they can work on it, so both of these are important, basically front end where you are creating the user interface and then guys we have a back
And okay, in which you can see that right now we are looking at Node and Express, those things which we can use as a back end, okay, basically it is a language in which you can fill any form, okay, so we What do they do first? They pass it to the back end. And our purpose of passing it to the back end is that the user is filling in the data, you have to store it somewhere. So whatever you store, you do that. Where do you do it in your database, in the database, we have read the back end, so I I am guessing, you must obviously know this, so
when you have learned the front end, when
you have learned the back end, then only one thing is
left, the database, so why should we leave it, so as
I told you guys, our Node and
Express Ka si I want to make something awesome in this, that's
it but now if you see the reality
then Mango Dib is there but ma kail
guys he is never going anywhere, that's
what this ODM is so I would
like to tell you, look guys, I would like to tell you simply guys
in case of My AL what we
do is mostly we have a
relational database with tables or this is your non-
relational database right so whenever it
comes to relational database basically
object relational mapping or mapper whatever you
call it we
call it ORM yes guys so we are going to
look at drizzle as well in this series of ours as
I told you you will enjoy
how you front end note just express and
drizzle together a you know like combine it
Ka si I want to make something awesome in this, that's it but now if you see the reality then Mango Dib is there but ma kail guys he is never going anywhere, that's what this ODM is so I would like to tell you, look guys, I would like to tell you simply guys in case of My AL what we do is mostly we have a relational database with tables or this is your non-relational database right so whenever it comes to relational database basically object relational mapping or mapper whatever you call it we call it ORM yes guys so we are going to look at drizzle as well in this series of ours as I told you you will enjoy how you front end note just express and drizzle together a you know like combine it You can create any application by combining these. You
will see with mall as well as Mango
DB as well as with result or M.
Now for Mango DB we have
not only OR M but also OD M now this
time now we Object document mapping
because [ __ ] dab is all about r
document so that's
it and then we have one more or m
and that is your prisma yes guy so
in this series we are going to cover
like my sql you know basically
postgres will also be there Mango DB Drizzle Mangos
Prisma So this is so awesome that
we have taken note of it, we have seen the express,
now we will see everything in the end, the world
best, if you remember, look here, this has been
noted but recently version 19 has been
released recently. React if you remember let's do
one thing I'll go to the playlist
here if you see then guy we
recently launched React version 19 Object document mapping because [ __ ] dab is all about r document so that's it and then we have one more or m and that is your prisma yes guy so in this series we are going to cover like my sql you know basically postgres will also be there Mango DB Drizzle Mangos Prisma So this is so awesome that we have taken note of it, we have seen the express, now we will see everything in the end, the world best, if you remember, look here, this has been noted but recently version 19 has been released recently. React if you remember let's do one thing I'll go to the playlist here if you see then guy we recently launched React version 19
I have already completed the 2025 playlist, if you have
n't checked it out yet, then
do check it out, there are almost 139 videos
in it, you will enjoy it so much, I
mean, if you are clear, then this is done, node and
express done, now our database Kind of now
here also you will learn it, okay
before starting the video, guys if
you are feeling interested and you are very
excited finally the result prisma
to learn all this, guys please till now if
you have not subscribed to my awesome channel Thapa Technical If not,
please do it
and on the right side a red color bell
icon will appear, hit it and click
so that you don't miss the daily awesome videos,
let's see guys, introduction to
database, what is this database, you
can see it very clearly Yes brother, this database is
a structured way to store and manage data.
I had simply
explained the examples to you a while ago.
We use database to store and manage any data,
for example
user. Kind of now here also you will learn it, okay before starting the video, guys if you are feeling interested and you are very excited finally the result prisma to learn all this, guys please till now if you have not subscribed to my awesome channel Thapa Technical If not, please do it and on the right side a red color bell icon will appear, hit it and click so that you don't miss the daily awesome videos, let's see guys, introduction to database, what is this database, you can see it very clearly Yes brother, this database is a structured way to store and manage data. I had simply explained the examples to you a while ago. We use database to store and manage any data, for example user. If the user fills the registration form,
where will you keep the data filled by him? You will
keep it in the database. Right also, if you see
so many products on an e-commerce website,
they will
not be coming for free, they will also be collected from the database by
doing a like query. If you are getting it then guys
database is useful everywhere where ever you
get data now it helps organize data
for easy access, retrieve and updates
obviously we have already seen in e-commerce also
you can tackle it very easily now this is
important Like databases store data
like tables, documents and key value
pairs, so all of them, I mean all your
document database languages, all of them are included, some are
storing the data in the format of tables, some are
doing it in the format of documents That it is
doing it in the format of value pairs, we will handle it
now, just understand it superficially,
you will understand this much also, the work of the database
is to store and manage data, the matter ends
when we see it practically, you will know they are
used in application to
If you are getting it then guys database is useful everywhere where ever you get data now it helps organize data for easy access, retrieve and updates obviously we have already seen in e-commerce also you can tackle it very easily now this is important Like databases store data like tables, documents and key value pairs, so all of them, I mean all your document database languages, all of them are included, some are storing the data in the format of tables, some are doing it in the format of documents That it is doing it in the format of value pairs, we will handle it now, just understand it superficially, you will understand this much also, the work of the database is to store and manage data, the matter ends when we see it practically, you will know they are used in application to Handle user and system data same thing,
databases are made sure that data is consistent,
available whenever it is needed and
examples, so you have already seen so much,
okay now I will tell you one more thing
which I guess very few people will tell you, why Do we need
databases the most important thing is
data integrity nc data
consistency for example in a banking this
transaction here happens fully or not at all you are
understanding this this is a very important thing
if you go to the bank and you tell me give me 1
lakh If you want to withdraw it then either it will be complete
or it will not be, in between hey sir
you said 1 lakh, 50000 has come out, they will give 50 later, does
this happen, doesn't it happen,
he will say brother what are you doing, do you
understand this here But either we need the data to be complete
or we don't need it at all. We do
n't want any interruption in between. So here
we need data integrity, which means consistency of data,
not concurrency management.
Do we need databases the most important thing is data integrity nc data consistency for example in a banking this transaction here happens fully or not at all you are understanding this this is a very important thing if you go to the bank and you tell me give me 1 lakh If you want to withdraw it then either it will be complete or it will not be, in between hey sir you said 1 lakh, 50000 has come out, they will give 50 later, does this happen, doesn't it happen, he will say brother what are you doing, do you understand this here But either we need the data to be complete or we don't need it at all. We don't want any interruption in between. So here we need data integrity, which means consistency of data, not concurrency management. If you remember the coincidence, when we
were doing masters, I guess masters or
bachelor, I forgot but we had a course in
currency management and then I did not know much,
but when I
sat down to work in the practical world, when the situation in front of me Let's see
how multiple users
can access the same data without any conflict.
That is called concurrency management. How we deal with that will be seen.
But whatever it is, you at least need to know all these things. You
just have to play with the data and
store it. You have to do a card operation, that is not what
we just call a database,
if crores of people are accessing the same data, then
how confused are you, that is such a big deal,
now backup and recovery is even
more important than that, you have
created a lot of users, right? Transactions worth thousands, lakhs and crores are happening every day
and yesterday the database got hacked and
somebody blew away your entire
backup, whatever it was, like which
users are connected with you and what is their
payment method like premium members were that
Let's see how multiple users can access the same data without any conflict. That is called concurrency management. How we deal with that will be seen. But whatever it is, you at least need to know all these things. You just have to play with the data and store it. You have to do a card operation, that is not what we just call a database, if crores of people are accessing the same data, then how confused are you, that is such a big deal, now backup and recovery is even more important than that, you have created a lot of users, right? Transactions worth thousands, lakhs and crores are happening every day and yesterday the database got hacked and somebody blew away your entire backup, whatever it was, like which users are connected with you and what is their payment method like premium members were that Were there VIP members or silver ones
or platinum ones, you don't get anything, you never
get anything, everything is over, the world is gone, then there are
those things in that which are beyond like when
you are a professional then what to say but you should
know all this initially that All these
things can also happen if you are
dealing with database, I mean you can see that
risk is everywhere, now scalability is
also very important because if
you create a database thinking that it is
my hobby project But it
went viral and people started connecting with it, so now
how will you guys handle your database, where
earlier you were thinking of one or two or thousands,
now you are going to deal with crores and you have to
add all their data there If you are going to do this then it
should be so scalable
that you can redesign the code in that way.
Okay, so you should never forget these four things. I
guess if you
understand this much then you will know the value of O my
God database. So much is happening, this is
going to be the last slide of this video
All these things can also happen if you are dealing with database, I mean you can see that risk is everywhere, now scalability is also very important because if you create a database thinking that it is my hobby project But it went viral and people started connecting with it, so now how will you guys handle your database, where earlier you were thinking of one or two or thousands, now you are going to deal with crores and you have to add all their data there
If you are going to do this then it should be so scalable that you can redesign the code in that way. Okay, so you should never forget these four things. I guess if you understand this much then you will know the value of O my God database. So much is happening, this is going to be the last slide of this video Where as if I talk about types of database in broad categories then we have
two types of database and that is
Sequel or SQL and then second one is
No Sequel or No SQL database simple
and as far as I know you can
understand Sequel very well You must already know I guess
if not it doesn't matter and I have already
uploaded a video on it let me know
in the comment section if you want world
best SQL in one video yes guy
I want to make my AL in one video
in 2025 In which there will be something like start, tall and so on,
which means it will be fun. Like, till now I have already
made these ones of ours, then
if I go here, so guys, if I
come here, then you can see that I have already
made a complete web development.
World's best ATML course, CSS course? Can you
find anything better than this? Please tell me.
I have created a JavaScript course in 28 hours,
basic, advanced and
then e-commerce website. Okay,
that's it for now and yes, I have already learned Mango Deb.
You must already know I guess if not it doesn't matter and I have already uploaded a video on it let me know in the comment section if you want world best SQL in one video yes guy I want to make my AL in one video in 2025 In which there will be something like start, tall and so on, which means it will be fun. Like, till now I have already made these ones of ours, then if I go here, so guys, if I come here, then you can see that I have already made a complete web development. World's best ATML course, CSS course? Can you find anything better than this? Please tell me. I have created a JavaScript course in 28 hours, basic, advanced and then e-commerce website. Okay, that's it for now and yes, I have already learned Mango Deb. I have made Mango Dev as well, I have already
completed it, I had also
made React 3 years ago but it is fine and
Bribe is also already ready, even SQL
and Ma SQL I have already made,
you can check them out here as well You
can do that too 5 years ago, you are thinking that
I have made all this 5 years ago, it's
alright, no problem, you can still see it, I will
tell you in simple words, when we
do it practically, then all your doubts will get
cleared right now You can understand from the top
that when you deal with sequelize,
so basically what they do is they
store their data in these structured tables,
basically in the format of tables, they we have
a row and then columns
but when you have a no sequelize database If you deal with it then there is
no problem of tables there, you can call it unstructured
or same structure, basically
you can say that we are storing data on document base
object.
You can do that too 5 years ago, you are thinking that I have made all this 5 years ago, it's alright, no problem, you can still see it, I will tell you in simple words, when we do it practically, then all your doubts will get cleared right now You can understand from the top that when you deal with sequelize, so basically what they do is they store their data in these structured tables, basically in the format of tables, they we have a row and then columns but when you have a no sequelize database If you deal with it then there is no problem of tables there, you can call it unstructured or same structure, basically you can say that we are storing data on document base object. In the form or document form, something
like this, so now guys, if you see the second point,
we use a pre-defined schema where
the structure is fixed before the data
entry, what happens here is that guys, you
already define that your
What kind of data is going to come in this particular table?
Simple data can be the user's name,
user's age, user's
qualification, you know his unique
registration ID, which is the primary key,
which is the foreign key, will there be any void or not Will there be
any null or not, so basically
we already define all those things and
we work on that basis, but in No
SQL, we don't have to define any such schema,
as per your wish, first
you said okay to me, user's Name and
roll number are required. After some time you say no,
I want their age as well, I
want their classes as well, then this will
not be possible here because we have
already set it, but here you can easily add the
data when it comes to adding the data. that
basically there is no schema here
What kind of data is going to come in this particular table? Simple data can be the user's name, user's age, user's qualification, you know his unique registration ID, which is the primary key, which is the foreign key, will there be any void or not Will there be any null or not, so basically we already define all those things and we work on that basis, but in No SQL, we don't have to define any such schema, as per your wish, first you said okay to me, user's Name and roll number are required. After some time you say no, I want their age as well, I want their classes as well, then this will not be possible here because we have already set it, but here you can easily add the data when it comes to adding the data. that basically there is no schema here It's like you are going to build a house, you know
you don't have any that I
want such a house, you are just building it, you
feel no I shouldn't do this, let's do this,
not this, let's do that That
is your No SQL but in the sequel you should
understand that your designer, you
know architect, you have already
made the complete map of the house with them and you are working on the basis of that
only now support
using AL Structure Query Language And
support
complexity gains and API specific to
each no SQL database like Mango DB has
Json like queries Cassandra has
CQL new 4G has Cypher for this
let's see it's not a big deal you can
understand it as an example we have a my Sequel
Postgres Sequel SQL Server Extra
Even Oracle I guess and then here if
you see so example based on the format
in which data is stored this is import
yes see I told you a while
ago in the previous slide there is no
That is your No SQL but in the sequel you should understand that your designer, you know architect, you have already made the complete map of the house with them and you are working on the basis of that only now support using AL Structure Query Language And support complexity gains and API specific to each no SQL database like Mango DB has Json like queries Cassandra has CQL new 4G has Cypher for this let's see it's not a big deal you can understand it as an example we have a my Sequel Postgres Sequel SQL Server Extra Even Oracle I guess and then here if you see so example based on the format in which data is stored this is import yes see I told you a while ago in the previous slide there is no Some are doing it in document format, some are
doing it in table format, some are
doing it with the value of the key, so table, you have understood that
all your sequels are in table
format but there is difference in each sequel
like Redis and then Dynamo
In which format does the database
store the data,
in which value format do we have a key
and then the value now
who is doing it in document format, so this Mango DB,
Couch DB, so what do they do There are
like documents for user profiles, so
they are storing data in document format
and then if you see, it is
also stored in graph format like N4J
ArangoDB, whatever social network and recommendation
engine, so it is something like this It is
working, just understand that one is
your Guys relational database and second is non-
relational database, one has pre-defined
schema, second does not have it and the rest,
now when we do practical then you will
understand one by one and second you just have to understand this much it is
their job to In which format does the database store the data, in which value format do we have a key and then the value now who is doing it in document format, so this Mango DB, Couch DB, so what do they do There are like documents for user profiles, so they are storing data in document format and then if you see, it is also stored in graph format like N4J ArangoDB, whatever social network and recommendation engine, so it is something like this It is working, just understand that one is your Guys relational database and second is non-relational database, one has pre-defined schema, second does not have it and the rest, now when we do practical then you will understand one by one and second you just have to understand this much it is their job to Deal with your data,
to store the data and to manage the data and do
not forget these four points at all, these are
very important points, if anyone
asks you about database then you will
tell these four points, scalability, backup
and recovery Concurrency Management and then
Data Integrity, you will be impressed by me.
Okay, so guys, I also hope that
you must have been impressed by this video of mine today.
If you liked it, guys,
please like and share it with your friends and
comment. Definitely do it if you feel like it
and I know that I reveal my face
now, I mean what can I say, I used to do it
earlier but right now due to some reason
I am not able to do it, but very soon
I will also like add my like face I will do it like
I normally add and then I will
do it in such a way that at least it will
not have any effect on our video
because I am giving my 110% to
explain each and every thing to you in depth, so guys please If
you like my hard work then you
Concurrency Management and then Data Integrity, you will be impressed by me. Okay, so guys, I also hope that you must have been impressed by this video of mine today. If you liked it, guys, please like and share it with your friends and comment. Definitely do it if you feel like it and I know that I reveal my face now, I mean what can I say, I used to do it earlier but right now due to some reason I am not able to do it, but very soon I will also like add my like face I will do it like I normally add and then I will do it in such a way that at least it will not have any effect on our video because I am giving my 110% to explain each and every thing to you in depth, so guys please If you like my hard work then you No then please like it, I am telling you again, don't I?
Comment and tell me what other
improvements you want to see and if you have
n't subscribed yet, please do so.
I will meet you in tomorrow's video till then guys,
thank you so much. Take Care [Music] Take Care [Music]
