WEBVTT 00:00.560 --> 00:01.060 Hey guys. 00:01.060 --> 00:01.700 Welcome back. 00:01.850 --> 00:08.210 Now in this letter let us talk about databases so we'll be talking about my school as well as a school 00:08.210 --> 00:08.630 light. 00:08.990 --> 00:11.650 I hope you might have heard about databases. 00:11.780 --> 00:16.240 So if you are into a new development field databases are really important. 00:16.280 --> 00:19.240 You know how important is data nowadays. 00:19.250 --> 00:24.620 We have to store data into certain rules and column and that's where database coming to better. 00:25.070 --> 00:26.770 So we have to talk about two things. 00:26.780 --> 00:30.660 The first one is about my school database and escalate. 00:30.730 --> 00:37.490 And the second one is why we're using a squall light or some sheet or why we are not storing data into 00:37.530 --> 00:40.400 Excel or maybe list maybe dictionaries. 00:40.400 --> 00:43.840 So why we're using databases so to talk about first point. 00:43.840 --> 00:46.160 That is my school and a school life. 00:46.400 --> 00:52.730 So my school is actually a full database which required to install it identifies certain of us all were 00:52.760 --> 00:57.470 created some rude user set up a password and there are a lot more things than one. 00:57.740 --> 01:01.320 So this is something like a proper relational database. 01:01.490 --> 01:07.220 Whereas if I talk about a school light you can see that the word light it's a minimum version database 01:07.490 --> 01:14.120 which can be used properly like my screen but it don't require to set up a server and it don't require 01:14.150 --> 01:18.330 a user name and password like a minus equal database does. 01:18.380 --> 01:23.000 So it's a light version of my sequel which do exactly what we want. 01:23.000 --> 01:30.230 The second thing is why we use our database why we use a screen database or a school like database why 01:30.230 --> 01:36.500 we're not storing data in the form of list dictionaries or maybe in the form of Excel sheet or 60. 01:36.530 --> 01:39.880 The main reason is that databases have data points. 01:39.920 --> 01:44.570 We can create different tables like we can create different sheet an Excel point. 01:44.570 --> 01:49.520 And also we can store everything in row and column format permanently. 01:49.550 --> 01:55.010 So if you run a program for some time you store some data you might start working on that program maybe 01:55.010 --> 01:59.380 after 13 days that data would be stored in that particular database. 01:59.390 --> 02:04.500 So if I talk about Facebook as an application it's stored everything inside their database. 02:04.520 --> 02:10.250 You create a user name you keep your I.D. you keep your password you create your first name last name 02:10.550 --> 02:17.170 everything is stored in the form of table rows and column so they can store your information. 02:17.170 --> 02:23.000 And whenever you are going to visit Facebook you can just extract that data with the help of certain 02:23.000 --> 02:25.720 variables on also certain fields. 02:25.730 --> 02:27.800 If I want to sum up what this database. 02:27.870 --> 02:33.130 So database is something it's a collection of data which you keep in an organized manner. 02:33.390 --> 02:39.680 So you divide all the data in the form of tables and empty words you divide them into rows and column. 02:39.680 --> 02:42.280 If I take an example maybe of a company. 02:42.320 --> 02:48.830 So companies usually use databases maybe for their employer for the projects for their future projects 02:49.130 --> 02:50.930 and for their past history. 02:50.930 --> 02:54.260 So for that employer projects all these are tables. 02:54.260 --> 02:56.600 And if I talk about rows and columns. 02:56.660 --> 03:00.740 So for employees they might be Name First Name Last Name. 03:00.740 --> 03:04.030 So all these would be rows and columns of Employee table. 03:04.040 --> 03:06.200 The second can be the projects. 03:06.350 --> 03:11.690 So they might have different type of projects that would be stored in Project table in the form of rules 03:11.690 --> 03:12.500 and column. 03:12.740 --> 03:16.290 Third might be some attendance system and there can be a lot more things. 03:16.460 --> 03:20.840 So that's how a database tables and rows and columns are divided. 03:20.930 --> 03:24.920 If I talk about in general perspective what we are going to perform the database. 03:25.310 --> 03:28.640 So the first thing is to insert data in our database. 03:28.640 --> 03:33.800 Second thing is to fetch the data elsewhere we have in so doing so then amount of data we should know 03:33.800 --> 03:37.430 how to get that data back to display to our user. 03:37.430 --> 03:43.160 Toby will be how to update that data if we have stored a name and some salary. 03:43.160 --> 03:46.410 So we should know how to update that particular data. 03:46.490 --> 03:48.720 And the fourth one is how to delete data. 03:49.040 --> 03:54.020 So these are the four important commands that we should know and we should be familiar to work with 03:54.080 --> 03:55.500 any database. 03:55.520 --> 03:57.110 I hope this letter was helpful. 03:57.110 --> 04:01.880 This is a brief stopping or a school light database in the next letter. 04:01.880 --> 04:04.440 Let us start working on our database. 04:04.490 --> 04:05.870 How do we import our data. 04:05.870 --> 04:09.910 How to create connection how to create database and all other stuff. 04:10.490 --> 04:12.860 So see you in the next one hand let's get started.