SQL

SQL

1. SELECT - get data from a database table

2. The code usually used in databases

3. UPDATE - change data in a database table

4. DELETE - remove data from a database table

5. INSERT INTO - insert new data in a database table

6. ORDER BY - order column name in either ascending (ASC) or descending (DESC) order

7. AND/OR - can join two or more conditions in a WHERE clause

8. GROUP BY - aggregate functions can return a result grouped by column values