A Guide to SQL, 8th Edition
- Philip J. Pratt Grand Valley State University
- Mary Z. Last
- ISBN-10: 0324597681 | ISBN-13: 9780324597684
- 360 Pages
- Previous Editions: 2005, 2003, 2001
- © 2009 | Published
- Newer Edition Available
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 students 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.
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.
Choose the textbook packaged with the resources that best meet your course and student needs. Contact your Learning Consultant for more information.
ISBN-10: 1133803253 | ISBN-13: 9781133803256
All supplements have been updated in coordination with the main title. Select the main title's "About" tab, then select "What's New" for updates specific to title's edition.
For more information about these supplements, or to obtain them, contact your Learning Consultant.
The Instructor Resources include the Instructor's Manual, PowerPoint® Presentations, Test Banks, and Exercise Solutions.