A Guide to SQL (Available Titles Skills Assessment Manager (SAM) - Office 2010) - Softcover

Pratt, Philip J.; Last, Mary Z.

Softcover

ISBN 10: 0324597681 ISBN 13: 9780324597684

Publisher: Cengage Learning, 2008

Synopsis

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 this title

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 more than 75 textbooks and has co-authored three levels of Microsoft Office Access 2013 books for this popular 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, 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 database texts.

Review:

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.

About this edition

• Publisher: Cengage Learning
• Publication date: 2008
• ISBN 10: 0324597681
• ISBN 13: 9780324597684
• Binding: Paperback
• Number of pages: 360