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.

Amazon.com® Reader Reviews (Ranked by Helpfulness)

Average Amazon.com® Rating:  Based on 25 Ratings

A Must Have Database Primer - 2009-10-17
Reviewer Rating:
I purchased this book because of the high reviews that it received from others and it has certainly lived up to those reviews. Ben Forta has a way of cutting through the details by giving concise explanations of each database statement and by providing output examples of each statement. His prose is not so terse as to leave the reader in the dark but just verbose enough to promote an understanding of the MySQL language syntax. This is an excellent book to have next to your computer whenever you need to confirm your syntax or if you need to figure out how to perform a query that may be complex. Even the size of the book is a plus (5.5 x 8 in.), as it's quite easy to thumb through and locate whatever it is you need. Just another great book from Sams Publishing.

Good, fast summary of the range of MySQL functions and processes - 2009-09-18
Reviewer Rating:
Could have had more exercises for the reader, but still, quite useful for someone looking to gain quick SQL skills. Well written and clear.

Absolutely awesome - 2009-07-30
Reviewer Rating:
Easy, complete, flows naturally and logically. This book took me from a total noob to a fairly confident MySQL user in about three weeks. Don't be intimidated that everything is done on the command line, as I initially was... it's the only way to learn MySQL, even if you never use the command prompt again.

Excellent MySQL guide - 2009-07-21
Reviewer Rating:
This book does a great job of presenting both basic concepts that aid in understanding how mySQL works and practical tips and instructions to get you started. Also, it's not a ridiculously huge brick of a book. You can stick it in your bag and bring it with you to read on the train...

My SQL Bible - 2009-05-04
Reviewer Rating:
I have been in the business of sql/Mysql for some time, and in the journey, I have accumulated a plethora of books. But the queen of all books is this simple unassuming book.

For revision and refreshing my memory I come back to this book again and again. Why is this book so dear to me? because it has a very simple and logical style. Words are not wasted, there is a respect for your time.

To me it is the Bible of SQL. I will always keep this book.

A resounding 5 Stars, Congratulations Mr Forta.

Browse Similar Topics

Top Level Categories:
Databases

Sub-Categories:
Databases > MySQL