Loading...

A Guide to SQL,
10th Edition

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

ISBN-13: 9780357361689 | ISBN-10: 0357361687

Copyright 2021

| Published 2020

| 320 pages

List Price USD $99.95

Overview

Master today's SQL programming principles and learn how to most effectively apply your SQL skills with Shellman/Afyouni/Pratt/Last's A GUIDE TO SQL, Tenth Edition. This edition's leading approach combines straightforward instruction and extensive hands-on exercises with a strong foundation and emphasis on today's actual business applications. This edition introduces basic SQL commands in the context of an intriguing, ongoing case in which a business uses SQL to manage orders, items, customers and sales reps. This edition emphasizes how to apply fundamental principles and strengthen your programming practices, regardless of the database environment. You work with examples from the latest versions of MySQL, the world's most popular open source, free database, as well as Oracle® and Microsoft® SQL Server. In addition, MindTap digital learning solution is available to help you strengthen your SQL skills.

Read More

Meet the Authors

Show More Show Less

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.

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

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

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

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 Instant Access

ISBN13:9780357419809
ISBN10:0357419804
Cengage Testing, powered by Cognero® is a flexible, online system that allows you to import, edit and manipulate content from the text’s test bank or elsewhere, including your own favorite test questions; create multiple test versions in an instant; and deliver tests from your LMS, your classroom or wherever you want.

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

ISBN13:9780357419793
ISBN10:0357419790

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

ISBN13:9780357419816
ISBN10:0357419812
Everything you need for your course in one place! This collection of product-specific lecture and class tools is available online via the instructor resource center at www.cengage.com/login. You'll be able to access and download materials such as PowerPoint® presentations, images, instructor’s manual, videos and more.

Compare Buying Options

Show More Show Less

Pricing Options

A Guide to SQL

  • ISBN-10: 0357361687
  • ISBN-13: 9780357361689

Price USD$ 99.95

eBook: A Guide to SQL 12Months

  • ISBN-10: 8000032678
  • ISBN-13: 9788000032672

Price USD$ 49.99

MindTap: A Guide to SQL 12Months

  • ISBN-10: 0357491254
  • ISBN-13: 9780357491256

Price USD$ 121.00

Buy

*Purchase not available for this country