Basic SQL

Flashcards covering the key concepts, definitions, and terminology related to Basic SQL.

SQL (Structured Query Language)

A programming language used for managing and manipulating relational databases.

DDL (Data Definition Language)

SQL commands used to define and manage all constructs in a database.

DML (Data Manipulation Language)

SQL commands used for managing data within schema objects.

VIEW

A virtual table in SQL created using the CREATE VIEW statement that provides a way to present data.

PRIMARY KEY

A constraint that uniquely identifies each record in a table.

FOREIGN KEY

A field (or collection of fields) in one table that uniquely identifies a row of another table.

VARCHAR

A variable-length string data type used in SQL to store text.

CHAR

A fixed-length string data type used in SQL.

DEFAULT Clause

Specifies a default value for the attribute if no value is specified during record insertion.

CHECK Constraint

A rule that specifies the conditions under which a database can accept data values.

JOIN Condition

A condition that combines rows from two or more tables based on related columns.

UNIQUE Constraint

A constraint that ensures all values in a column are different from one another.

DISTINCT Keyword

A keyword used in SQL queries to return unique values in the result set.

ORDER BY Clause

A clause used in SQL to specify the order of the result set.

INSERT Command

An SQL command used to add new records (tuples) to a table.

DELETE Command

An SQL command used to remove records from a table.

UPDATE Command

An SQL command used to modify existing records in a table.

TUPLE

A single row of data in a table, which contains data for each column.