info management prefinals

Query

A specific request for data manipulation issued by the end-user or the application to the DBMS

SQL

Structured Query Language; consists of commands to create structures, manipulate/administer data, and query information

CREATE DATABASE

Creates a new database

DROP DATABASE

Deletes an existing database

CREATE TABLE

Creates a new table in a database

DROP TABLE

Deletes an existing table in a database

TRUNCATE TABLE

Deletes only the table's data without removing the table structure

ALTER TABLE

Adds, deletes, or modifies columns in an existing table

NOT NULL

Ensures that a column cannot have a NULL value

UNIQUE

Ensures that all values in a column are different

PRIMARY KEY

Uniquely identifies each row in a table

FOREIGN KEY

Uniquely identifies a row in another table

CHECK

Ensures that all values in a column satisfy a specific condition

DEFAULT

Sets a default value for a column when no value is specified

INSERT INTO

Adds new rows or records to a table

SELECT

Retrieves values of all rows or a subset of rows in a table

DISTINCT

An operator used with SELECT to retrieve unique values from columns

WHERE

An option used with SELECT to filter rows based on provided criteria

IS NULL

An operator used with SELECT to determine whether a field is empty

LIKE

An operator used with WHERE to determine if a value matches a given string pattern

IN

An operator used with WHERE to check if a value matches any value within a given list

BETWEEN

An operator used with WHERE to check whether a value is within a range

ORDER BY

An option used with SELECT to sort retrieved values in ascending or descending order

UPDATE

Modifies existing records in a table

DELETE

Removes existing records in a table