SQL fundamentals
by
 
Patrick, John J.

Title
SQL fundamentals

Author
Patrick, John J.

ISBN
9780130669476

Personal Author
Patrick, John J.

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.

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


LibraryMaterial TypeItem BarcodeShelf NumberCopy
IIEMSAGeneral Books33168025408929005.7565 S772 PAT 20021
VC Cape TownGeneral Books000004481005.7565 PAT1
VC Cape TownGeneral Books000001164005.7565 PAT2
VC Durban NorthLecturer Books000022601005.75651
VC SandtonGeneral Books000054848005.756 PAT1
VC SandtonGeneral Books000052656005.756 PAT2