See more Amazon Details

Contents Listing

Preface
Part I. Introduction
1. MySQL
Relational Databases
The History of MySQL
MySQL Design
MySQL Features
MySQL Applications
What You Get
2. Installation
Preparation
Unix Installation
Windows Installation
3. SQL According to MySQL
SQL Basics
Database Creation
Table Management
MySQL Data Types
Indexing
Managing Data
Queries
SQL Operators
Advanced Features
4. Database Administration
Configuration
Server Startup and Shutdown
Logging
Backup
Recovery
Table Maintenance and Crash Recovery
Part II. MySQL Administration
5. Performance Tuning
An Approach to Performance Tuning
Application Tuning
Database Server Tuning
Operating System/Hardware Tuning
6. Security
Database Security
System Security
Application Security
7. Database Design
Database Design Primer
Normalization
A Logical Data-Modeling Methodology
Physical Database Design
Part III. MySQL Programming
8. Database Applications
Architecture
Connections and Transactions
Object/Relational Modeling
9. Perl
Introduction to DBI
DBI and CGI
A General Model for Maintainable Perl Programs
10. Python
DB-API
Proprietary Operations
Applied DB-API
11. PHP
Introducing PHP
Installing PHP
Accessing the MySQL DBMS with PHP
Securing User Data
Managing Sessions
Writing Data with PHP
Using the HTML