What Are Databases and Why Are They Important?

Ashutosh Pawar
A free video tutorial from Ashutosh Pawar
Entrepreneur, Python, Java & Android Geek
4.4 instructor rating • 11 courses • 329,098 students

Lecture description

In this lecture we will learn what are databases and why do we need databases and also what is SQL and why we need SQL while dealing with databases.

Learn more from the full course

SQL Course For Beginners: Learn SQL Using MySQL Database

Learn SQL From Scratch Using MySQL Databases, A Complete SQL Course For Beginners

04:42:51 of on-demand video • Updated April 2020

  • Understand what are database and why they are used.
  • How to write SQL queries to insert, update and delete data into database.
  • How to write SQL queries to manipulate data.
  • How to write complex SQL queries to obtain useful information from the database.
  • Learn how to create database tables using SQL commands.
  • Learn SQL operators to write complex SQL queries.
  • Learn how to perform different types of join operations.
  • Learn about different SQL functions and constrains.
English [Auto] Hello and welcome to this introduction lecture. And in this introduction lecture all of you are going to go over some basic concepts about what is a school and what are databases. So Escurial basically stands for structured query language and skewl is a language which allows us to communicate with their databases. Now the most important thing which we need to understand here is that why do we actually need databases and this lecture is exactly going to tell you the same. So let's first take a simple example. So when you are designing any software or any Web site for that matter you will have something which is called. The user interface and the user interface is nothing but it is like a window if your software and of your application or it is going to be the landing page of your website or anything like that. So what happens is that the data which is entered into the user interface actually gets captured and it actually gets stored into the database which is nothing but the back. So if we talk about any site or any application it consists of two parts the first part or the front turn to scorelines the user interface so a user interface is something with which the user interacts with the user is able to look at and the back. And we have the database which actually stores the data entered by the user. Now let's take a simple example. So let's say this is your Web site and this is the users so the user is obviously going to interact with the website and now they use that actually has data. So for example the user has his name which is John his age 25 and let's consider his agenda is meal and the location is United States and he is an engineer. So in case of your Web site what happens is that as you say it is going to store information to users. You actually need to have Ovi to store the data. So similar to John there are multiple other users and what you need to actually do is that you need to store data related to each and every user. For example this user right here is going to have a different set of data. This use that is going to have his own set of data. So on and so forth. So this is what the actual scenario looks like. So here we have our user. And here we have our interface so let's consider that this user interface is nothing but let's see a sign up form in which they use it actually fills in his information so essentially that user is passing on data to the user interface. So once the user does as they don't do the user interface that does nothing but the sign up form what happens in reality is that that data is transferred to the database and the data is actually stored in this database right here. So the data off load takes place and this we use that actually in those do don't do this form. This form captures the data and turns it on to their database. Now let's learn how the data is actually stored into the database. So and of starting that it randomly into the database what we do here is that we create something we just call that stable. And the data are related to Bozon is actually stored in the form of tables. So as we need to see the name age gender and location of a person what we do here is that in database redesign or table having the following columns which is name age gender and location and information for each and every person is inserted into their database and form or photo. So for example if you have to find the gender for Chris so you could find this here and you could find gender here and you could identify that Chris is a male. So this is how the data is actually stored in the database and are tabular format and we are going to go through this in a much more better way in the upcoming lectures. So here is the summary and some key points. So the first point is that databases are used to sort of the data related to any software website or application. So as we have discussed the purpose of databases is to store data when you are actually designing any software a new Web site or let's say any mobile application databases helps us to manage the data efficiently without any issue. So the tabular structured database actually allows us to store and retrieve data in a much more Berto the data in databases is stored in the form of a table. So basically instead of randomly saving data we make certain tables into the database and then in those tables we actually see the data on a single database can have multiple tables to store data from various categories. So in case of our database we could go ahead and create multiple tables to store data related to multiple categories. So for example as we wanted to store the data related to our website users we could create a separate table for that. And let's say you also want to list out products on your website which you want to sell. So for that purpose you could have a completely new table. Just call us products. So that's it for this lecture and I hope you guys understood why we actually need databases while creating any website software or application. So thank you very much for watching and I'll see you guys in the next lecture. Thank you.