Guide To MySQL

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.

A Guide to MySQL, by Philip Pratt and Mary Last, is yet another step into the open-source arena, which is rapidly growing in the technology industry. Topics include design techniques, data definition, commands to query a database, updates, administration and client tools, and finally, MySQL special topics.

A Guide to MySQL, by Philip Pratt and Mary Last, is yet another step into the open-source arena, which is rapidly growing in the technology industry. Topics include design techniques, data definition, commands to query a database, updates, administration and client tools, and finally, MySQL special topics.

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.

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