The content in my own approach in the best manner to learn MySQL like easy things in the best way to go. Not required any prior previous basic technical knowledge. You will learn only the MySQL database in a very fast, easy, and fun fashion way. Everything we will learn from scratch. Lucent explained to the point with the best examples. Let us Start!
Direct Switch to Contents:
What do you mean by data?
Before, we go to discuss what is the MySQL database? Let us get to the basic first and understand What does data mean after that we will go deep.
Data is collected information that will be stored somewhere and reuse it later. In simple words, It’s actually a piece of meaning-full information based on observations by which later we can perform various operations.
Let us take the examples of Data: Anything we write on paper, or in Microsoft-excel sheet or in any text file, they all are the data.
Let us take another example of data i.e., In our daily life, we create an abundant amount of data whether taking phone calls, clicking photos, getting like on it, sending emails, saving contacts on the phone, etc. Any action that is performed will be taken as data.
So these data increases day by day rapidly. There are so many types of Data. Broadly the types are based on Numerical, Categorical, Qualitative, Quantitative, etc.
What is Database & Why do we need it?
Nowadays we have an abundant amount of data. To store and manage this abundant amount of data well we need a lot of memory called Databases.
Now, Database is a place where we store organized data, or can that store a systematic collection of data.
In other words, Well-versed managed data collection is Database. We use databases to Store, Access, Manipulate, Analyse the data.
Every company whether its private body or Government Bodies, everyone using Databases. Like Banks, Electricity Companies, Hospitals, etc., Uses Databases to store the information of their customer and also their employee.
Why do we need Databases to Store data while we have Note-Book (Registers) or Excel Sheet in Computer?
If the data is in an abundant amount then it is not possible to write it on papers or in an excel sheet. If in any case suppose we have written data on papers or excel sheets then to access it or any change to data like manipulation is not quite possible.
So we need a database where these data easily get stored and any manipulation gets easy.
Security also plays an important role in the database. An MS-excel sheet in a computer or a notebook (register) gets easily accessible by anyone and It can be stolen too. So Data is not safe there. Databases are more secure then to the conventional method to store data.
In other words, Databases are the electronic system which is composed of a huge amount of Storage & MEMORY, and some unit like CPU, and software to handle the DATA in an organized form.
With the help of software, DATA is well organized into the storage and while retrieving the DATA these Memory will be used. To perform these operations so quickly on DATA we need processors (CPU Unit).
Now, How can we Store>Access>Manipulate>Retrieve the DATA from the Database?
What is concept of DBMS?
To do so we need a system (or can say that software) to manage the database that is called Database Management System (DBMS-Abbreviation of Database Management System).
DBMS is a collection of the program which enables to access database, manipulate the data, and retrieve data to the users.
Types of DBMS:-
There are so many approaches or methods(Structures) to store data into the Databases, access the data from Databases, Manipulate the data from Databases, and Retrieve the data from Databases.
Generally, there are four types of DBMS-
- Navigational DBMS(also called Hierarchical DBMS)
- Network DBMS
- Relational DBMS
- Object-Relational DBMS
*Do not go deep in each type of DBMS. Just have the basic knowledge. DBMS itself an Engineering Subject. We will only talk About only four as mentioned above.
It is a type of DBMS in which parent-child relationships uses to store data in Databases. It stores the data like a tree with nodes and branches fashion. Currently very few uses of this DBMS.
IBM has developed this type of Database structure in the 1960s. The best two examples of these databases are the Windows XP registry and IBM-Information Management System (Called IMs).
Let’s understand this with a basic figure that shows a parent-child relationship.
Here each node record storing information that’s related to each other and follows a parent-child relationship fashion. Learn More…
It simply means relation like many to many relations. Raima Database Manager (RDM) server is the best example of this DBMS. It creates a complex structure of the database if the database is quite big. So it is not frequently useful anymore DBMS.
Not similar to Hierarchical Database, In-Network Database a child can have multiple parents and vice-versa. Learn More…
Here the data store in databases in the form of a table (Table is an insertion of rows and column). Nowadays, It is the best and most widely used DBMS.
Examples are Oracle, Microsoft SQL Server, MySQL, MS Access, SQLite etc. Learn More..
Here we can create our own new datatype to store the data in the database. The data will be stored in the form of an object.
Those who are familiar with Oops can get it easy. Example PostgreSQL. Learn More…
*Some of the more types of Databases are Graph Databases, ER Databases, Document Databases. Here we will only discuss more the Relational Databases.
What is SQL?
So far we have studied data, database, and DBMS. Now we have to understand one more thing that is Structure Query Language (SQL-Abbreviation of Structure Query Language).
SQL is a standard computer language that is used to operate data of DATABASES in Relational DMBS. In other words, It is just a standard language use to operate databases includes DATA Manipulations, Data Storing, Retrieving Data.
SQL is an ANSI that is the American National Standards Institute, standard language to operate data of only relational databases. It pronounced as seek-well or as just split each letter of the SQL as S-Q-L. IBM has designed language was SQL in the 1970s.
SQL itself a broad subject to study. But we will cover only important topics when we will be implementing queries in MySQL.
Here SQL is the base of RDBMS. It is just a medium to commune with the databases while RDBMS is a system by which we perform SQL queries.
As we discussed briefly above all, RDBMS, it deals data with Tables.
Let us take a figure for a better understanding as below:
Let’s take a flow what we have learned and to be more clear about these terminologies, A well manage organized Data is called Database, and to manage this Database we need a management system called DATABASE MANAGEMENT SYSTEM(DBMS).
As we know different types of DBMS, RDBMS is one type that uses Table to Store data in rows and column fashion.
SQL is standard language lets take a brief about this language. What is queries DDL DML Commands, Syntex?
I hope you figured out each basic concept.
Here we tried to learn about some basics of MySQL database in the best approach,
MySQL database is an open-source relational DBMS.
Here, we need data(collected information) to be used in a systematic way known as the database. We can’t store abundant information in huge piles of paper.
Therefore, that application is used for a wide range of purposes, including data warehousing, e-commerce, and logging application.
Any meaning-full information that can be stored somewhere is Data whereas Database is place or storage where data are stored in well-organized fashion and DBMS is a Collection of Program or system (Tool) by which we can store Data into Databases, managed it by Accessing databases, Manipulating the data from databases, and Retrieving the data from Database.
For any organization whether its small or big, to manage the data and have the operation on it, so we need a database. To store and manage this large chunks abundant amount of data well we need Databases. It is also the most secure and also provides security.
It provides high security and eliminates redundancy data. And also sharing of data is possible in real-time by multiuser. Multi-user means different users can access and manipulate data in parallel.