Skip to main content
SpringerLink
Log in

Database Design Manual: using MySQL for Windows

  • Book
  • © 2004

Overview

Authors:
  1. Matthew Norman
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Deals predominantly with MySQL based on the relatively new windows based version of MySQL lots of examples and illustrations to make it easy to use
  • Includes supplementary material: sn.pub/extras

Part of the book series: Springer Professional Computing (SPC)

  • 5921 Accesses

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 16.99 USD 84.99
Discount applied Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 159.00
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book USD 109.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (16 chapters)

  1. Front Matter

    Pages i-x
    Download chapter PDF

  2. MySQL and Databases

    Pages 1-8

  3. Installing and Testing MySQL

    Pages 9-18

  4. How Shall We Store it? — Datatypes

    Pages 19-31

  5. Designing and Creating Tables

    Pages 33-43

  6. Populating the Database

    Pages 45-54

  7. Retrieving the Data

    Pages 55-72

  8. Joining Tables

    Pages 73-86

  9. Changing Data

    Pages 87-101

  10. Deleting our Data

    Pages 103-106

  11. Aggregate Functions

    Pages 107-116

  12. Working with Dates and Times

    Pages 117-134

  13. Securing the Database

    Pages 135-149

  14. Optimizing MySQL

    Pages 151-161

  15. Sharing MySQL data with MyODBC

    Pages 163-181

  16. MySQL with PHP, Apache and Perl

    Pages 183-198

  17. Making life easier

    Pages 199-204

  18. Back Matter

    Pages 205-209
    Download chapter PDF
Back to top

Keywords

About this book

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.

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)

Bibliographic Information

  • Book Title: Database Design Manual: using MySQL for Windows

  • Authors: Matthew Norman

  • Series Title: Springer Professional Computing

  • DOI: https://doi.org/10.1007/b97536

  • Publisher: Springer London

  • eBook Packages: Springer Book Archive

  • Copyright Information: Springer-Verlag London 2004

  • Hardcover ISBN: 978-1-85233-716-2Published: 09 October 2003

  • Softcover ISBN: 978-1-84996-899-7Published: 22 October 2010

  • eBook ISBN: 978-1-85233-859-6Published: 18 April 2006

  • Edition Number: 1

  • Number of Pages: X, 209

  • Number of Illustrations: 176 b/w illustrations

  • Topics: Programming Languages, Compilers, Interpreters, Database Management

Publish with us

Policies and ethics

Back to top

Search

Navigation