SQL

Question 1

What is SQL used for

Answer 1

declerative language to manipulate databases

Question 2

SELECT

Answer 2

collect fields from a given table

Question 3

FROM

Answer 3

specify which table the info comes from

Question 4

WHERE

Answer 4

specify the search criteria

Question 5

BETWEEN

Answer 5

between two values like BETWEEN 10 AND 20

Question 6

ORDER BY

Answer 6

Specifies if you want it ascending or descending.
ORDER BY DatePublished Desc

Question 7

JOIN

Answer 7

combines rows from multiple tables from a common field

Question 8

CREATE

Answer 8

Make new databases.
CREATE TABLE TableName
(
Attribute1 INTEGER NOT NULL, PRIMARY KEY,
Attribute2 VARCHAR(20) NOT NULL,
)

Question 9

ALTER

Answer 9

Used to add, delete or modify columns in a table.

delete: ALTER TABLE TableName
DROP COLUMN AttributeX

Question 10

INSERT INTO

Answer 10

INSERT INTO (column1, column2, …)
VALUES (value1, value2, …)

Question 11

UPDATE

Answer 11

update a record.
UPDATE TableName
SET column1 = value1
WHERE columnX = value