Home > Store > Data > MySQL

MySQL Tutorial

Register your product to gain access to bonus material or receive a coupon.

MySQL Tutorial

Best Value Purchase

Book + eBook Bundle

  • Your Price: $41.79
  • List Price: $67.98
  • About Adobe DRM eBooks
  • This eBook requires the free Adobe® Digital Editions software.

    Before downloading this DRM-encrypted PDF, be sure to:


    • Install the free Adobe Digital Editions software on your machine. Adobe Digital Editions only works on Macintosh and Windows, and requires the Adobe Flash Player. Please see the official system requirements.
    • Authorize your copy of Adobe Digital Editions using your Adobe ID (select AdobeID as the eBook vendor). If you don't already have an Adobe ID, you can create one here.

More Purchase Options

Book

  • Your Price: $31.99
  • List Price: $39.99
  • Usually ships in 24 hours.

eBook (Adobe DRM)

  • Your Price: $22.39
  • List Price: $27.99
  • About Adobe DRM eBooks
  • This eBook requires the free Adobe® Digital Editions software.

    Before downloading this DRM-encrypted PDF, be sure to:


    • Install the free Adobe Digital Editions software on your machine. Adobe Digital Editions only works on Macintosh and Windows, and requires the Adobe Flash Player. Please see the official system requirements.
    • Authorize your copy of Adobe Digital Editions using your Adobe ID (select AdobeID as the eBook vendor). If you don't already have an Adobe ID, you can create one here.

About

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.

Description

  • Copyright 2004
  • Dimensions: 7 X 9
  • Pages: 288
  • Edition: 1st
  • Book
  • ISBN-10: 0-672-32584-5
  • ISBN-13: 978-0-672-32584-7
  • eBook (Adobe DRM)
  • ISBN-10: 0-7686-6284-2
  • ISBN-13: 978-0-7686-6284-9

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.

Downloads

Downloads

All the code developed for the book in one convenient file for download - 3 kb -- code.zip

Sample Content

Online Sample Chapters

Database Design Crash Course

Database Design Crash Course

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.

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership