Request for consultation

Thanks for your request. You’ll soon be chatting with a consultant to get the answers you need.
Your form is submitting...
{{formPostErrorMessage.message}} [{{formPostErrorMessage.code}}]
Email Address is required. 'Email Address' must contain at least 0 characters 'Email Address' cannot exceed 0 characters Please enter a valid Email Address
First Name is required. 'First Name' must contain at least 0 characters 'First Name' cannot exceed 0 characters Please enter a valid First Name
Last Name is required. 'Last Name' must contain at least 0 characters 'Last Name' cannot exceed 0 characters Please enter a valid Last Name
Institution is required.
Discipline is required.
Country is required. 'Country' must contain at least 0 characters 'Country' cannot exceed 0 characters Please enter a valid Country
Cengage, at your service! How can we best meet your needs? is required.
Why are you contacting us today? is required. 'Why are you contacting us today?' must contain at least 0 characters 'Why are you contacting us today?' cannot exceed 0 characters Please enter a valid Why are you contacting us today?

A Guide to SQL, 10th Edition

Mark Shellman, Hassan Afyouni, Philip J. Pratt, Mary Z. Last

  • Copyright 2021
  • {{checkPublicationMessage('Published', '2020-08-04T00:00:00+0000')}}
Starting At £44.79 See pricing and ISBN options
Instructor Next Steps
Students: Buy now
A Guide to SQL 10th Edition by Mark Shellman/Hassan Afyouni/Philip J. Pratt/Mary Z. Last
Quick Navigation

Overview

Effectively introduce your students to SQL programming today using the straightforward instruction, extensive hands-on exercises and emphasis on actual business applications in Shellman/Afyouni/Pratt/Last's A GUIDE TO SQL, Tenth Edition. This edition builds upon a best-selling, proven presentation as the authors introduce basic SQL commands in the context of an intriguing ongoing case. Students see how this contemporary business uses SQL to manage orders and items as well as track the activities of customers and sales reps.

The authors emphasize how to apply fundamental principles and enhance programming practices, regardless of the database environment. Meaningful examples throughout the text highlight the latest versions of MySQL as well as Oracle® and Microsoft SQL Server. In addition, comprehensive digital teaching support, including the latest version of MindTap, provides integrated digital learning solutions that you can customize to your course needs.

{{readMore['overview'] ? 'Read More' : 'Read Less'}}

Meet the Authors

{{collapseContainerClosed['meet-the-author'] ? 'Show More' : 'Show Less'}}

Mark Shellman

Dr. Mark Shellman is an instructor and the Chair of the Information Technology Department at Gaston College in Dallas, North Carolina. Dr. Mark, as his students refer to him, prides himself on being student-centered and loves learning himself. His favorite subjects in the information technology realm include databases and programming languages. Dr. Mark has been teaching information technology for more than thirty years and has co-authored several texts in the New Perspectives Series on Microsoft® Access databases.

Hassan Afyouni

Dr. Hassan Afyouni has been working in the information technology field for more than thirty years. He is a database expert, Oracle® specialist, an enterprise architect, technical advisor and educator. He has been an instructor for several colleges and universities in Canada, the United States and Lebanon. He is a respected author of several leading books in the database field.

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 books for the popular Shelly Cashman Series, in addition to the popular 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 leading database texts.

What's New

{{collapseContainerClosed['whats-new'] ? 'Show More' : 'Show Less'}}
  • REFOCUSED, ENGAGING NARRATIVE PRESENTS MYSQL AS THE PRIMARY DATABASE ENVIRONMENT. The authors have revised this edition's presentation to highlight MySQL, which is the world's most popular open source, free database. This edition now uses MySQL as the primary database environment for demonstrations throughout the text, while still equipping readers to work successfully in any environment.
  • THIS EDITION PRESENTS ORACLE® AND MICROSOFT® SQL SERVER EXAMPLES IN FEATURE BOXES. For quick reference and easily accessibility, this edition presents Oracle® and Microsoft® SQL Server examples throughout the narrative in redesigned, special User Tip feature boxes.
  • NEW FULL-COLOR PRESENTATION USES COLOR-CODING TO DEPICT TODAY'S ACTUAL DATABASE ENVIRONMENTS. This edition's engaging full color design and color-coded SQL queries better represent the typical database environments that students will encounter on the job.
  • NEW MODULE QUIZZES AT THE END OF EACH MODULE OFFER AN EASY WAY TO CHECK STUDENT UNDERSTANDING BEFORE THEY PROGRESS. These new Module Quizzes use multiple-choice questions to improve the grading experience for you and enable more immediate feedback for your students.
  • NEW APPENDIX C DETAILS HOW TO ACCESS MYSQL, ORACLE® AND MICROSOFT® SQL SERVER. Helpful step-by-step instructions guide students in setting up access to MySQL, Oracle® and Microsoft® SQL Server database management systems.
  • REFRESHED, ONGOING CASE INTEGRATES NEW, CONTEMPORARY DATA THAT REFLECTS TODAY'S DEVELOPMENTS IN SQL. Your students work with the latest information and data as they progress through this edition's engaging, continuing case.

Features

{{collapseContainerClosed['features'] ? 'Show More' : 'Show Less'}}
  • BOOK SERVES AS LONG-TERM REFERENCE TOOL WELL BEYOND YOUR COURSE. This edition's well organized, straightforward approach, strong foundation and practice using actual business scenarios make this an invaluable reference source for SQL programming that students can reference in future classes or on the job.
  • REVIEW, PRACTICE, PROJECTS AND CASES REINFORCE CONCEPTS AND APPLICATION. Review questions, exercises, hands-on projects and case studies ensure understanding and strengthen skills at the conclusion of each module. Students practice applying key concepts, while critical-thinking questions and focused exercises challenge students to use problem-solving and analytical skills.
  • Building on the longstanding success of this proven text, the Tenth 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 MySQL, Oracle®, and SQL Server.

Table of Contents

{{collapseContainerClosed['table-of-contents'] ? 'Show More' : 'Show Less'}}
1. Introduction to KimTay Pet Supplies and StayWell Student Accommodation Databases
2. Database Design Fundamentals
3. Creating Tables
4. Single-Table Queries
5. Multiple-Table Queries
6. Updating Data
7. Database Administration
8. Functions, Procedures, and Triggers
Appendix A: SQL Reference
Appendix B: How Do I Reference
Appendix C: The 10 Commandments of Writing Queries

Compare Buying Options

{{collapseContainerClosed['compare-buying-options'] ? 'Show More' : 'Show Less'}}

MindTap Options

{{collapseContainerClosed['detail_1'] ? 'Show More' : 'Show Less'}}
MindTap
Each MindTap product offers the full, mobile-ready textbook combined with superior and proven learning tools at one affordable price. Students who purchase digital access can add a print option at any time when a print option is available for their course.

This Cengage solution can be seamlessly integrated into most Learning Management Systems (Blackboard, Brightspace by D2L, Canvas, Moodle, and more) but does require a different ISBN for access codes. Please work with your Cengage Learning Consultant to ensure the proper course set up and ordering information. For additional information, please visit the LMS Integration site.

Standalone Digital Access — Ultimate Value

Recommended and most popular

  • ISBN-10: 8214491282
  • ISBN-13: 9798214491288
  • RETAIL £45.00
Instructor Next Steps
Students: Buy now

Textbook Only Options

Traditional eBook and Print Options

{{collapseContainerClosed['detail_0'] ? 'Show More' : 'Show Less'}}

  • ISBN-10: 0357709314
  • ISBN-13: 9780357709313
  • RETAIL £44.79

  • ISBN-10: 0357361687
  • ISBN-13: 9780357361689
  • RETAIL £55.99
Instructor Next Steps
Students: Buy now

Supplements

{{collapseContainerClosed['supplements'] ? 'Show More' : 'Show Less'}}

Cengage provides a range of supplements that are updated in coordination with the main title selection. For more information about these supplements, contact your Learning Consultant.

FOR STUDENTS

International MindTap Instant Access for Shellman/Afyouni/Pratt/Last's A Guide to SQL

ISBN: 9798214491288
International MindTap Instant Access for Shellman/Afyouni/Pratt/Last's A Guide to SQL, 10th Edition, is the digital learning solution that powers students from memorization to mastery. It gives you complete control of your course--to provide engaging content, to challenge every individual, and to build their confidence. Empower students to accelerate their progress with MindTap. MindTap: Powered by You. MindTap gives you complete ownership of your content and learning experience. Customize the interactive syllabi, emphasize the most important topics and add your own material or notes in the ebook. All online text media materials accessible through this access code are available in EMEA, Latin America, Asia, and India only.