Taylor's Library Banner
Image from Google Jackets

SQL fundamentals / John J. Patrick

By: Publication details: Upper Saddle River, N.J. : Prentice Hall PTR, c2002Edition: 2nd edDescription: xxvi, 834 p. : ill. ; 24 cm. + 1 electronic optical disc (CD-ROM) (4 3/4 in.)ISBN:
  • 0130669474
Subject(s): DDC classification:
  • 005.7565 PAT
Contents:
Preface. - Ch. 1. Storing Information in Tables. - Ch. 2. Getting Information from a Table. - Ch. 3. Compound Conditions in the Where Clause. - Ch. 4. Saving Your Results. - Ch. 5. Modifying Data Through a View. - Ch. 6. Creating Your Own Tables. - Ch. 7. Formats, Sequences, and Indexes. - Ch. 8. Data Integrity. Ch. 9. Row Functions. - Ch. 10. Using Row Functions. - Ch. 11. Summarizing Data. - Ch. 12. Controlling the level of Summarization. - Ch. 13. Inner Joins. - Ch. 14. Outer Joins. Ch. 15. Union and Union All. - Ch. 16. Self Joins, Cross Joins. - Ch. 17. Combining Tables in a Production Database. - 18. If-Then-Else and Subqueries. - Ch. 19. The Multiuser Environment - Ch. 20. The Design of SQL. - Appendix A. Obraining and Installing Oracle. Appendix B. Tips on Using Oracle. Appendix C. Tips on Using Access. Appendix D. Diagram of the Lunches Database. - Index.
No physical items for this record

Preface. - Ch. 1. Storing Information in Tables. - Ch. 2. Getting Information from a Table. - Ch. 3. Compound Conditions in the Where Clause. - Ch. 4. Saving Your Results. - Ch. 5. Modifying Data Through a View. - Ch. 6. Creating Your Own Tables. - Ch. 7. Formats, Sequences, and Indexes. - Ch. 8. Data Integrity. Ch. 9. Row Functions. - Ch. 10. Using Row Functions. - Ch. 11. Summarizing Data. - Ch. 12. Controlling the level of Summarization. - Ch. 13. Inner Joins. - Ch. 14. Outer Joins. Ch. 15. Union and Union All. - Ch. 16. Self Joins, Cross Joins. - Ch. 17. Combining Tables in a Production Database. - 18. If-Then-Else and Subqueries. - Ch. 19. The Multiuser Environment - Ch. 20. The Design of SQL. - Appendix A. Obraining and Installing Oracle. Appendix B. Tips on Using Oracle. Appendix C. Tips on Using Access. Appendix D. Diagram of the Lunches Database. - Index.