Ebook: Database Design Manual: using MySQL for Windows

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.

---

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.

---

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.
Content:
Front Matter....Pages i-x
MySQL and Databases....Pages 1-8
Installing and Testing MySQL....Pages 9-18
How Shall We Store it? — Datatypes....Pages 19-31
Designing and Creating Tables....Pages 33-43
Populating the Database....Pages 45-54
Retrieving the Data....Pages 55-72
Joining Tables....Pages 73-86
Changing Data....Pages 87-101
Deleting our Data....Pages 103-106
Aggregate Functions....Pages 107-116
Working with Dates and Times....Pages 117-134
Securing the Database....Pages 135-149
Optimizing MySQL....Pages 151-161
Sharing MySQL data with MyODBC....Pages 163-181
MySQL with PHP, Apache and Perl....Pages 183-198
Making life easier....Pages 199-204
Back Matter....Pages 205-209

---

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.
Content:
Front Matter....Pages i-x
MySQL and Databases....Pages 1-8
Installing and Testing MySQL....Pages 9-18
How Shall We Store it? — Datatypes....Pages 19-31
Designing and Creating Tables....Pages 33-43
Populating the Database....Pages 45-54
Retrieving the Data....Pages 55-72
Joining Tables....Pages 73-86
Changing Data....Pages 87-101
Deleting our Data....Pages 103-106
Aggregate Functions....Pages 107-116
Working with Dates and Times....Pages 117-134
Securing the Database....Pages 135-149
Optimizing MySQL....Pages 151-161
Sharing MySQL data with MyODBC....Pages 163-181
MySQL with PHP, Apache and Perl....Pages 183-198
Making life easier....Pages 199-204
Back Matter....Pages 205-209
....