WEBVTT 00:00.390 --> 00:01.310 Welcome back. 00:01.310 --> 00:03.630 Now let us get started without ask you a line. 00:04.020 --> 00:09.720 If I talk about a square light it's a lightweight database that can provide relational data management 00:09.720 --> 00:14.770 system with zero configuration because we don't need to configure anything. 00:14.790 --> 00:19.840 We do need to set up anything we just need to import a square light tree. 00:19.890 --> 00:24.750 It's already available with Python and we don't have to do anything. 00:24.780 --> 00:30.810 The second thing is in general obscure light as a soulless database that can be used with an almost 00:30.960 --> 00:33.980 all programming languages including python. 00:34.020 --> 00:39.750 So solving this means there is no need to install any separate software to work with a square light 00:40.080 --> 00:43.040 so you can connect them directly with their database. 00:43.050 --> 00:46.970 As I talked about earlier my ass will require some server setup. 00:46.980 --> 00:49.410 We need to set up user username and password. 00:49.470 --> 00:54.900 Now the first time that we need to do is just directly import a square library. 00:54.960 --> 01:00.040 Once you import you on a school like tree you have to perform three doors every time. 01:00.330 --> 01:03.480 So the first one will be to create a connection with the database. 01:03.470 --> 01:04.230 Second will be. 01:04.230 --> 01:10.290 We need to create an object for Gaza and the third one will be to close all the connection that will 01:10.290 --> 01:12.240 be at the end of the program. 01:12.270 --> 01:18.270 So that means you have to perform these three step for every program in which you want to include a 01:18.270 --> 01:21.630 square like tree that is you want to work with database. 01:21.870 --> 01:23.640 After creating causative method. 01:23.640 --> 01:25.190 You can do anything that you want. 01:25.200 --> 01:27.120 That is your execution of update. 01:27.160 --> 01:27.990 And so. 01:28.200 --> 01:33.240 And all the things that you are going to work with you do timetables but after that we need to close 01:33.240 --> 01:35.130 our connection without any delay. 01:35.130 --> 01:37.890 Let us create our first connection with our database. 01:38.220 --> 01:44.820 So there could be a variable on and I need to use my square like tree then dot then connect and then 01:44.820 --> 01:49.810 I need to give a database name that's done. 01:49.830 --> 01:52.260 We have created our connection with our database. 01:52.260 --> 01:58.830 The second thing is to execute any school light statement we need to create a code set object so you 01:58.830 --> 02:04.500 can created with the help of course elementary school night because it is a method of connection object 02:04.600 --> 02:10.740 so to execute the school light to statement a connection is established at first and then an object 02:10.740 --> 02:14.270 of Koza is created using the connection object. 02:14.550 --> 02:20.100 Once that is done we can now execute all the queries or the statement with our database. 02:20.470 --> 02:26.730 So before doing anything else let me close this connection and run this file so I can create my database. 02:26.730 --> 02:30.230 Now let me run my mean not by and see what result I am going to get. 02:33.070 --> 02:37.350 I haven't got any error and you can see I have my my company and our baby. 02:37.390 --> 02:40.520 So this is our database basically and it contained nothing. 02:40.750 --> 02:47.030 But my main motive was to make you understand about this and if I open this file you would see nothing. 02:47.400 --> 02:54.690 And we cannot use this DB an item we have to use different software to actually view our database currently. 02:54.700 --> 03:00.880 This looks fine so I hope you understand about all the process on how we are going to execute and all 03:00.880 --> 03:03.390 the Kuwaitis all the statement would be present. 03:03.690 --> 03:06.620 So in the next lecture let us start creating tables. 03:06.640 --> 03:11.650 Let us start doing some query Well I hope this lecture was helpful to you in the next one.