Table of Contents
What is SQL?
SQL is a standard language for storing, manipulating and retrieving data in databases.
SQL is used for?
SQL can be employed to insert records in the database through “update”, “delete”, and “insert” statements. SQL can be used to perform many other functions, such as maintaining and optimizing databases.
Let’s see some points:
- It assists users in accessing information in the RDBMS system.
- It aids in describing the information.
- It lets you specify the data stored in databases and modify the data.
- With the aid of SQL, it is possible to create and drag databases and tables.
- SQL allows you to utilize the functions in a database to create a view and store procedure.
- You can grant permissions to procedures, tables, as well as views.
Types of SQL Statements
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
- Data Control Language (DCL)
- Transaction Control Language (TCL)
- Data Query Language (DQL)
What is a database in SQL?
A database consists of a set of tables which store the most precise collection of structured data. A table is one which contains rows, also known as tuples or records as well as columns, also known as attributes.
Each column is created to store specific kinds of information such as names, dates, numbers, and ID etc.
- SELECT – Use to select data from table.
- UPDATE – Use to update/modify/change existing data.
- DELETE – Use to delete the whole data (table).
- INSERT – Use to insert or assign value to data (table).
- WHERE – Use to define the condition where action will be taken.
RDBMS is the abbreviation of Relational Database Management System.
RDBMS is the foundation for SQL and all modern databases including MS SQL Server, IBM DB2, Oracle, and MySQL along with Microsoft Access.
The information in RDBMS is stored inside database objects, also known as tables. The term table refers to a group of data entries related to each other and it is composed of rows and columns.
Also Read: Python MySQL
If you find anything incorrect in the above-discussed topic and have further questions, please comment below.