MySQL Database Usage & Administration (eBook - Adobe EPUB) (eBook)

Vikram Vaswani

(Author)

Write a Review

20 %

List Price: Rs.

2,692
Our Price: Rs.

2,154 ($ 40.93) (£ 24.26)
You Save: Rs.

538 (20%)

This item is Discontinued.

System Requirements for Adobe-DRM eBooks

Also Available in:

Edition	Price	Availability
Paperback 2009	2,894 2,257	In Stock. 5-7 business days

MySQL Database Usage & Administration eBook Description

Adobe EPUB eBook Rights:
Copying not allowed.
Printing allowed, unlimited pages every unlimited days.
Lending not allowed.
Reading aloud not allowed.
Never expires.

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 & 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 (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.

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

eBook Details

Title:	MySQL Database Usage & Administration
Publisher:	McGraw-Hill Professional
Author:	Vikram Vaswani
Edition:	Ebook 1 , EPUB
Language:	English
ISBN:	0071605509-BEEPB
EAN:	9780071605502-BEEPB

Deliverable Countries: This product delivers to United Arab Emirates, Antigua, Austria, Australia, Barbados, Belgium, Bahrain, Bahamas, Bhutan, Botswana, Canada, Switzerland, China, Cyprus, Czech Republic, Germany, Denmark, Dominca, Egypt, Spain, Finland, Fiji, France, United Kingdom, Grenada/Carricou, Greece, Guyana, Hong Kong, Indonesia, Ireland, Israel, India, Italy, Jamaica, Japan, Kenya, South Korea, Kuwait, Cayman Islands, Sri Lanka, Luxembourg, Monaco, Mali, Montserrat, Mauritius, Maldives, Malaysia, Netherlands, Norway, Nepal, New Zealand, Oman, Philippines, Poland, Portugal, Qatar, Yemen, Russia, Saudi Arabia, Seychelles, Sweden, Singapore, St. Kitts and Nevis, Syria, Thailand, Turkey, Trinidad and Tobago, Taiwan, United States, South Africa, Zimbabwe.