Request for consultation

Thanks for your request. You’ll soon be chatting with a consultant to get the answers you need.
{{formPostErrorMessage.message}} [{{formPostErrorMessage.code}}]
First Name is required. 'First Name' must contain at least 0 characters 'First Name' cannot exceed 0 characters Please enter a valid First Name
Last Name is required. 'Last Name' must contain at least 0 characters 'Last Name' cannot exceed 0 characters Please enter a valid Last Name
Institution is required.
Discipline is required.
Why are you contacting us today? is required. 'Why are you contacting us today?' must contain at least 0 characters 'Why are you contacting us today?' cannot exceed 0 characters Please enter a valid Why are you contacting us today?

Overview

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, Grand Valley State University

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,

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.
  • Gives detailed coverage of how to use the SQL language within MySQL in the context of three running cases that appear throughout the book.
  • Presents modern database design techniques, including E-R diagrams and the normalization process.
  • Addresses key MySQL topics, including importing and exporting data, query optimization, the MySQL Query Browser, the MySQL Administrator, the MySQL Table Editor, and more.
  • Includes a comprehensive command reference for all the major SQL clauses and operators taught in the book.
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

Textbook Only Options

Traditional eBook and Print Options

{{collapseContainerClosed['detail_0'] ? 'Show More' : 'Show Less'}}
z

  • ISBN-10: 1133341896
  • ISBN-13: 9781133341895
  • STARTING AT $15.49

  • ISBN-10: 1418836354
  • ISBN-13: 9781418836351
  • Bookstore Wholesale Price $90.75
  • RETAIL $120.95

Cengage provides a range of supplements that are updated in coordination with the main title selection. For more information about these supplements, contact your Learning Consultant.

FOR INSTRUCTORS

A Guide to MySQL

ISBN: 9781418836351
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.

Instructor Resources

ISBN: 9781418836368

FOR STUDENTS

A Guide to MySQL

ISBN: 9781418836351
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.