(See related pages)
This chapter provides the foundation for query formulation using the industry standard Structured Query Language (SQL). Query formulation is the process of converting a request for data into a statement of a database language such as SQL. After this chapter the student should have acquired the following knowledge and skills:
|
|
|
Write SQL SELECT statements for queries involving the restrict, project, and join operators. |
|
|
|
Use the critical questions to transform a problem statement into a database representation. |
|
|
|
Write SELECT statements for difficult joins involving three or more tables, self joins, and multiple joins between tables. |
|
|
|
Understand the meaning of the GROUP BY clause using the conceptual evaluation process. |
|
|
|
Write English descriptions to document SQL statements. |
|
|
|
Write INSERT, UPDATE, and DELETE statements to change the rows of a table. |