Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

SQL + Postgres

memorize.ai (lvl 286)

(0)

12 cards

()

Section 1

Preview this deck

foreign key

Front

1 / 12

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (12)

Section 1

(12 cards)

foreign key

Front

Allow us to associate a row in one table to a row in another table.

Back

surrogate key

Front

A value that is created solely for the purpose of identifying a row of data in a database table.

Back

RIGHT OUTER JOIN

Front

A join that includes all of the rows from the right (second) table in the query and only those records from the first table that match the join field in the second table.

Back

natural key

Front

An existing value in a dataset that can be used to uniquely identify each row of data in that dataset.

Back

modality

Front

Indicates if a relationship is required or not.

Back

DCL (Data Control Language)

Front

Used to determine what various users are allowed to do when interacting with a database.

Back

INNER JOIN

Front

A join that returns the intersection where the tables match on the joined condition.

Back

DDL (Data Definition Language)

Front

Used to define the structure of a database and the tables and columns within it.

Back

LEFT OUTER JOIN

Front

A join that includes all of the rows from the left (first) table in the query and only those records from the second table that match the join field in the first table.

Back

primary key

Front

A unique identifier for a row of data.

Back

cardinality

Front

The number of objects on each side of a relationship.

Back

DML (Data Manipulation Language)

Front

Used to retrieve or modify data stored in a database. SELECT queries are part of this.

Back