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 |
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 clause in SQL that limits the number of rows returned in a query result. |