A Guide to SQL

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.

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.