MySQL Weekend Crash Course<sup><small>TM</small></sup>,9780764536342

MySQL Weekend Crash CourseTM

by
Edition: CD
ISBN13: 9780764536342
ISBN10: 0764536346
Format: Paperback
Pub. Date: 2002-01-01
Publisher(s): Wiley
List Price: $29.99

Rent Book

Select for Price
Add to Cart
There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Summary

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.

Author Biography

<b>Jay Greenspan</b> 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.

Table of Contents

PART 1: FRIDAY EVENING. Evening PO
1. Why MySQL?
2. MySQL Installation and Post-Installation Review.
3. Creating Databases: Governing Principles.
4. Creating Databases in MySQL.
Friday Evening Part Review.
PART 2: SATURDAY MORNING. PO
5. Viewing and Altering Databases and Tables.
6. Inserting, Updating, and Deleting MySQL Data.
7. Getting Data from MySQL, Part I: The Basic SELECT.
8. Getting Data from MySQL, Part II: Using SELECT with Multiple Tables.
9. Basic Functions in MySQL.
10. Date Functions in MySQL.
Saturday Morning Part Review.
PART 3: SATURDAY AFTERNOON.
11. Other MySQL Functions.
12. Beyond LIKE: Using Regular Expressions and FULLTEXT Indexes.
13. Transactions with MyISAM and BDB Tables.
14. Using InnoDB and Gemini Tables.
15. Working with MySQL and PHP.
16. MySQL and PHP: Best Practices.
Saturday Afternoon Part Review.
PART 4: SATURDAY EVENING.
17. Using MySQL with Perl.
18. MySQL and Perl: Best Practices.
19. Optimizing MySQL Queries.
20. Securing MySQL, Part I: The GRANT Tables.
Saturday Evening Part Review.
PART 5: SUNDAY MORNING.
21. Securing MySQL, Part II: Your Unix Environment.
22. Advanced Configuration Options.
23. MySQL Client Applications.
24. Backing Up and Exporting MySQL Data.
25. Transferring and Importing Data into MySQL.
26. Replication. Sunday Morning Part Review.
PART 6: SUNDAY AFTERNOON.
27. Diagnosing and Repairing Table Problems.
28. MySQL GUI Clients.
29. Optimizing MySQL.
30. Answering Remaining Questions.
Sunday Afternoon Part Review.
Appendix A: Answers to Part Reviews.
Appendix B: What's on the CD-ROM.

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.