A Guide to SQL
By Mark Shellman, Hassan Afyouni, Philip J. Pratt, Mary Z. Last
About your course materials
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.
Related study tools
MindTap for Shellman/Afyouni/Pratt/Last's A Guide to SQL, 1 term Instant Access
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 memori…
MindTap for Shellman/Afyouni/Pratt/Last's A Guide to SQL, 1 term Printed Access Card
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 memori…
MindTap for Shellman/Afyouni/Pratt/Last's A Guide to SQL, 2 terms Printed Access Card
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 memori…
Frequently asked questions
How do I enroll in or join my course?
How do I redeem an access code, or what if my code isn't working?
Why can't I access my course?
Where can I find my eBook or textbook?
What if I don't have access to my course materials yet?
About this product
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.
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
Chapters
Module 1. Introduction to KimTay Pet Supplies and StayWell Student Accommodation DatabasesPreview this chapter
Resources
Instructor resources for this title can include manuals, test banks, educator guides, multimedia and companion sites. Sign in to see what is available.
Pricing and formats
MindTap
Give students content, practice, assignments, and AI support, with real-time insights to track their progress.
Give students more with Cengage Unlimited
Choose the Cengage content and Learning Platform that fit your course while giving students access to Cengage Learning Platforms and our entire eBook library with one subscription.
4-12 month student access
eBook
Give students digital access to textbook content with tools to highlight, bookmark and search as they read.
Paperback
Related products
Database Systems: Design, Implementation, & Management
Principles of Information Systems
Database Systems: Design, Implementation, & Management
Still need support?
