1/32
Vocabulary flashcards covering core MySQL database management concepts, SQL commands, data types, constraints, joins, transactions, views, indexes, subqueries, stored procedures, and triggers.
MySQL Workbench
A visual tool used for database development and administration that provides a graphical interface to design databases, write SQL queries, manage servers, create backups, and monitor performance.
Database Management System (DBMS)
Software that allows users to create, store, organize, retrieve, and manage data efficiently, acting as a bridge between users and databases.
Database
A container that stores related data in an organized way, holding one or more tables in MySQL.
INT Data Type
An integer data type in MySQL used for storing whole numbers.
VARCHAR(100) Data Type
A variable-length string data type that stores text up to 100 characters in length.
ENUM Data Type
A string object data type with a value chosen from a predefined list of permitted values.
DECIMAL(10, 2)
An exact numeric data type used for financial data where 10 represents the total number of digits and 2 represents the number of digits after the decimal point.
PRIMARY KEY Constraint
A constraint that uniquely identifies each row in a table, requiring values to be unique and non-NULL, with only one allowed per table.
UNIQUE Constraint
A constraint that ensures all values in a column are different from one another, while permitting one or more NULL values.
AUTO_INCREMENT Attribute
An attribute used with a primary key to automatically generate a unique sequential number for each new row inserted.
CHECK Constraint
A constraint that ensures all values stored in a column satisfy a specific defined condition.
DEFAULT Constraint
A constraint that sets a default value for a column if no value is explicitly provided during row insertion.
ALTER TABLE Statement
An SQL command used to modify the structure of an existing table, such as adding, dropping, modifying, or renaming columns.
AutoCommit Mode
A default setting in MySQL where every SQL statement is treated as an individual transaction and committed automatically.
COMMIT Command
An SQL command used to permanently save all database changes made during the current transaction.
ROLLBACK Command
An SQL command used to undo and revert all changes made since the last COMMIT or ROLLBACK.
Foreign Key
A column or field in one table that links to and references the primary key in another table to maintain data integrity between related tables.
ON DELETE CASCADE
A foreign key action that automatically deletes related child table rows when the referenced parent table row is deleted.
INNER JOIN
A join type that returns only matching rows from both tables based on the specified join condition.
LEFT JOIN
A join type that returns all rows from the left table and matching rows from the right table, returning NULLs when no match exists.
RIGHT JOIN
A join type that returns all rows from the right table and matching rows from the left table, returning NULLs when no match exists.
UNION Operator
An SQL operator used to combine the result sets of two or more SELECT queries into a single result set, automatically removing duplicate rows.
UNION ALL Operator
An SQL operator that combines the result sets of multiple SELECT queries while retaining all duplicate rows.
Self JOIN
A regular join operation in which a table is joined with itself using table aliases to evaluate relationships among rows within the same table.
MySQL View
A virtual table based on the result of a SELECT query that does not store data itself but dynamically reflects live data from base tables.
MySQL Index
A database structure used to speed up data retrieval and row lookup performance on table columns.
Subquery
A query nested inside another SQL statement (such as within SELECT, WHERE, or FROM clauses) used for dynamic filtering or calculations.
HAVING Clause
A clause used to filter grouped data after an aggregation operation has been performed with GROUP BY.
WITH ROLLUP Modifier
A modifier used with GROUP BY to generate summary rows representing subtotals and grand totals.
Stored Procedure
A saved block of SQL code with optional parameters stored in the database for reusable execution.
MySQL Trigger
A stored database program automatically executed in response to specific events (INSERT, UPDATE, or DELETE) on a table.
TRUNCATE TABLE Statement
A fast command that removes all rows from a table while retaining its structure, which cannot be rolled back in most cases.
DISTINCT Keyword
A keyword used in SELECT queries to eliminate duplicate records and return only unique values.