What is DBMS?

DBMS stands for Database Management System(DBMS), it is like a file manager that manages data in a database rather than saving it in a files system. DBMS is a program that controls the creation, maintenance, and use of a database.

What is RDBMS?

RDBMS stands for Relational Database management System which stores the data in the collection of tables.

What is SQL?

SQL stands for Structured Query Language, it is a database that is used to create and access databases to support software applications like MySQL. This database language is primarily designed for maintaining data in relational database management systems. It is a special tool used by data scientists to process structured data (data stored in tabular form). It is also designed to process streams in RDSMS. You can easily create and edit databases, access and modify table rows and columns, etc. This query language became an ANSI standard in 1986 and an ISO standard in 1987.

SQL for Data Science or Data Analytics:

SQL is an important part of Data Science or Data Analytics, if you want to become a data science then you must know SQL with advanced concepts. Currently, I am working as Data Analytics and we use SQL every time. So SQL is important for ML or Data scientists.

Types of SQL Statements:

1. DDL(Data Definition Language)

CREATE Statement

ALTER Statement

DROP Statement

TRUNCATE Statement

RENAME Statement

2. DML(Data Manipulation Language)

SELECT Statement

INSERT Statement

UPDATE Statement