SQL fundamentals
by
 
Patrick, John J.

Title
SQL fundamentals

Author
Patrick, John J.

ISBN
9780137126026

Personal Author
Patrick, John J.

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.

Title Subject
Oracle (Computer file)
 
Microsoft Access.
 
Microsoft Access. (OCoLC)fst01371910
 
Oracle (Computer file) (OCoLC)fst01363816

Subject Term
SQL (Computer program language)
 
SQL (Computer program language) (OCoLC)fst01102869

Electronic Access
Table of contents http://catdir.loc.gov/catdir/toc/ecip0820/2008024745.html