Structured Query Language

WHICH QUERY?

defines the list of fields to be displayed

• SELECT

• FROM

• WHERE

• ORDER BY

WHICH QUERY?

defines the list of tables the data will come from

• SELECT

• FROM

• WHERE

• ORDER BY

WHICH QUERY?

defines the list of search criteria

• SELECT

• FROM

• WHERE

• ORDER BY

WHICH QUERY?

defines the way in which the data will appear

e.g. ______ age DESC

• SELECT

• FROM

• WHERE

• ORDER BY

Which symbol can be used as a 'wild card' in sql?

Which query can be used to search for a pattern in the WHERE clause?

e.g. WHERE word _____ '%ing' to search for words ending in 'ing'

What are the two ways in which you can specify links between tables?

• WHERE tblCustomer.custID = tblSubscription.custID

• WHERE custID.tblSubscription = custID.tblCustomer

• JOIN tblPlayer, tblTeam

  ON teamID

• JOIN tblPlayer

  ON tblPlayer.teamID = tblTeam.teamID

What is the query you would use to make a brand new table?

Select all the possible data types in an sql database

• CHAR(n)

• INTEGER

• INT

• STR

Select all the possible data types in an sql database

• VARCHAR(n)

• BOOLEAN

• VARCHAR

• FLOAT