Request for consultation
Your form is submitting...
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.
- 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.
- 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.
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'}}
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 $84.95
Textbook Only Options
Traditional eBook and Print Options
- ISBN-10: 0357709314
- ISBN-13: 9780357709313
- RETAIL $79.95
- ISBN-10: 0357361687
- ISBN-13: 9780357361689
- RETAIL $154.95
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, 2 terms Instant Access
ISBN: 9780357419762
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—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.
The 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.