SQL Flashcards

1
Q

ORDER BY syntax

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

INSERT syntax

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

UPDATE syntax

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

DELETE syntax

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

TOP syntax

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

LIKE syntax

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

SQL wildcards

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

IN operator syntax

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

BETWEEN operator syntax

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

AS syntax on tables

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

AS syntax on columns

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

JOIN types

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

[INNER] JOIN syntax

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

LEFT JOIN syntax

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

RIGHT JOIN syntax

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

FULL JOIN syntax

A
17
Q

UNION syntax

A
18
Q

SELECT INTO syntax

A
19
Q

CREATE DATABASE syntax

A
20
Q

CREATE TABLE syntax

A
21
Q

CONSTRAINT types

A
22
Q

CREATE INDEX syntax

A
23
Q

DROP syntax

A
24
Q

TRUNCATE syntax

A
25
Q

ALTER TABLE syntax

A
26
Q

Autoincrementing a field in a table

A
27
Q

CREATE VIEW syntax

A
28
Q

GROUP BY syntax

A
29
Q

SQL aggregate functions

A
30
Q

SQL scalar functions

A
31
Q
A