is a database that organizes information into one or more tables. Here the relational database contains one table.
Back
>=
Front
greater than or equal to
Back
GROUP BY
Front
is a clause used with aggregate functions to combine data from one or more columns.
Back
SELECT
Front
is the clause you use every time you want to query information from a database.
Back
AND and OR
Front
are special operators that you can use with WHERE to filter the query on two or more conditions.
Back
AS
Front
is a keyword in SQL that allows you to rename a column or table in the result set using an alias.
Back
UPDATE
Front
edits a row in a table.
Back
INNER JOIN
Front
will combine rows from different tables if the join condition is true.
Back
LEFT OUTER JOIN
Front
will return every row in the left table, and if the join condition is not met, NULL values are used to fill in the columns from the right table.
Back
Aggregate functions
Front
combine multiple rows together to form a single value of more meaningful information.
Back
ALTER TABLE
Front
changes an existing table.
Back
Primary Key
Front
is a column that serves a unique identifier for row in the table. Values in this column must be unique and cannot be NULL.
Back
CREATE TABLE
Front
creates a new table.
Back
MIN()
Front
takes the column name as an argument and returns the smallest value in that column.
Back
SUM()
Front
takes the column name as an argument and returns the sum of all the values in that column.
Back
WHERE
Front
is a popular command that lets you filter the results of the query based on conditions that you specify.
Back
ORDER BY
Front
lets you sort the results of the query in either ascending or descending order.
Back
INSERT INTO
Front
adds a new row to a table.
Back
Foreign Key
Front
is a column that contains the primary key to another table in the database. It is used to identify a particular row in the referenced table.
Back
ROUND()
Front
takes two arguments, a column name and the number of decimal places to round the values in that column.
Back
column
Front
is a set of data values of a particular type. Here id, name, and age are each columns.
Back
AVG()
Front
takes a column name as an argument and returns the average value for that column.
Back
<=
Front
less than or equal to
Back
Joins
Front
are used in SQL to combine data from multiple tables.
Back
Tables
Front
A _____ is a collection of data organized into rows and columns. _____ are sometimes referred to as relations. Here the _____ is celebs.
Back
!=
Front
not equals
Back
COUNT NULL.
Front
takes the name of a column(s) as an argument and counts the number of rows where the value(s) is not
Back
LIKE and BETWEEN
Front
are special operators that can be used in a WHERE clause
Back
DELETE FROM
Front
deletes rows from a table.
Back
SELECT
Front
queries data from a table.
Back
LIMIT
Front
lets you specify the maximum number of rows that the query will return. This is especially important in large tables that have thousands or even millions of rows.
Back
MAX()
Front
takes the column name as an argument and returns the largest value in that column.