0%

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

Table of Contents

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