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

Result Set

SQL Schema Statements (DDL)

CREATE

CREATE TABLE

ALTER TABLE

SQL Data Statements (DML)

INSERT

UPDATE

UPDATE WHERE

DELETE

DELETE WHERE

SELECT

Query execution. SQL optimizer.

SQL Transaction Statements

Transactions.

Data Types

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

.