SQL terms

DCL REVOKE

Withdrawal of access privileges given with the GRANT command.

Field

A database storage most simplest unit.

DCL GRANT

Gives user's access privileges to DB.

Database, DB

Database, DB is a storage space for content / information data; It is an organized collection of data.

DDL TRUNCATE

Remove all records from a table.

Relational databases

A collective set of multiple data sets organized by tables, records and columns. It establishes a well-defined relationship between database tables.

FOREIGN KEY, FK

A column that is used to establish a relationship between tables. They are usually not unique (one-to many) and will always point to a primary key.

Table

A container for data elements and relations. It uses columns and rows.

Data Control Language DCL

A data control language is a syntax similar to a computer programming language used to control access to data stored in a DB.

Schema

A logical container for database objects that the user creates. (objects = tables, views, triggers)

Query

A request to a database to retrieve information.

Record

A row and it represents a single structured data set in table.

Data Definition Language, DDL

A syntax similar to a computer programming language for defining data structures, especially database schemas. create, alter, drop, truncate, comment, rename

PRIMARY KEY, PK

A unique identifier of every record in a table.

DDL COMMENT

Add comments to the data dictionary.

DDL ALTER

Alter the structure of the DB

SQL CREATE

Creates a table (index, view) in a database

DDL CREATE

Creates objects in the DB

Database Management System (DBMS)

DBMS, Database Management System, is a software that controls the organization, storage, retrieval, security and integrity of data in dB.

SQL DELETE

Deletes a record from a table. (all records)

SQL DROP

Deletes a table (index,view)

DML DELETE

Deletes all or specific records from a table.

SQL TRUNCATE

Deletes data in the table, but not table itself.

DDL DROP

Deletes objects from the DB

SQL INSERT

Inserts a record in a table (doesn't violate constraints)

DML INSERT

Inserts data into a table.

SQL UPDATE

Modifies a record into a table itself.

Popular Databases

ORACLE, Sybase, MySQL, DB2, etc

Structured Query Language SQL

SQL stands for Structured Query Language. It is a database computer language, designed to retrieve and manage data, create and modify dB schema, etc.

DDL Rename

Renames an object

DML SELECT

Retrieve data from the DB.

SQL SELECT

Retrieves data from one or more DB tables or views. Most often used statement.

Data Manipulation Language DML

Statements that manage data within a schema.

Normalization

The DB process of organizing the fields and tables of a relationship database to minimize redundancy and dependency. This divides large table into smaller tables and defining relationships between them .

Report

The returned information to the specified query.

DML UPDATE

Updates existing data within a table.

SQL ALTER

Used to add, delete, or modify columns in an existing table.