Databases Reference
In-Depth Information
DATA ACCESS AND
MANIPULATION
Starting Point
Go to
www.wiley.com/college/gillenson
to assess your knowledge of SQL
language use.
Determine where you need to concentrate your effort.
What You'll Learn in This Chapter
▲
SELECT statement keywords and clauses
The use of joins and subqueries
▲
The fundamentals of writing batches and scripts
▲
After Studying This Chapter, You'll Be Able To
▲
Use common SELECT statement keywords
Design, write, and use queries to retrieve and organize data
▲
Design, write, and use queries that group data and calculate values using
aggregate functions
▲
Design, write, and use queries that join two or more tables
▲
Design, write, and use queries that use nested subqueries to retrieve data
▲
Given data requirements, choose either a join or subquery as the best data
retrieval solution
▲
Design, write, and execute batches and scripts
▲
Use variables in batch execution
▲
Control batch execution based on Boolean expressions
▲