Beginning MySQL

by Geoff Moes and Robert Sheldon

Book Overview

Provides programmers with a complete foundation in MySQL, the multi-user, multi-threaded SQL database server that easily stores, updates, and accesses information Offers detailed instructions for... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0764579509
• ISBN13: 9780764579509
• Release Date: April 2005
• Publisher: Wrox Press
• Length: 840 Pages
• Weight: 2.90 lbs.
• Dimensions: 1.8" x 6.8" x 9.7"

Customer Reviews

Hace honor a su título: BEGINNING

Muy buen libro trata lo esencial de MYSQL, sinceramente muy bueno para gente que empieza con MySQL. Si ya eres un usuario avanzado no te recomiendo el libro.

the best reference for the biginners

I advise every person who want to learn MYSQL to Buy this book , it's learn you the following : an introduction to database systems . an introduction to strucure query language (SQL). simple way to learn the mysql .

Great MYSQL book!

MYSQL is an open-source standard DBMS now and is a great way (free) to get yourself started in learning about web design and how to create databases. This is a great book to use a starter guide to learning MYSQL or for people who have learned some MYSQL on their own and want a guide and/or resource for learning more intermediate topics. The first thing the author goes into how to get/install/configure MYSQL whether it be on a Windows or UNIX environment. There are some differences between the two setups on the different OS so it's an important first chapter. The next chapter covers how to create a relational database while explaining good design with normalization, relationships (one to many, many to many, etc), understanding what a data model is, and showing some good database examples. Jumping into creating your tables before you understand design theory can be disastrous down the road when you realize you need to re-design your tables which can lead to hours of extra work. Then of the meat of the book (Chapters 5 - 10) goes into explaining the SQL (Structured Query Language) in how to create a table, retrieve data, update, append and delete data. The author spends a good amount of time on the basics of SQL and shows some good examples. After the basics it shoes the MYSQL specific syntax more complex queries and uses working examples for each of them. The author does a great job of going through the syntax first then shows some examples and then goes through using the new syntax in a database project as well. The rest of the book (Chapter 11 - 16) goes into administration tasks such as exporting and copying databases, managing transactions, setting up security and optimizing and performance issues. The final 3 chapters goes into using different web technologies (PHP, ASP.NET and Java) to interact with MYSQL databases and show data on a web page. A very nice change of pace that can prove helpful if you want to get into web development as well. Overall this a great book on MYSQL that really explains the important topics with some great examples.