Learn SQL

(SQL) The _______ *operator* is used to *filter the result set within a certain range*. The values can be numbers, text or dates.

BETWEEN

(SQL)_____() is a *function* that takes the *name of a column as an argument* and counts the number of rows where the column is not NULL.

COUNT()

______ _____ is a *clause* that tells SQL you want to *create a new table*.

CREATE TABLE

(SQL) ______ ____ is a *clause* that lets you *delete rows from a table*.

DELETE FROM

(SQL) ____ _____ ____ 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*.

LEFT OUTER JOIN

(SQL) ____ can be a useful *operator* when you want to *compare similar values*.

LIKE

(SQL) ______ is a *clause* that lets you specify the *maximum number of rows the result set* will have.

LIMIT

(SQL Aggregate functions) ___() takes the *column name* as an *argument* and *returns the largest value* in that *column*.

MAX()

(SQL Aggregate functions) ___() takes the *column name* as an *argument* and *returns the smallest value* in that *column*.

MIN()

___ is a *keyword* in SQL that is used with *ORDER BY* to sort the results in *ascending order*.

ASC

(SQL Aggregate functions) ___() takes the *column name* as an *argument* and *returns the average* value in that *column*.

AVG()

(SQL) _________ functions compute a single result from a set of input values.

Aggregate

(SQL) _ is a *wildcard character* that *matches zero* or more *missing letters* in the *pattern*.

%

(SQL) What special *wildcard* character allows you to *select every column in a table* without having to name each one individually.

*

(SQL) _______ perform specific tasks in SQL. By convention, _______ are written in capital letters. _______ can also be referred to as commands.

*Clause*

(SQL) You would use _______ and _______ ___ to connect rows in two different tables.

*foreign keys* & *primary keys*

(SQL) Some common *data-types* stored in a *relational database* are

1. *Interger* (a positive or negative whole number) 2. *Text*, a text string 3. *Date* (YYYY-MM--DD) 4. *Real*, a decimal value

(SQL) By specifying that the id column is the PRIMARY KEY, SQL makes sure that:

1. None of the values in this column are NULL. 2. Each value in this column is unique

(SQL) _____ _____ changes an existing table.

ALTER TABLE

__ is a *keyword* in SQL that allows you to *rename* a *column* or *table* using an *alias*.

AS

____ is a *keyword* in SQL that is used with *ORDER BY* to *sort the results* in *descending order*

DESC

(SQL) _____ __ is a clause in SQL that is *only used* with *aggregate functions*. It is used in collaboration with the SELECT statement to *arrange identical data into groups*.

GROUP BY

(SQL) _____ ____ will combine rows from different tables if the join condition is true.

INNER JOIN

(SQL) ______ ____ is a *clause* that adds the *specified row* or *rows*

INSERT INTO

(SQL) _____ __ is a *clause* that indicates you want to *sort the result set* by a *particular column* either alphabetically or numerically.

ORDER BY

(SQL Aggregate functions) _____() takes *two arguments*, a *column name* and the number of *decimal places to round* the values in that *column*.

ROUND()

(SQL) ______ is a *clause* that indicates that the *statement is a query*. You will use ______ every time you query data from a database.

SELECT

(SQL) ______ ________ is used to return unique values in the result set. It filters out all duplicate values.

SELECT DISTINCT

(SQL) ___ is a *clause* that indicates the *column to edit*.

SET

What does *RDBMS* stand for?

SQLite Relational Database Management System.

(SQL Aggregate functions) ___() takes the *column name* as an *argument* and *returns the sum* of all the *values in that column*.

SUM()

What does *SQL* stand for?

Structured Query Language

(SQL) ______ is a *clause* that *edits a row* in the *table*.

UPDATE

(SQL) ______ is a *clause* that indicates the *data being inserted*.

VALUES

(SQL) _____ is a *clause* that indicates *which row(s) to update* with the *new column value*.

WHERE

(SQL) A ______ is a set of data values of a particular type.

column

(SQL) One way to *query multiple tables* is to write a *SELECT statement* with *multiple* table names *separated by a comma*. This is also known as a _____ ____.

cross join

(SQL) Unlike primary keys, *foreign keys* __ ___ ____ to be unique and *can be NULL*.

do not need

(SQL) _______ ___ 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*.

foreign key

(SQL) A _________ is a *list of columns, data types, or values* that are *passed* to a *clause* as an *argument*.

parameter

(SQL) _______ ___ is a column that serves a *unique identifier* for a *row in the table*. Values in this column *must be unique* and *cannot be* NULL.

primary key

(SQL) A __________ ________ is a database that organizes information into one or more tables.

relational database

(SQL) A ___ is a single record in a table.

row

(SQL) A _____ is a collection of data organized into rows and columns. Tables are sometimes referred to as *relations*.

table