MGSC 394 Quiz 4
Expression SQL term
Combination of identifiers, operators, constants and functions that evaluates to a single value
Rules of SQL syntax
Every statement ends with a semi-colon (;) Has clauses Each clause performs a function
Operator SQL term
Keyword that represents an action or modifies an action
Select SQL clause
List the fields that contain data or interest Required in each SQL
From SQL clause
Lists the tables that contain the fields listed in the select clause Required in each SQL
Identifiers with spaces
Must be enclosed in square brackets
Constant SQL term
Value that does not change, such as a number or NULL
SQL syntax
A set of rules that define how elements of a language are correctly combined
What does a wildcard do (*)
Allows you to include all fields from a data source
Identifier SQL term
Name used to identify a database object Name of a field or table
Multiple identifiers in a clause
Need a comma between them
Is SQL case sensitive?
No, but can be used to improve readability
What is Structured Query Language?
Programming language designed specifically for managing data held in relational database management systems
Group By SQL clause
SQL statement that lists fields that are not summarized in the select clause
Having SQL clause
Specifies conditions that must by fields that are summarized in the select statement
Where SQL clause
Specifies field criteria that must be met by each record to be included
Order by SQL clause
Specifies how to sort the results
Inner Join On SQL Clause
Specifies the of join and the linking fields
What does SQL stand for?
Structured Query Language
Why should you learn SQL?
Understanding it can help you create better queries and fix a query that is not returning desired results
Does access ignore line breaks?
Yes, and line breaks should be used to improve readability
Can you use SQL in programs outside of access?
Yes, is an international standard that can be used in other programs
