Introduction to Structured Query Language - Database Processing: Fundamentals, Design, and Implementation - page 92

MIN
query by example (QBE)
schema
SQL AND operator
SQL AS keyword
SQL asterisk (*) wildcard character
SQL BETWEEN keyword
SQL built-in functions
SQL comment
SQL DESC keyword
SQL DISTINCT keyword
SQL expression
SQL FROM clause
SQL GROUP BY clause
SQL HAVING clause
SQL IN operator
SQL inner join
SQL INNER JOIN phrase
SQL JOIN keyword
SQL JOIN ON syntax
SQL join operator
SQL LEFT JOIN syntax
SQL left outer join
SQL LIKE keyword

SQL NOT IN operator
SQL ON keyword
SQL OR operator
SQL ORDER BY clause
SQL outer join
SQL percent sign (%) wildcard character
SQL query
SQL RIGHT JOIN syntax
SQL right outer join
SQL script file
SQL SELECT clause
SQL SELECT/FROM/WHERE
framework
SQL Server Compatible Syntax (ANSI 92)
SQL TOP {NumberOfRows} property
SQL underscore (_) wildcard character
SQL WHERE clause
SQL/Persistent stored modules (SQL/PSM)
stock-keeping unit (SKU)
Structured Query Language (SQL)
subquery
SUM
TableName.ColumnName syntax
Transaction control language (TCL)

Review Questions

2.1 What is a business intelligence (BI) system?

2.2 What is an ad-hoc query?

2.3 What does SQL stand for, and what is SQL?

2.4 What does SKU stand for? What is an SKU?

2.5 Summarize how data were altered and filtered in creating the Cape Codd data
extraction.

2.6 Explain, in general terms, the relationships among the RETAIL_ORDER, ORDER_
ITEM, and SKU_DATA tables.

2.7 Summarize the background of SQL.

2.8 What is SQL-92? How does it relate to the SQL statements in this chapter?

2.9 What features have been added to SQL in versions subsequent to the SQL-92?

2.10 Why is SQL described as a data sublanguage?

2.11 What does DML stand for? What are DML statements?

2.12 What does DDL stand for? What are DDL statements?

2.13 What is the SQL SELECT/FROM/WHERE framework?

2.14 Explain how Microsoft Access uses SQL.

2.15 Explain how enterprise-class DBMS products use SQL.