Database Concepts

Front

Procedures

Back

A set of SQL statements that can be stored and executed as a single unit.

Front

Triggers

Back

A set of instructions that are automatically executed in response to certain events on a particular table or view.

Front

Functions

Back

A stored program that can be called to perform a specific task and return a value.

Front

Views

Back

A virtual table based on the result set of a SQL query.

Front

Relational Algebra

Back

A formal system for manipulating relations in a database.

Front

DML

Back

Data Manipulation Language, used for managing data within schema objects.

Front

DDL

Back

Data Definition Language, used for defining and managing all database objects.

Front

Normalization

Back

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

Front

Index

Back

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