SQL Keywords and Operators

What are SQL keywords?
Keywords are used in SQL statements to specify actions or tasks to be performed in a database.
SQL keywords are not case sensitive.
These are reserved words that are used to define and to perform various operations on data.

What are SQL operators?
Operators are essential to the Sequel language as they allow us to perform mathematical and logical functions on data stored in the database.
SQL operators are grouped in the following categories;
1. Arithmetic Operators

+ Add
- Subtract
* Multiply
/ Divide
% Modulo


2. Comparison Operators

= Equal to
> Greater than
< Less than >= Greater than or Equal to
<= Less than or Equal to <> Not equal to


3. Bitwise Operators

& AND
| OR
^ exclusive OR


4. Compound Operators

+= Add equals
-= Subtract equals
*= Multiply equals
/= Divide equals
%= Modulo equals
&= AND equals
^-= exclusive equals
|*= OR equals


5. Logical Operators

ALL
AND
ANY
BETWEEN
EXISTS
IN
LIKE
NOT
OR
SOME