- STAFF PICKS
- GIFTS + GIFT CARDS
- SELL BOOKS
- FIND A STORE
New Trade Paper
Ships in 1 to 3 days
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
More copies of this ISBN
A Guide to SQLby Philip J. Pratt
Synopses & Reviews
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.
A GUIDE TO SQL, 8E, illustrates the basics of SQL programming using straightforward instruction and extensive hands-on exercises. Phil Pratt and Mary Last continue to present basic SQL commands in a business context using Oracle. A new running case, for a total of three, presents lessons in a real-world context for managing orders, parts, customers, and sales reps. The text provides hands-on projects at the end of each chapter, including review questions, running cases, and extensive exercises, providing students with the opportunity to solve problems and apply skills from each chapter.
About 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 60 textbooks, including coauthoring three levels of Microsoft Office Access 2010 books for the Shelly Cashman Series, the Concepts of Database Management, and A Guide to SQL.
Table of Contents
1. An Introduction to Premiere Products, Henry Books, and Alexamara Marina Group. 2. Database Design Fundamentals. 3. An Introduction to SQL. 4. Single-Table Queries. 5. Multiple-Table Queries. 6. Updating Data. 7. Database Administration. 8. SQL Functions and Procedures. Appendix A: SQL Reference. Appendix B: "How do I" Reference. Appendix C: Answers to Odd-Numbered Review Questions.
What Our Readers Are Saying
Other books you might like
Business » High Tech Management