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.
Customer Reviews
Average Rating:
Rating: - clear concise and comprehensive
If you are considering MySQL you may not know how, but you are not a dummy. This book is not for dummys in that it doesn't patronize nor take you into convoluted scenarios, this book is for the reasonably intelligent who want to do stuff. What a blessing.
I was familiar with databases having worked with MS Access, but I had never worked with SQL. This book hit the spot in showing me what I needed to know to get going. I am now using MySQL successfully with a Java/Struts front end. ... Read More
Rating: - I learned a lot from this book.
I had always had problems with trying to figure out how to use Sub Selects. Now I feel silly for not "getting it" quicker. This book has been a big help in me learning about the capabilities of MySQL in general.
Money very well spent.
This is also a great book for those just wanting to learn SQL. The examples are great.
Rating: - Great for databases in general, falls apart on administrivia
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 ... Read More
Rating: - Good for Beginners
As others have said, this is a great book for beginners, whether in MySQL or in databases in general. Because I have a lot of database experience, I went throught it very quickly.
When I started to apply some of the techniques I learned to existing applications, I found out VERY quickly that this is insufficient as a reference. Each topic has enough hands-on examples to give you a start, but not nearly enough depth to use for looking things up.
Rating: - A great book, easy to read, lots of information.
If MySQL will suite your needs then this book is for you. I read the book cover-to-cover in my downtime at work over a few days and walked away with a solid understanding of MySQL.
Unfortunately MySQL isn't the most mature database solution, but if it's good enough for your project, then this is a great resource.
- Great for databases in general, falls apart on administrivia
