## Introduction to SQL
- SQL stands for Structure Query Language
- SQL is standard language for storing, Manipulating(updating), retrieving data from database.
- You can use SQL syntax in below list of database.
- MySQL
- SQL Server
- Oracle
- MS access
- PostGreySQL
- sybase etc..
## Introduction to DBMS
- DBMS stands for database management systems
- Database management system (DBMS) is a software that manage or organize the data in a database.
- Best Example of DBMS are - MYSQL, Oracle, PostGreySQL etc
Types of DBMS
There are two type of DBMS
- Non Relational
- Relational
1- Non-Relational Database Management System (Non-RDBMS)
- In Non-RDBMS, data is stored in key-value pairs.
- Commonly used Non-RDBMS: MongoDB, Amazon DynamoDB, Radis, etc.
2- Relational Database Management System (RDBMS)
- In RDBMS, data is stored in tabular format. For example,
- In RDBMS, two or more tables may be related to each other. Hence the term " Relational". For example, Order table and Customer table are relation with Customer_ID column.
## Difference between DBMS and SQL
Database management system (DBMS)
1. It is used to manage the database. For example:- MYSQL, oracle.
2. It provides security to the database.
3. It contains automatic backup and database recovery.
4. It can control data redundancy (i.e. it stores all the data in one single database file.)
5. It can reduce complex relationship between data.
Structured Query Language (SQL)
1. It is a query language not a database.
2. It is designed for managing data in RDMS (Relational database management system)
3. It allows the user to create a view stored procedure function in database.
4. It helps in creating, updating , deleting data from the database.
5. It consists of different types of SQL languages like DDL, DML, TCL.
