Close Notification

Your cart does not contain any items



We can order this in for you
How long will it take?


Course Technology Inc
04 August 2020
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.
By:   Mark Shellman (Gaston College), Hassan Afyouni (e-conn (Chief Information Officer)), Mary Last, Philip Pratt (Grand Valley State University)
Imprint:   Course Technology Inc
Country of Publication:   United States
Edition:   10th edition
Dimensions:   Height: 232mm,  Width: 188mm,  Spine: 13mm
Weight:   544g
ISBN:   9780357361689
ISBN 10:   0357361687
Pages:   320
Publication Date:   04 August 2020
Audience:   College/higher education ,  Primary
Format:   Paperback
Publisher's Status:   Active
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

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 (R) Access databases. Dr. Hassan Afyouni has been working in the information technology field for more than thirty years. He is a database expert, Oracle (R) 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. 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. 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 (R) Office Access books for the popular Shelly Cashman Series, in addition to the popular A GUIDE TO SQL.

See Also