SQL Fundamentals / Edition 2
by John J. Patrick, John PatrickDon't just learn "generic" SQL: learn SQL to get results with the world's top database platforms -- Oracle for the enterprise and Microsoft Access for the desktop! Based on John J. Patrick's hands-on SQL course at the University of California at Berkeley Extension, this book shows exactly how to retrieve the data you want, when you need it, in any application -- from… See more details below
Overview
Don't just learn "generic" SQL: learn SQL to get results with the world's top database platforms -- Oracle for the enterprise and Microsoft Access for the desktop! Based on John J. Patrick's hands-on SQL course at the University of California at Berkeley Extension, this book shows exactly how to retrieve the data you want, when you need it, in any application -- from ad hoc reports to the data warehouse. From the simplest Select statements to the most sophisticated joins, Patrick shows you exactly how to write SQL queries that are easy to understand, verify, modify, and extend.
Product Details
- ISBN-13:
- 9780130669476
- Publisher:
- Prentice Hall Professional Technical Reference
- Publication date:
- 05/28/2002
- Edition description:
- 2nd Edition Book & CD-ROM
- Pages:
- 864
- Product dimensions:
- 7.00(w) x 9.50(h) x 1.24(d)
Table of Contents
| Preface | ||
| Acknowledgments | ||
| Ch. 1 | Storing Information in Tables | 1 |
| Ch. 2 | Getting Information from a Table | 33 |
| Ch. 3 | Compound Conditions in the Where Clause | 89 |
| Ch. 4 | Saving Your Results | 139 |
| Ch. 5 | Modifying Data Through a View | 177 |
| Ch. 6 | Creating Your Own Tables | 227 |
| Ch. 7 | Formats, Sequences, and Indexes | 277 |
| Ch. 8 | Data Integrity | 315 |
| Ch. 9 | Row Functions | 357 |
| Ch. 10 | Using Row Functions | 397 |
| Ch. 11 | Summarizing Data | 435 |
| Ch. 12 | Controlling the Level of Summarization | 473 |
| Ch. 13 | Inner Joins | 521 |
| Ch. 14 | Outer Joins | 563 |
| Ch. 15 | Union and Union All | 601 |
| Ch. 16 | Cross Joins and Self Joins | 643 |
| Ch. 17 | Combining Tables in a Production Database | 669 |
| Ch. 18 | If-Then-Else and Subqueries | 691 |
| Ch. 19 | The Multiuser Environment | 735 |
| Ch. 20 | The Design of SQL | 779 |
| App. A | Obtaining and Installing Oracle | 791 |
| App. B | Tips on Using Oracle | 801 |
| App. C | Tips on Using Access | 813 |
| App. D | Diagram of the Lunches Database | 821 |
| Index | 825 |
Customer Reviews
Average Review: