A Guide to MySQL, 1st Edition

  • Philip J. Pratt Grand Valley State University
  • Mary Z. Last
  • ISBN-10: 1418836354
  • ISBN-13: 9781418836351
  • 288 Pages Paperback 
  • © 2006 | Published
Request a Copy
 

About The Solution

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.


Additional Product Information

Features/Benefits

  • 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.

Best Buy Packages

Other Popular Packages

Choose the textbook packaged with the resources that best meet your course and student needs. Contact your Cengage Learning representative for more information.


Bundle: A Guide to MySQL + Concepts of Database Management, 6th
ISBN-10: 1428383492  | ISBN-13: 9781428383494


Bundle: Concepts of Database Management, 7th + A Guide to MySQL
ISBN-10:  1133391346  | ISBN-13:  9781133391340



ISBN-10:  1435432185 | ISBN-13:  9781435432185


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

Supplements

Instructor Supplements

Instructor Supplements

All supplements have been updated in coordination with the main title. Select the main title’s "About the Solution" tab, then select "What's New" for updates specific to title's edition. For more information about these supplements, or to obtain them, contact your Learning Consultant.

Instructor Resources  (ISBN-10: 1418836362 | ISBN-13: 9781418836368)


Concepts of Database Management  (ISBN-10: 0619215291 | ISBN-13: 9780619215293)

Concepts of Database Management is the perfect short yet complete introduction to database concepts. The two featured case problems, Premiere Products and Henry Books, bring to life real-world database issues such as database design, data integrity, concurrent updates, and data security. This edition includes expanded coverage of SQL, entity-relationship (E-R) diagrams, normalization, and database design.



Student Supplements

Student Supplements

All supplements have been updated in coordination with the main title. Select the main title’s "About the Solution" tab, then select "What's New" for updates specific to title's edition. For more information about these supplements, or to obtain them, contact your Learning Consultant.

Concepts of Database Management  (ISBN-10: 0619215291 | ISBN-13: 9780619215293)

This edition includes expanded coverage of SQL, entity-relationship (E-R) diagrams, normalization, and database design. The two featured case problems bring to life real-world database issues such as database design, data integrity, concurrent updates, and data security.



Meet the Author

About the Author

Philip J. Pratt

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

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.