SQL Tutorials [Part 1]- What is Database?

What is Database?

Database is collection of data like Text, numbers, Images, Audio, Videos, etc in an organized way that it can be accessed easily.

What is Database Management System (DBMS)?

In order to manage Databases we are using the software called Database Management System which also known as DBMS

We are sending the instructions to DBMS for creating an object or manipulating the data and DBMS execute that instruction on the database and return the result to us.

DBMS is classified into 2 Categories

1. Relational Database OR SQL (Structured Query Language)
2. Non-Relational Database OR No SQL

Lets take some deeper knowledge in both categories

1. Relational Database

Now the question is what is Relational Database

• In Relational Database we are storing data in the table which are linked to each other via Primary Key and Foreign Key using relationships, and from this we are calling this database Relational database
• Each Table contains the information about the specific type of object such as Customer, Order, Product,etc..

• Structured Query Language (SQL) is a language we used to work with this relational database management systems For example

select * from products where category='food' order by price

What is RDMS?

RDMS stands for Relational Database Management System, a Software which helps us to manage Relational Database

The List of RDMS are as follows

1. Microsoft Sql Server
2. MySql
3. Oracle
4. Postgre SQL

and many more.., you can check out the List of RDMS by click here.

Each DBMS have variations of SQL, but all this implementations are similar and are based on Standard SQL specification. So most of the SQL Code you will learn in this tutorials will work with any DBMS. In this Tutorials we will Use MySql.

2. Non-Relational Database

• In non Relational databases we don’t have tables and relational ship, this database is completely different from relational databases
• Non Relational Database Management system don’t understand SQL, they have their own query language

Key Learnings

• What is Database?
• What is DBMS and its types?
• Categories of DBMS?
• What is RDMS?

Now if you feel comfortable with this basic concept of database, Proceed with

SQL Tutorials [Part 2]- Installing MySQL on Windows.

If you have any questions or have any doubt please ask in comment section or you can mail me @ [email protected]