SQL fundamentals / John J. Patrick
Material type: TextPublisher: Upper Saddle River, New Jersey : Prentice Hall PTR, c2002Edition: second editionDescription: xxvi, 834 pages : illustrations ; 24 cm. + 1 CD-ROM (4 3/4 in.)Content type: text Media type: unmediated Carrier type: volumeISBN: 0130669474 [paperback]Subject(s): SQL (Computer program language)DDC classification:Item type | Current location | Call number | Status | Date due | Barcode |
---|---|---|---|---|---|
Book | 005.7565 P27 2002 (Browse shelf) | Available | 3UCBL000003212 |
Includes appendices and index
Contents : Chapter 1 Storing information in tables -- Chapter 2 Getting information from a table -- Chapter 3 Compound conditions in the where clause -- Chapter 4 Saving your results -- Chapter 5 Modifying data through a view -- Chapter 6 Creating your own tables -- Chapter 7 Formats, sequences, and indexes -- Chapter 8 Data integrity -- Chapter 9 Row functions -- Chapter 10 Using row functions -- Chapter 11 Summarizing data -- Chapter 12 Controlling the level of summarization -- Chapter 13 Inner joins -- Chapter 14 Outer joins -- Chapter 15 Union and union all -- Chapter 16 Cross joins and self joins -- Chapter 17 Combining tables in a production database -- Chapter 18 If-then-else and subqueries -- Chapter 19 The multiuser environment -- Chapter 20 The design of sql
System requirements for accompanying CD-ROM: PC; Microsoft Windows 98/NT/2000/XP. The Oracle portion can also be used on UNIX and Linux. The Access portion can also be used on Microsoft Windows Me.
English
There are no comments on this title.