No Words Wasted Sale
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Original Essays | December 8, 2014

    Marina Warner: IMG How Is Fantasy Different from Fairy Tale?



    Fairy tale is a country of the mind where there are many inhabitants stretching back into deep time, and we're like people before Babel, we speak a... Continue »

    spacer

On Order

$49.99
New Trade Paper
Currently out of stock.
Add to Wishlist
Qty Store Section
- Local Warehouse Database- Design

MySQL Database Usage & Administration

by

MySQL Database Usage & Administration Cover

 

Synopses & Reviews

Publisher Comments:

Take your MySQL skills to the top tier

Maximize every powerful feature available in MySQL 5.1 with hands-on instruction from a MySQL expert. This definitive guide shows you how to use MySQL's advanced suite of data management tools, optimize performance and reliability, and secure and administer a robust RDBMS. MySQL Database Usage and Administration includes detailed code examples in each chapter to highlight real-world applications of the material covered. If you want to get the most out of MySQL, you need this practical handbook.

  • Understand MySQL's features, technical architecture, subsystems, and commands
  • Make database design decisions that optimizre performance, storage, and reliability
  • Write complex queries using joins, subqueries, and views
  • Group SQL statements into transactions and execute them atomically
  • Build and use sophisticated stored procedures and functions
  • Automate database operations with triggers and scheduled events
  • Import and export data in different formats, includiong SQL, CSV, and XML
  • Optimize server and query performance
  • Administer a secure, high availability MySQL RDBMS
  • Manage users and control access
  • Perform database maintenance, replication, backup, and recovery

Vikram Vaswani is the founder and CEO of Melonfire (www.melonfire.com), a consultancy firm with special expertise in open-source tools and technologies. His previous books include MySQL: The Complete Reference, PHP: A Beginner's Guide, and PHP Programming Solutions.

Book News Annotation:

Intended for beginners, this guide introduces MySQL's version of SQL commands for building relational databases and running queries, examines MySQL's support for server-side stored routines, and discusses built-in tools for importing and exporting data in different formats. The administration chapters explore the server status command, log files, the MySQL security and privilege system, backup and restore utilities, and replication features. The end of each chapter refers the user to trusted websites for further reading. Annotation ©2010 Book News, Inc., Portland, OR (booknews.com)

Synopsis:

The most authoritative reference on the MySQL database server. The MySQL development team will review and provide a foreword for the book.

About the Author

Vikram Vaswani is the founder and CEO of Melonfire (www.melonfire.com), a software consultancy. He is the author of PHP Programming Solutions and MySQL: The Complete Reference.

Table of Contents

Part I: Usage; Chapter 1. An Introduction to MySQL; Chapter 2. Understanding Basic Commands; Chapter 3. Making Design Decisions; Chapter 4. Using Joins, Subqueries, and Views; Chapter 5. Using Transactions; Chapter 6. Using Stored Procedures and Functions; Chapter 7. Using Triggers and Scheduled Events; Chapter 8. Working with Data in Different Formats; Chapter 9. Optimizing Performance; Part II: Administration; Chapter 10. Performing Basic Server Administration; Chapter 11. Managing Users and Controlling Access; Chapter 12. Performing Maintenance, Backup, and Recovery; Chapter 13. Replicating Data; Appendix A. Installing MySQL and the Sample Database; Index

Product Details

ISBN:
9780071605496
Author:
Vaswani, Vikram
Publisher:
McGraw-Hill/Osborne Media
Author:
Vaswani Vikram
Subject:
Non-Classifiable
Subject:
Client-server computing
Subject:
Relational databases
Subject:
Database Management - General
Subject:
Technical Skills
Subject:
MySQL, book, guide, how to, Installation, Configuration, Subqueries, Transactions, Triggers, Stored Procedures, Functions, Views, Events, Localization, Administration, Security, Privileges, Maintenance, Backup, Recovery, Optimization, Replication, Cluster
Subject:
Database design
Publication Date:
20091131
Binding:
TRADE PAPER
Grade Level:
Professional and scholarly
Language:
English
Illustrations:
Y
Pages:
348
Dimensions:
9.00x7.30x.80 in. 1.30 lbs.

Other books you might like

  1. Head First Rails: A Learner's... Used Trade Paper $7.95
  2. Beginning Mac Programming: Develop... Used Trade Paper $23.00

Related Subjects

Computers and Internet » Computer Languages » XML
Computers and Internet » Database » Design
Computers and Internet » Software Engineering » Software Management
Health and Self-Help » Health and Medicine » Medical Specialties

MySQL Database Usage & Administration New Trade Paper
0 stars - 0 reviews
$49.99 Backorder
Product details 348 pages McGraw-Hill/Osborne Media - English 9780071605496 Reviews:
"Synopsis" by , The most authoritative reference on the MySQL database server. The MySQL development team will review and provide a foreword for the book.
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.