A Guide to SQL, 8th Edition
- Philip J. Pratt Grand Valley State University
- Mary Z. Last
- ISBN-10: 0324597681 | ISBN-13: 9780324597684
- 360 Pages
- Previous Editions: 2005, 2003, 2001
- © 2009 | Published
- Newer Edition Available
A GUIDE TO SQL, 8E, continues to be the essential SQL reference. It builds on the success of previous editions by presenting basic SQL commands in the context of a running case in which a business uses SQL to manage orders, parts, customers, and sales reps. The book covers the fundamentals of SQL programming using straightforward instruction and extensive hands-on exercises. Continuing with its focus on students learning the basics regardless of the database environment chosen, this edition features examples from the latest databases: Oracle 11g, Access 2007, and MySQL. The eighth edition expands on the use of running case studies by adding a third running case to the extensive hands-on pedagogy at the end of every chapter.
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.
Choose the textbook packaged with the resources that best meet your course and student needs. Contact your Learning Consultant for more information.
ISBN-10: 1133803253 | ISBN-13: 9781133803256
ISBN-10: 0538787082 | ISBN-13: 9780538787086