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;
24 Cards in this Set
- Front
- Back
SQL (abbrev) |
Structured query language |
|
SQL (Definition) |
Programming language designed to manage data stored in relational databases |
|
Relational Database |
Database that organizes information into one or more tables |
|
Date format |
YYYY-MM-DD |
|
Select * from |
Allows you to view information from a given table |
|
Statement |
A string of characters that the database recognizes as a valid command |
|
Create table |
Creates new table |
|
Insert into |
Adds new row to a table |
|
Select |
Queries data from a table |
|
Update |
Edits a row in a table |
|
Alter table |
Changes existing table |
|
Delete from |
Deletes row from a table |
|
Where |
Let's you filter results of query based on conditions you specify |
|
Like and between |
Special operators used with where to filter query on two or more conditions |
|
Order by |
Lets you sort the results of a query in ascending or descending order |
|
Limit |
Lets you specify the maximum number of rows that the query will return |
|
Count |
Takes name of column(s) as an argument and counts the number of rows where the value is not null |
|
Group by |
A clause used with aggregate functions to combine data from one or more columns |
|
Sum () |
Tales column as argument and returns the sum of all values in that column |
|
Max () |
Takes column as argument and returns max value in that column |
|
Avg () |
Takes a column as an argument and returns the average value for that column |
|
Round |
Takes two arguments, a column name and the number of decimal places to round the values in that column |
|
Primary key |
A unique identifier for each row or record in a given table (id) |
|
Foreign key |
A column that contains the primary key of another table in the database |