| Aggregate |
A function in SQL that performs calculations on a set of values and returns a single value. |
| Conditional |
A statement in SQL that allows you to perform different actions based on a set of conditions. |
| Data Retrieval |
The process of fetching specific data from a database based on certain criteria or conditions. |
| Database |
A structured collection of data that is organized and accessible in various ways. |
| Database View Query |
A method used to retrieve specific information from a database by creating a virtual table that combines data from multiple tables. |
| Derived Field |
A field in a database or data table that is calculated or derived from other fields, rather than being directly inputted or stored. |
| Distinct |
A keyword in SQL used to return only unique rows in the result of a query. |
| Filter |
A clause in SQL that allows you to retrieve only rows from a table that meet specified criteria. |
| Group By |
A clause in SQL that is used to group rows based on one or more columns. |
| Having |
A clause in SQL that allows you to specify conditions on groups of rows created by the 'GROUP BY' clause. |
| Injection Attacks |
Security vulnerabilities that occur when user input is directly concatenated into SQL queries. |
| Join |
A SQL operation used to combine rows from two or more tables based on a related column between them. |
| Limit |
A clause in SQL that limits the number of rows returned in a query result. |
| Parameter Markers |
Symbols used to represent parameter placeholders in a SQL statement. |
| Parameterized Query |
A SQL statement that uses parameters to substitute variable values in the query. |
| Parameters |
Values that are substituted into the SQL parameter query at runtime. |
| Placeholder |
A placeholder is a character or sequence of characters used in a SQL statement as a substitute for a parameter value. |
| Query |
A request for data or information from a database, typically written in a specific query language such as SQL. |
| SQL Injection |
A code injection technique that attackers use to exploit vulnerabilities in a database's SQL statements. |
| Sort |
The process of arranging rows in a SQL table in a specific order based on one or more columns. |
| Subquery |
A nested query in SQL that is placed within another query and is used to retrieve data from multiple tables. |
| View |
A virtual table derived from the result of a database query, which can be treated like a regular table for data retrieval purposes. |
| Virtual Table |
A table that is not physically stored in the database but is created dynamically based on the result of a query. |
