Applications Programmer

0.0(0)
Studied by 0 people
call kaiCall Kai
Locked
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/13

encourage image

There's no tags or description

Looks like no tags are added yet.

Last updated 7:07 AM on 8/29/26
Name
Mastery
Learn
Test
Matching
Spaced
Call with Kai
Chat

No analytics yet

Send a link to your students to track their progress

14 Terms

1
New cards

DISTINCT

REMOVES DUPLICATES

2
New cards

LIMIT

NUMBER OF ROWS

3
New cards

table.column

qualified column

4
New cards

WHERE

FILTER ROWS

5
New cards

LIKE

PATTERN MATCHING

6
New cards

ALIAS

TEMPORARY NAME

7
New cards

INNER JOIN

MATCHING RECORDS ONLY

8
New cards

LEFT OUTER JOIN

KEPP EVERYTHING ON LEFT

9
New cards

RIGHT OUTER JOIN

KEPP EVERYTHING ON RIGHT

10
New cards

SQL UNION

combine + remove duplicates

11
New cards

SQL UNION ALL

combine + keep duplicates

12
New cards

ALTER TABLE

CHANGE TABLE STRUCTURE

13
New cards

SQL DROP

remove an object

14
New cards

SQL VIEW

saved query / virtual table