What is SQL, DBMS and RDBMS
Hello friends, in this article we going to discuss what is SQL ( Structured Query Language), DBMS (Database Management System), and RDBMS (Relational Database Management System), also understand what is the difference between DBMS and RDBMS.
What is SQL?
SQL (Structured Query Language) is used for Data Manipulation and Retrieval Language in RDBMS (Relational Database Management System). In simple language, we can say that with SQL you can CREATE a new table in the database, and you can INSERT, UPDATE, DELETE in the table and you can also create VIEWS, SEQUENCES, PROCEDURE, FUNCTION, and PACKAGES.
What is DBMS?
DBMS (Database Management System) is a Database software that is used to store the information and manage the Database. The DBMS software gives a technical way to store the information in the Database. With the help of DBMS software, we can INSERT, UPDATE, DELETE, MERGE records in Database and use it easily, Nowadays many DBMS software running in the market.
What is RDBMS?
Relational Database Management System (RDBMS) it’s developed by DR.E.F.codd in 1970. Actually, it’s an advanced part of DBMS (Database Management System).In the RDBMS we can store the Data in the collection of tables. which is make a relation with the same common field and RDBMS also provides the relational operators and joins so that with the help of join you can retrieve the data from one or more tables. For making a relation you use the primary key constraint and foreign key constraint, both keys make a child and parent relation in between two and more tables.
Read - Using SQL Select Statements