Mysql and Msql (Paperback)

Preface

I. Getting Started with MySQL and mSQL 1

1. Introduction to Relational Databases
What Is a Database?
What Is a Relational Database?
Applications and Databases
MySQL and mSQL

2. Database Design
Database Design
Normalization
A Logical Data Modeling Methodology
Physical Database Design

3. Installation
MySQL
mSQL

4. MySQL
Design
Installing MySQL
Running MySQL
Database Administration
MySQL Utilities
Performance Tuning

5. mSQL
Design
mSQL Versions
Installing mSQL
Running mSQL
Database Administration
mSQL Utilities

6. SQL According to MySQL and mSQL
SQL Basics
Creating and Dropping Tables
SQL Datatypes
Indices
Sequences and Auto-Incrementing
Managing Data
Queries
Extended Functionality

7. Other Mid-Range Database Engines
What Is 'Free'?
What MySQL and mSQL Lack
PostgreSQL
GNU SQL
Beagle
Making Comparisons

II. Database Programming 121

8. Database Application Architectures
The Client/Server Architecture
Data Processing
Object/Relational Modeling
The Three-tier Architecture

9. CGI Programming
What Is CGI?
HTML Forms
The CGI Specification
Important Considerations for CGI Scripts
CGI and Databases

10. Perl
DBI
An Example DBI Application
Msql.pm
MysqlPerl

11. Python
Basic Connectivity
Dynamic Connectivity

12. PHP and Other Support for Database-driven HTML
Alternatives for Dynamic Content on the Web
W3-mSQL
PHP
Embedded Perl

13. C and C++
The Two APIs
Object-oriented Database Access in C++

14. Java and JDBC
What Is JDBC?
Simple Database Access
Dynamic Database Access
A Guest Book Servlet

III. Reference 229

15. SQL Reference
MySQL SQL
mSQL SQL

16. MySQL and mSQL System Variables
MySQL System Variables
mSQL System Variables

17. MySQL and mSQL Programs and Utilities
MySQL Utilities
mSQL Utilities

18. PHP and Lite Reference
PHP
Lite

19. C Reference
MySQL C API
mSQL C API

20. Python Reference
Module: MySQL
Module: mSQL

21. Perl Reference
Installation
DBI.pm API
Msql.pm API
Mysql.pm API

22. JDBC Reference

Index