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.