SQL(1.3.2 d)

Question 1

SQL

Answer 1

declarative query language
standardised way to add/remove/change/read data from a relational database
interacts with the abstract concept of tables

Question 2

DBMS stands for

Answer 2

DataBase Management System

Question 3

SQL select

Answer 3

simplest operation to find data from a single table
* = everything
SELECT * FROM Person
WHERE FirstName = “Douglas”;

Question 4

SQL boolean

Answer 4

combining conditions with boolean
behaves as you would expect (AND, OR)
SELECT Surname FROM Person
WHERE Surname = “Adams OR PersonID = “24601”

Question 5

SQL wildcards

Answer 5

using % as a wildcard
% means “any character(s)”
D% = D then any character(s)
SELECT Surname FROM Person
WHERE FirstName LIKE “%o”

Question 6

SQL inserting

Answer 6

specify the table (and fields)
provide the value to insert
INSERT INTO Person (PersonID, FirstName, Surname)
VALUES (18989,, “Techno”, “Tronics”);

Question 7

SQL deleting

Answer 7

specify the table
specify the conditions to find records to delete
DELETE FROM Person
WHERE FirstName = “Techno”;

Question 8

SQL update

Answer 8

specify the table
specify the field to change
identify the specific record(s) you want to change
UPDATE Person
SET FirstName = “Atari”
WHERE Surname = “Sinclair”;

Question 9

SQL drop

Answer 9

specify the table
gets banished to shadow realm
DROP TABLE Person;

Question 10

SQL joins

Answer 10

select each field you want (from either table)
join the two tables together with a common field (e.g primary and foreign key)
JOIN many also be called INNER JOIN
SELECT ProductID, ProductName.CategoryName
FROM Product
JOIN Category ON Product.CategoryID = Category.CategoryID;