Higher Education

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
  • College Bookstore Wholesale Price = $90.75
  • Newer Edition Available
  *Why an online review copy?
  • It's the greener, leaner way to review! An online copy cuts down on paper and on time. Reduce the wait (and the weight) of printed texts. Your online copy arrives instantly, and you can review it anytime from your computer or favorite mobile device.

If you prefer a print copy to review, please contact your representative.



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.

Features and Benefits

  • Provides hands-on projects at the end of each chapter, including review questions, running cases, and extensive exercises, to solve problems and apply skills from each chapter.
  • The eighth edition can be bundled with Oracle 11g software to give students hands-on database experience.

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.

What's New

  • The new edition teaches the basics of SQL programming using three running cases.
  • The text focuses on presenting the basics regardless of the database environment and is based on Oracle 11g, Access 2007, and MySQL to keep your class current.

Learning Resource Bundles

Choose the textbook packaged with the resources that best meet your course and student needs. Contact your Learning Consultant for more information.

Bundle: Database Systems: Design, Implementation, and Management (with Design, Implementation, and Management (with Premium WebSite Printed Access Card and Essential Textbook Resources Printed Access Card), 10th + A Guide to SQL

ISBN-10: 1133803253 | ISBN-13: 9781133803256

List Price = $332.95  | College Bookstore Wholesale Price = $250.50

This Bundle Includes:

  • A Guide to SQL
    List Price = $120.95  | CengageBrain Price = $120.95  | College Bookstore Wholesale Price = $90.75
  • Database Systems: Design, Implementation, and Management
    List Price = $276.95  | College Bookstore Wholesale Price = $207.75


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.

Instructor Supplements

Instructor's Resource CD-ROM  (ISBN-10: 0324597339 | ISBN-13: 9780324597332)

The Instructor Resources include the Instructor's Manual, PowerPoint® Presentations, Test Banks, and Exercise Solutions.

Meet the Author

Author Bio

Philip J. Pratt

Philip J. Pratt is Professor Emeritus of Mathematics and Computer Science at Grand Valley State University, where he taught for 33 years. His teaching interests include database management, systems analysis, complex analysis, and discrete mathematics. He has authored more than 75 textbooks and has co-authored three levels of Microsoft® Office Access 2013 books for this popular Shelly Cashman Series and A Guide to SQL.

Mary Z. Last

Mary Z. Last has taught computer information systems since 1984. She retired from the University of Mary Hardin-Baylor, Belton, Texas, where she was an Associate Professor and the Director of the Center for Effectiveness in Learning and Teaching. Ms. Last is actively involved in the Computing Educator's Oral History Project that encourages young women to pursue careers in math and science. She has been a contributing author to the Shelly Cashman Series since 1992. She also authors many instructor resources for database texts.