Introduction to SQL [Week 5]
What is SQL?
SQL (Structured Query Language) is a language used to interact with relational databases. It allows for querying, updating, inserting, and managing data.
SQL Data Types
- Numeric:
INT
,FLOAT
,DECIMAL
- String:
VARCHAR
,TEXT
,CHAR
- Date & Time:
DATE
,DATETIME
,TIMESTAMP
- Boolean:
BOOLEAN
SQL Operators
- Arithmetic Operators:
+
,-
,*
,/
- Comparison Operators:
=
,!=
,>
,<
- Logical Operators:
AND
,OR
,NOT