MySQL Database Usage & Administration
- Length: 368 pages
- Edition: 1
- Language: English
- Publisher: McGraw-Hill Osborne Media
- Publication Date: 2009-10-14
- ISBN-10: 0071605495
- ISBN-13: 9780071605496
- Sales Rank: #1102713 (See Top 100 Books)
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 & Administrationincludes 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.
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
A: Installing MySQL and the Sample Database
Donate to keep this site alive
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.