MySQL Weekend Crash CourseTM - Softcover

Greenspan, Jay

Softcover

ISBN 10: 0764536346 ISBN 13: 9780764536342

Publisher: John Wiley & Sons, 2002

Synopsis

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.

About this title

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.

Edition details

• Publisher: John Wiley & Sons
• Publication date: 2002
• ISBN 10: 0764536346
• ISBN 13: 9780764536342
• Binding: Paperback
• Language: English
• Number of pages: 384