Database Design Manual: using MySQL for Windows

Matthew Norman (Autor)

Buch | Softcover

209 Seiten

2010 | Softcover reprint of the original 1st ed. 2004
Springer London Ltd (Verlag)
978-1-84996-899-7 (ISBN)

Artikel merken

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.

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.

Erscheint lt. Verlag	22.10.2010
Reihe/Serie	Springer Professional Computing
Zusatzinfo	176 Illustrations, black and white; X, 209 p. 176 illus.
Verlagsort	England
Sprache	englisch
Maße	178 x 254 mm
Themenwelt	Informatik ► Datenbanken ► MySQL
	Mathematik / Informatik ► Informatik ► Programmiersprachen / -werkzeuge
	Informatik ► Theorie / Studium ► Compilerbau
ISBN-10	1-84996-899-3 / 1849968993
ISBN-13	978-1-84996-899-7 / 9781849968997
Zustand	Neuware