MySQL database usage & administration /
Vaswani, Vikram
MySQL database usage & administration / Vikram Vaswani. - New York : McGraw-Hill, 2010. - xix, 348 p.: 23 cm.
Includes index
An introduction to MySQL -- Understanding basic commands -- Making design decisions -- Using joins, subqueries, and views -- Using transactions -- Using stored procedures and functions -- Using triggers and scheduled events -- Working with data in different formats -- Optimizing performance -- Performing basic server administration -- Managing users and controlling access -- Performing maintenance, backup, and recovery -- Replicating data -- Installing MySQL and the sample database.
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. - Publisher.
English
978-0-07-160549-6
MySQL (Electronic resource)
Relational databases
Client/server computing
005.7585 V44m
MySQL database usage & administration / Vikram Vaswani. - New York : McGraw-Hill, 2010. - xix, 348 p.: 23 cm.
Includes index
An introduction to MySQL -- Understanding basic commands -- Making design decisions -- Using joins, subqueries, and views -- Using transactions -- Using stored procedures and functions -- Using triggers and scheduled events -- Working with data in different formats -- Optimizing performance -- Performing basic server administration -- Managing users and controlling access -- Performing maintenance, backup, and recovery -- Replicating data -- Installing MySQL and the sample database.
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. - Publisher.
English
978-0-07-160549-6
MySQL (Electronic resource)
Relational databases
Client/server computing
005.7585 V44m