WEBVTT

00:00.180 --> 00:07.680
OK so that can give me some sign some sort of some you know create table.

00:07.680 --> 00:13.800
So these are some commands which are specific Kresge like if you wish to have a look at them.

00:14.070 --> 00:16.100
They are their options.

00:16.320 --> 00:22.160
You can have a look Eski light escalate commands.

00:22.560 --> 00:26.410
So these are the commands that you can deal with.

00:26.430 --> 00:29.510
Charles points one of them which we'll deal with.

00:29.820 --> 00:31.970
Or you can just go to.

00:32.070 --> 00:37.500
You can just go to escalate towards the command line shell for a satellite and it gives you all the

00:37.500 --> 00:42.280
documentation for the same where it says if you want or you can.

00:42.870 --> 00:45.990
You can just create a table by saying create table.

00:46.050 --> 00:52.870
And the tables name should be there that is Table 1 and you should give the name of the columns inside.

00:52.890 --> 00:56.520
So the names of the columns in that table one and two.

00:56.730 --> 01:00.940
And what is the type of the variable that these columns will hold.

01:01.110 --> 01:06.430
That needs to be given you vodka for Strain small and for something else.

01:06.590 --> 01:06.920
OK.

01:06.930 --> 01:11.830
So you have a couple of things and then you insert into these the values.

01:12.420 --> 01:16.730
So we're going to deal with that in detail as we as we start up.

01:16.820 --> 01:17.180
OK.

01:17.190 --> 01:18.960
So we are going to lead.

01:18.960 --> 01:21.230
So let's start.

01:21.480 --> 01:26.760
Let's start up with this and let's start with the commands.

01:26.760 --> 01:27.370
OK.

01:27.570 --> 01:29.790
So we are going to say.

01:30.360 --> 01:31.920
Let me just put it up.

01:31.980 --> 01:33.370
Let me just put it up out here.

01:33.450 --> 01:40.380
So the company that table like Mercy create table create table what I need to give a name let me say

01:40.380 --> 01:42.600
the name of the table is employee.

01:42.930 --> 01:48.090
OK if I put just a semi-colon I actually put a semi-colon after every reskill light statement.

01:48.120 --> 01:53.840
Other than the ones which are dot helper dot exit or dot databases or something like that.

01:53.910 --> 01:55.030
Tables.

01:55.050 --> 01:58.650
Now you don't need to present every call for them but you do put a table for everybody.

01:58.700 --> 02:01.950
Stylites into every valid as a light command.

02:01.950 --> 02:03.740
So you say there's an error why.

02:03.780 --> 02:10.380
Because you cannot just create a table but you also need to say what kind of columns are there in this

02:10.380 --> 02:16.000
particular room table employees want you to put them in brown brackets and then need to say the kind

02:16.650 --> 02:18.150
columns that you want to employ.

02:18.150 --> 02:22.180
So let me let me say I want every employee should have an ID.

02:22.350 --> 02:23.000
OK.

02:23.320 --> 02:27.350
Every every employee should have should have a first name.

02:27.630 --> 02:29.710
Every employee should have a last name.

02:29.940 --> 02:38.440
Every employee should have you know something which defines your salary and something which defines

02:38.440 --> 02:39.300
their.

02:39.420 --> 02:46.200
So they have their first name they have their last name they have their salary and also you can have

02:46.200 --> 02:56.080
something like they're things like the employee they're OK they're email they're in the store and.

02:56.440 --> 02:59.420
And of course there you can store that data.

02:59.430 --> 03:00.030
But.

03:00.150 --> 03:00.890
OK.

03:01.260 --> 03:05.870
Date of birth or date of joining or something like that let's just have just one.

03:05.880 --> 03:06.340
OK.

03:06.390 --> 03:12.430
And let's say if even if now if I say enter it will give me an arrow.

03:12.720 --> 03:16.410
So it didn't give me an error but by default it takes.

03:16.470 --> 03:19.970
If you want to see the tables you will see the tables.

03:20.160 --> 03:21.600
And there's an employee.

03:21.600 --> 03:31.510
So if I select star or if I if I want to see what all are there in tables you know.

03:31.790 --> 03:32.850
So.

03:33.310 --> 03:43.620
So if you can right there select star from employee that's as you can see select star from the table

03:43.630 --> 03:48.510
ones that will give you all the columns but OK the columns nothing is there but at least the name of

03:48.510 --> 03:49.750
the headings should be seen.

03:49.980 --> 03:57.350
So irritated at her on Dot header on and then do the select star from imply.

03:57.510 --> 04:03.130
Oh so there's doesn't work out there for reasons.

04:03.200 --> 04:03.870
OK.

04:03.950 --> 04:07.030
So here in this case it is on.

04:07.040 --> 04:17.090
So it gave you the you know it gave that particular command and it made it on OK as we go ahead.

04:17.440 --> 04:19.720
Let's understand a few things out here.

04:19.720 --> 04:23.590
So we created a table and the.

04:23.960 --> 04:31.390
So that's one thing but second thing that we need to understand is we also if you want to drop this

04:31.390 --> 04:35.920
particular table you have to it drop drop table.

04:36.100 --> 04:45.000
An employee I can just say that Tropp table Employee and now if I say Doc tables if I say that tables

04:45.310 --> 04:51.270
there there's no employee table because I just dropped it but now I want to say I still want to see

04:51.270 --> 04:56.240
just employee but I also want to say what should be each of these.

04:56.370 --> 05:03.540
Should be of what type it should be of type in teacher OK should you have type in teacher first name

05:03.540 --> 05:08.490
should we have type of CAD of around 20.

05:08.640 --> 05:09.120
OK.

05:09.120 --> 05:14.340
Last name should also be right care of around 20.

05:14.410 --> 05:15.330
Right.

05:15.420 --> 05:21.140
So salary salary should be should be in.

05:21.530 --> 05:22.150
OK.

05:22.170 --> 05:24.420
E-mail should again be over Carol.

05:24.440 --> 05:30.730
We're on 20 DRP should be of what type and have a look.

05:30.730 --> 05:38.540
There are different types of data which is which is given here you can have a look output format or

05:38.570 --> 05:39.480
something like that.

05:39.480 --> 05:41.720
Just a second you can have a look.

05:42.010 --> 05:47.880
So you have text real small NCSA we import export Export with Excel.

05:47.900 --> 05:52.550
You have a lot of things which you can do to export files.

05:52.730 --> 06:04.900
But so if you were the one to have a look at the escalate options where you have different data structures

06:04.900 --> 06:09.210
or different you know different things that you can look at.

06:09.400 --> 06:14.710
So maybe in the documentation you can just just go ahead have a look for the documentation and there

06:14.750 --> 06:20.850
are all the documents there are you know the alphabetical listing.

06:20.890 --> 06:21.410
OK.

06:21.580 --> 06:27.640
So what you can do is you can go for the if you go for the overview documents it's about the overall

06:28.180 --> 06:31.790
programming interfaces is escalating five minutes or so.

06:32.440 --> 06:38.480
Escalate syntax is the rescuers and that's ok so.

06:38.490 --> 06:43.830
So the programming interfaces is what we need to need to know.

06:43.960 --> 06:44.250
Right.

06:44.250 --> 06:49.220
So this is side of the school a skylight in five minutes or less so we could just talk.

06:49.270 --> 06:58.180
So we just did about escalator DV and you have or you have an estimate for you know which way you can

06:58.180 --> 07:00.300
connect using C-code.

07:00.490 --> 07:02.240
That's not what you want to do though.

07:02.560 --> 07:04.940
So if you want you can just write.

07:05.350 --> 07:08.510
You know whenever you feel you want to come on.

07:08.950 --> 07:11.620
Escalate command which which is a query.

07:11.690 --> 07:20.090
And you want to say escalate date you know good times syntax or something like that.

07:21.370 --> 07:28.350
So if you want something like that you have a daytime function and maybe you can have a look at escalator

07:28.360 --> 07:34.390
to work itself which which takes date locate supports file date and time functions.

07:34.390 --> 07:35.670
One is data itself.

07:35.860 --> 07:38.320
So data takes a time string.

07:38.320 --> 07:39.090
You can have that.

07:39.100 --> 07:46.290
So you can have a date which of course you can have it so you be again going to be something Colus DBI

07:46.870 --> 07:48.190
is going to be date.

07:48.220 --> 07:49.040
That's it.

07:49.120 --> 07:52.720
So it's going to be I've typed it and then you might.

07:52.720 --> 07:59.200
So there are certain things which are which you want it to be so Id of an employee is going to be the

07:59.200 --> 08:04.930
primary key which will recognize them more which will you know mock him so I can put that as a primary

08:04.930 --> 08:05.560
key.

08:05.600 --> 08:13.400
Also I need to say this particular primary key increment every time an employee comes in or is that

08:13.400 --> 08:16.100
fit into is actually play I should increment it.

08:16.330 --> 08:19.680
So this must be very clearly stated in the auto increment.

08:19.690 --> 08:25.480
Now there are certain things which should not be null which means that you should be inserted for each

08:25.480 --> 08:25.790
of them.

08:25.790 --> 08:29.910
So for example if name first name it should not be null.

08:29.960 --> 08:31.490
Right there not now.

08:31.620 --> 08:38.200
OK a last name can be null No worries salary also may not be of criteria to put in the database for

08:38.200 --> 08:39.490
now.

08:39.490 --> 08:47.360
Email also we can say all right not null and no media 2 you can press not.

08:47.360 --> 08:50.390
No sorry if you don't want it to be.

08:50.440 --> 08:54.160
You have to put it not only if you want it to be compulsory.

08:54.160 --> 09:00.030
So don't put a not NULL for email and salary because.

09:00.100 --> 09:02.600
Because we have the choice then of not putting it up.

09:02.740 --> 09:05.670
It's the last names that end up.

09:05.770 --> 09:10.420
So it says that is an area near the autoincrement syntax.

09:10.690 --> 09:22.320
So primarily so in teacher you need to say our increment let's say disco Yes you put it on us go for

09:22.320 --> 09:24.970
our increment and they have the primary key.

09:25.170 --> 09:25.540
OK.

09:25.560 --> 09:28.470
So these are a few things that you have any create a table.

09:28.470 --> 09:36.240
Now if I see what tables it will give you this thing and if I say that's Bema backi my it will tell

09:36.240 --> 09:39.870
you the schema of the table Employee that you just created.

09:39.870 --> 09:41.490
What was the scheme all the same.

09:41.730 --> 09:44.520
OK so this is about creating a table.

09:44.520 --> 09:48.330
Now let's see how to insert values into the data.

09:48.780 --> 09:49.200
OK.
