Title:
SQL fundamentals
Author:
Patrick, John J.
ISBN:
9780137126026
Personal Author:
Edition:
3rd ed.
Publication Information:
Upper Saddle River, NJ : Prentice Hall, ©2009.
Physical Description:
xxviii, 803 pages : illustrations ; 24 cm
General Note:
Includes index.
Contents:
Storing information in tables -- Getting information from a table -- Compound conditions in the where clause -- Saving your results -- The data dictionary and other oracle topics -- Creating your own tables -- Formats, sequences, and indexes -- Data integrity -- Row functions -- Using row functions -- Summarizing data -- Controlling the level of summarization -- Inner joints -- Outer joints -- Union and union all -- Cross joints, self joints, and crosstab queries -- Combining tables in a production database -- If-then-else, parameter queries, and subqueries -- The multiuser environment -- The design of SQL -- Appendix A : Oracle is free : how to get your copy -- Appendix B : Quick start with oracle -- Appendix C : Quick start with access -- Appendix D : Diagram of the lunches database.
Electronic Access:
Table of contents http://catdir.loc.gov/catdir/toc/ecip0820/2008024745.html