1

00:00:00,090 --> 00:00:00,960

All right, folks.



2

00:00:00,970 --> 00:00:01,840

So welcome back.



3

00:00:02,280 --> 00:00:06,620

This is Virginia, and this session is about walking off a school choir.



4

00:00:09,720 --> 00:00:17,150

And in a nutshell, what are we going to talk about as how the you are I'll get converted to the second



5

00:00:17,160 --> 00:00:17,490

grade.



6

00:00:17,780 --> 00:00:23,170

OK, so understanding the secretary is the master.



7

00:00:23,220 --> 00:00:25,200

Very important, but you see.



8

00:00:27,210 --> 00:00:36,450

But this is the information there are there are three columns which we read and we have the first we



9

00:00:36,450 --> 00:00:42,960

have we have name, location and interest of some of these students have the interest phone hacking,



10

00:00:43,350 --> 00:00:51,230

some of them are one of them, in fact, is having infosec has the interest the name of the table as



11

00:00:51,240 --> 00:00:51,870

students.



12

00:00:52,290 --> 00:00:57,030

So in the event we created a Debby's, we have to name one database.



13

00:00:57,030 --> 00:01:03,630

And the in the in the in the database, there can be multiple tables and it is stable, whether it be



14

00:01:03,630 --> 00:01:08,850

having multiple columns and there is corresponding information.



15

00:01:09,540 --> 00:01:09,920

All right.



16

00:01:09,930 --> 00:01:20,660

So it's that easy now when somebody send the query when you go to where you are and send some query,



17

00:01:20,670 --> 00:01:27,510

let's say you want to you even go to a search bar on a Web site, let's say example, dot com slash



18

00:01:27,510 --> 00:01:31,110

in the student section and type some in someone's name.



19

00:01:31,560 --> 00:01:36,900

When you go to the students, a question mark represents your query, what you search for.



20

00:01:37,260 --> 00:01:39,150

It even works for Google dot com.



21

00:01:39,150 --> 00:01:43,400

If you search very well, a question mark and name is equal to John.



22

00:01:44,310 --> 00:01:50,340

So usually what you supposed to get is the John Miami Miami.



23

00:01:50,340 --> 00:01:53,220

And the hacking is the interest.



24

00:01:53,220 --> 00:01:55,650

That is the information available on the database.



25

00:01:55,920 --> 00:02:03,140

And that's what you are supposed to see on your Web site, on the Web site and on your browser.



26

00:02:03,280 --> 00:02:05,580

OK, but what really happened?



27

00:02:05,730 --> 00:02:13,650

This information goes to the Web application and the Web application can walk in to and Nesquik ready



28

00:02:14,190 --> 00:02:16,170

to give it to the database.



29

00:02:16,170 --> 00:02:18,470

And that's is how it looks like.



30

00:02:19,410 --> 00:02:26,580

So you see and select anything from any of the different OK from any of the different from the from



31

00:02:26,580 --> 00:02:28,350

any of the anywhere.



32

00:02:28,350 --> 00:02:34,200

In fact, that's what it stymies any OK from students.



33

00:02:34,210 --> 00:02:41,970

So in the student table, if you see the when you go to any tab into the website that belongs to what



34

00:02:41,970 --> 00:02:46,080

people and students where the name is actually John.



35

00:02:46,230 --> 00:02:54,110

So where they call them specify which row you belong to, where a alas are Bob.



36

00:02:54,120 --> 00:02:56,780

So in that case the individual will be selected.



37

00:02:57,720 --> 00:03:04,020

So you see the student is the table here and the name becomes the column here.



38

00:03:04,350 --> 00:03:10,080

And that's how the data get three from the database is OK.



39

00:03:10,380 --> 00:03:14,070

And this is how the entire query really works.



40

00:03:14,550 --> 00:03:15,720

I hope you got the idea.



41

00:03:15,720 --> 00:03:17,760

Will catch you in the next session then you.