|
![]() |
|||
|
||||
OverviewMaster 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. Full Product DetailsAuthor: Mark Shellman (Gaston College) , Hassan Afyouni (e-conn (Chief Information Officer)) , Mary Last , Philip Pratt (Grand Valley State University)Publisher: Cengage Learning, Inc Imprint: Course Technology Inc Edition: 10th edition Dimensions: Width: 18.80cm , Height: 1.50cm , Length: 23.20cm Weight: 0.544kg ISBN: 9780357361689ISBN 10: 0357361687 Pages: 320 Publication Date: 04 August 2020 Audience: College/higher education , Tertiary & Higher Education Format: Paperback Publisher's Status: Active Availability: Available To Order ![]() We have confirmation that this item is in stock with the supplier. It will be ordered in for you and dispatched immediately. Table of Contents1. 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 QueriesReviewsAuthor InformationDr. 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. 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® Office Access books for the popular Shelly Cashman Series, in addition to the popular A GUIDE TO SQL. Tab Content 6Author Website:Countries AvailableAll regions |