MySQL Tutorial

by Welling, Luke; Thomson, Laura

• ISBN13: 9780672325847
• ISBN10: 0672325845
• Edition: 1st
• Format: Paperback
• Copyright: 2003-11-24
• Publisher: MySQL Press

Summary

bull; Written in a timeless tutorial style by the best-selling authors of PHP and MySQL Web Development. bull; Carefully organized and thoughtfully written to effortlessly guide the reader through the fundamentals of using, programming and administering MySQL databases. bull; Authors are skilled instructors, with a reputation for clear explanations of difficult concepts.

Author Biography

Luke Welling is a lecturer in the School of Computer Science and Information Technology at RMIT University in Melbourne, Australia. He chooses to use Open Source software whenever practical and evangelizes the advantages of this approach as widely as possible. He has spoken to audiences in Australia, North America, and Europe about MySQL, PHP, and other Open Source topics. He has taught a wide variety of technical topics to university students and professionals, but he specializes in Internet-related topics.

Laura Thomson is a lecturer in the School of Computer Science and Information Technology at RMIT University in Melbourne, Australia. She has taught a wide variety of courses with a Web and Internet focus and is currently completing a Ph.D. in Web Mining. She speaks at conferences around the globe and has delivered training at organizations as diverse as Ericsson and Lonely Planet. Previously, Laura has worked for Telstra and the Boston Consulting Group. She holds a first-class honors degree in Computer Systems Engineering and a degree (with distinction) in Computer Science. In her spare time, she rides her horses, feeds her menagerie of animals, and occasionally speaks to Luke about something nontechnical.

Table of Contents

Introduction

MySQL Basics

Installing MySQL

Quick Tour

Designing and Creating Databases with MySQL

Database Design Crash Course

Creating Databases, Tables and Indexes

Using MySQL

Inserting, Deleting, and Updating Data

Querying MySQL

Advanced Queries

Using MySQL Built-in Functions with SELECT

MySQL Table Types and Transactions

Understanding MySQL's Table Types

Using Transactions with InnoDB Tables

Administering MySQL

Managing User Privileges

Configuring MySQL

Administering Your Database

Backup and Disaster Recovery

Securing Your MySQL Installation

Replicating Your Database

Optimizing MySQL

Optimizing Your MySQL Server Configuration

Optimizing Your Database

Optimizing Your Queries

Index

Table of Contents provided by Publisher. All Rights Reserved.