Hello and welcome to this video.
This video is Aboutaleb Exercise, so I want you guys to complete this three super simple exercise.
So the first one is find out the name of employees.
Second is list all the employees who are working in I.T. department and the thought is, sure, different
types of department.
So what is the reference of this, how you are going to get this table?
So I'm going to show you the table, the table structure.
And based on that, you have to fire this three simple queries into your Ezekial database.
I would encourage doing it yourself, try to search it out on the Internet, try to take reference from
previous videos, work hard and try to solve it.
Still, if you are not able to do this, continue watching this video till the end.
I am going to solve all this three exercise for you.
So here is the table structure.
I want you guys to create this structure, something like this.
That table should have three columns by the name I.D., employee name and employee department, the
name of the table should be employee.
The data type should be enough for the employee I.D. and for the restaurant should be worker.
The size of Dendi should be 10, the maximum allowed size for the Neimann Department should be 50 and
50.
So this is how the structure should look like.
Your are the values to be inserted into the table one, two and three, John, Harry, Peter and the
department are finance IDM major.
Was the video for five minutes tried to do it on your own, take the exercise questions, understand
about the structure and the data, and try to write down three different queries for three simple questions,
which I have assigned to you over here.
If you are not able to do it, then continue watching this video.
I am going to go on my localhost now, I'm using the database, which I have created previously.
You can also create a new database if you want.
I am using the same user database which I have created previously.
I'm going to directly create a table by the name employee is given in to the lab exercise from your.
It says that I have to create a table by the name employee, so I'm using the same name that is employed
to create a table.
With three columns.
And he don't go.
Let's copy the name of the column from the Bible itself, so I'm going to copy the name that is employing
the school.
I'll go on to the local host and paste this in BIJA, and the length maximum should be then the second
column name was Employer and the school names, so I'm going to rename this to employee name.
Changed this to worker and value should be 50 again.
The third thing, I'm going to rename this to employ the underscore department data I should be working
and the length maximum allowable should be 50.
Great.
So everything seems perfect, looks exactly what the requirement was, so I'm going to conceive.
And the structure of my table is now ready.
I am ready with three different columns as suggested, so I'm going to go into the employees table to
see this structure.
If you see that you're I have three columns, employer, employee name and employee department.
So now what next?
So I'm going to quickly enter the values into the table.
So doing so, the value I'll go to the school tab, select on insert button, and then I'm going to
change the values.
Change the first value to one second value to John.
And the third value to finance.
And click on Go.
It's exactly what the requirement was.
So make sure that you put a single coat when you are entering the market.
I'm just copying this so that it becomes easy to enter the second record and yes, the first row has
been inserted into my table, that is employees.
You can edit it from your or else you can go into the school and do the same process, so I pasted the
line, I copy, I'm changing the values to do Harry and now again hit on go another day.
Another record has been inserted.
I'm going to toward record, that is Peter.
Three and each click on Go, the last row is also been inserted to check out how the table looks like
select staff from employees.
And here is how the table looks like.
It's exactly what the requirements was.
So that is it for the video.
And next video, we are going to perform three simple queries.
Thank you so much.