SQL Syntax

SQL Syntax

SQL follows a unique set of rules and guidelines called syntax. Here, we are providing all the basic SQL syntax.

– SQL is not case-sensitive. Generally, SQL keywords are written in uppercase.
– SQL statements are dependent on text lines. We can place a single SQL statement on one or multiple text lines.
– You can perform most of the action in a database with SQL statements.
– SQL depends on relational algebra and tuple relational calculus.

SQL statement

SQL statements are started with any of the SQL commands/keywords like SELECT, INSERT, UPDATE, DELETE, ALTER, DROP, etc. and the statement ends with a semicolon (;).

Example of SQL statement:

SELECT “column_name” FROM “table_name”;

These are important SQL commands:

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

Course Video