Skip to main content

Humanities, Social Science and Language


Digital Products


Connect®
Course management and student learning tools backed by great support.

McGraw Hill GO
Greenlight learning with the new eBook+

ALEKS®
Personalize learning and assessment

ALEKS® Placement, Preparation, and Learning
Achieve accurate math placement

SIMnet
Ignite mastery of MS Office and IT skills

McGraw Hill eBook & ReadAnywhere App
Get learning that fits anytime, anywhere

Sharpen: Study App
A reliable study app for students

Virtual Labs
Flexible, realistic science simulations

AI Reader
Encourage Discovery, Boost Understanding

Services


Affordable Access
Reduce costs and increase success

Learning Management System Integration
Log in and sync up

Content Collections powered by Create®
Curate and deliver your ideal content

Custom Courseware Solutions
Teach your course your way

Education for All
Let’s build a future where every student has a chance to succeed

Business Program
Explore business learning solutions & resources

Professional Services
Collaborate to optimize outcomes

Remote Proctoring
Validate online exams even offsite

Institutional Solutions
Increase engagement, lower costs, and improve access for your students

Evergreen
Updated, relevant materials—without the hassle.

Support


General Help & Support Info
Customer Service & Tech Support contact information

Online Technical Support Center
FAQs, articles, chat, email or phone support

Support At Every Step
Instructor tools, training and resources for ALEKS, Connect & SIMnet

Instructor Sample Requests
Get step by step instructions for requesting an evaluation, exam, or desk copy

Platform System Check
System status in real time

MySQL Database Usage & Administration

ISBN10: 0071605495 | ISBN13: 9780071605496

MySQL Database Usage & Administration
ISBN10: 0071605495
ISBN13: 9780071605496
By Vikram Vaswani

Step 1 . Download Adobe Digital Editions to your PC or Mac desktop/laptop.

Step 2. Register and authorize your Adobe ID (optional). To access your eBook on multiple devices, first create an Adobe ID at account.adobe.com. Then, open Adobe Digital Editions, go to the Help menu, and select "Authorize Computer" to link your Adobe ID.

Step 3. Open Your eBook. Use Adobe Digital Editions to open the file. If the eBook doesn’t open, contact customer service for assistance.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. 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.

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

Need support?   We're here to help - Get real-world support and resources every step of the way.

Top