SQL

SQL

Structured Query Language: A programming language designed to manage data stored in a relational database. It operates through simple declarative statements. Keeps data accurate and secure, and helps maintain the integrity of databases, regardless of size.

Relational Database

Store of data organized in tables made of columns and rows, and the relationships between those tables.

RDBMS

Relational Database Management System:

Table

A collection of data organized into rows and columns. Tables are sometimes referred to as relations.

Column

A set of data values of a particular type.

Row

A single record in a table.

Clauses

Perform specific tasks in SQL. By convention, clauses are written in capital letters. Can also be referred to as commands.

Trigger

Procedural code that is automatically executed in response to certain events on a particular table or view in a database. The trigger is mostly used for maintaining the integrity of the information on the database.