Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

SQL

memorize.ai (lvl 286)

Section 1

Preview this deck

FULL (OUTER) JOIN

Front

1 / 14

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 (14)

Section 1

(14 cards)

FULL (OUTER) JOIN

Front

returns all records from both tables even if there are no matching rows

Back

What does it mean to have a "normalized" database?

Front

- A normalized database is a database that is organized into tables and columns. - The table should be about a specific topic and only the columns that support that topic are included - A normalized database minimizes duplicate data, avoids data modification issues and simplifies queries.

Back

What are the different types of JOINs?

Front

Inner Join Left Join Right Join Full Join

Back

What is a JOIN?

Front

- A JOIN is a means for combining fields from two tables by using values common to each

Back

Foreign Key

Front

a field in the table that is the primary key in another table

Back

How would you select all tables in a database?

Front

SELECT *

Back

RIGHT (OUTER) JOIN

Front

returns all records from the right table, and the matched records from the left table

Back

Primary Key

Front

uniquely identifies a record in a table

Back

WHERE

Front

used for filtering rows

Back

LEFT (OUTER) JOIN

Front

returns all records from the left table, and the matched records from the right table

Back

INNER JOIN

Front

returns records that have matching values in both tables

Back

HAVING

Front

used to filter groups

Back

Difference between UNION and UNION ALL

Front

UNION selects only distinct values UNION ALL allows for duplicate values

Back

How do you select all the data in one table?

Front

SELECT * FROM

Back