Overview

Appropriate for all courses in database usage, development, or design with MySQL. In MySOL Tutorial, two of the world's leading MySQL experts present a clear and concise tutorial on the fundamental concepts and techniques needed to work with MySQL. One step at a time, Luke Welling and Laura Thompson teach the beginning MySQL user how to create and administer powerful databases that can be used at home, at work, and on the Web. This task-oriented book focuses on several key areas: installation and configuration; database design and creation; querying MySQL databases; working with MySQL tables and transactions; administering MySQL databases; and optimizing database performance. Taken together, these are the core skills needed to use MySQL professionally. Each chapter contains a set of review questions and practical exercises that enable students to practice their skills and test their understanding. The first book from MySQL Press, MySQL Tutorial has been reviewed for technical accuracy by MySQL AB, the developers of MySQL.

Full Product Details

Author:   Luke Welling ,  Laura Thomson
Publisher:   MySQL Press
Imprint:   MySQL Press
Dimensions:   Width: 17.90cm , Height: 1.70cm , Length: 22.90cm
Weight:   0.464kg
ISBN:  

9780672325847

ISBN 10:   0672325845
Pages:   288
Publication Date:   04 December 2003
Audience:   College/higher education ,  Tertiary & Higher Education
Format:   Paperback
Publisher's Status:   Active
Availability:   In Print  
This item will be ordered in for you from one of our suppliers. Upon receipt, we will promptly dispatch it out to you. For in store availability, please contact us.

Table of Contents

Introduction. I. MySQL Basics.  1. Installing MySQL.  2. Quick Tour. II. Designing and Creating Databases with MySQL.  3. Database Design Crash Course.  4. Creating Databases, Tables and Indexes. III. Using MySQL.  5. Inserting, Deleting, and Updating Data.  6. Querying MySQL.  7. Advanced Queries.  8. Using MySQL Built-in Functions with SELECT. IV. MySQL Table Types and Transactions.  9. Understanding MySQL's Table Types. 10. Using Transactions with InnoDB Tables. V. Administering MySQL. 11. Managing User Privileges. 12. Configuring MySQL. 13. Administering Your Database. 14. Backup and Disaster Recovery. 15. Securing Your MySQL Installation. 16. Replicating Your Database. VI. Optimizing MySQL. 17. Optimizing Your MySQL Server Configuration. 18. Optimizing Your Database. 19. Optimizing Your Queries. Index.

Reviews

Author Information

Luke Welling is a lecturer in the School of Computer Science and Information Technology at RMIT University in Melbourne, Australia. He chooses to use Open Source software whenever practical and evangelizes the advantages of this approach as widely as possible. He has spoken to audiences in Australia, North America, and Europe about MySQL, PHP, and other Open Source topics. He has taught a wide variety of technical topics to university students and professionals, but he specializes in Internet-related topics. Laura Thomson is a lecturer in the School of Computer Science and Information Technology at RMIT University in Melbourne, Australia. She has taught a wide variety of courses with a Web and Internet focus and is currently completing a Ph.D. in Web Mining. She speaks at conferences around the globe and has delivered training at organizations as diverse as Ericsson and Lonely Planet. Previously, Laura has worked for Telstra and the Boston Consulting Group. She holds a first-class honors degree in Computer Systems Engineering and a degree (with distinction) in Computer Science. In her spare time, she rides her horses, feeds her menagerie of animals, and occasionally speaks to Luke about something nontechnical.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions