A GUIDE TO SQL, Ninth Edition, provides an effective introduction to SQL programming using straightforward instruction, extensive hands-on exercises, and a strong foundation in real-world business applications. The Ninth Edition builds on the longstanding success of this proven text by presenting basic SQL commands in the context of a running case, in which a business uses SQL to manage orders, items, customers, and sales reps. The authors emphasize that fundamental principles and practices apply regardless of the database environment chosen, and they include examples from the latest versions of Oracle and Microsoft Access, and SQL Server throughout the text.
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 over 75 textbooks, including coauthoring three levels of Microsoft Office Access 2013 books for the Shelly Cashman Series and A Guide to SQL.
Mary Z. Last has taught computer information systems since 1984. She retired from the University of Mary Hardin-Baylor, Belton, TX where she was an Associate Professor and the Director of the Center for Effectiveness in Learning and Teaching. Mary 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 and also authors many instructor resources for database texts.
More About This Textbook
Overview
A GUIDE TO SQL, Ninth Edition, provides an effective introduction to SQL programming using straightforward instruction, extensive hands-on exercises, and a strong foundation in real-world business applications. The Ninth Edition builds on the longstanding success of this proven text by presenting basic SQL commands in the context of a running case, in which a business uses SQL to manage orders, items, customers, and sales reps. The authors emphasize that fundamental principles and practices apply regardless of the database environment chosen, and they include examples from the latest versions of Oracle and Microsoft Access, and SQL Server throughout the text.
Product Details
Meet the Author
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 over 75 textbooks, including coauthoring three levels of Microsoft Office Access 2013 books for the Shelly Cashman Series and A Guide to SQL.
Mary Z. Last has taught computer information systems since 1984. She retired from the University of Mary Hardin-Baylor, Belton, TX where she was an Associate Professor and the Director of the Center for Effectiveness in Learning and Teaching. Mary 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 and also authors many instructor resources for database texts.
Table of Contents
1. Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group. 2. Database Design. 3. An Introduction to SQL. 4. Single-Table Queries. 5. Multiple-Table Queries. 6. Updating Data. 7. Database Administration. 8. Reports. 9. Embedded SQL. Appendix A: SQL Reference. Appendix B: "How do I" Reference. Appendix C: Answers to Odd-Numbered Review Questions.