1
00:00:01,290 --> 00:00:08,700
So now we are going to learn some obscure Connery's other comments in this video and as you can see,

2
00:00:08,820 --> 00:00:17,280
how connected to my local MySQL server and I would explain the interface over here to get a much better

3
00:00:17,280 --> 00:00:18,720
feeling of undiscerning.

4
00:00:19,110 --> 00:00:20,310
And you can click on this file.

5
00:00:20,310 --> 00:00:27,240
You can create a new model or you can define your own database and a set of rules and you can open a

6
00:00:27,240 --> 00:00:28,150
new query type.

7
00:00:28,230 --> 00:00:29,610
It's the same like this.

8
00:00:32,190 --> 00:00:38,680
And you can also open this up, open a square script, if you will have any comments written in a script.

9
00:00:38,680 --> 00:00:46,200
And you can open that in the using this organized group and you can also open and you can also run a

10
00:00:46,440 --> 00:00:49,390
script and you can also call the tabs and scripts.

11
00:00:49,950 --> 00:00:55,980
So these are used for this opening and closing the scripts and you can choose the preferences if you

12
00:00:55,980 --> 00:01:03,960
want to and you can do the home banners and the next minute placement, etc. And in this quarter you

13
00:01:03,960 --> 00:01:10,830
can select the statements you want to execute either current statement or are the statements.

14
00:01:11,760 --> 00:01:19,440
So you can if you want to open another current to that, another database which is on another computer

15
00:01:19,440 --> 00:01:20,880
or any other part.

16
00:01:22,200 --> 00:01:28,830
So in this server, as you can see this one, you can click on this admission, the same settings you

17
00:01:29,100 --> 00:01:34,770
see under this server options and the tools you can configuration tools.

18
00:01:34,770 --> 00:01:37,530
You can back up the connections and restore those connections.

19
00:01:38,220 --> 00:01:40,610
So you can also use this scripting.

20
00:01:40,890 --> 00:01:43,650
You can execute the commands here.

21
00:01:44,280 --> 00:01:47,070
And we are not going to execute any scoops.

22
00:01:47,070 --> 00:01:48,060
No, no.

23
00:01:48,070 --> 00:01:49,410
What is click on this.

24
00:01:50,100 --> 00:01:54,180
So these key ones are like metadata for this database.

25
00:01:54,210 --> 00:01:59,730
It defines what columns are there, what tables are there and etc..

26
00:02:00,090 --> 00:02:05,580
So these are the three databases that are provided in world with MySQL.

27
00:02:06,420 --> 00:02:13,350
I start to use the PowerPoint presentation to display my school of basics, but I thought it would take

28
00:02:13,350 --> 00:02:21,210
so much time because this my school is very long and also making PBT is I'm tired of this.

29
00:02:21,540 --> 00:02:26,640
But anyway, I will explain from basics this obscure statements.

30
00:02:27,720 --> 00:02:33,280
As you can see, there are two databases here, Sakinah and, uh, CIS and the works.

31
00:02:33,280 --> 00:02:35,750
This is the main database used by this school.

32
00:02:35,940 --> 00:02:39,700
And you can see these are these two are the sample data, which is a killer and the world.

33
00:02:39,930 --> 00:02:46,110
To click on this Aramaki, you can see this database has been expanded and this inWorld database, you

34
00:02:46,110 --> 00:02:49,140
have the tables, you score procedures and functions.

35
00:02:49,630 --> 00:02:54,000
So these functions are to automate this school statements.

36
00:02:54,000 --> 00:02:56,580
You can just call these functions and they will execute.

37
00:02:57,060 --> 00:02:59,430
And you can also click on these tables.

38
00:02:59,430 --> 00:03:04,170
And in these tables we will have the information in the rows and columns.

39
00:03:04,200 --> 00:03:07,770
These columns contains the actual data and the rows contains the values.

40
00:03:08,280 --> 00:03:12,620
And if you click on this city, you can see here the information it's telling you.

41
00:03:12,810 --> 00:03:18,020
So in this city table, I have the schema as no country, Kurdish population.

42
00:03:19,320 --> 00:03:27,330
So that means, uh, in this city I have some names contribute district and population to the same way

43
00:03:27,340 --> 00:03:28,530
if I could to this country.

44
00:03:28,530 --> 00:03:33,870
I have the name counterintelligence service area, and there is so much information about this.

45
00:03:34,290 --> 00:03:37,660
So I want to display this data.

46
00:03:37,770 --> 00:03:41,070
So how do you do this is first you need to use.

47
00:03:43,720 --> 00:03:56,380
Use a four letter word, so I'm this my high school education to that means capital use and smart use

48
00:03:56,380 --> 00:03:57,560
and capital is both awesome.

49
00:03:57,610 --> 00:03:59,320
You either one.

50
00:04:01,130 --> 00:04:09,540
But many developers use the capital letters for the school syntax comments like you select and so on.

51
00:04:10,400 --> 00:04:13,250
So first, we need to use this word for a run.

52
00:04:13,280 --> 00:04:17,570
This I need to click on this record to run this statement.

53
00:04:17,960 --> 00:04:19,980
And you can see here, this is the log.

54
00:04:20,000 --> 00:04:25,310
You can see the output we have that this useful.

55
00:04:25,580 --> 00:04:29,870
And you can if you go right over here, you can see this is the left banner.

56
00:04:30,170 --> 00:04:31,450
This is Breuker negating.

57
00:04:31,520 --> 00:04:32,870
Have to click on this.

58
00:04:33,170 --> 00:04:34,430
This will go off.

59
00:04:34,730 --> 00:04:41,120
And if you click on again, it will really just give us a update on this, though.

60
00:04:41,390 --> 00:04:44,750
Uh, you can see the click on this now.

61
00:04:44,750 --> 00:04:45,620
It will vanish.

62
00:04:46,100 --> 00:04:51,350
Now, if I click on this, it would reappear now in the same way, right there is the right window.

63
00:04:52,080 --> 00:04:55,160
Uh, you can add excursions.

64
00:04:56,250 --> 00:04:58,520
Uh, we don't want that for now.

65
00:04:58,520 --> 00:05:02,530
I am in this, uh, to disappear so fast.

66
00:05:02,690 --> 00:05:04,320
We have learned this useful.

67
00:05:04,340 --> 00:05:12,020
So this database will be use it as it may not like this obscure condenser pointer pointing to this or

68
00:05:12,170 --> 00:05:16,430
any operations we have will do will reflect in this database.

69
00:05:16,880 --> 00:05:20,000
So we are going to learn select committee.

70
00:05:20,090 --> 00:05:21,100
This is very important.

71
00:05:21,650 --> 00:05:29,090
And what we want to do, we want to start started in a sense, all the columns and we need to see from

72
00:05:30,620 --> 00:05:30,930
you on.

73
00:05:30,950 --> 00:05:33,850
These are the tables you want to display from, let's say, city.

74
00:05:34,940 --> 00:05:35,870
That's a city.

75
00:05:36,390 --> 00:05:44,720
And I can see this program is, uh, every line ends with semicolon in the same way as you can envision.

76
00:05:45,530 --> 00:05:53,710
Uh, but in the modern, uh, high school, uh, syntaxes, uh, even though if you do not put semicolon,

77
00:05:53,870 --> 00:06:01,280
uh, this is Kirkman's gets rejected, but it's best practice to know if I click on this icon.

78
00:06:03,310 --> 00:06:08,170
Uh, I can close this output using this, we don't want the output we want.

79
00:06:09,130 --> 00:06:10,120
We don't want drugs.

80
00:06:10,130 --> 00:06:13,840
We don't want only this output to expand this.

81
00:06:14,110 --> 00:06:19,370
You can see the whole information about this table in the city table.

82
00:06:19,510 --> 00:06:24,030
I have the illegal name column, country, district population.

83
00:06:24,280 --> 00:06:26,380
This top heading is called columns.

84
00:06:26,390 --> 00:06:29,800
You can see this is the column and this is this is this and this.

85
00:06:30,310 --> 00:06:37,420
And in the column I have the values one, two, three, four, etc. I have the values, Cowgill, Conder,

86
00:06:37,420 --> 00:06:39,970
etc. Connecticut district population as well.

87
00:06:40,150 --> 00:06:47,230
So this is called one drop and this is called the horizontal values are called rules and the vertical

88
00:06:47,650 --> 00:06:48,910
columns are columns.

89
00:06:49,600 --> 00:06:54,040
And I started started because I want to display all the columns.

90
00:06:54,280 --> 00:06:58,760
If I want to display only the column, I can say, uh.

91
00:07:00,940 --> 00:07:05,410
So if I click on this one, I can see there are only the ideas.

92
00:07:06,820 --> 00:07:14,130
So let me click on the star and click on this and I get the ah, the values.

93
00:07:14,380 --> 00:07:22,150
Now I can just particularly sort of two or three columns by supporting them with let's let them come

94
00:07:22,150 --> 00:07:24,850
up and just.

95
00:07:29,440 --> 00:07:33,130
So I think the syntax is correct.

96
00:07:33,610 --> 00:07:40,450
OK, now that's so if I run this, I will get only two columns verbatim.

97
00:07:40,450 --> 00:07:48,040
And so these are the basic derivations we have in my school.

98
00:07:48,880 --> 00:07:54,670
I can also say Sarac star from a country.

99
00:07:57,660 --> 00:08:00,760
Let me execute this, OK?

100
00:08:00,870 --> 00:08:03,220
There is a lot more information going on.

101
00:08:03,660 --> 00:08:11,880
You can see, though, this is a country called name continent region service area and their population,

102
00:08:11,880 --> 00:08:14,040
etc. As you can see, there is a value called.

103
00:08:14,640 --> 00:08:16,700
So no value represents nothing.

104
00:08:16,710 --> 00:08:24,060
It's just like placeholder to say that there is no information about this column and about this law.

105
00:08:24,260 --> 00:08:32,730
So suppose if you, uh, have some information but you don't know yet, but we want to find out in the

106
00:08:32,730 --> 00:08:33,030
future.

107
00:08:33,360 --> 00:08:38,970
So in that case, you can keep the value so that others can understand that the value is unavailable

108
00:08:38,970 --> 00:08:41,520
or it may be available in the future.

109
00:08:41,550 --> 00:08:45,770
So it's like a placeholder if you don't know the value you can put here.

110
00:08:46,440 --> 00:08:49,920
So these are the big databases available for them.

111
00:08:50,430 --> 00:08:52,840
But we do not want the database.

112
00:08:53,430 --> 00:08:56,340
We are going to create our own sample databases.

113
00:08:56,370 --> 00:09:02,160
Let me call this output to create a database we need to go create.

114
00:09:04,460 --> 00:09:05,900
Database and database, no.

115
00:09:08,750 --> 00:09:17,780
Let's say students, so we are going to clear the database kada students at Mexica this.

116
00:09:19,360 --> 00:09:24,310
And you can see there is no assurance that the best way to handle this, you want to click the button

117
00:09:24,550 --> 00:09:31,360
to see the changes and you can see there is the student database.

118
00:09:31,630 --> 00:09:39,250
So this is not highlighted, but, uh, the world has the ball ball because, uh, previous comments

119
00:09:39,250 --> 00:09:47,440
we have used that use all the, uh, Quarrie that swing this world is in the, uh, accoustic.

120
00:09:47,440 --> 00:09:53,680
So we need to get the students as an to we need to say we can do this great.

121
00:09:53,690 --> 00:09:55,930
That the students are in a school.

122
00:09:55,940 --> 00:09:59,150
You can put two hyphens and the space to create a comment.

123
00:09:59,170 --> 00:10:01,170
So this line will be ignored.

124
00:10:01,330 --> 00:10:05,110
And if you can this nothing will happen because this is a comment.

125
00:10:05,620 --> 00:10:10,650
And this comment is very important in a school inflection point of view.

126
00:10:12,040 --> 00:10:20,970
So I can say use students or I can just Double-Click on the students to make sure that this is actually

127
00:10:20,970 --> 00:10:21,370
the best.

128
00:10:21,700 --> 00:10:24,750
So I get on this one and shouldn't be going back again.

129
00:10:24,760 --> 00:10:28,490
I figured if I double click on this world, it will be Comsec to know.

130
00:10:28,690 --> 00:10:31,480
However, we will execute this, uh, statement.

131
00:10:31,480 --> 00:10:40,710
You students don't worry if I use the statements Kuwaiti's or any other, uh, uh, language.

132
00:10:40,870 --> 00:10:42,970
What are some recent statements are saying?

133
00:10:44,380 --> 00:10:48,770
OK, now my students database is inactive.

134
00:10:48,940 --> 00:10:56,560
It is always, uh, a good method to use the database you are, uh, performing.

135
00:10:57,160 --> 00:11:07,320
I mean, this that I database name, uh, in front of whatever before the any changes go into this by

136
00:11:07,330 --> 00:11:07,780
students.

137
00:11:08,320 --> 00:11:12,730
Uh, this make sure that we are actually performing the operations on the students database.

138
00:11:14,110 --> 00:11:16,440
So we do not have any tables.

139
00:11:16,450 --> 00:11:20,520
Not this is empty tables, empty database.

140
00:11:20,560 --> 00:11:21,750
We need to create the table.

141
00:11:21,750 --> 00:11:28,000
Lets to do that the secret uh table.

142
00:11:28,660 --> 00:11:32,860
We ritzier our table.

143
00:11:33,370 --> 00:11:38,560
We need to put the table name that's uh in for.

144
00:11:40,600 --> 00:11:47,900
And we need to select the types of columns we need to add into this info table.

145
00:11:48,700 --> 00:11:55,780
So let me say open bracket and in this open bracket, we need to define the column values column.

146
00:11:56,280 --> 00:11:59,170
Uh, better let's it.

147
00:11:59,890 --> 00:12:03,990
So every student have the idea and the data for this idea is integer.

148
00:12:05,740 --> 00:12:09,840
So I want to serve first the underscore name.

149
00:12:10,180 --> 00:12:11,740
So we shouldn't have the first name.

150
00:12:11,740 --> 00:12:15,700
And I can say where worker of 250.

151
00:12:16,090 --> 00:12:25,480
This is like ASCII, sorry, NC you can see 256, uh ASCII plus extended ASCII values can put this as

152
00:12:25,480 --> 00:12:25,960
it first.

153
00:12:27,190 --> 00:12:27,480
Right.

154
00:12:27,500 --> 00:12:29,800
This is the basic syntax of DIWAKAR.

155
00:12:29,800 --> 00:12:32,340
I don't want to go in depth into these variables.

156
00:12:32,350 --> 00:12:36,550
I just explain the basic values that are integers and workers.

157
00:12:36,550 --> 00:12:43,310
And there are actually in the sense a lot of uh, uh, LNT characters.

158
00:12:43,330 --> 00:12:48,090
OK, a student can have a last last name.

159
00:12:49,630 --> 00:12:58,300
Last name is also where care workers sense verbal character and she can say open brackets.

160
00:12:58,310 --> 00:13:04,250
You can see where various options were to differ.

161
00:13:04,510 --> 00:13:13,150
And we have the first name, last name until the last three four underscore number.

162
00:13:15,090 --> 00:13:23,280
For no reason right now, I can successfully cross this, uh, braggarts and put the semi current let

163
00:13:23,280 --> 00:13:27,810
me execute this query for a fresh this.

164
00:13:27,810 --> 00:13:29,610
You can see there is a table created in.

165
00:13:31,820 --> 00:13:36,220
So we do not want this because I want I want I'm going to do this.

166
00:13:37,250 --> 00:13:41,240
Now, let's start from, uh, Disinfo.

167
00:13:43,430 --> 00:13:48,310
To see what other values are there in the info table.

168
00:13:50,800 --> 00:13:57,820
Let me run this query can see there is there is no let up because we just created this table.

169
00:13:57,820 --> 00:14:00,220
And what this is, this is called schema.

170
00:14:00,370 --> 00:14:06,480
And also there are other countries and the concept Koliada diagrams that is into the relationship diagrams.

171
00:14:07,090 --> 00:14:14,170
You can just map these translations using this relationship diagrams in a diagrammatically.

172
00:14:14,410 --> 00:14:22,780
That's why this is this database, as is called Relational Database Management System RDBMS, because

173
00:14:22,780 --> 00:14:29,200
we can, uh, connect these databases tables using these, uh, relationships.

174
00:14:29,350 --> 00:14:36,970
So we will see how we can connect using the joints, uh, in the end of this area are within a few moments.

175
00:14:37,360 --> 00:14:43,210
So now if I start this structure from info, I have got no data because we just created the table and

176
00:14:43,210 --> 00:14:48,220
we have no data is you can see there is a different name and phone number.

177
00:14:48,220 --> 00:14:48,500
Right.

178
00:14:49,810 --> 00:14:55,620
So we are going to insert some values into this crew that I want to insert into.

179
00:14:56,440 --> 00:14:58,060
I want to specify the table.

180
00:14:58,060 --> 00:15:05,020
I want to insert I want to insert into enforceable and enforceable and I consider brackets.

181
00:15:05,230 --> 00:15:11,050
And under what columns I need to insert, I want to insert our first name or phone number.

182
00:15:11,380 --> 00:15:22,240
If I want to insert into all these columns, I can just simply say, well, well, you s and I should

183
00:15:22,240 --> 00:15:25,200
do in order the values of the first row.

184
00:15:26,500 --> 00:15:32,710
So I, I'm, I'm going to enter the first row that is ID number, let's say one comma and first term

185
00:15:32,880 --> 00:15:37,150
to Nagasaki, which is my name.

186
00:15:37,570 --> 00:15:45,550
And let's, let's say last night musicological nickel and then let's say for number one, two, three,

187
00:15:45,550 --> 00:15:48,540
four, five and put the same in Canada.

188
00:15:48,730 --> 00:15:56,200
So what this means is we are inserting into this in four tables and the values are one.

189
00:15:56,200 --> 00:16:02,560
This goes into the idea and this now goes into this name and this nickel goes into the last name and

190
00:16:02,560 --> 00:16:04,360
one to if it goes to the phone number.

191
00:16:06,240 --> 00:16:11,040
So if you want to insert into only first name and the last name, you need to say.

192
00:16:12,300 --> 00:16:13,350
Info off.

193
00:16:16,830 --> 00:16:18,720
For first name and the last name.

194
00:16:28,640 --> 00:16:30,570
Fashion for them.

195
00:16:30,670 --> 00:16:38,500
I need to switch to only two values and the two are going to go into these two respective columns first

196
00:16:38,680 --> 00:16:39,410
and last name.

197
00:16:39,430 --> 00:16:40,660
So I don't want to do that.

198
00:16:40,660 --> 00:16:48,850
I want to put in these exact values into this exact columns because there are four columns and the four

199
00:16:48,880 --> 00:16:52,930
values of the first, and that if you exclude this.

200
00:16:54,870 --> 00:16:55,630
OK.

201
00:16:55,860 --> 00:17:02,060
I did not use the static statement to refer to the data structure from.

202
00:17:03,440 --> 00:17:15,260
In four, so if I run this query, as you can see, these come this insert is has been neglected and

203
00:17:15,260 --> 00:17:17,010
we got the first one.

204
00:17:17,030 --> 00:17:18,640
Now, one, two, three, four, five.

205
00:17:19,250 --> 00:17:25,330
So let's try to insert some more values, some morals.

206
00:17:25,340 --> 00:17:27,260
I mean, let me copy this.

207
00:17:31,950 --> 00:17:36,600
So let me try to insert the first two three.

208
00:17:38,010 --> 00:17:45,210
For so let me add some of the students so I don't have any friends that say Acer is a laptop.

209
00:17:46,630 --> 00:17:48,370
A sort of Strix.

210
00:17:50,230 --> 00:17:52,150
And let's say 100.

211
00:17:54,470 --> 00:17:59,150
And let's talk to the Navy's Lenovo.

212
00:18:01,370 --> 00:18:04,480
It's a last name for this Runaway's Legian.

213
00:18:06,180 --> 00:18:10,550
And let's you know, the phone number of this region is 500.

214
00:18:11,190 --> 00:18:16,800
I'm just putting for one purpose and let's say Iesus.

215
00:18:18,070 --> 00:18:21,000
And rashness, let's roll.

216
00:18:23,470 --> 00:18:29,230
Let's say the very one, two, three, one, two, three, four ruffian's, so we are going to insert

217
00:18:29,440 --> 00:18:32,050
three more rules and let's see.

218
00:18:34,800 --> 00:18:39,500
And there you can go, there you can see the four walls have been inserted, first name, last name

219
00:18:39,540 --> 00:18:40,650
and the phone numbers.

220
00:18:46,510 --> 00:18:56,110
So this is the, um, basic the my escort clients are let us see some more.

221
00:19:00,840 --> 00:19:10,770
So I have a comment on these comments now, we need to see some of these filter options from the statement,

222
00:19:11,310 --> 00:19:13,260
there is a condition called bear.

223
00:19:14,840 --> 00:19:23,260
And this word can be used to filter the options, uh, certain with this select statement I can see

224
00:19:23,870 --> 00:19:30,280
are the results are the columns from the info where I can say it is greater than two.

225
00:19:31,490 --> 00:19:33,440
So I can say it is greater than two.

226
00:19:33,860 --> 00:19:42,860
If I select this for execute this now, I will see the output only with the rules that are greater than

227
00:19:42,860 --> 00:19:43,100
two.

228
00:19:43,250 --> 00:19:45,460
So we got the three fatalities.

229
00:19:45,830 --> 00:19:50,390
So that's how you use the word to filter these ideas.

230
00:19:51,530 --> 00:19:58,880
So you can also put the greater than as equals two to get two, three, four rows and you can put the

231
00:19:58,880 --> 00:20:01,700
rest on articles two together, one, two rows.

232
00:20:02,090 --> 00:20:05,810
And you can also, uh, put the rest then.

233
00:20:08,270 --> 00:20:10,340
Less than two to get the first true.

234
00:20:11,990 --> 00:20:18,060
And you can also put this greater than or greater than a than rather than three.

235
00:20:19,400 --> 00:20:20,870
This is not as equals.

236
00:20:21,040 --> 00:20:27,220
You can put, uh, exclamation as equals to to get decided not as close to three.

237
00:20:27,530 --> 00:20:32,090
So I get the rules with the I.D. one, two, four and not three.

238
00:20:33,590 --> 00:20:41,210
As you can see, one, two, four, and not so this is another form for the not equal to some of these

239
00:20:41,210 --> 00:20:49,050
databases of Resident Getdown and some of these databases support databases like the obscure maybe actually

240
00:20:49,110 --> 00:20:51,920
suppose less Democratic than audemars because of all this.

241
00:20:52,830 --> 00:20:56,700
It's good practice to know these alternatives.

242
00:20:57,230 --> 00:20:58,460
So let me show ID.

243
00:21:01,470 --> 00:21:10,260
So I got this one botrytis, so this is how you can use the word and you can also filter with the ah

244
00:21:10,260 --> 00:21:17,100
and the, uh, statement you can see and, uh, let's see.

245
00:21:21,370 --> 00:21:24,430
The for no less than a dozen.

246
00:21:26,690 --> 00:21:33,440
So what this means is we are starting all the columns from the info table where it should be less than

247
00:21:33,440 --> 00:21:36,770
three and also for no less than a thousand.

248
00:21:37,280 --> 00:21:49,510
So if I execute this, I get the second and third this and can be used to a union, these conditions.

249
00:21:49,520 --> 00:21:52,330
So this is one condition and this is the second condition.

250
00:21:52,340 --> 00:21:57,470
If only both conditions are true, then only this output will be displayed.

251
00:21:57,590 --> 00:22:03,080
Otherwise it will get a blank output based on these statements we have given, based on the conditions

252
00:22:03,080 --> 00:22:03,530
we are given.

253
00:22:03,560 --> 00:22:04,760
Let me ask you this.

254
00:22:05,460 --> 00:22:11,500
As you can see, two and three words, because less than not equal to three and also for no less than

255
00:22:11,510 --> 00:22:11,630
two.

256
00:22:11,870 --> 00:22:15,320
We got these two and you can also put the other.

257
00:22:18,930 --> 00:22:26,670
And so, as you can see, it is less than or equal to three or four, no less than dozen.

258
00:22:27,360 --> 00:22:32,710
So since this I.D. culture is done, this photo has been filled.

259
00:22:33,000 --> 00:22:39,270
But why this has been displayed because the phone number of this group has been one to three and it's

260
00:22:39,270 --> 00:22:40,100
less than today.

261
00:22:40,110 --> 00:22:43,150
So that's why we can we got this photo also.

262
00:22:44,670 --> 00:22:47,960
So that is how you use the R and the end.

263
00:22:51,930 --> 00:22:52,740
And.

264
00:22:55,090 --> 00:22:59,050
You can use the color distinct.

265
00:23:06,950 --> 00:23:08,870
So is that a distinct.

266
00:23:10,980 --> 00:23:17,880
So there are no any repeater values of this, so just you can also say they are using their distinct

267
00:23:19,410 --> 00:23:25,760
and OK, I have made the mistake a gaming laptops name is Predator.

268
00:23:25,770 --> 00:23:30,750
If I want to make a bet this value, I can say.

269
00:23:32,270 --> 00:23:33,110
I bet.

270
00:23:35,370 --> 00:23:46,470
A bird in for updating for the world said the last name is equal to where they want to, I want to see

271
00:23:47,130 --> 00:23:52,830
change that strikes into the Predator because there is a gaming laptops name is Predator, and I want

272
00:23:52,830 --> 00:23:54,990
to change the last name.

273
00:23:56,020 --> 00:24:04,900
The calls to prayer there are so far this comment, this is a very dangerous comment because if we do

274
00:24:04,900 --> 00:24:09,390
not give the condition, it will apply to all the rules.

275
00:24:09,520 --> 00:24:16,270
Face this attitude, this one, this predator will be placed under this strict region and rule out this

276
00:24:16,270 --> 00:24:16,720
radical.

277
00:24:17,920 --> 00:24:19,740
That's why this is very dangerous comment.

278
00:24:19,780 --> 00:24:22,000
And you only update this.

279
00:24:24,480 --> 00:24:33,500
Use these statements very carefully and also put where and I want to share ideas close to two of every

280
00:24:33,540 --> 00:24:36,170
single is that you can choose whatever you want.

281
00:24:36,510 --> 00:24:40,700
I want to choose the idea for run this.

282
00:24:43,290 --> 00:24:49,530
So it says that record you are using, save a bit more and try to build a world without work.

283
00:24:49,950 --> 00:24:55,050
So this is like my school, save more for our patients.

284
00:24:55,230 --> 00:24:56,850
So patients, you need to.

285
00:24:57,160 --> 00:24:59,590
What we want to see is you need to say.

286
00:25:03,180 --> 00:25:05,580
Said, Yes, Kule.

287
00:25:08,550 --> 00:25:09,350
Save.

288
00:25:10,570 --> 00:25:13,210
A bit is equal to zero.

289
00:25:15,520 --> 00:25:16,750
So you run this.

290
00:25:18,740 --> 00:25:24,570
And now you can see so after setting this up, there was as good as Alphabet's physiological.

291
00:25:24,860 --> 00:25:28,310
I actually ran this set up as you wish.

292
00:25:28,880 --> 00:25:33,160
So my are Strix has been replaced by rewriter.

293
00:25:33,410 --> 00:25:40,690
So that's why you can see this is very important to keep out of their condition.

294
00:25:41,780 --> 00:25:48,200
And if you do not put that, are the will be the replaceable predator sort of Miklós this.

295
00:25:53,370 --> 00:25:56,970
All right, I think I said are the basics.

296
00:25:57,160 --> 00:26:05,160
Now let's move on to the joints so I have a few more set theory in mathematics, like, yeah, union

297
00:26:05,160 --> 00:26:09,140
B, Section B and disjointing very, very easy.

298
00:26:09,480 --> 00:26:11,320
So don't get confused.

299
00:26:11,340 --> 00:26:16,290
I will explain in a very clear manner that first let me

300
00:26:18,900 --> 00:26:22,290
display the results of the info table.

301
00:26:22,320 --> 00:26:24,960
We have the I.D. of these students.

302
00:26:25,620 --> 00:26:27,870
Let me create a new database.

303
00:26:30,070 --> 00:26:31,090
So.

304
00:26:37,470 --> 00:26:47,970
OK, let me create a new database to create the tubists.

305
00:26:51,960 --> 00:26:53,170
Richard Marks.

306
00:26:53,310 --> 00:26:58,110
So why do not clear that up as we can simply create another table, right?

307
00:27:01,670 --> 00:27:03,380
Ritsa, Gruyère.

308
00:27:07,710 --> 00:27:08,190
Creer.

309
00:27:12,170 --> 00:27:22,630
Bill Marks, so what we're going to do is we should have this one column, uh, like equal in two or

310
00:27:22,630 --> 00:27:26,380
three tables, then we can join those two there was using the same column.

311
00:27:26,560 --> 00:27:27,790
So let me explain this.

312
00:27:29,620 --> 00:27:31,860
So create table marks.

313
00:27:31,870 --> 00:27:40,210
And I want to say it by putting the point and I want to say, uh, Marks.

314
00:27:44,660 --> 00:27:48,950
And the are also integer, so me correct this.

315
00:27:51,040 --> 00:27:56,500
You can see so there are two levels, let me go and insert somewhere else into this.

316
00:28:01,640 --> 00:28:07,460
Inserting tool marks that values.

317
00:28:10,150 --> 00:28:22,560
Well, you s let me go and insert 81, that cigar that marks 100 marks, so let me copy this in such

318
00:28:22,570 --> 00:28:26,470
statement and post multiple times.

319
00:28:29,210 --> 00:28:39,580
So I want to create the second lady and so Marks is to three hundred thirty marks is equal to two 200

320
00:28:40,130 --> 00:28:41,820
and now I'm going to put the idea.

321
00:28:41,840 --> 00:28:53,350
It is not enough in for, let's say, eight to eighty, eighty, eighty and how the monks 900.

322
00:28:53,850 --> 00:28:55,670
So let me go and execute this.

323
00:28:56,900 --> 00:28:59,590
She can see are the statements have been executed.

324
00:28:59,600 --> 00:29:03,320
And let me start from.

325
00:29:05,170 --> 00:29:05,980
Marks.

326
00:29:11,680 --> 00:29:18,020
As you can see, there is I.D. one, it is one, two, three, and the marks, 100, 200, 200, 900.

327
00:29:18,460 --> 00:29:20,710
Let me also display the info.

328
00:29:24,290 --> 00:29:33,860
So these are the student names as these are the students, one, two, three, four, and previously

329
00:29:34,490 --> 00:29:38,670
we have the marks and observe only the authorities.

330
00:29:38,690 --> 00:29:43,640
We have one, two, three, four, and the details of the students if you exclude the marks.

331
00:29:44,240 --> 00:29:47,950
So we have the I.D. one, two, 380 and the marks.

332
00:29:48,120 --> 00:29:52,670
So what we can join these two was using these marks.

333
00:29:53,600 --> 00:29:56,520
So I will show you how to do the joint.

334
00:29:56,720 --> 00:29:58,630
So these are some types of joints.

335
00:29:58,940 --> 00:30:00,280
Those are inner join.

336
00:30:00,320 --> 00:30:08,000
So inner joints in the sense that the two days and the already displayed results, which are common

337
00:30:08,000 --> 00:30:09,020
in those tables.

338
00:30:09,170 --> 00:30:11,140
So what are the common in these two there?

339
00:30:11,150 --> 00:30:13,700
Was it one, two, three are in this table.

340
00:30:13,820 --> 00:30:17,250
And also I one, two, three are there in total.

341
00:30:17,600 --> 00:30:20,300
So all the disparate results, which are the commonality.

342
00:30:20,480 --> 00:30:23,420
So inner joint is like a intersection B.

343
00:30:27,410 --> 00:30:29,940
In Chinese intersection B.

344
00:30:40,250 --> 00:30:47,830
So I will show you what is here and what is being so fast, I want to see a select.

345
00:30:50,210 --> 00:30:51,500
A star from.

346
00:30:53,690 --> 00:30:58,160
For now, I want to apply, not join, I want to say.

347
00:31:00,180 --> 00:31:08,820
Inner join, I want to join in for table with Mark.

348
00:31:12,130 --> 00:31:20,080
And now I want to say on so on what basis, on what basis, your journey, these two tables on the Idy

349
00:31:20,080 --> 00:31:24,780
basis, I am joining these tables because the article is in this info in the box.

350
00:31:25,150 --> 00:31:26,380
So I will say.

351
00:31:28,870 --> 00:31:29,470
It's.

352
00:31:31,950 --> 00:31:39,720
So that's so you can you can access this table using the students that info and students dot marks,

353
00:31:40,500 --> 00:31:42,720
so it's students.

354
00:31:44,440 --> 00:31:56,410
Not in full or not, Heidi, you can access this individual column using the student database and enforce

355
00:31:56,410 --> 00:31:58,600
the will and the article is equal to.

356
00:32:00,790 --> 00:32:07,040
Students taught and marks, not I.

357
00:32:08,950 --> 00:32:18,460
So I am I want to join this info and the marks on the basis of this I.D. it makes good this.

358
00:32:23,250 --> 00:32:24,600
So I have some.

359
00:32:35,300 --> 00:32:36,320
Oh, I think I should.

360
00:32:48,460 --> 00:32:50,050
OK, students.

361
00:32:52,010 --> 00:32:52,960
So there you go.

362
00:32:53,010 --> 00:33:03,890
Yes, I got this what I have done is I said I want to order this from me for where I need to get all

363
00:33:03,890 --> 00:33:06,720
the resources that are matched with this marks.

364
00:33:06,890 --> 00:33:09,040
So what are the results that are my trademarks?

365
00:33:09,410 --> 00:33:11,020
On what basis it is?

366
00:33:11,020 --> 00:33:15,830
So I have only three ideas that are mentioned in this info table.

367
00:33:15,830 --> 00:33:17,960
And amongst those are three areas.

368
00:33:18,200 --> 00:33:21,290
And you can see the three and the first number on the phone number.

369
00:33:21,500 --> 00:33:29,990
And also I have joined the march to march here on the radar because this is a table we have as human

370
00:33:31,040 --> 00:33:32,600
left side and this is the right there.

371
00:33:32,600 --> 00:33:36,950
You can see this is these four sorry.

372
00:33:39,230 --> 00:33:44,780
So this these are not left in photos and this right.

373
00:33:45,230 --> 00:33:50,320
Uh, Tukaram Soldat, Mark's information can see it and the box.

374
00:33:50,930 --> 00:33:55,940
So this is a intersection B, so this is the year and this is the beat.

375
00:33:56,120 --> 00:34:02,370
So on intersexual we got only the matter is the are one, two, three.

376
00:34:03,140 --> 00:34:04,360
So this is a joint.

377
00:34:04,370 --> 00:34:05,370
I hope you have understood.

378
00:34:05,630 --> 00:34:07,040
Now let's see the left.

379
00:34:07,040 --> 00:34:07,850
The joint left.

380
00:34:14,500 --> 00:34:24,760
So what this does is it's like year on year when it's been union in the Section B. So what is that?

381
00:34:25,060 --> 00:34:32,350
What it does is it would display all of the info are the columns from the info table and also only the

382
00:34:32,740 --> 00:34:34,570
matching where you saw the marks.

383
00:34:34,580 --> 00:34:40,500
And if there are any that does not match, it will put the dollar values of I execute this.

384
00:34:41,530 --> 00:34:45,460
And as you can see, it displays are the columns from the info.

385
00:34:45,820 --> 00:34:47,820
There are the currents funding the info.

386
00:34:50,050 --> 00:34:52,020
And you can see there is a photo issues.

387
00:34:52,420 --> 00:34:55,140
But in this market, we do not have a default.

388
00:34:55,300 --> 00:34:56,300
We have the idea.

389
00:34:57,070 --> 00:34:59,200
So in this case, there is no default.

390
00:34:59,200 --> 00:35:01,030
That's where it has put the null values.

391
00:35:01,360 --> 00:35:07,420
So it is with all the value of here and only the matching value of being the so called innot left to

392
00:35:07,430 --> 00:35:07,740
join.

393
00:35:09,070 --> 00:35:17,980
And if I say right joint, so now you can get the right joint it displays are the values of these marks

394
00:35:18,220 --> 00:35:21,210
and only the matched results of this info.

395
00:35:21,370 --> 00:35:26,170
And if there are any leftovers from the info table, it will be replaced with another.

396
00:35:26,410 --> 00:35:29,860
So this is the joint if you change it to rejoin.

397
00:35:30,040 --> 00:35:38,130
Hourigan sees these values will be filled with data and the marks and these values internal to execute

398
00:35:38,140 --> 00:35:38,470
this.

399
00:35:46,420 --> 00:35:55,570
OK, now, if you can see these are the rules of these marks, they will have been successfully got

400
00:35:55,570 --> 00:36:02,110
and since there is no ideate in the info table, we got the Navajo's.

401
00:36:02,260 --> 00:36:06,370
So this is the right to only be and also match results from that.

402
00:36:06,370 --> 00:36:18,670
Yet it will be when you say intersection B minus the union intersection B, so there is a card for our

403
00:36:18,670 --> 00:36:22,450
joint which will combine every various.

404
00:36:26,240 --> 00:36:27,140
Squid, this.

405
00:36:32,830 --> 00:36:35,800
Ocurred, this is floatplane.

406
00:36:46,330 --> 00:36:50,260
OK, I don't know why I'm getting this are so full of.

407
00:36:51,920 --> 00:36:59,950
OK, if I run this floater, then I'll get that for Riley and also I'd already but in case it will join

408
00:36:59,950 --> 00:37:01,660
the whole left and right.

409
00:37:04,900 --> 00:37:06,940
So that's what this is called.

410
00:37:06,940 --> 00:37:07,630
Basic Search.

411
00:37:07,670 --> 00:37:14,460
I hope you have understood even I suggest you do practice all these statements.

412
00:37:14,470 --> 00:37:18,230
You can also Google them and practice the basic, uh, yes.

413
00:37:18,250 --> 00:37:19,060
Good qualities.

414
00:37:19,600 --> 00:37:25,350
And even those who do not practice just understand this video and it will be very much helpful.

415
00:37:25,940 --> 00:37:27,980
A further injection.

416
00:37:28,630 --> 00:37:33,850
You can do the manually, the you can join these tables and you can also union disturbers.

