CMU-Database-Notes

Introduction to SQL

Relational Languages

The language is comprised of different classes of commands:

  1. Data Manipulation Language (DML): SELECT, INSERT, UPDATE, and DELETE statements.
  2. Data Definition Language (DDL): Schema definitions for tables, indexes, views, and other objects.
  3. Data Control Language (DCL): Security, access controls.
  4. It also includes view definition, integrity and referential constraints, and transactions.

AGGREGATES

Window Functions

Nested Queries

Lateral Joins