Understanding the SQL syntax written language SQL programming language

SQL define unique set of guidelines and rules it called syntax..
Let’s see one of the examples with basic information

SQL keywords are written in uppercase.
SQL is not case sensitive.
SQL can perform the database actions using different syntax
SQL depends on the relational algebra and tuple calculus

SQL Syntax Statement

SQL statements are started out with keywords like select, insert, update, alter drop, and more.
SQL syntax closed with semicolon(;)

Example

SELECT "column_name" FROM "table_name";


Understand the syntax keywords

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