1
00:00:00,000 --> 00:00:00,000
Hello guys.

2
00:00:00,000 --> 00:00:03,000
So we are going to continue our discussion with respect to this particular project.

3
00:00:03,000 --> 00:00:08,000
Now in this video, I'll just give you an idea how you can go ahead and install the MySQL workbench.

4
00:00:09,000 --> 00:00:13,000
So just go ahead and search in Google SQL Database Workbench.

5
00:00:13,000 --> 00:00:18,000
And then you will be getting a button which is called as download MySQL workbench after you get this.

6
00:00:18,000 --> 00:00:23,000
So here you can probably go ahead and select your operating system like whether you are using windows,

7
00:00:23,000 --> 00:00:27,000
Linux, fedora, Mac OS or anything that you want.

8
00:00:27,000 --> 00:00:30,000
Let's say you want to go ahead with windows.

9
00:00:30,000 --> 00:00:32,000
So just go ahead and click on this.

10
00:00:32,000 --> 00:00:37,000
After you click on this, uh, you know, I'll just go and I don't want to log in it.

11
00:00:37,000 --> 00:00:38,000
So just say no thanks.

12
00:00:38,000 --> 00:00:40,000
Just start my download automatically.

13
00:00:40,000 --> 00:00:45,000
The download will start once you do this, uh, again you can double click it and you can just click

14
00:00:45,000 --> 00:00:46,000
on next, next, next.

15
00:00:46,000 --> 00:00:49,000
Make sure to press all the check buttons that is available over there.

16
00:00:49,000 --> 00:00:51,000
And go ahead and do the installation.

17
00:00:51,000 --> 00:00:56,000
Anyhow, uh, I as a YouTuber have also created an amazing playlist in YouTube.

18
00:00:56,000 --> 00:01:03,000
Uh, regarding complete MySQL and the tutorial itself, I will be giving you the link, uh, just before

19
00:01:03,000 --> 00:01:04,000
this particular video I guess.

20
00:01:04,000 --> 00:01:10,000
And then you can also make sure that you can watch those videos, like how to do the installation.

21
00:01:10,000 --> 00:01:14,000
But after you do the installation and once you do the SQL connection, right.

22
00:01:14,000 --> 00:01:17,000
So this is how things are going to look at uh here.

23
00:01:17,000 --> 00:01:19,000
You can basically go ahead and write your query.

24
00:01:19,000 --> 00:01:21,000
You can use your database you know.

25
00:01:21,000 --> 00:01:27,000
So this definitely requires a lot of tutorials with respect to SQL itself.

26
00:01:27,000 --> 00:01:32,000
So for my sake, right, what I am actually going to do, I'm going to probably go ahead and create

27
00:01:32,000 --> 00:01:34,000
my student table.

28
00:01:34,000 --> 00:01:37,000
So what I will do, I will just say hey drop student.

29
00:01:39,000 --> 00:01:40,000
Drop table student.

30
00:01:40,000 --> 00:01:43,000
First of all, since I've already created the student over here.

31
00:01:43,000 --> 00:01:45,000
So I will go ahead and execute this.

32
00:01:46,000 --> 00:01:51,000
So, uh, so I'll just select this and execute it okay.

33
00:01:51,000 --> 00:01:54,000
So once I drop it here, you can see I am not getting this particular table.

34
00:01:54,000 --> 00:01:55,000
Uh, student table.

35
00:01:55,000 --> 00:01:58,000
So this is my database that I've actually created.

36
00:01:58,000 --> 00:02:02,000
I will just go ahead and create a student table over here.

37
00:02:02,000 --> 00:02:02,000
Right.

38
00:02:02,000 --> 00:02:09,000
So here you can see I have written create student, uh, table student name worker, class worker section

39
00:02:09,000 --> 00:02:11,000
worker marks and the same.

40
00:02:11,000 --> 00:02:14,000
All the commands are almost same, like how we have actually used it.

41
00:02:14,000 --> 00:02:16,000
And I'm going to use this particular database.

42
00:02:16,000 --> 00:02:19,000
So once I execute it here, you can see it has got executed perfectly.

43
00:02:19,000 --> 00:02:25,000
Now quickly let me just go ahead and write select star from student.

44
00:02:25,000 --> 00:02:29,000
And once I execute this you will be able to see all my records.

45
00:02:29,000 --> 00:02:32,000
So here are all the records that I have right.

46
00:02:32,000 --> 00:02:39,000
So this is the basic way of, uh, just executing a query in my SQL database and in my MySQL database.

47
00:02:39,000 --> 00:02:43,000
What I'm actually going to do, I'm going to read this entire table right?

48
00:02:43,000 --> 00:02:49,000
And I'm going to probably get it as again, as I told you before, this particular module only I have

49
00:02:49,000 --> 00:02:52,000
given you the entire SQL playlist from my YouTube channel.

50
00:02:52,000 --> 00:02:54,000
You can definitely go ahead and watch it over there.

51
00:02:54,000 --> 00:03:00,000
But once you prepare this entire student table, uh, now it's time that we'll start building our project

52
00:03:00,000 --> 00:03:01,000
in our next video.

53
00:03:01,000 --> 00:03:04,000
So let's go ahead and let's I'll see you all in the next video.

54
00:03:04,000 --> 00:03:04,000
Thank you.