Higher Education

A Guide to SQL, 9th Edition

  • Philip J. Pratt Grand Valley State University
  • Mary Z. Last
  • ISBN-10: 111152727X  |  ISBN-13: 9781111527273
  • 360 Pages
  • Previous Editions: 2009, 2005, 2003
  • © 2015 | Published
  • College Bookstore Wholesale Price = $90.75
  *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.

About

Overview

A GUIDE TO SQL, Ninth Edition, provides an effective introduction to SQL programming using straightforward instruction, extensive hands-on exercises, and a strong foundation in real-world business applications. The Ninth Edition builds on the longstanding success of this proven text by presenting basic SQL commands in the context of a running case, in which a business uses SQL to manage orders, items, customers, and sales reps. The authors emphasize that fundamental principles and practices apply regardless of the database environment chosen, and they include examples from the latest versions of Oracle® and Microsoft® Access®, and SQL Server throughout the text.

Features and Benefits

  • This invaluable reference introduces SQL programming using straightforward instruction, hands-on exercises, and a strong foundation in real-world business scenarios.
  • Review questions, exercises, and hands-on projects conclude each chapter to reinforce learning and provide practice applying key concepts. Critical thinking questions and exercises challenge students to use problem-solving and analytical skills.

Table of Contents

1. Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group.
2. Database Design.
3. An Introduction to SQL.
4. Single-Table Queries.
5. Multiple-Table Queries.
6. Updating Data.
7. Database Administration.
8. Reports.
9. Embedded SQL.
Appendix A: SQL Reference.
Appendix B: "How do I" Reference.
Appendix C: Answers to Odd-Numbered Review Questions.

What's New

  • Building on the longstanding success of this proven text, the Ninth Edition introduces basic SQL commands in a real-world context using a running case, which explores how a business might use SQL to manage orders, parts, customers, and sales reps.
  • To illustrate that fundamental principles and practices remain valid regardless of which database environment is used, the authors include numerous examples of the latest versions of Oracle®, Microsoft® Access®, and SQL Server.
  • A new continuing case problem appears in each chapter throughout the book.
  • New cases are used in the end-of-chapter exercises and cases.
  • Critical thinking questions and exercises that challenge students to use problem-solving and analytical skills appear in each case.

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: New Perspectives on Microsoft® Access 2013, Introductory + A Guide to SQL, 9th + A Guide to Computer User Support for Help Desk and Support Specialists, 6th + SAM 2013 Assessment, Training, and Projects with MindTap Reader for New Perspectives Microsoft Access 2013 Comprehensive v3.0 Multi-Term Printed Access Card

ISBN-10: 1337147257 | ISBN-13: 9781337147255

List Price = $586.95  | CengageBrain Price = $586.95  | College Bookstore Wholesale Price = $441.00

This Bundle Includes:

  • New Perspectives on Microsoft® Access 2013, Introductory
    List Price = $133.95  | CengageBrain Price = $133.95  | College Bookstore Wholesale Price = $100.50
  • A Guide to SQL
    List Price = $120.95  | CengageBrain Price = $120.95  | College Bookstore Wholesale Price = $90.75
  • A Guide to Computer User Support for Help Desk and Support Specialists
    List Price = $186.95  | CengageBrain Price = $186.95  | College Bookstore Wholesale Price = $140.25
  • SAM 2013 Assessment, Training, and Projects with MindTap Reader for New Perspectives Microsoft Access 2013 Comprehensive v3.0 Multi-Term Printed Access Card
    List Price = $146.00  | College Bookstore Wholesale Price = $109.50


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.