MySQL Tutorial

Description

A concise introduction to the fundamentals of working with MySQL.

MySQL is an open-source relational database management system that is rapidly growing in popularity. Known for its speed, reliability, and ease of use, MySQL has proven itself to be particularly well suited both for beginners and for experienced developers to create sophisticated database-backed Web sites and applications.

MySQL Tutorial is a clear, concise introduction to the fundamental concepts and techniques of working with MySQL. It teaches the beginning MySQL user how to create and administer powerful databases that can be used at home, at work, and on the Web.

Whether you are a novice to databases or a technical professional looking to find out more about how MySQL works, MySQL Tutorial efficiently guides you through the information you need in order to get started with MySQL and quickly become proficient.

Back Cover

A concise introduction to the fundamentals of working with MySQL.

MySQL is an open-source relational database management system that is rapidly growing in popularity. Known for its speed, reliability, and ease of use, MySQL has proven itself to be particularly well suited both for beginners and for experienced developers to create sophisticated database-backed Web sites and applications.

MySQL Tutorial is a clear, concise introduction to the fundamental concepts and techniques of working with MySQL. It teaches the beginning MySQL user how to create and administer powerful databases that can be used at home, at work, and on the Web.

Whether you are a novice to databases or a technical professional looking to find out more about how MySQL works, MySQL Tutorial efficiently guides you through the information you need in order to get started with MySQL and quickly become proficient.

Contents


Introduction.

I. MySQL Basics.

II. Designing and Creating Databases with MySQL.

III. Using MySQL.

IV. MySQL Table Types and Transactions.

V. Administering MySQL.

VI. Optimizing MySQL.

Features

• The official MySQL Press guide to MySQL—Thoroughly reviewed for accuracy by the creators of MySQL.

  • Gives students confidence that they are learning from materials that are both accurate and effective.

• Coverage through MySQL 4.1—Reflects the latest MySQL features, including the InnoDB storage engine, improved user privilege management, and more.

  • Teaches students techniques they will be able to utilize for many years to come.

• Task-oriented, concise, and focused—Delivers efficient, task-oriented coverage of the skills every user needs in order to work professionally with MySQL: installation, configuration, queries, administration, security, and optimization.

  • Prepares students for the MySQL database challenges they are most likely to encounter, while providing a firm foundation in concepts and techniques they will rely upon constantly.

• End-of-chapter exercises and review questions—Includes exercises and review questions that can easily be tailored to the needs of specific courses and instructors.

  • Provides constant feedback and reinforcement to ensure that students understand the material they are learning.

• By two of the worlds leading MySQL experts—Authored by experts with a proven track record of explaining MySQL and related technologies clearly and effectively.

  • Helps students learn more efficiently, by anticipating their needs and answering their questions.

Author

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.