1 00:00:05,930 --> 00:00:12,410 Here everyone in the studio I will tell you that what actually database is so the database is very simple 2 00:00:12,410 --> 00:00:13,220 concept. 3 00:00:13,250 --> 00:00:15,200 Once you get it you will never forget about it. 4 00:00:16,130 --> 00:00:20,030 And it's very easy to use install and you can get it everywhere. 5 00:00:20,960 --> 00:00:23,540 So first of all let me begin with the computer. 6 00:00:24,260 --> 00:00:26,400 This is the main P.C. here. 7 00:00:26,840 --> 00:00:33,200 But this screen is something that doesn't store the data whenever you are doing something writing something 8 00:00:33,200 --> 00:00:36,940 or during any music file video and anything else. 9 00:00:37,250 --> 00:00:43,010 Like when we have downloaded the data then the data is not stored on the screen or these on these icons 10 00:00:43,580 --> 00:00:46,930 that it is actually storing the hard drive. 11 00:00:46,960 --> 00:00:50,590 So basically the harddrive acts as a database for this computer. 12 00:00:51,430 --> 00:00:57,790 Now after that when just suppose I'm playing some music on a speaker and I am using a memory chip or 13 00:00:57,790 --> 00:01:04,810 any say band right then I'm inserting that particular pendulum that my music system and that music system 14 00:01:04,810 --> 00:01:08,670 is taking songs from that one and making us to listen them. 15 00:01:09,070 --> 00:01:15,700 So there at that point the band I will say memory card is acting the database. 16 00:01:15,700 --> 00:01:22,390 So in simple words the database is just that player because a source or space where our data is stored 17 00:01:23,080 --> 00:01:27,620 or the point from where the computer takes the data and interacts with us. 18 00:01:27,820 --> 00:01:32,260 So that in there in very short is actually database. 19 00:01:32,260 --> 00:01:38,080 The most common use for that one is the Internet like well whenever you are browsing something on the 20 00:01:38,080 --> 00:01:47,160 internet you are getting data and that data is most of you not most of everyone you would get angry 21 00:01:47,170 --> 00:01:49,540 with that when that data is not in a computer. 22 00:01:49,600 --> 00:01:51,710 We are getting that from internet. 23 00:01:51,730 --> 00:01:55,390 Now the question is what actual internet is from where you are getting that. 24 00:01:56,560 --> 00:02:04,840 So actually that data is that we are getting on a browser whatever we are using is coming through some 25 00:02:04,840 --> 00:02:11,880 databases and their databases manage a database company where any source say Oracle which is the biggest 26 00:02:11,880 --> 00:02:13,300 part of his company. 27 00:02:13,510 --> 00:02:19,250 And there you can store your data from which every user can access data. 28 00:02:19,660 --> 00:02:26,900 You can take any example of any websites even Google who will have their own database entries also destroyed 29 00:02:26,950 --> 00:02:30,160 their data on that one and you have a year. 30 00:02:30,180 --> 00:02:35,200 The concept of hosting hosting is something from their big databases databases. 31 00:02:35,210 --> 00:02:41,150 The centers are very big same number of buildings a larger number of hard drives are stored alternate 32 00:02:41,150 --> 00:02:41,810 to each other. 33 00:02:42,470 --> 00:02:44,090 So they what they do. 34 00:02:44,090 --> 00:02:50,060 This has some space all that particular data to the users who are using internet or those who have websites 35 00:02:50,450 --> 00:02:57,530 say any music company assists Simpson Apple or any company whatever you will look for on the Internet. 36 00:02:57,830 --> 00:03:04,100 They have buy some space on the database and they're storing their data files there so that other users 37 00:03:04,100 --> 00:03:11,210 can access statement also here if you notice on this deck stop this desktop interface but it actually 38 00:03:11,210 --> 00:03:16,330 consists of code and that code is stored in my computer so that I can access this one. 39 00:03:16,460 --> 00:03:21,010 Similarly websites are made from coding that is known as Web development. 40 00:03:21,350 --> 00:03:24,650 So they also include that file. 41 00:03:24,660 --> 00:03:30,870 Now the Web sites files are also stored in the databases so someone can access that websites. 42 00:03:30,890 --> 00:03:38,000 Now if we talk about the computer that is about the Internet then most of you are thinking that when 43 00:03:38,000 --> 00:03:43,550 we are actually storing the data on your computer then by we need to install the databases like when 44 00:03:43,550 --> 00:03:49,430 you have booked on the programs you have used when he was at that point your data is stored in variables 45 00:03:49,520 --> 00:03:54,350 and the variables are actually storing the data in the hard drive one meeting when you press controls 46 00:03:54,350 --> 00:03:58,610 that you will get you mean code return whatever you have deleted. 47 00:03:58,740 --> 00:04:03,690 The reason for that one is also the code is consequently stored in the hard drives from where you can 48 00:04:03,750 --> 00:04:05,760 access that the. 49 00:04:05,880 --> 00:04:10,680 Now when we talk about why we need the databases on the computer then again the same reason instead 50 00:04:10,680 --> 00:04:17,030 of searching the complete Internet domain or computer whatever we are looking one will direct us to 51 00:04:17,030 --> 00:04:19,190 that particular database on the Internet. 52 00:04:19,250 --> 00:04:22,890 From there we will test the data of that particular Web site and work with that one. 53 00:04:23,630 --> 00:04:28,850 Similarly instead of searching complete hard right we will make a separate point on that particular 54 00:04:28,850 --> 00:04:32,920 hard drive where we just set salable data off of a program. 55 00:04:33,830 --> 00:04:39,860 So you have made a simple application in which the only entry and a button at whenever you enter something 56 00:04:39,920 --> 00:04:42,270 Sandy name it will get added to your database. 57 00:04:43,220 --> 00:04:48,610 So if you will not use any data the data will be entered randomly in your computer. 58 00:04:48,970 --> 00:04:53,140 But if you have a database then that particular data is entered at particular space. 59 00:04:53,200 --> 00:04:55,870 That is actually your database with which you then [REMOVED]. 60 00:04:56,890 --> 00:05:00,970 So this is the concept of database. 61 00:05:00,970 --> 00:05:03,440 Now we will come to how to use these. 62 00:05:03,700 --> 00:05:06,550 So we cannot just directly make our database here. 63 00:05:07,720 --> 00:05:13,780 However the Python programming and other parameters also provide us the by default creating databases. 64 00:05:13,780 --> 00:05:16,150 That is with the Esko like reliability. 65 00:05:16,300 --> 00:05:19,960 So we have a library by which we can create the databases. 66 00:05:19,960 --> 00:05:22,350 But it's a little hard to interact with that one. 67 00:05:23,500 --> 00:05:29,260 So we have different databases software with which we can create databases access that one at easily 68 00:05:29,260 --> 00:05:30,970 use these. 69 00:05:31,030 --> 00:05:34,880 They include a number of softwares but before them. 70 00:05:35,060 --> 00:05:36,490 This is how actually they look like. 71 00:05:36,500 --> 00:05:38,630 Let me show you the list. 72 00:05:38,630 --> 00:05:44,290 So you have a large number of list of databases so these are actually software that will create our 73 00:05:44,290 --> 00:05:47,260 database and they will interact with Declan. 74 00:05:48,160 --> 00:05:54,070 So here we have my sequel Oracle post jihadi rescue plan no offline. 75 00:05:54,070 --> 00:06:00,370 First I want to make you learn about my sequel because this one is the most popular one and open source 76 00:06:01,030 --> 00:06:06,480 but installing this one is a little harder and making it one ready again and again. 77 00:06:06,520 --> 00:06:07,830 So what we are going to learn here. 78 00:06:07,840 --> 00:06:14,590 We are going to learn this one poses serious good because this one is very easy to install restive working 79 00:06:14,590 --> 00:06:16,420 of every database is same. 80 00:06:16,540 --> 00:06:23,740 Just like if you use Python programming any editor the programming remains in just interfaces difference. 81 00:06:24,010 --> 00:06:27,910 So similarly we have all the databases with the same commands. 82 00:06:27,910 --> 00:06:31,210 This is the interface or installing process it is a little different. 83 00:06:31,840 --> 00:06:38,930 So I am using the one which is easy to install so that you will not get any difficulty in that one after 84 00:06:38,930 --> 00:06:39,870 that one. 85 00:06:39,980 --> 00:06:43,020 These are actually what our database looked like. 86 00:06:43,040 --> 00:06:49,740 Simple example this one they use to retain form of tables like this so you create tables like this. 87 00:06:49,770 --> 00:06:53,010 We have names there we have the continent. 88 00:06:53,090 --> 00:06:58,790 Capital and these rules can be added by programming or by your program. 89 00:06:58,790 --> 00:07:05,360 Like if I have a program here my entry whenever I add something that will be added to database or this 90 00:07:05,360 --> 00:07:08,300 table and that is stored safely at that particular point. 91 00:07:08,720 --> 00:07:13,920 Now whenever I need that data my program will just go to that position and get me that data. 92 00:07:15,200 --> 00:07:16,980 So this one makes things very easy. 93 00:07:17,030 --> 00:07:23,060 Instead of making some complex in the situation like store everything at different position and then 94 00:07:23,060 --> 00:07:31,080 it's very hard to access them after that one as I have told you we have local databases also. 95 00:07:31,100 --> 00:07:36,980 That is a skill like reliability with this one we can create a local database and we will learn about 96 00:07:36,980 --> 00:07:40,640 these that how we can create them and use them in the next video. 97 00:07:41,120 --> 00:07:43,570 Then the concept will be more clear to you. 98 00:07:43,610 --> 00:07:44,830 So thanks for watching. 99 00:07:44,840 --> 00:07:45,770 See in the next video.