Title:
SQL fundamentals
Author:
Patrick, John J.
ISBN:
9780130669476
Personal Author:
Edition:
2nd ed.
Publication Information:
Upper Saddle River, NJ : Prentice Hall PTR, ©2002.
Physical Description:
xxvi, 834 pages : illustrations ; 24 cm + 1 CD-ROM (4 3/4 in.)
Contents:
Storing Information in Tables -- Getting Information from a Table -- Compound Conditions in the Where Clause -- Saving Your Results -- Modifying Data Through a View -- Creating Your Own Tables -- Formats, Sequences, and Indexes -- Data Integrity -- Row Functions -- Using Row Functions -- Summarizing Data -- Controlling the Level of Summarization -- Inner Joins -- Outer Joins -- Union and Union All -- Cross Joins and Self Joins -- Combining Tables in a Production Database -- If-Then-Else and Subqueries -- Multiuser Environment -- Design of SQL -- Obtaining and Installing Oracle -- Tips on Using Oracle -- Tips on Using Access -- Diagram of the Lunches Database.