Enhance Your Understanding with MySQL Programming Concept Cards for quick learning
An open-source relational database management system (RDBMS) that uses Structured Query Language (SQL) for managing and manipulating data.
A structured collection of data stored and organized in a way that allows efficient retrieval, modification, and deletion of data.
A collection of related data organized in rows and columns, representing a specific entity or concept in a database.
A SQL command used to retrieve data from one or more tables in a database.
A SQL command used to insert new rows of data into a table in a database.
A SQL command used to modify existing data in one or more rows of a table in a database.
A SQL command used to remove one or more rows of data from a table in a database.
A SQL command used to create a new database, table, or other database objects.
A SQL command used to modify the structure of a table or other database objects.
A SQL command used to delete a database, table, or other database objects.
A SQL operation used to combine rows from two or more tables based on a related column between them.
A column or a set of columns that uniquely identifies each row in a table.
A column or a set of columns in a table that refers to the primary key of another table, establishing a link between the two tables.
A database structure that improves the speed of data retrieval operations on a table by creating a copy of selected columns.
A set of SQL statements that are stored in the database and can be executed as a single unit.
A database object that accepts parameters, performs a specific task, and returns a value.
A sequence of SQL statements that are executed as a single unit, ensuring data consistency and integrity.
A SQL command used to permanently save the changes made in a transaction to the database.
A SQL command used to undo the changes made in a transaction and restore the database to its previous state.
A mechanism used to manage simultaneous access to a database by multiple users, ensuring data consistency and preventing conflicts.
The process of organizing data in a database to eliminate redundancy and improve data integrity.
The process of creating copies of data to protect against data loss and restoring data from backups in case of a failure.
Virtual tables that are based on the result of a SQL query, providing an alternative way to present data stored in tables.
Database objects that are automatically executed in response to specified events, such as insertions, updates, or deletions.
A query nested within another query, used to retrieve data based on the result of the outer query.
Functions in SQL that perform calculations on a set of values and return a single value, such as SUM, AVG, MIN, MAX, and COUNT.
Categories of data that determine the type of values that can be stored in a column, such as INTEGER, VARCHAR, DATE, and BOOLEAN.
Symbols or words used to perform operations on data, such as arithmetic operators (+, -, *, /), comparison operators (=, <>, >, <), and logical operators (AND, OR, NOT).
A special value in SQL that represents the absence of a value or an unknown value.
A SQL operator used to match a specified pattern in a column value, allowing wildcard characters such as % (matches any sequence of characters) and _ (matches any single character).
A SQL clause used to sort the result of a query in ascending or descending order based on one or more columns.
A SQL clause used to group rows based on one or more columns and perform aggregate calculations on each group.
A SQL clause used to filter the result of a query based on a condition applied to groups created by the GROUP BY clause.
A SQL clause used to limit the number of rows returned by a query, useful for pagination or retrieving a subset of data.
A SQL expression used to perform conditional logic and return different values based on specified conditions.
A SQL operator used to combine the result of two or more SELECT statements into a single result set, removing duplicate rows.
A SQL operator used to check the existence of rows returned by a subquery, returning true if the subquery returns any rows.
A SQL operator used to check if a value matches any value in a list or the result of a subquery.
A SQL command used to analyze the execution plan of a query, providing information about how the database will retrieve and process the data.