To filter rows based on a condition
To perform conditional logic within a query
To create a new table
To join tables based on a condition
LIKE
MATCH
CONTAINS
COMPARE
AND
OR
NOT
XOR
To retrieve all rows from both tables, even if there is no match
To retrieve only the common rows between two tables based on a related column
To retrieve rows from the first table and matching rows from the second table
To retrieve rows from the second table and matching rows from the first table
Reducing the redundancy and dependency of data in a database
Adding redundancy to improve data integrity
Increasing the dependency of data between tables
Modifying the structure of a table
GRANT ALL PRIVILEGES
GRANT SELECT
GRANT PERMISSION
GRANT ROLE
To concatenate two or more strings
To count the number of characters in a string
To find the position of a substring in a string
To convert a string to uppercase
Atomicity, Consistency, Isolation, Durability
Aggregate, Consistency, Isolation, Durability
Atomic, Consistent, Isolated, Durable
Association, Consistency, Isolation, Durability
DROP FOREIGN KEY
REMOVE FOREIGN KEY
ALTER TABLE
DELETE FOREIGN KEY
To round a numeric value to the nearest integer
To generate a random number
To retrieve a random record from a table
To rank rows based on a specified column
To lock a table for read access only
To lock a table for write access only
To lock one or more tables for specific operations
To unlock all tables in the database
To find the maximum value among a set of values
To find the minimum value among a set of values
To concatenate strings
To calculate the average value of a set of values
REVOKE
DENY
REMOVE PRIVILEGES
DELETE PRIVILEGES
To find the modulus of two numbers
To perform modulo arithmetic
To round a numeric value
CHANGE COLUMN
ALTER COLUMN TYPE
MODIFY COLUMN
UPDATE COLUMN TYPE
To count the total number of rows in a result set
To assign a unique number to each row within a partition of a result set
To retrieve the row with the maximum value in a column
To calculate the average value of a column
Combines the result sets of two or more SELECT statements and includes duplicate rows
Concatenates strings from multiple columns
Groups the result set based on a specific column
Performs a mathematical union operation on numeric values
LENGTH()
CHAR_LENGTH()
STRLEN()
LEN()
Converts a value to lowercase
Returns the first non-null expression among its arguments
Concatenates two or more strings
Performs arithmetic operations on numeric values
IN
BETWEEN
IS NULL
