Microsoft Word - Sam's Teach Yourself MySQL in 21 Days - SAMS.doc

Sam's Teach Yourself MySQL in 21 Days

by Mark Maslakowski^ ISBN: 0672319144

A complete course in using one of the most-popular open

source databases.

Table of Contents Colleague Comments

Back Cover (^)
(^)

Synopsis by Stan Miastkowski

For those who need a full-powered relational DBMS without the considerable
expense of well-known commercial products (such as Microsoft SQL Server),
MySQL has quickly become a favorite. This open source database is available
for virtually all platforms, including the various incarnations of Windows. But
like many open source products, its documentation is sparse. Enter Teach
Yourself MySQL in 21 Days, a book that solves the documentation dearth
problem with an effective and accessible step-by-step course in the DBMS.
No prior SQL experience is assumed so even beginners will benefit from this
book.

Table of Contents

Sams Teach Yourself MySQL in 21 Days - 3^

Introduction - 5^

Week 1 At a Glance^

Day 1^ - What Is MySQL? - 9

Day 2^ -^ Getting Started - 13^

Day 3^ -^ Designing Your First Database - 21^

Day 4^ -^ Creating Your First Database - 32^

Day 5^ -^ Making Your Data Normal - 38^

Day 6^ - Adding Tables, Columns, and Indexes to Your Database - 43

Day 7^ -^ MySQL Data Types - 50^

Week 2 At a Glance^

Day 8^ -^ Populating the Database - 58^

Day 9^ -^ Querying the Database - 71^

Day 10^ - Letting MySQL Do the Work—Intrinsic Functions - 85

Day 11^ -^ MySQL Table Locks and Assorted Keys - 93^

Day 12^ -^ How to Get the Data—Database Interfaces - 107^

Day 13^ -^ How to Use MyODBC - 111^

Day 14^ -^ The Perl Database Interface - 139^

Week 3 At a Glance^

Day 15^ -^ MySQL and PHP - 156^