Derived Field Parameters
Parameterized Query Injection Attacks
SQL Injection Parameter Markers
Placeholder Database View Query

 

Values that are substituted into the SQL parameter query at runtime. A field in a database or data table that is calculated or derived from other fields, rather than being directly inputted or stored.
Security vulnerabilities that occur when user input is directly concatenated into SQL queries. A SQL statement that uses parameters to substitute variable values in the query.
Symbols used to represent parameter placeholders in a SQL statement. A code injection technique that attackers use to exploit vulnerabilities in a database's SQL statements.
A method used to retrieve specific information from a database by creating a virtual table that combines data from multiple tables. A placeholder is a character or sequence of characters used in a SQL statement as a substitute for a parameter value.

 

Database View
Query Virtual Table
Data Retrieval Aggregate
Join Filter

 

A virtual table derived from the result of a database query, which can be treated like a regular table for data retrieval purposes. A structured collection of data that is organized and accessible in various ways.
A table that is not physically stored in the database but is created dynamically based on the result of a query. A request for data or information from a database, typically written in a specific query language such as SQL.
A function in SQL that performs calculations on a set of values and returns a single value. The process of fetching specific data from a database based on certain criteria or conditions.
A clause in SQL that allows you to retrieve only rows from a table that meet specified criteria. A SQL operation used to combine rows from two or more tables based on a related column between them.

 

Sort Conditional
Subquery Group By
Having Distinct
Limit Language

 

A statement in SQL that allows you to perform different actions based on a set of conditions. The process of arranging rows in a SQL table in a specific order based on one or more columns.
A clause in SQL that is used to group rows based on one or more columns. A nested query in SQL that is placed within another query and is used to retrieve data from multiple tables.
A keyword in SQL used to return only unique rows in the result of a query. A clause in SQL that allows you to specify conditions on groups of rows created by the 'GROUP BY' clause.
A set of rules and symbols used for communication and expression. A clause in SQL that limits the number of rows returned in a query result.

 

Database Definition Language Schema
Column Constraint
Primary Key Foreign Key
SQL DDL

 

A logical representation of the structure of a database. A language used to define and manipulate the structure and organization of a database.
A rule that restricts the values allowed in certain columns or tables. A vertical part of a table that holds a specific type of data.
A field in one table that refers to the primary key in another table. A unique identifier for each record in a table.
Data Definition Language, a subset of SQL used to define and modify the structure of database objects. Structured Query Language, a popular database language used to manipulate and retrieve data.

 

Data Manipulation Language CREATE TABLE
ALTER TABLE DROP TABLE
TRUNCATE TABLE ADD COLUMN
DROP COLUMN RENAME TABLE

 

A DDL query used to create a new table in a database. A subset of SQL that allows manipulation of data stored in a database, including inserting, updating, and deleting records.
A DDL query used to delete a table from a database. A DDL query used to modify the structure of an existing table.
A DDL query used to add a new column to an existing table. A DDL query used to remove all the data from a table while keeping its structure intact.
A DDL query used to change the name of an existing table. A DDL query used to remove a column from an existing table.