SQL: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Tag: Reverted
Tags: Manual revert Reverted
Line 47: Line 47:
=Indexes=
=Indexes=
=Constraints=
=Constraints=
=Set Operations=

Revision as of 20:54, 22 May 2024

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. Subqueries.

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