Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
26 Cards in this Set
- Front
- Back
|
Relational Database |
A database that organizes information into one or more tables |
|
|
Table (aka Relations) |
A collection of data organized into rows and columns. |
|
|
Column |
Set of data values of a particular type. |
|
|
Row |
A single record in a table. |
|
|
CREATE TABLE |
Clause that creates a brand new table. |
|
|
table_name |
The name of the table that the command (clause) is applied to. |
|
|
Parameter |
A list of columns, data types, or values that are passed to a clause as an argument. |
|
|
INSERT INTO |
Clause that adds the specified rows or rows. |
|
|
VALUES |
Clause that indicates the data being inserted. |
|
|
SELECT |
Clause that indicates that the statement is a query. Will be used every time you query data from a database. |
|
|
* |
A special wildcard character that allows you to select every column in a table without having to name each one individually. |
|
|
UPDATE |
Clause that edits a row in the table. |
|
|
SET |
Clause that indicates the column to edit |
|
|
WHERE |
Clause that indicates which rows to update/delete with the new column value. |
|
|
ALTER TABLE |
Clause that lets you make the specified changes to a table. |
|
|
ADD COLUMN |
Clause that lets you add a new column to a table. |
|
|
TEXT |
String data type |
|
|
NULL |
Special value in SQL that represents missing or unknown data. |
|
|
DELETE FROM |
Clause that lets you delete rows from a table. |
|
|
IS NULL |
Condition in SQL that returns true when the value is NULL. |
|
|
SQL (Structured Query Language) |
Programming language designed to manipulate and manage data stored in relational databases. |
|
|
SELECT DISTINCT |
Causes the SELECT statement to query the table and return unique values in the specified columns. (No repeated values) |
|
|
LIKE |
Special operator used with WHERE. Used to search for a specific pattern/similar values in a column. |
|
|
_ |
Wildcard character that allows you to substitute any individual character in a string without breaking the pattern. |
|
|
% |
Wildcard that matches zero or more missing letters in a pattern. |
|
|
BETWEEN |
Filters the result set within a certain range. |
