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.
