Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

SQL

memorize.ai (lvl 286)

Section 1

Preview this deck

INNER JOIN

Front

1 / 47

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

1 year ago

Date created

Mar 1, 2020

Cards (47)

Section 1

(47 cards)

INNER JOIN

Front

Combines rows from different tables if the join condition is true.

Back

INTEGER

Front

a data type that shows data in nominal numbers that can be negative or positive.

Back

VALUES

Front

a clause that indicates the data being inserted.

Back

Relational Database

Front

a database that organizes information into one or more tables.

Back

SELECT

Front

queries data from a table.

Back

DELETE FROM

Front

deletes rows from a table

Back

WHERE

Front

a clause that lets you select which rows you want to delete.

Back

Statement

Front

a string of characters that the database recognizes as a valid command.

Back

LIKE

Front

a useful operator when you want to compare similar values. Is used with WHERE.

Back

SQL

Front

a programming language designed to manipulate and manage data stored in relational databases.

Back

IS

Front

conditional command

Back

_

Front

wildcard character that can substitute any individual character without breaking the pattern.

Back

AND

Front

An operator that combines two conditions. Both conditions must be true for the row to be included in the result set.

Back

Table

Front

a collection of data organized into rows and columns.

Back

CREATE

Front

creates a new table.

Back

SET

Front

a clause that indicates the column to edit.

Back

ASC

Front

A keyword used with ORDER BY to sort the results in the ascending order.

Back

*

Front

wildcard symbol used to select all information.

Back

Foreign Key

Front

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

What are?: =, !=, >, <, >=, <=

Front

Operators than can be used to create a condition that can be evaluated as either true or false.

Back

ORDER BY

Front

A clause that indicates you want to sort the result set by a particular column either alphabetically or numerically.

Back

INSERT INTO

Front

adds a new row to a table.

Back

Parameter

Front

a list of columns, data types, or values that are passed to a clause as an argument.

Back

Primary Key

Front

a column that serves a unique identifier for row in the table. Values in this column must be unique and cannot be NULL.

Back

;

Front

always used to finish a statement.

Back

DESC

Front

A keyword used with ORDER BY to sort the results in the descending order.

Back

GROUP BY

Front

a clause used with aggregate functions to combine data from one or more columns.

Back

UPDATE

Front

edits a row in a table.

Back

BETWEEN

Front

An operator used to filter the result set within a certain range. The values can be numbers, text or dates.

Back

TEXT

Front

a data type that shows data in letters.

Back

%

Front

A wildcard character that matches zero or more missing letters in the pattern.

Back

LEFT OUTER JOIN

Front

Returns 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 side table.

Back

NULL

Front

A value that represents missing or unknown data.

Back

ROUND()

Front

takes two arguments, a column name and the number of decimal places to round the values in that column.

Back

OR

Front

An operator that filters the result set to only include rows where either condition is true.

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

Joins

Front

Used in SQL to combine data from multiple tables

Back

SELECT DISTINCT

Front

A clause used to return unique values in the result set. It filters out all duplicate values.

Back

Aggregate Functions

Front

combine multiple rows together to form a single value of more meaningful information.

Back

AS

Front

A keyword in SQL that allows you to rename a column or table in the result set using an alias.

Back

COUNT

Front

takes the name of a column(s) as an argument and counts the number of rows where the value(s) is not NULL.

Back

LIMIT

Front

A clause that lets you specify the maximum number of rows the result set will have.

Back

ADD COLUMN

Front

a clause that lets you add a new column to a table.

Back

MAX()

Front

takes the column name as an argument and returns the largest value.

Back

AVG()

Front

takes a column name as an argument and returns the average value for that column.

Back

ALTER TABLE

Front

changes an existing table.

Back