Discover published sets by community

Structured Query Language, a standardized programming language used for managing and manipulating relational databases.

Term in relational databases that refers to a single row in a table, which represents a single record.

A process of organizing data in a database to reduce redundancy and improve data integrity.

A special type of stored procedure that automatically executes in response to certain events on a particular table or view.

A database concept that ensures relationships between tables remain consistent and that foreign keys match primary keys after operations such as insert, update, or delete.

A conceptual blueprint of a relational database that defines the structure and relationships between data.

A SQL operation used to combine rows from two or more tables based on a related column between them.

A mathematical term for a table in a relational database; consists of tuples and attributes.

Subset of SQL commands used to define or modify the structure of a database schema, including creating, altering, and dropping tables and indexes.

In the context of databases, it refers to the uniqueness of data values contained in a particular column (attribute) of a database table.

The structure of a database system, described in a formal language supported by the database management system (DBMS).

A database management activity to ensure multiple transactions are executed in a manner that ensures the consistency of a database, minimizing conflicts and ensuring ACID properties.

A database optimization structure that improves the speed of data retrieval operations on a database table.

The process of adding redundant data to a database to improve read performance, often at the expense of write performance and data integrity.

A unique identifier for each record in a relational database table, which ensures that no two rows can have the same value in this column.

Subset of SQL commands used to add, update, or delete data within a database. This includes INSERT, UPDATE, and DELETE commands.

A field (or collection of fields) in one table that uniquely identifies a row of another table, creating a relationship between the two tables.

A virtual table based on the result-set of a SQL statement. It contains rows and columns, just like a real table.

A key composed of two or more columns in a table that can be used to uniquely identify a row in a table when the individual columns do not provide uniqueness.

A column in a relational database table that describes a property of the entity represented by the table.

A unit of work performed within a database management system which is treated in a coherent and reliable way independent of other transactions.

An abstract model that organizes data elements and standardizes how they relate to one another and to the properties of real-world entities.

Set of properties of database transactions intended to guarantee validity even in the event of errors, power failures, etc. These are Atomicity, Consistency, Isolation, Durability.

A set of SQL statements that can be stored in the database and executed repeatedly whenever required.