MySQL (5th Edition) (Developer's Library) (英語) ペーパーバック – 2013/4/12
Kindle 端末は必要ありません。無料 Kindle アプリのいずれかをダウンロードすると、スマートフォン、タブレットPCで Kindle 本をお読みいただけます。
MySQL, Fifth Edition by Paul DuBois
The definitive guide to using, programming and administering MySQL 5.5 and MySQL 5.6
MySQL provides a comprehensive guide to effectively using and administering the MySQL database management system (DBMS).
Author Paul DuBois describes everything from the basics of getting information into a database and formulating queries, to using MySQL with PHP or Perl to generate dynamic web pages, to writing your own programs that access MySQL databases, to administering MySQL servers. The book also includes a comprehensive reference section providing detailed information on MySQL’s structure, language, syntax, and APIs.
The fifth edition of this bestselling book has been meticulously revised and updated to thoroughly cover the latest features and capabilities of MySQL 5.5, as well as to add new coverage of features introduced with MySQL 5.6.
MySQL is an open source relational database management system (DBMS) that has experienced a phenomenal growth in popularity and use. Known for its speed and ease of use, MySQL has proven itself to be particularly well-suited for developing database-backed websites and applications. MySQL runs on anything from modest hardware all the way up to enterprise servers, and its performance rivals any database system put up against it.
Paul DuBois' MySQL, Fifth Edition, is the definitive guide to fully exploiting all the power and versatility of MySQL 5.5 and MySQL 5.6
Contents at a Glance
Part I: General MySQL Use
Chapter 1 Getting Started with MySQL
Chapter 2 Using SQL to Manage Data
Chapter 3 Data Types
Chapter 4 Views and Stored Programs
Chapter 5 Query Optimization
Part II: Using MySQL Programming Interfaces
Chapter 6 Introduction to MySQL Programming
Chapter 7 Writing MySQL Programs Using C
Chapter 8 Writing MySQL Programs Using Perl DBI
Chapter 9 Writing MySQL Programs Using PHP
Part III: MySQL Administration
Chapter 10 Introduction to MySQL Administration
Chapter 11 The MySQL Data Directory
Chapter 12 General MySQL Administration
Chapter 13 Security and Access Control
Chapter 14 Database Maintenance, Backups, and Replication
Part IV: Appendixes
Appendix A Software Required to Use This Book
Appendix B Data Type Reference
Appendix C Operator and Function Reference
Appendix D System, Status, and User Variable Reference
Appendix E SQL Syntax Reference
Appendix F MySQL Program Reference
Appendix I PHP API Reference
Paul DuBois is a writer, database administrator, and leader in the open source and MySQL communities. He has contributed to the online documentation for MySQL and is the author of MySQL and Perl for the Web (New Riders), MySQL Cookbook, Using csh and tcsh, and Software Portability with imake (O’Reilly). He is currently a technical writer with the MySQL documentation team at Oracle Corporation.
Amazon.com で最も参考になったカスタマーレビュー (beta)
The organization of the chapters is logical, proceeding from introductory to advanced topics in clearly defined stages. The author thankfully resisted the current trend of giving the chapters cutesy names that communicate nothing. The writing is clear and concise. The indexing is superb. The coverage of the subject matter is unbelievably complete, encompassing not only MySQL and general database theory, but also almost every other aspect of database programming.
In the six months I've been working with it I've never been unable to find the answer to a MySQL question in this book. Indeed, the Appendices are so good that I have found answers in here when the books I was reading on PHP and the Perl DBI turned out to be wrong.
MySQL is a very impressive achievement in all respects.
I am new to SQL and this book is something worth buying. It is written for both techies and non-techies, and if you have the desire to learn MySQL, buy this book. It is the most concise and well written book on the language ever.
Make sure you block out a chunk of time, because once you start reading, you will not put this book down. It fills the gap where other books fail. The tutorial gets you up to speed very quickly (VERY) and you will be building databases within the first 1/2 hour of opening the book. I buy an average of 5 or so books a week and I guarantee that most of them will be covered with dust before I put this book down.
If you have the desire to learn on your own and want to learn MySQL...
BUY THE BOOK! Don't wait! Sell something if you have to, get a second job. Whatever it takes, you can not be without this book!
After that I decided to buy the book, and I was very satisfied with my decision. Below I am listing several evaluative criterias that indeed make the book ( and the author, as well) the best choice available thus far:
1) Great for beginners: To understand how to keep a grade book, you don't need huge brains(I hope so). That's exactly what Paul starts his book with, and makes his way through to some RDBMS terminologies that you won't even notice.
2) From the simplest to more advanced... Such books make the learning for beginniners piece of cake, and for experienced ones a lof of fun. The book's focus is on couple of tables that you build in the first chapter, and keep manipulating throughout the book. Paul never forgets about those tables. Even in the Second section of the book (Using MySQL Programming Interfaces), he teaches you to write applications using C, Perl and PHP to manipulate them. Since you build them all together with Paul, you have more understanding of what you're doing. Of course, by the end of the book it gets advanced, which makes it the right choise for advanced programmers as well.
3) Great references Oh yes. Awesome appendixes. Listings of all the functions, keywords, syntaxes are available (in alphabetical order). Also seperate appendixes for Perl DBI API, C API and PHP API makes it even more useful
4) Easy language. This is deginitely important. Even though the books are in english, not all of them gurantee you comprehension. Sometimes you might find the lingo of the book of too high a level, or even vice versa. None of those are the cases with the MySQL book. Paul uses plain english and switches to RDBMS lingo whenever he thinks it is appropriate.
5) The book is definitely from an expert. You better don't doubt it! Since Paul is the one in charge of the official documentation, who else could tell you more about the subject?
6) Still got the gap? Let him fill it... Another thing that pleased was the fact, unlike other aUtHoRs, it is not hard to get hold of Paul in mysql mailing list. He is kind enough to answer the questions, and/or contribute to the discussions about the subject.
If you are interested with learning MySql, I want you to buy the book, because there're no other books better than this one so far. Also, support for such authors is important.
I cannot speak for a lay audience, but suspect that the tutorial will help bring anyone up to speed.
For someone who is familiar with MySQL, however cursorily, this book is perfect. It's not a question-answer format, but simply superbly written prose. There is a reference section in the back, most every topic of interest is covered. There are detailed programming interface discussions for Perl::DBI, C, and php.
If you want to install MySQL onto a box, have MySQL on a box, or want to optimize your databases and queries, buy this book.
It's the best computer 'tome' I've ever read, kudos to the author.