Database Design Manual: using MySQL for Windows / Edition 1

by Matthew Norman

Overview

Databases are now an integral part of the internet and many web sites use databases in the background to control their content. MySQL is one of the most commonly used open source database management systems. Due to it’s bundling with PHP, MySQL has proved a popular choice for many sites as it enables a database driven, content managed website to be set up with little or no software costs. This book will show you how to design and use databases for the web using MySQL as a tool to learn SQL. Key Topics Installing and testing MySQL SQL basics, and using SQL to communicate with databases Database design techniques and concepts Using MySQL with PHP, Apache and Perl How to make other products communicate with MySQL Features and Benefits. Gives an insight into how databases work in relation to the web. Introduces general SQL techniques by means of MySQL. Explains the concepts behind a structured query language and how it can be used to communicate with databases. Provides an introduction to database design and how an efficiently designed database can improve the performance of MySQL.

Product Details

ISBN-13:	9781849968997
Publisher:	Springer London
Publication date:	12/15/2010
Series:	Springer Professional Computing
Edition description:	Softcover reprint of the original 1st ed. 2004
Pages:	209
Product dimensions:	6.90(w) x 9.20(h) x 0.70(d)

Table of Contents

MySQL and Databases.- Installing and Testing MySQL.- How Shall We Store it? — Datatypes.- Designing and Creating Tables.- Populating the Database.- Retrieving the Data.- Joining Tables.- Changing Data.- Deleting our Data.- Aggregate Functions.- Working with Dates and Times.- Securing the Database.- Optimizing MySQL.- Sharing MySQL data with MyODBC.- MySQL with PHP, Apache and Perl.- Making life easier.

Editorial Reviews

From the reviews:

"MySQL is one of the most commonly used open source relational database management systems (RDBMS). Fully updated to include information on latest versions, this Springer book is becoming one of the most easily understandable texts on MySQL available. … Norman does a good job … . The text is liberally interspersed with examples of SQL … . Windows users who need to set up MySQL will greatly appreciate this book. … The book is a thorough, yet easy to understand resource for beginners." (Hector Zenil Chavez, Computing Reviews, December, 2004)

From the Publisher