SQL

Question 1

How to create table

Answer 1

CREATE TABLE tablename(
              MemberId CHAR(6),
              FirstName VARCHAR(30),
              InstructorID INT,
              PRIMARY KEY (MemberID)
              FOREIGN KEY (...) REFERENCES othertable(...));

Question 2

Define SQL Data Types

Answer 2

VARCHAR (n)
CHAR (n)
DATE
INT
BOOLEAN
DECIMAL (n,n)

NOT NULL - cannot be empty

Question 3

Define SQL

Answer 3

Structured Query Language

Question 4

SQL Syntax

Answer 4

SELECT … , … FROM Table

WHERE name = ‘John’;

Question 5

SQL Order

Answer 5

ORDER BY …;
Auto Ascending
ORDER BY … DESC;

Question 6

SQL Operators

Answer 6

= Equal to

<> Not Equal to

Question 7

SQL KeyWords

Answer 7

WHERE ... IN ' ' 
WHERE ... NOT IN ' '
WHERE ... BETWEEN ... AND ...
WHERE ... IS NULL
WHERE ... LIKE ...%

% - zero, one, multiple characters
_ - single character

Question 8

SQL Join Tables

Answer 8

SELECT Member.__, Job.___ FROM Member, Job

WHERE Member…. = Job….

Question 9

SQL Insert Into

Answer 9

INSERT INTO table(…, …)
VALUES(…, …)

IV

Question 10

SQL Update

Answer 10

UPDATE table
SET Fee = 25
WHERE … = ‘ ‘;

USW

Question 11

SQL Delete

Answer 11

DELETE FROM table

WHERE …;