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
| Library | Material Type | Item Barcode | Shelf Number | Copy |
|---|
| IIEMSA | General Books | 33168025408929 | 005.7565 S772 PAT 2002 | 1 |
| VC Cape Town | General Books | 000004481 | 005.7565 PAT | 1 |
| VC Cape Town | General Books | 000001164 | 005.7565 PAT | 2 |
| VC Durban North | Lecturer Books | 000022601 | 005.7565 | 1 |
| VC Sandton | General Books | 000054848 | 005.756 PAT | 1 |
| VC Sandton | General Books | 000052656 | 005.756 PAT | 2 |