SQL

Question 1

CREATE Table and INSERT Data

Answer 1

Create Table
CREATE TABLE  ( , … PRIMARY KEY ());
Data Types
INT, String, Money, char, … 
Insert Data
INSERT INTO  VALUES (value1, value2, value3, ...);

Question 2

READ, SELECT, and WHERE

Answer 2

Selecting specific columns
SELECT FROM ;
Selecting specific rows
SELECT FROM WHERE ;

Question 3

Updating Single Values and Adding Columns in SQL

Answer 3

UPDATE SET = WHERE = ;
Adding a new column
ALTER TABLE (Add, Delete, or Modify Columns in a Table)
ALTER TABLE ADD ;

Question 4

DELETE

Answer 4

DELETE FROM WHERE ;

Question 5

Relationships, Foreign Keys, and Inner Joins

Answer 5

Foreign Key
Links between table
Inner Join