A Guide to SQL / Edition 8
by Philip J. Pratt, Mary Z. Last
A GUIDE TO SQL, 8E, continues to be the essential SQL reference. It builds on the success of previous editions by presenting basic SQL commands in the context of a running case in which a business uses SQL to manage orders, parts, customers, and sales reps. The book covers the fundamentals of SQL programming using straightforward instruction and extensive hands-on…
See more details below
Overview
A GUIDE TO SQL, 8E, continues to be the essential SQL reference. It builds on the success of previous editions by presenting basic SQL commands in the context of a running case in which a business uses SQL to manage orders, parts, customers, and sales reps. The book covers the fundamentals of SQL programming using straightforward instruction and extensive hands-on exercises. Continuing with its focus on learning the basics regardless of the database environment chosen, this edition features examples from the latest databases: Oracle 11g, Access 2007, and MySQL. The eighth edition expands on the use of running case studies by adding a third running case to the extensive hands-on pedagogy at the end of every chapter.
Product Details
- ISBN-13:
- 9780324597684
- Publisher:
- Cengage Learning
- Publication date:
- 10/02/2008
- Series:
- Available Titles Skills Assessment Manager (SAM) - Office 2010 Series
- Edition description:
- Older Edition
- Pages:
- 360
- Sales rank:
- 767,284
- Product dimensions:
- 7.30(w) x 9.00(h) x 0.70(d)
Table of Contents
1. An Introduction to Premiere Products, Henry Books, and Alexamara Marina Group. 2. Database Design Fundamentals. 3. An Introduction to SQL. 4. Single-Table Queries. 5. Multiple-Table Queries. 6. Updating Data. 7. Database Administration. 8. SQL Functions and Procedures. Appendix A: SQL Reference. Appendix B: "How do I" Reference. Appendix C: Answers to Odd-Numbered Review Questions.
Customer Reviews
Average Review: