Section 1

Preview this deck

relational database

Front

Star 0%
Star 0%
Star 0%
Star 0%
Star 0%

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Active users

0

All-time users

0

Favorites

0

Last updated

2 years ago

Date created

Mar 14, 2020

Cards (32)

Section 1

(32 cards)

relational database

Front

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.

Back