MySQL Tutorial
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: - MySQL, 3rd Edition; Paul DuBois, $31.95, 36% Off!
- High Performance MySQL: Optimization, Backups, Replication & Load Balancing; Jeremy Zawodny, et al, $24.50, 39% Off!
- MySQL Language Reference; Mark Taber, $25.50, 36% Off!
- MySQL Administrator's Guide and Language Reference, 2nd Edition; MySQL AB, $31.95, 36% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
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
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.
About the Authors
Luke Welling and Laura Thomson are co-founders of Tangled Web Design, and recently
won the CCH Emerging Technology award for a site they built using PHP. Both
are teachers at RMIT University in Melbourne, and have five
years web design experience.
|
