SQL

From NovaOrdis Knowledge Base
Jump to navigation Jump to search

External

Internal

Overview

This article documents standard SQL. For database-specific extensions, we'll link to the databases-specific DML operations page.

SQL is a non-procedural language TODO: this

Terms

Table

In a relational model, data is stored in a set of tables, also known as relations. Within a relation, data is organized in rows (records) and columns.

Also see:

Relational Databases

Primary Key

Relational Databases | Primary Keys

Entity

Result Set

View

SQL Schema Statements (DDL)

CREATE

CREATE TABLE

ALTER TABLE

SQL Data Statements (DML)

Refactor PostgreSQL DML Operations and surface in "Standard SQL" everything that can be handled with standard SQL.

INSERT

UPDATE

UPDATE WHERE

DELETE

DELETE WHERE

Queries with SELECT

Queries with SELECT

SQL Transaction Statements

Transactions.

Data Types

  • SQL data types
  • Database-specific data types
  • Working with different data types
  • Conversion functions

SQL NULL

NULL in conditions.

Indexes

Constraints

Set Operations

SQL Conditional Logic