Nexusly the SQL glossary

The SQL glossary

The complete A–Z index of 29 SQL and database terms covered by Nexusly.

A

  1. Aggregate FunctionsQuerying

C

  1. CHECK ConstraintsSchema & Design
  2. Common Table ExpressionsQuerying
  3. CREATE TABLE and ALTER TABLESchema & Design

D

  1. Database IndexesSchema & Design
  2. Database NormalizationSchema & Design
  3. The DELETE StatementModification
  4. DISTINCT and DuplicatesQuerying

F

  1. FOREIGN KEY ConstraintsSchema & Design

G

  1. GROUP BY and GroupingQuerying

H

  1. The HAVING ClauseQuerying

I

  1. The INSERT StatementModification

L

  1. LIMIT and OFFSETQuerying

N

  1. NULL and Missing ValuesQuerying

O

  1. ORDER BY and SortingQuerying

P

  1. PRIMARY KEY ConstraintsSchema & Design

S

  1. The SELECT StatementQuerying
  2. SQL Data TypesSchema & Design
  3. SQL JoinsQuerying
  4. Stored ProceduresTransactions & Programmability
  5. SubqueriesQuerying

T

  1. Transactions and ACIDTransactions & Programmability
  2. TriggersTransactions & Programmability

U

  1. UNION and Set OperationsQuerying
  2. UNIQUE ConstraintsSchema & Design
  3. The UPDATE StatementModification

V

  1. ViewsTransactions & Programmability

W

  1. The WHERE ClauseQuerying
  2. Window FunctionsQuerying