1

00:00:03,010 --> 00:00:04,840

Hello and welcome to this video.



2

00:00:04,870 --> 00:00:12,250

This video is Aboutaleb Exercise, so I want you guys to complete this three super simple exercise.



3

00:00:12,640 --> 00:00:15,620

So the first one is find out the name of employees.



4

00:00:15,620 --> 00:00:21,520

Second is list all the employees who are working in I.T. department and the thought is, sure, different



5

00:00:21,520 --> 00:00:22,670

types of department.



6

00:00:23,020 --> 00:00:27,480

So what is the reference of this, how you are going to get this table?



7

00:00:27,490 --> 00:00:30,670

So I'm going to show you the table, the table structure.



8

00:00:30,910 --> 00:00:36,420

And based on that, you have to fire this three simple queries into your Ezekial database.



9

00:00:37,090 --> 00:00:43,450

I would encourage doing it yourself, try to search it out on the Internet, try to take reference from



10

00:00:43,450 --> 00:00:46,980

previous videos, work hard and try to solve it.



11

00:00:47,320 --> 00:00:52,470

Still, if you are not able to do this, continue watching this video till the end.



12

00:00:52,480 --> 00:00:55,390

I am going to solve all this three exercise for you.



13

00:00:56,300 --> 00:00:58,490

So here is the table structure.



14

00:00:58,520 --> 00:01:02,000

I want you guys to create this structure, something like this.



15

00:01:05,480 --> 00:01:11,480

That table should have three columns by the name I.D., employee name and employee department, the



16

00:01:11,480 --> 00:01:13,550

name of the table should be employee.



17

00:01:14,150 --> 00:01:19,970

The data type should be enough for the employee I.D. and for the restaurant should be worker.



18

00:01:21,390 --> 00:01:29,040

The size of Dendi should be 10, the maximum allowed size for the Neimann Department should be 50 and



19

00:01:29,040 --> 00:01:29,580

50.



20

00:01:30,150 --> 00:01:33,450

So this is how the structure should look like.



21

00:01:35,040 --> 00:01:40,830

Your are the values to be inserted into the table one, two and three, John, Harry, Peter and the



22

00:01:40,830 --> 00:01:43,500

department are finance IDM major.



23

00:01:45,750 --> 00:01:53,880

Was the video for five minutes tried to do it on your own, take the exercise questions, understand



24

00:01:53,880 --> 00:02:00,630

about the structure and the data, and try to write down three different queries for three simple questions,



25

00:02:00,630 --> 00:02:02,720

which I have assigned to you over here.



26

00:02:03,570 --> 00:02:07,550

If you are not able to do it, then continue watching this video.



27

00:02:10,210 --> 00:02:16,780

I am going to go on my localhost now, I'm using the database, which I have created previously.



28

00:02:16,810 --> 00:02:19,830

You can also create a new database if you want.



29

00:02:19,840 --> 00:02:23,950

I am using the same user database which I have created previously.



30

00:02:24,760 --> 00:02:32,180

I'm going to directly create a table by the name employee is given in to the lab exercise from your.



31

00:02:32,710 --> 00:02:39,370

It says that I have to create a table by the name employee, so I'm using the same name that is employed



32

00:02:39,370 --> 00:02:40,450

to create a table.



33

00:02:42,430 --> 00:02:44,410

With three columns.



34

00:02:45,530 --> 00:02:46,550

And he don't go.



35

00:02:50,050 --> 00:02:56,620

Let's copy the name of the column from the Bible itself, so I'm going to copy the name that is employing



36

00:02:56,620 --> 00:02:57,040

the school.



37

00:02:59,350 --> 00:03:06,490

I'll go on to the local host and paste this in BIJA, and the length maximum should be then the second



38

00:03:06,490 --> 00:03:11,830

column name was Employer and the school names, so I'm going to rename this to employee name.



39

00:03:12,310 --> 00:03:17,050

Changed this to worker and value should be 50 again.



40

00:03:17,060 --> 00:03:23,840

The third thing, I'm going to rename this to employ the underscore department data I should be working



41

00:03:24,520 --> 00:03:27,280

and the length maximum allowable should be 50.



42

00:03:29,090 --> 00:03:29,540

Great.



43

00:03:29,570 --> 00:03:38,330

So everything seems perfect, looks exactly what the requirement was, so I'm going to conceive.



44

00:03:39,740 --> 00:03:42,530

And the structure of my table is now ready.



45

00:03:42,560 --> 00:03:49,040

I am ready with three different columns as suggested, so I'm going to go into the employees table to



46

00:03:49,040 --> 00:03:50,120

see this structure.



47

00:03:50,570 --> 00:03:56,970

If you see that you're I have three columns, employer, employee name and employee department.



48

00:03:57,380 --> 00:03:58,490

So now what next?



49

00:03:58,700 --> 00:04:02,510

So I'm going to quickly enter the values into the table.



50

00:04:03,900 --> 00:04:11,010

So doing so, the value I'll go to the school tab, select on insert button, and then I'm going to



51

00:04:11,010 --> 00:04:12,330

change the values.



52

00:04:14,170 --> 00:04:19,840

Change the first value to one second value to John.



53

00:04:21,080 --> 00:04:25,730

And the third value to finance.



54

00:04:27,280 --> 00:04:28,450

And click on Go.



55

00:04:31,330 --> 00:04:34,790

It's exactly what the requirement was.



56

00:04:35,410 --> 00:04:41,220

So make sure that you put a single coat when you are entering the market.



57

00:04:43,590 --> 00:04:49,500

I'm just copying this so that it becomes easy to enter the second record and yes, the first row has



58

00:04:49,500 --> 00:04:53,070

been inserted into my table, that is employees.



59

00:04:56,380 --> 00:05:02,260

You can edit it from your or else you can go into the school and do the same process, so I pasted the



60

00:05:02,260 --> 00:05:10,300

line, I copy, I'm changing the values to do Harry and now again hit on go another day.



61

00:05:10,460 --> 00:05:12,370

Another record has been inserted.



62

00:05:16,370 --> 00:05:19,460

I'm going to toward record, that is Peter.



63

00:05:20,660 --> 00:05:30,800

Three and each click on Go, the last row is also been inserted to check out how the table looks like



64

00:05:30,800 --> 00:05:32,960

select staff from employees.



65

00:05:32,960 --> 00:05:35,090

And here is how the table looks like.



66

00:05:35,420 --> 00:05:38,440

It's exactly what the requirements was.



67

00:05:39,110 --> 00:05:40,930

So that is it for the video.



68

00:05:40,940 --> 00:05:44,290

And next video, we are going to perform three simple queries.



69

00:05:44,300 --> 00:05:45,410

Thank you so much.