Basic SQL
a standard language for storing, manipulating, and retrieving data in databases.
SQL (Structured Query Language)
What SQL stands for?
Structured Query Language
This statements are used to define the database structure or table.
DDL (Data Definition Language)
This statements are used for managing data within table object.
DML (Data Manipulation Language)
Create new database/table.
CREATE
Modifies the structure of database/table.
ALTER
Deletes a database/table.
DROP
Remove all table records including allocated table spaces.
TRUNCATE
Rename the database/table.
RENAME
Retrieve Data from table
SELECT
Insert data into a table.
INSERT
Updates existing data with new data within a table
UPDATE
Deletes the records rows from the table.
DELETE
It also called UPSERT statements to INSERT new records or UPDATE existing records depending on condition matches or not.
MERGE
lock one or more tables in a specified mode. Table access denied to a other users for the duration of your table operation.
LOCK TABLE
It's made up of a single constant, variable, scalar function, or column name and can also be
the pieces of a SQL query that compare values against other values or perform arithmetic calculations.
Expression