A Guide to SQL,
10th Edition

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

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

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

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.

Cengage Testing, powered by Cognero® for Shellman/Afyouni/Pratt/Last's A Guide to SQL
9780357419793

Cengage Testing, powered by Cognero® for Shellman/Afyouni/Pratt/Last's A Guide to SQL Instant Access
9780357419809

Instructor's Companion Website for Shellman/Afyouni/Pratt/Last's A Guide to SQL
9780357419816

MindTap: A Guide to SQL 12 Months
9780357491256

Cengage eBook: A Guide to SQL 12 Months
9788000032672