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.
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?

MindTap for Shellman/Afyouni/Pratt/Last's A Guide to SQL, 2 terms Instant Access, 10th Edition

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

  • Copyright 2021
  • {{checkPublicationMessage('Published', '2020-11-17T00:00:00+0000')}}
Starting At $129.95 See pricing and ISBN options
Instructor Next Steps
Students: Buy now
MindTap for Shellman/Afyouni/Pratt/Last's A Guide to SQL, 2 terms Instant Access 10th Edition by Mark Shellman/Hassan Afyouni/Philip J. Pratt/Mary Z. Last
Quick Navigation

Overview

The 10th edition of Shellman/Afyouni/Pratt/Last's A Guide to SQL brings a brand-new MindTap for increased student engagement. MindTap is the digital learning solution that powers students from memorization to mastery. It gives you complete control of your course\u2014to provide engaging content, to challenge every individual, and to build their confidence. Empower students to accelerate their progress with MindTap. MindTap: Powered by You.\n\nMindTap 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.\n\nThe 10th edition MindTap introduces your students to auto-graded SQL lab activities within a real-world integrated development environment that feed directly to your gradebook. MindTap also contains Database for Life activities to help build student interest in the Database field, as well as lifelong learning habits. Each module includes a Reflection discussion prompt that encourages self-reflection and open sharing among classmates. Also included are engaging concept clip videos, Candid Career videos and interactive end-of-module assessments, along with the standard MindTap flashcard and PowerPoint lecture slides.

{{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.

Features

{{collapseContainerClosed['features'] ? 'Show More' : 'Show Less'}}
  • Pre- and Post-Assessments and Module Quizzes: Multiple-choice, auto graded assessments measure student mastery of new material and help instructors to gauge student understanding and progress.
  • Concept Clips: Videos explore key concepts or demonstrate how to perform tasks using SQL
  • Career Connection: An interview video series of database industry professionals with an accompanying open-response writing assignment
  • Database for Life: Open-response writing assignment based on industry-focused podcasts, videos, and articles
  • Use It: Scenario-based multiple choice assessments foster decision-making skills and provide auto-feedback.
  • SQL Coding Labs: Auto-graded SQL coding labs provide targeted practice and assessment of SQL tasks in a cloud-based Integrated Development Environment.

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: 0357419766
  • ISBN-13: 9780357419762
  • RETAIL $129.95

  • ISBN-10: 035741974X
  • ISBN-13: 9780357419748
  • RETAIL $129.95
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

MindTap for Shellman/Afyouni/Pratt/Last's A Guide to SQL, 1 term Instant Access

ISBN: 9780357419748
The 10th edition of Shellman/Afyouni/Pratt/Last's A Guide to SQL brings a brand-new MindTap for increased student engagement. MindTap is the digital learning solution that powers students from memorization to mastery. It gives you complete control of your course\u2014to provide engaging content, to challenge every individual, and to build their confidence. Empower students to accelerate their progress with MindTap. MindTap: Powered by You.\n\nMindTap 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.\n\nThe 10th edition MindTap introduces your students to auto-graded SQL lab activities within a real-world integrated development environment that feed directly to your gradebook. MindTap also contains Database for Life activities to help build student interest in the Database field, as well as lifelong learning habits. Each module includes a Reflection discussion prompt that encourages self-reflection and open sharing among classmates. Also included are engaging concept clip videos, Candid Career videos and interactive end-of-module assessments, along with the standard MindTap flashcard and PowerPoint lecture slides.