| | |  | Software Engineering | Home » » » MySQL Crash Course | | | | | | | Product Promotions: | | | | | Description: | | MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual corporate databases to simple end-user applications, and everything in between. And this book will teach you all you need to know to be immediately productive with MySQL. By working through 30 highly focused hands-on lessons, your MySQL Crash Course will be both easier and more effective than you'd have thought possible. Learn how to: -
Retrieve and sort data -
Filter data using comparisons, regular expressions, full text search, and much more -
Join relational data -
Create and alter tables -
Insert, update, and delete data -
Leverage the power of stored procedures and triggers -
Use views and Cursors -
Manage transactional processing -
Create user accounts and manage security via access control Ben Forta is Macromedia's Senior Technical Evangelist, and has almost 20 years of experience in the computer industry in product development, support, training, and product marketing. Ben is the author of the best-selling Sams Teach Yourself SQL in 10 Minutes (now in its third edition, and translated into over a dozen languages), ColdFusion Web Application Construction Kit, and Advanced ColdFusion Development (both published by Que Publishing), Sams Teach Yourself Regular Expressions in 10 Minutes, as well as books on SQL, Flash, JSP, HomeSite, WAP, Windows 2000, and other subjects. | | | Product Details: | | | Author:
| Ben Forta | | Paperback:
| 336 pages | | Publisher:
| Sams | | Publication Date:
| December 22, 2005 | | Language:
| English | | ISBN:
| 0672327120 | | Product Length:
| 8.3 inches | | Product Width:
| 5.52 inches | | Product Height:
| 0.74 inches | | Product Weight:
| 0.76 pounds | | Package Length:
| 8.1 inches | | Package Width:
| 5.5 inches | | Package Height:
| 0.8 inches | | Package Weight:
| 0.7 pounds | | Average Customer Rating:
|  based on 35 reviews |
| | | | Customer Reviews: | |
Average Customer Review:
 ( 35 customer reviews )
Write an online review and share your thoughts with other customers.
Most Helpful Customer Reviews
48 of 48 found the following review helpful:
 Great Book For BeginnersMar 07, 2006
By Michael Hillyer
I've previously stated that I am glad to see good books on advanced MySQL usage appearing such as Pro MySQL, High Performance MySQL and the like. Well, now there is a book that makes be glad to see good books for beginners: MySQL Crash Course by Ben Forta.
While experienced MySQL users should steer clear of this book, MySQL Crash Course is an excellent book for the beginner. It starts right from the basics, talking about what a database is, what SQL is, what MySQL is, then hits the ground running talking about constructing queries, sorting, using functions, etc.
The book has a good, easy to read format for each section that discusses the purpose of the section, shows a sample query, its output, and an analysis. The book wisely hides the advanced details not relevant to the beginner (such as no discussion of isolation levels in the section on transactions, just the basics of BEGIN, COMMIT, ROLLBACK, etc) and sticks to the facts for the version it is targeted against (MySQL 5.0, with sections on triggers and stored procedures).
It was nice to see that the book even covers areas such as the aforementioned stored procedures and triggers, along with views and basic maintenance and performance tuning sections.
All in all, MySQL Crash Course by Ben Forta looks like an excellent book for the beginning users just getting started with MySQL and perhaps SQL in general.
18 of 18 found the following review helpful:
Simply the BestFeb 16, 2006
By Gateone Gmbh
Anyone who wants to understand MySQL MUST buy this book. Even if you're not the hard core programmer, but - like me - just "heavy uses" PHP/MySQL apps like the great "Drupal" CMS (http://www.drupal.org)! I have had quite some books on SQL, but this is the best introduction ever. Most books tend to be quite heavy on the reader, especially if you have to get to know MySQL while at the same time being busy with your every day job. This one however I started reading on a half hour plane ride, and finished off at night in front of the TV and in just that one single day I had found the key to MySQL! Go buy it!
16 of 16 found the following review helpful:
 Great for databases in general, falls apart on administriviaAug 21, 2008
By M. Sharps
If you are fairly familiar with the concept of a database, this book could very well be all you need to get going. My issue with it is that it skimps on some of the very basic stuff. For example, it never goes over the syntax of the create call for creating a database, doesn't explain calling mysql at the command prompt as a particular user, gives you 11 chapters on manipulating data before showing you how to create a table, waits for chapter 28 to mention administering users, and puts datatypes in the appendix. These are the first things I wanted to learn. By the time I was done googling these concepts, I got pretty good at mySql and knew where to find better resources. At that point, the book became a very light reference.
19 of 20 found the following review helpful:
Ben Forta is G-dSep 21, 2006
By Dude Dudeness
"Dude"
Ben Forta is easily the most readable and to-the-point technical writer I know of. He includes all the right details at the right time. Example: all the books tell you how to do selects and how to create databases and tables, but the bury the simple detail of how to CONNECT to a database. Do you have any idea how many sql books neglect this extraordinarily important point? In ben's book it's right up front. And that's only one example. Buy the book for yourself and see.
12 of 13 found the following review helpful:
True to the PromiseFeb 23, 2006
By Kevin M. Johnson
"BlaydRunner007"
Finally, a book on MySQL that actually works for the beginner. I'm a designer, not a developer. I need real world metaphors and clear definitions. Forta not only holds my hand, he speaks clearly. Excellent for those who need a "Crash Course".
See all 35 customer reviews on Amazon.com
| | |
|
