Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
MySQL Database Usage & Administration

Buy

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

(HTML tags aren't allowed.)

Professional Application Lifecycle Management with Visual Studio 2013
Professional Application Lifecycle Management with Visual Studio 2013

Ramp up your software development with this comprehensive resource

Microsoft's Application Lifecycle Management (ALM) makes software development easier and now features support for iOS, MacOS, Android, and Java development. If you are an application developer, some of the important factors you undoubtedly consider in...

The Best Software Writing I: Selected and Introduced by Joel Spolsky
The Best Software Writing I: Selected and Introduced by Joel Spolsky

Frustrated by the lack of well-written essays on software engineering, Joel Spolsky (of www.joelonsoftware.com fame) has put together a collection of his favorite writings on the topic.

With a nod to both the serious and funny sides of technical writing, The Best Software Writing I: Selected and Introduced by Joel Spolsky is an...

Team Turnarounds: A Playbook for Transforming Underperforming Teams
Team Turnarounds: A Playbook for Transforming Underperforming Teams

How any manager can turn a struggling team into business champs

In today’s uncertain economic environment, teams are asked to do more with less. With resources stretched thin, turning around a struggling team has never been harder, and managers must work to identify and maximize whatever potential strengths a team...


As If an Enemy's Country: The British Occupation of Boston and the Origins of Revolution (Pivotal Moments in American History)
As If an Enemy's Country: The British Occupation of Boston and the Origins of Revolution (Pivotal Moments in American History)

In the dramatic few years when colonial Americans were galvanized to resist British rule, perhaps nothing did more to foment anti-British sentiment than the armed occupation of Boston. As If an Enemy's Country is Richard Archer's gripping narrative of those critical months between October 1, 1768 and the winter of 1770 when Boston was...

The Customer Loyalty Solution : What Works (and What Doesn't) in Customer Loyalty Programs
The Customer Loyalty Solution : What Works (and What Doesn't) in Customer Loyalty Programs

Database marketing is today’s most powerful tool for designing cost-effective, resource-efficient marketing and operations programs. The Customer Loyalty Solution cuts through theory and guesswork to examine how leading marketers from Lands’ End to IBM are using today’s new breed of database marketing tools to...

Yoghurt: Science and Technology, Second Edition
Yoghurt: Science and Technology, Second Edition

Yoghurt: Science and Technology is a standard work in its field for both industry professionals and those involved in applied research. Because manufacture is still, essentially, a natural biological process, it remains difficult to control the quality of the final product. Such control depends on a thorough understanding of the nature of...

©2019 LearnIT (support@pdfchm.net) - Privacy Policy