Database Design Manual: using MySQL for Windows

Matthew Norman

210 pages, parution le 23/10/2003

Ajouter à une liste

Indisponible

Résumé

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.

Written for:
Web designers, database programmers, database designers, undergraduate students

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

Caractéristiques techniques

	PAPIER
Éditeur(s)	Springer
Auteur(s)	Matthew Norman
Parution	23/10/2003
Nb. de pages	210
Format	18 x 24
Couverture	Relié
Poids	655g
Intérieur	Noir et Blanc
EAN13	9781852337162
ISBN13	978-1-85233-716-2