SQL [Week 5-10]

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