| |
Get a Handle on Your Data
Whether you’re running a business, keeping track of members and meetings for a club, or just trying to organize a large and diverse collection of information, you’ll find the MySQL database engine to be a lifelong friend. And there’s no better way to make MySQL work for you than Learning MySQL. This densely packed tutorial includes detailed instructions to help you set up and design an effective database, create powerful queries using SQL, configure MySQL for improved security, and glean useful information from your data.
After covering the basics, Learning MySQL travels far into MySQL’s subtleties, including complex queries and joins, how to interact with the database over the Web using PHP or Perl, and important housekeeping such as backups and security.
Topics include:
Installation on Linux, Windows, and Mac OS X
Basic and advanced querying using SQL
User management and security
Backups and recovery
Tuning for improved efficiency
Command-line and web database applications using the PHP and Perl programming languages.
MySQL is the most popular open source database, offering the power of a fully relational database in a package that’s easy to set up and administer. Whether you’ve never touched a database or have already completed some MySQL projects, you’ll find insights in Learning MySQL that will last a career.
Saied Tahaghoghi is a senior lecturer at the RMIT University School of Computer Science and Information Technology, and he is a member of the RMIT Search Engine Group, where he supervises research on text, image, video, and code retrieval.
Hugh E. Williams is a software design engineer at Microsoft’s Windows Live Search in Redmond, Washington. He’s published over 70 research papers and holds several patents, mostly in the search engine area.
ISBN : 9788184042672
|
| |
Pages : 632
|