1
00:00:05,290 --> 00:00:06,400
Here we.

2
00:00:07,190 --> 00:00:10,750
I hope you get installed successfully deployed serious skill.

3
00:00:10,880 --> 00:00:13,000
And if you're getting some problems then you can ask me.

4
00:00:13,010 --> 00:00:14,700
I was so late.

5
00:00:14,780 --> 00:00:18,280
So now we finally begin working the databases.

6
00:00:18,340 --> 00:00:23,960
Now we have to learn what the database actually eats and how we can install the one that is both cheery

7
00:00:23,970 --> 00:00:25,260
as well.

8
00:00:25,370 --> 00:00:31,390
Now we are going to learn that how we can cope with that from now things will be very easy for you.

9
00:00:31,460 --> 00:00:37,690
So first of all make a file for the databases in the US.

10
00:00:37,880 --> 00:00:48,630
So the item you file save this phone is say D.B. denoting database not be why i i'm taking short names

11
00:00:48,630 --> 00:00:59,640
so that I do not have to write much in terminal and this on his own next to and not no when one thing

12
00:00:59,640 --> 00:01:00,100
I'm doing.

13
00:01:00,120 --> 00:01:06,900
I'm going to do here is I have this file at this point and I'm going to make a copy of this one at this

14
00:01:06,900 --> 00:01:12,720
database base too and rename the son D.B. to the spacing between them.

15
00:01:12,720 --> 00:01:18,720
Now also on this file here we have this I just have got this one here.

16
00:01:18,720 --> 00:01:19,660
Now why.

17
00:01:19,670 --> 00:01:28,350
To file one for the default database one for the both jihadi so that you can see that how they're different

18
00:01:28,770 --> 00:01:30,080
because they are no different at all.

19
00:01:31,190 --> 00:01:37,190
Now let me begin first of all working with any database is very simple.

20
00:01:37,210 --> 00:01:44,500
Hey I will tell you only three things that will make you to go to these one possible use or any database

21
00:01:44,620 --> 00:01:46,060
very easily.

22
00:01:46,270 --> 00:01:55,810
And those three things are plus one five step three second one is like what that is

23
00:01:59,000 --> 00:02:04,150
focusing on Goma and caution.

24
00:02:05,120 --> 00:02:08,940
So you need to only focus on these two things.

25
00:02:09,020 --> 00:02:14,740
Are very different from the other languages I believe because in that one you did not require what.

26
00:02:15,050 --> 00:02:20,710
And last thing functions usage.

27
00:02:20,900 --> 00:02:24,370
So if you will just focus on these two things.

28
00:02:24,370 --> 00:02:32,670
There is nothing more except this thing in the complete database I believe that the only thing first

29
00:02:32,850 --> 00:02:35,710
that we consider these fights step.

30
00:02:36,030 --> 00:02:40,410
So the database works on four.

31
00:02:40,800 --> 00:02:44,600
Now what the area they stands for First one

32
00:02:47,140 --> 00:02:48,750
connection.

33
00:02:48,790 --> 00:02:52,020
Second one Gaza

34
00:02:54,700 --> 00:02:56,800
third one.

35
00:02:57,340 --> 00:03:06,680
Connect enough then fourth one is close and between them we have execute

36
00:03:09,740 --> 00:03:16,970
so these are the seeds we e middle which make all the work done with these databases.

37
00:03:16,970 --> 00:03:20,400
Now what they actually are is like here we have the database.

38
00:03:20,420 --> 00:03:24,050
This one is a hard drive separately and I'm working on my main hunch right.

39
00:03:24,440 --> 00:03:28,660
So first I need a connection between my program and this hard drive.

40
00:03:29,120 --> 00:03:33,770
After that one let me take a simple example you have a drawer in your house in which you need to add

41
00:03:33,770 --> 00:03:35,250
some stuff.

42
00:03:35,300 --> 00:03:38,510
So first of all you need to go to that one.

43
00:03:38,680 --> 00:03:41,190
Second thing you need to open.

44
00:03:42,070 --> 00:03:48,310
So that what you will do with your hands so your hands are acting as it goes out there that are doing

45
00:03:48,310 --> 00:03:48,680
this.

46
00:03:49,720 --> 00:03:56,090
And connection is you are getting to Denver after that execute is like you are putting your stuff there

47
00:03:56,090 --> 00:03:57,810
and taking other stuff from Denver.

48
00:03:58,310 --> 00:04:02,150
So that is the execute or maybe you are adding some more.

49
00:04:02,240 --> 00:04:08,170
You are changing something and you are maybe taking money from distraught to draw like that.

50
00:04:09,170 --> 00:04:15,400
After that one this one is not connect this is commit maybe by hitting and date it.

51
00:04:15,540 --> 00:04:17,180
Same as they connect.

52
00:04:17,180 --> 00:04:19,350
So they commit after that one is made.

53
00:04:19,370 --> 00:04:22,080
Like now you have done all this stuff.

54
00:04:22,160 --> 00:04:23,010
You are going to leave.

55
00:04:23,000 --> 00:04:24,610
There is nothing as left.

56
00:04:26,130 --> 00:04:28,720
After that we have to close that is closing the door.

57
00:04:28,860 --> 00:04:31,050
Otherwise someone else will steal that.

58
00:04:32,330 --> 00:04:41,140
And you can also see these two steps like commit is closing and closes locking the now they will move

59
00:04:41,270 --> 00:04:45,910
to this but before that function focusing on this one the functions.

60
00:04:46,450 --> 00:04:54,690
So these are the two things that we are going to focus on the program the comas and caution Mark caution

61
00:04:54,690 --> 00:05:05,670
mark may only be required for local or we can see default database.

62
00:05:05,680 --> 00:05:08,840
We did not require this one while we are working with people cheering.

63
00:05:08,840 --> 00:05:13,840
So this is not a typical issue of daily functions use it.

64
00:05:14,180 --> 00:05:15,720
This thing is very important.

65
00:05:15,830 --> 00:05:20,240
Like if you are creating the Escalade then I have told you the five steps.

66
00:05:20,240 --> 00:05:26,510
So whatever you need to do like the draw is the best example if you need to add something update something

67
00:05:26,870 --> 00:05:29,690
take something you always need to perform that five steps.

68
00:05:29,690 --> 00:05:31,350
There is no shortcut for document.

69
00:05:31,640 --> 00:05:36,950
So you not write all the five lines again and again in your program whenever you need to update something

70
00:05:37,520 --> 00:05:42,820
like If you are adding 100 names then you gonna write again and again that lengths.

71
00:05:43,160 --> 00:05:50,710
So it is very good to make some simple thing functions so that you can define them once and call whenever

72
00:05:50,710 --> 00:05:51,450
you are required.

73
00:05:52,330 --> 00:05:57,130
So with the databases we are going to do everything in functions.

74
00:05:57,130 --> 00:05:59,860
So let's begin with that one.

75
00:05:59,880 --> 00:06:07,290
First of all if I'm working on the default database I need to import a library that is known as a school

76
00:06:08,400 --> 00:06:15,640
right or because it is too light three make sure that no double L in between them so here we have a

77
00:06:15,640 --> 00:06:17,240
school like.

78
00:06:17,620 --> 00:06:27,310
After that when I'm making a simple connection here for that one defining a function say connect.

79
00:06:27,550 --> 00:06:33,660
We have this one or this one you can simply do without any connections also.

80
00:06:33,760 --> 00:06:36,940
Let me just define this one without any connection.

81
00:06:36,940 --> 00:06:38,740
So connect is very simple.

82
00:06:38,890 --> 00:06:49,810
You just need to add Sue and then denoting connection then ask you a light tree don't because we are

83
00:06:49,810 --> 00:06:58,990
using this library as the main default database and then just add connect and they're in quotes bus

84
00:06:59,410 --> 00:07:03,420
light database that is light dot baby.

85
00:07:03,460 --> 00:07:06,540
So this is all about the connection at this point.

86
00:07:06,580 --> 00:07:08,790
Your file are connected.

87
00:07:08,930 --> 00:07:14,920
Now what about creating some table with everything you are going to store in the database is stored

88
00:07:14,920 --> 00:07:18,330
in form of tables as I have shown you on the Safari.

89
00:07:18,940 --> 00:07:21,430
So no of book with functions begin.

90
00:07:21,740 --> 00:07:33,820
I'm defining a function here that is create say DBA princes and then courts in that van wherever you

91
00:07:33,820 --> 00:07:35,590
are drawing something.

92
00:07:35,620 --> 00:07:38,820
You always need a connection again like the draw.

93
00:07:38,860 --> 00:07:43,450
You first need to go to that one after that when you need to create some hands.

94
00:07:43,450 --> 00:07:45,320
That is a Gaza.

95
00:07:45,400 --> 00:07:47,040
So this goes of it act.

96
00:07:47,200 --> 00:07:51,880
So we have CNN connection and then Gaza.

97
00:07:53,730 --> 00:07:56,190
So this is very important step.

98
00:07:56,190 --> 00:07:59,840
You always need after that when we have execution step.

99
00:08:00,040 --> 00:08:08,370
I'm leaving a enter here because this is the only line that will differ in know every like when we add

100
00:08:08,430 --> 00:08:16,800
delete view like these operations press the forces will all be same only the E is different.

101
00:08:16,800 --> 00:08:24,390
So when you are done everything just become it about that one solves connection not commit and Pence's

102
00:08:24,960 --> 00:08:30,200
there is no parameter in this and in last when you do just close that one.

103
00:08:30,210 --> 00:08:32,070
Otherwise your data will not be saved.

104
00:08:33,730 --> 00:08:36,600
So these are the four lines that will always remain seen.

105
00:08:36,640 --> 00:08:41,150
Now about creating the data.

106
00:08:41,350 --> 00:08:47,370
So whenever you are working the data is this thing you will understanding the next video event.

107
00:08:47,400 --> 00:08:53,710
I will show you with the posterior clear there I can show you all the things but not in this video.

108
00:08:54,180 --> 00:09:02,340
We have only a few commands select to select any data or we have then create

109
00:09:04,850 --> 00:09:06,500
insert this time.

110
00:09:06,530 --> 00:09:10,420
So stuff I was there to talk about this in the next video.

111
00:09:10,790 --> 00:09:11,800
Let me focus on this one.

112
00:09:12,740 --> 00:09:20,230
So execution is done with these hands like you can not just put the stuff without your hands.

113
00:09:20,300 --> 00:09:28,700
So you only also need to include DeCosta so because they're not executed there we have this one Pence's

114
00:09:29,930 --> 00:09:35,310
and then in that one make sure always passing the quotes because query language is the language which

115
00:09:35,330 --> 00:09:40,340
is always bus in between courts whether you are working on the Internet or you are working on local

116
00:09:40,340 --> 00:09:43,090
host this will always be in courts.

117
00:09:43,340 --> 00:09:49,880
And one more thing here we can use for separation of things is this symbol this this is actually the

118
00:09:49,880 --> 00:09:57,780
one before one and about the step number one and about f or D below the debt escape button.

119
00:09:57,780 --> 00:10:02,800
Now you can just copy this whole to use this one again and again because this will all that you've been

120
00:10:02,810 --> 00:10:11,900
seeing now to create a table we use here just create the language is very simple just add here create

121
00:10:11,960 --> 00:10:15,060
if you want to create insert if you want to insert.

122
00:10:15,110 --> 00:10:16,890
Simple as that.

123
00:10:16,910 --> 00:10:18,320
So one more thing.

124
00:10:18,350 --> 00:10:19,910
Well it is good.

125
00:10:19,970 --> 00:10:26,630
If you prefer capital letters because they will separate the votes from the one that we are adding locally

126
00:10:26,930 --> 00:10:32,330
because there is no comma no slash no equal to used in between these.

127
00:10:32,450 --> 00:10:34,400
Just a simple syntax line.

128
00:10:34,520 --> 00:10:37,790
That's why I have to loop coma and question mark.

129
00:10:37,790 --> 00:10:38,880
All this focus on that.

130
00:10:39,160 --> 00:10:43,880
So create and then what we need to create here a table so paper.

131
00:10:43,910 --> 00:10:49,100
Now if you notice here we have no separation and no codes and no Epsilon.

132
00:10:49,280 --> 00:10:52,230
You can also separate this one by adding this like this.

133
00:10:52,340 --> 00:10:56,210
It will still work but more I'm taking a simple example.

134
00:10:56,540 --> 00:11:05,140
Create table space there provide the name of people you want to create say I want to create data there

135
00:11:05,150 --> 00:11:09,910
we have this one here the table is created.

136
00:11:09,960 --> 00:11:15,850
Now if you want to add columns in that table simply a table consists of columns and tools.

137
00:11:16,430 --> 00:11:23,030
So for that one now you need to pass Prentiss with the name that you have created there.

138
00:11:23,690 --> 00:11:29,490
And then there at that point add what you want to see in my first column is name.

139
00:11:29,780 --> 00:11:33,180
So you simply just need to provide a name for us.

140
00:11:33,270 --> 00:11:38,340
And just providing things that I'm adding here comma after that I need say.

141
00:11:38,390 --> 00:11:43,770
Lemme say I'm adding muscle to students and then I have months.

142
00:11:43,850 --> 00:11:52,650
So here these two things I need to add in my data or say rule number is before the name that is.

143
00:11:52,730 --> 00:11:59,930
Why would you have this one lady this is about adding the columns.

144
00:11:59,950 --> 00:12:05,340
Now one more thing you need to specify with that one like whatever you are adding provided data.

145
00:12:06,100 --> 00:12:08,830
And that is simple like rule number just a space.

146
00:12:08,830 --> 00:12:10,150
And what did what number will be.

147
00:12:10,300 --> 00:12:12,870
This one will be an integer.

148
00:12:13,000 --> 00:12:14,700
There we go with that one name.

149
00:12:14,720 --> 00:12:16,460
This one is going to be a XT.

150
00:12:16,520 --> 00:12:21,380
So not string we have XT again I will show you this thing in the next video.

151
00:12:21,570 --> 00:12:26,420
Then we have marks this one maybe like floating point values in integer values.

152
00:12:26,420 --> 00:12:29,400
For that we use real.

153
00:12:30,080 --> 00:12:31,090
Now we are done with this one.

154
00:12:31,520 --> 00:12:36,700
So this is all about creating a table and all about everything in the database.

155
00:12:36,740 --> 00:12:44,630
Just this line will defer with the things press will always remain the same maybe in few.

156
00:12:44,760 --> 00:12:48,220
We have a different or because of one more addition line here.

157
00:12:48,240 --> 00:12:50,510
Next we will talk about the press.

158
00:12:50,520 --> 00:12:52,470
These things will always be seen.

159
00:12:52,470 --> 00:12:55,710
So you will not find difficulty with using databases.

160
00:12:55,710 --> 00:12:59,170
So just controls this one.

161
00:12:59,500 --> 00:13:02,020
And I have just created a function here.

162
00:13:02,410 --> 00:13:15,330
I also need to call this one and just remove the death for now or just this one simple lines or you

163
00:13:15,330 --> 00:13:17,570
can just call here.

164
00:13:17,580 --> 00:13:25,510
Create table and benches see if this one day long the terminal is not fixed.

165
00:13:25,590 --> 00:13:31,560
So I'm using the terminal separately see next door.

166
00:13:31,560 --> 00:13:42,300
And then here byte and three DB Don't be why it written they will get this one successful no letter

167
00:13:42,870 --> 00:13:51,270
and the output is not here but here this one you have noticed this one is created at this point.

168
00:13:51,270 --> 00:14:03,850
Let me show you that one again with a different name see data to see if this one then it again You do

169
00:14:03,850 --> 00:14:05,170
not get this one right now.

170
00:14:05,830 --> 00:14:09,030
So that one is updated in that one right now.

171
00:14:09,310 --> 00:14:19,660
And if I delete this one and again on that one we go to that one again here light dot tv and if you

172
00:14:19,660 --> 00:14:23,890
change the name this will just only updated not a separate copy.

173
00:14:25,030 --> 00:14:26,520
So we have that now.

174
00:14:26,620 --> 00:14:31,150
So here we have created the data table.

175
00:14:31,150 --> 00:14:36,340
And if you tried to open this one you will not find any application in your computer but you can still

176
00:14:36,340 --> 00:14:40,420
open this one just right click open with an indexed for it.

177
00:14:41,380 --> 00:14:43,760
So this one is something you will get.

178
00:14:43,870 --> 00:14:47,430
You will not able to understand this when you have some data here.

179
00:14:47,770 --> 00:14:51,310
But that is it readable like this one table data.

180
00:14:51,610 --> 00:14:53,040
Create table data.

181
00:14:53,200 --> 00:14:55,570
Then my skill that I have passed there.

182
00:14:56,590 --> 00:15:00,160
And then I have passed data to for this same display.

183
00:15:00,640 --> 00:15:02,590
All the commands would be here.

184
00:15:02,770 --> 00:15:08,470
Also whatever the data you will add will be seen here but not in a systematic and efficient way.

185
00:15:09,100 --> 00:15:14,730
So this is the reason we why these other databases because you do not have a much efficient way here

186
00:15:16,560 --> 00:15:20,600
so this is all about creating a table in default database.

187
00:15:20,600 --> 00:15:21,540
We learn the same.

188
00:15:21,540 --> 00:15:23,970
The deposed jihadis will in the next video.

189
00:15:24,120 --> 00:15:25,350
I hope you understand this.

190
00:15:25,950 --> 00:15:26,820
So we'll see you there.