SQL

01.SQL full form?
SQL-Structured Query Language(SQL)

1. What is SQL?
   SQL stands for Structured Query Language and is a standardised programming language used for storing, manipulating, and retrieving data in relational databases.

2. What is a database?
   Collection of data.

3. How many databases?
   -Relational database (Table format)
   -Hierarchical database.
   -NoSQL database. (Without table format)
   Below are the NoSQL Database types:
   Key value
   Document based
   column based
   Graph based

4. What is the DBMS?
   A database management system
   The DBMS is a software.
   Interface between the database and the end user.
   Software to store, retrieve, define and manage data in a database.
   Easy CRUD operations. (CRUD- Create, read, update, delete)
   Takes care of authentication, concurrency, logging, backup, optimisation, etc.

5. What is RDBMS? (Relational database management software)
   RDBMS is a software. Below are the RDBMS software
   -MySQL-Open source
   -SQL server-microsoft
   -Oracle -IBM
   -PostgreSQL-Open source.

07.