Publisher's Synopsis
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
