MySQL Weekend Crash Course [Paperback]

Jay Greenspan (Author)

Book Description

ISBN-10: 0764536346 | ISBN-13: 978-0764536342 | Publication Date: March 15, 2002

Quickly learn MySQL -- the leading open source relational database management system! With MySQL Weekend Crash Course, you can get up to speed creating MySQL database applications in a single weekend! This book is for Web Developers and Programmers with no prior knowledge of MySQL. This crash course will help you learn how to use MySQL to get database applications to work quickly on the Web.

Editorial Reviews

From the Back Cover

Get Up to Speed on MySQL -- in a Weekend!

The big day is Monday. The day you get to show off what you know about the MySQL Open Source Database. The problem is, you're not really up to speed. Maybe it's been a while since you worked with relational databases. Maybe you're new to MySQL. Or maybe you just like a challenge. In any event, we've got a solution for you - MySQL Weekend Crash Course. Open the book Friday evening and on Sunday afternoon, after completing 30 fast, focused sessions, you'll be able to dive right in and start working with a MySQL database. It's as simple as that.

THE CURRICULUM

FRIDAY
Evening: 4 Sessions, 2 Hours
* Why MySQL?
* MySQL Installation and Post-Installation Review
* Creating Databases: Governing Principles
* Creating Databases in MySQL

SATURDAY
Morning: 6 Sessions, 3 Hours
* Viewing and Altering Databases and Tables
* Inserting, Updating, and Deleting MySQL Data
* Getting Data from MySQL, Part I: The Basic Select
* Getting Data From MySQL, Part II: Using Select with Multiple Tables
* Basic Functions in MySQL
* Date Functions in MySQL
Afternoon: 6 Sessions, 3 Hours
* Other MySQL Functions
* Beyond LIKE: Using Regular Expressions and FULLTEXT Indexes
* Transactions with MyISAM and BDB Tables
* Using InnoDB and Gemini Tables
* Working with MySQL and PHP
* MySQL and PHP: Best Practices
Evening: 4 Sessions, 2 Hours
* Using MySQL with Perl
* MySQL and Perl: Best Practices
* Optimizing MySQL Queries
* Securing MySQL, Part I: The Grant Tables
SUNDAY
Morning: 6 Sessions, 3 Hours
* Securing MySQL, Part II: Your Unix Environment
* Advanced Configuration Options
* MySQL Client Applications
* Backing Up and Exporting MySQL Data
* Tranferring and Importing Data into MySQL
* Replication
Afternoon: 4 Sessions, 2 Hours
* Diagnosing and Repairing Table Problems
* MySQL GUI Clients
* Optimizing MySQL
* Answering Remaining Questions
CD-ROM includes:
* Sample database
* Assessment software to help gauge your progress
* Links to Web resources
* phpMyAdmin
* Perl and PHP code samples

About the Author

Jay Greenspan is a writer and most recently a producer of Wired Digital's Webmonkey. He has written on PHP, ASP, and XML, and has spoken at various conferences. A Forrester's Research report listed him as a "thought leader" in the XML community. Prior to joining Webmonkey, Jay was a technical consultant, developing LANs and database-driven applications for small businesses.

Product Details

• Paperback: 420 pages
• Publisher: Wiley (March 15, 2002)
• Language: English
• ISBN-10: 0764536346
• ISBN-13: 978-0764536342
• Product Dimensions: 9.2 x 7.4 x 0.8 inches
• Shipping Weight: 1.3 pounds
• Average Customer Review: 4.0 out of 5 stars  See all reviews (2 customer reviews)
• Amazon Best Sellers Rank: #1,605,853 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

5 of 6 people found the following review helpful:

5.0 out of 5 stars Very helpful and got me started in MySQL!, September 2, 2004

By 

Gary King - See all my reviews
(REAL NAME)   

This review is from: MySQL Weekend Crash Course (Paperback)

Without this book, I would still be guessing my way through MySQL.

I would describe myself as more of a 'hands-on' web developer, so reading long, lengthy books would not be my cup of tea. Then here comes this book - and boy, did it make a difference. The way it was formatted - as stated in the title, just for a weekend (which works great because it makes you want to actually finish it in a weekend, like I did!), is great and I had the book to pace my speed for me, which I like so that I know this book won't actually take me a few months to complete like some of these bigger books.

In conclusion, I would suggest that all people to want to learn MySQL (and fast!) should pick this book up.

3.0 out of 5 stars Dated and riddled, October 15, 2009

By 

Steven K. Pfund - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: MySQL Weekend Crash Course (Paperback)

The book has fallen out of date since it was written, and MySQL is now on a later revision than is addressed by this book.
The book is also flawed by numerous typographical errors as well as sloppy editing.
That being said, the many mistakes actually helped me understand the coding better, being forced to play "Where's Waldo" looking for the inevitable error on what seemed to be every example.
The overall format was really not bad, and the book was pretty comprehensible despite the mistakes, so I gave it a couple stars back.
An updated edition paired with an editor who actually looks at the book would be in order. As it is, it is really only useful as a primer before engaging in deeper study with a more professionally produced book.