WEBVTT

00:00.230 --> 00:10.890
Now insert values in the table what we can do is we can insert values by saying we can we can just Grito

00:10.950 --> 00:17.520
we can just use the command Kalas insert so insert into employee.

00:17.610 --> 00:24.570
That is the table name you need to say employee insert into employee and you can directly insert the

00:24.570 --> 00:26.640
values if you want to and so all of them.

00:26.760 --> 00:32.130
But if you just want to insert selectively like say for example I just want to put a last name.

00:32.340 --> 00:37.930
I want to put the power to put an email and I want to put that up.

00:38.610 --> 00:42.530
I just want these things to be put up OK.

00:42.840 --> 00:48.000
I just need to say and sort of employ and I can select these three columns and I can see just ABC columns

00:48.000 --> 00:51.480
I want to see what should be the values corresponding to that.

00:51.480 --> 00:54.110
OK so first name I need to put in string.

00:54.120 --> 00:56.910
I need to put in double code I need to save the string.

00:56.910 --> 01:00.760
First name is going to be it's going to be c let's say X Y Z.

01:03.540 --> 01:07.310
Email is X Y Z at company dot com.

01:07.480 --> 01:08.080
Right.

01:08.230 --> 01:10.450
So that's also a strength.

01:10.870 --> 01:14.490
And let me say finally TAAB that's the data.

01:14.500 --> 01:23.150
But there's going to be a date but it's going to be let's say in nineteen Eighty-Four

01:25.250 --> 01:32.150
1984 you know 18 and sorry it's going to be let's say.

01:32.200 --> 01:39.170
So five and 80 and then close it up with the semi-colon.

01:39.180 --> 01:42.710
And so you first the goal then a month then the date.

01:42.860 --> 01:45.180
So that's how the GOP got start.

01:45.350 --> 01:51.980
So that's about one employee if you want to insert another one let's say and sort of employ values instead

01:51.980 --> 01:53.030
of x y z.

01:53.130 --> 02:03.500
Next CPQ or this time I want to even put the last name so I can put an L name come on you know P Q R

02:03.680 --> 02:09.460
can have p q p q r s t.

02:09.500 --> 02:10.900
Great.

02:11.180 --> 02:15.030
And then this can be just P-Q are at company dot com right.

02:15.080 --> 02:16.940
And the date of birth.

02:17.040 --> 02:21.320
Here he was born in 1989 1994.

02:21.790 --> 02:22.200
OK.

02:22.250 --> 02:23.660
And yet.

02:23.750 --> 02:24.820
That's it.

02:24.890 --> 02:26.350
What he was saying.

02:26.600 --> 02:27.530
OK let's see.

02:27.580 --> 02:39.250
And so now the FY if I say select r Let me answer one more insert into employee and sort of P-Q or it's

02:39.260 --> 02:40.570
going to be x y z.

02:40.610 --> 02:45.310
But he has the same surname as the earlier guy in this country.

02:45.330 --> 02:47.140
Email will the ex-wifes here.

02:47.270 --> 02:48.410
Compre dot com.

02:48.620 --> 02:57.730
And this time he's from 1974 and Mundus he's from 8 Tater's 50.

02:57.770 --> 02:58.400
That's it.

02:58.520 --> 03:05.780
And so now you can just have a look at you know if you say top tables we'll just give you the table

03:05.780 --> 03:06.790
name.

03:06.860 --> 03:16.520
What if I want all the columns in that table I should say select select all from the table employ so

03:16.540 --> 03:18.220
I can have multiple tables.

03:18.220 --> 03:24.380
So as you can see X Y Z then it gives you you know nothing nothing and then x y z a complete dot com.

03:24.400 --> 03:31.440
So it gives you the name Kenichi ID's their name is your name is your salary is your email.

03:31.490 --> 03:32.460
You use you.

03:32.620 --> 03:38.160
So it gives you even though hetero's for each of them if you're not aware of them.

03:38.200 --> 03:45.050
So it gives you the TAAB GOP it's just putting up though it's just putting up the year for now.

03:45.070 --> 03:45.990
That's OK.

03:46.320 --> 03:46.810
OK.

03:46.810 --> 03:52.950
So these are a few things that you need to know when you come to escalate the levees.

03:53.020 --> 04:00.280
Now after we go on deescalated abuses we need to go on to something called us since we are learning

04:00.280 --> 04:02.720
about this delight right.

04:02.860 --> 04:14.620
If I want you know if I want all those employees you know rich are richer richer having you know something

04:14.620 --> 04:16.690
like those employees.

04:16.760 --> 04:17.100
OK.

04:17.100 --> 04:22.330
By the way have IDs are incremented right.

04:22.530 --> 04:22.980
OK.

04:23.040 --> 04:29.130
So I just want those employees let's say who did I have to x y z.

04:29.290 --> 04:30.340
So that's OK.

04:30.400 --> 04:37.700
I want you know those guys whose age is about 25 or something like that.

04:37.870 --> 04:38.480
OK.

04:38.710 --> 04:41.220
Or if I I just want the date of it.

04:41.290 --> 04:43.060
I don't want all of that right.

04:43.090 --> 04:49.510
Or something like that if I want to do something where you know I want to deal with the IDs or something

04:49.510 --> 04:58.480
like that then I need to deal specifically with a way to where I can say well OK I can use the concept

04:58.480 --> 05:05.410
of where OK here now there's nothing that you can do you can probably put up or do or something like

05:05.410 --> 05:05.900
that.

05:05.950 --> 05:11.380
But if you want to you know if you want to exit this particular database you could just sit down is

05:11.420 --> 05:13.730
it ok you can say on exit.

05:13.780 --> 05:19.360
And after saying don't fix it you can just come out of the escalator.

05:19.540 --> 05:19.900
Right.

05:20.050 --> 05:25.810
So this is about how you can do with databases and how you can do this collated a business and how you

05:26.290 --> 05:27.310
go about it.

05:27.490 --> 05:31.890
OK it is quite simple this is quite not quite complicated and stuff like that.

05:31.910 --> 05:37.720
Now what we're trying to do is we're going to create some bindings between the Python code and this

05:37.720 --> 05:38.220
database.

05:38.230 --> 05:40.330
That is what is our next child.

05:40.360 --> 05:43.920
We need to create a binding bridge and that means you create a connection between them.

05:44.230 --> 05:50.800
Try to bring the databases and then get some data from them and send data back in such a way that he

05:50.800 --> 05:56.120
could store them or he can access them or he can work on them as and when time comes.

05:56.350 --> 05:56.820
All right.

05:56.950 --> 06:03.700
All right so what are you going to do was let's create Let's create a pilot file as we can see here.

06:03.790 --> 06:05.730
We're going to create a python file out here.

06:05.930 --> 06:11.860
We've already created you know a package that is set up the Senate where we're going to have a code

06:12.370 --> 06:19.300
written in order to connect our architecture writing code with databases deal with databases talk to

06:19.300 --> 06:25.050
databases access values said values populate it and stuff like that.

06:25.120 --> 06:25.870
Right.

06:25.870 --> 06:33.160
So let's do it let's let's connect to a database and then create a database connection and do it on.

06:33.190 --> 06:35.550
So we'll do that from the next.

06:35.810 --> 06:36.360
OK.
