Here are the few basic commands that one must be aware before even opening sql server.
SELECT : use to select data from a database
Syntax : SELECT Column_1,Column_2 FROM Table_1 OR SELECT * FROM TABLE_1
DISTINCT : Removes Duplicate Values
Syntax : SELECT DISTINCT FIRSTNAME FROM EMPLOYEE
WHERE : use to filter records.
Syntax : SELECT * FROM TABLE WHERE ID = 1
ORDER BY : to order the result by specific column or group of columns.
Syntax : SELECT
* FROM TABLE ORDER BY COLUMN1
INSERT : To insert records in the database.
Syntax : INSERT INTO table_name (column1, column2, column3,…)
VALUES (value1, value2, value3,…)
UPDATE : To update records in the database
Syntax : UPDATE table_name
SET column1=value, column2=value2,…
WHERE some_column=some_value
DELETE : To delete records from the database
Syntax : DELETE FROM table_name
WHERE some_column=some_value
