Section 1
Preview this deck
data type
Front
| 5 | 0 | ||
| 4 | 0 | ||
| 3 | 0 | ||
| 2 | 0 | ||
| 1 | 0 |
Active users
0
All-time users
0
Favorites
0
Last updated
6 years ago
Date created
Mar 1, 2020
Cards (81)
Section 1
(50 cards)
data type
Type of data that a column can contain as well as the maximum number of characters or digits that the column can store Character • CHAR(n): Fixed-length character data • VARCHAR(n): Variable-length character data Number • DECIMAL(p,q): used to represent decimal numbers • INT: used to represent integer values Date • DATE
IS NULL
special operator that specifies null values for a column in a query
key
the column on which data is to be sorted when the ORDER BY clause is used
INSERT
The SQL command used to add rows to a table
null
A data value used to represent situations in which an actual value is unknown, unavailable or not applicable
null data value
A data value used to represent situations in which an actual value is unknown, unavailable or not applicable
DESC
operator included in an ORDER BY clause when results are to be sorted in descending order
NOT NULL
The clause in a CREATE TABLE command used to indicate which columns cannot contain null values
Open source software
Software for which the source code is freely and publicly available
Reserved words
SQL command words
database management system (DBMS):
A software program that lets you create a database and then use it to add, change, delete, sort, and view the data in a database
grouping
Creates groups of tows that share some common characteristic
IS NOT NULL
special operator used to specify no null values for a column in a query
USE
The SQL command to change the default database
UPDATE
The SQL command used to change a value in a table
VALUES
The SQL command used to insert values in a table
CREATED DATABASE
The SQL command to create a database
IN clause
The clause that consists of the IN operator, the operator which finds a value in a group of values specified in the condition
MySQL
An open source, full-featured database management system
MIN
function that calculates the minimum value in a numeric range
compound condition
A condition formed by connecting two or more simple conditions
HAVING clause
The clause that limits a condition to the groups that are included
major sort key
The more important column when data on two columns needs to be sorted
MySQL
An open source database management system that supports the SQL language
AND
logical operator that connects simple conditions and requires all conditions to be true for the compound condition to be true
default database
Database to which all subsequent commands pertain
SHOW COLUMNS
The SQL command used to list all the columns in a table
DDL
data definition language
DESCRIBE
The SQL command used to list all the columns in a table and their corresponding data types
Structured Query Language
A language used for retrieving and manipulating database data
FROM clause
The clause that indicates the table from which to retrieve the specified columns
Database schema
logical container for the database objects
statement history
A special area in which the most recently entered command is stored
MAX
function that calculates the maximum value in a numeric range
AVG
function that calculates the average value in a numeric range
SQL
Structured Query Language
BETWEEN
special operator that specifies a range of values in a condition
minor sort key
The less important column when data on two columns needs to be sorted
DELETE
The SQL command used to delete a row in a table
SELECT
The SQL command used to view data in a table
GROUP BY clause
The clause that groups rows based on the specified column
COUNT
function that counts the number of rows in a table
DROP TABLE
The SQL command used to drop an entire table
aggregate function
Special SQL functions that apply to groups of rows and used to calculate sums, averages, counts, maximum values, and minimum values
DISTINCT
operator that eliminates duplicate values in the results of a query
database
A structure that contains different categories of information and the relationships between these categories
computed column
A column that does not exist in the database but can be computed using data in existing columns
IN
special operator which finds a value in a group of values specified in the condition
DML
data manipulation language
LIKE
special operator that uses one or more wildcard characters to test for a pattern match
Section 2
(31 cards)