[PDF] MySQL Database Usage & Administration Free Download

[message] Brief Description [PDF] MySQL Database Usage & Administration Free Download by Vikram Vaswani | Publisher : McGraw-Hill Osborn...

  • [message]
    • Brief Description
      • [PDF] MySQL Database Usage & Administration Free Download by Vikram Vaswani | Publisher : McGraw-Hill Osborne Media | Category : Computers & Internet | Tags : Mysql, Data Management, Database, Architecture, Server, Programming | ISBN-10 : 0071605495 | ISBN-13 : 9780071605496
  • [message]
    • Book Image
      • MySQL Database Usage & Administration by Vikram Vaswani, Publisher : McGraw-Hill Osborne Media
  • [message]
    • Complete Book Description
      • 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

  • [message]
    • Book Details
      • Book Name : MySQL Database Usage & Administration

        Edition : 1

        Author : Vikram Vaswani

        Publisher : McGraw-Hill Osborne Media

        Category : Computers & Internet

        ISBN-10 : 0071605495

        ISBN-13 : 9780071605496

        ASIN : 0071605495

        Pages : 368

        Language : English

        Publish Date : October 14, 2009
  • [message]
    • Purchase on Amazon

These study materials are for information purposes and completely free. If you find these study material useful please write to us in a comment box.

Disclaimer : We are not the original publisher of this Book/Material on net. This eBook/Material had been collected from other sources of net.

Thank You
The Free Study Team