Structured Query Language

A language for making Relational Databases. It is CRUD supported Data is stored in tables

Concepts

• SQL Table

Query Types

SELECT Queries

SQL DB Relationships

• One-to-one
• One-to-many
• Many-to-many

SQL Operations

• SQL Insert
• SQL Update
• SQL Drop
• SQL Select
• SQL Join

SQL Constaints

SERIAL

Denotes unique integer numbers for IDs

PRIMARY

The column is the primary key

NOT NULL

Cannot accept a null value

Connecting

• psycopg2
• Django
• Flask
• SQLAlchemy