Terminology

Different Query Language

• SQL (Structured Query Language)

  • Language: SQL, MySQL, PostgreSQL, SQLite

  • Database System: MariaDB, Oracle Database, Microsoft SQL Server

• PL/SQL (Procedural Language/SQL)

• NoSQL Query Languages

  • MongoDB, DynamoDB

• GraphQL

SQL (Structured Query Language) Sub-Language

• Data Definition Language (DDL)

  • Create, Drop, Alter, Truncate (Database Objects)

• Data Query Language (DQL)

  • Select (Row/Record/Tuple)

• Data Manipulation Language (DML)

  • Insert, Update, Delete

  • Call, Explain Call, Lock

• Data Control Language (DCL)

  • Grant, Revoke

• Transaction Control Language (TCL)

  • Commit, Savepoint, Rollback

  • Set Transaction, Set Constraint

Table Related Terms

General Terms	Database Terms	Relational Algebra Terms	Other
Database	Database / Schema
Table	Relation	Relation	Entity Set
Column	Field	Attribute
Row	Record	Tuple	Entity
Data Type	Domain	Domain
Keyword	Clause

Some Notes

• Use uppercase for SQL keywords

  • SQL is Case Insensitive (select or SELECT are the same)

• Backtik (``) is recommended to enclose table and attribute names

  • can be avoided as well

• Use a semicolon (;) at the end of each SQL statement

  • can be avoided for single-statement execution

• Must enclose string/date/datetime with double/single quote ("String" / 'String')