A Guide to MySQL / Edition 1

by Philip J. Pratt, Mary Z. Last

Overview

The MySQL database has become the world's most popular open source database because of its consistent fast performance, high reliability, and ease of use. That s why best-selling authors Phil Pratt and Mary Last are pleased to introduce their latest database textbook - A Guide to MySQL. This straightforward text utilizes three case databases - Premiere Products, Henry Books, and Alexamara Marina Group - to teach the concepts and techniques of using MySQL. Your students will gain the skills to build professional quality MySQL databases, thanks to this real-world approach. Additional hands-on exercises at the end of each chapter offer students the opportunity to problem-solve based on what they ve previously learned.

Product Details

ISBN-13:	9781418836351
Publisher:	Cengage Learning
Publication date:	12/09/2005
Series:	Available Titles Skills Assessment Manager (SAM) - Office 2010
Edition description:	New Edition
Pages:	288
Product dimensions:	7.50(w) x 9.06(h) x 0.64(d)

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 books for the popular Shelly Cashman Series, in addition to the popular 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 leading database texts.

Table of Contents

1. 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. MySQL Special Topics Appendix A: SQL Reference AppendixB: How Do I Reference Appendix C. Answers to Odd-Numbered Review Questions