Sign in
Log inSign up

What is SQL, Basic SQL Commands

Rohit Wadhwani's photo
Rohit Wadhwani
·Jul 30, 2021·

2 min read

SQL (Structured Query Language) This RDBMS (Relational Database Management System) Language; Language is very helpful for storing data. Data is manipulated and retrieved in SQL. SQL is an open-source language. In SQL, some records are created by the user. These records are modified, updated, deleted using some clauses and expressions.

SQL (Structured Query Language) This RDBMS (Relational Database Management System) Language; Language is very helpful for storing data.If you are preparing for interviews, you can see tricky sql queries for interview .Data is manipulated and retrieved in SQL. SQL is an open-source language.

In SQL, some records are created by the user. These records are modified, updated, deleted using some clauses and expressions.

SQL stores this RDBMS data inside itself.

SQL queries are stored in any database like MySQL, SQL Server, PostGre SQL, MS Access, Oracle.

SQL Commands

These are some important SQL commands:

SELECT: It extracts data from a database.
UPDATE: It updates the data in the database.
DELETE: It deletes the data from the database.
CREATE TABLE: This creates a new table.
ALTER TABLE: It is used to modify the table.
DROP TABLE: It deletes a table.
CREATE DATABASE: This creates a new database.
ALTER DATABASE: It is used to modify a database.
INSERT INTO: It inserts new data into a database.
CREATE INDEX: It is used to create the index (search key).
DROP INDEX: It deletes an index.