Hello guys.
So we are going to continue our discussion with respect to this particular project.
Now in this video, I'll just give you an idea how you can go ahead and install the MySQL workbench.
So just go ahead and search in Google SQL Database Workbench.
And then you will be getting a button which is called as download MySQL workbench after you get this.
So here you can probably go ahead and select your operating system like whether you are using windows,
Linux, fedora, Mac OS or anything that you want.
Let's say you want to go ahead with windows.
So just go ahead and click on this.
After you click on this, uh, you know, I'll just go and I don't want to log in it.
So just say no thanks.
Just start my download automatically.
The download will start once you do this, uh, again you can double click it and you can just click
on next, next, next.
Make sure to press all the check buttons that is available over there.
And go ahead and do the installation.
Anyhow, uh, I as a YouTuber have also created an amazing playlist in YouTube.
Uh, regarding complete MySQL and the tutorial itself, I will be giving you the link, uh, just before
this particular video I guess.
And then you can also make sure that you can watch those videos, like how to do the installation.
But after you do the installation and once you do the SQL connection, right.
So this is how things are going to look at uh here.
You can basically go ahead and write your query.
You can use your database you know.
So this definitely requires a lot of tutorials with respect to SQL itself.
So for my sake, right, what I am actually going to do, I'm going to probably go ahead and create
my student table.
So what I will do, I will just say hey drop student.
Drop table student.
First of all, since I've already created the student over here.
So I will go ahead and execute this.
So, uh, so I'll just select this and execute it okay.
So once I drop it here, you can see I am not getting this particular table.
Uh, student table.
So this is my database that I've actually created.
I will just go ahead and create a student table over here.
Right.
So here you can see I have written create student, uh, table student name worker, class worker section
worker marks and the same.
All the commands are almost same, like how we have actually used it.
And I'm going to use this particular database.
So once I execute it here, you can see it has got executed perfectly.
Now quickly let me just go ahead and write select star from student.
And once I execute this you will be able to see all my records.
So here are all the records that I have right.
So this is the basic way of, uh, just executing a query in my SQL database and in my MySQL database.
What I'm actually going to do, I'm going to read this entire table right?
And I'm going to probably get it as again, as I told you before, this particular module only I have
given you the entire SQL playlist from my YouTube channel.
You can definitely go ahead and watch it over there.
But once you prepare this entire student table, uh, now it's time that we'll start building our project
in our next video.
So let's go ahead and let's I'll see you all in the next video.
Thank you.