Beginning MySQL (Programmer to Programmer) | 
 enlarge | Authors: Robert Sheldon, Geoff Moes
Publisher: Wrox
Category: Book
List Price: $39.99
Buy New: $16.39
You Save: $23.60 (59%)
New (30) Used (9) from $8.48
Avg. Customer Rating:  3 reviews
Sales Rank: 259923
Media: Paperback
Edition: 1
Number Of Items: 1
Pages: 864
Shipping Weight (lbs): 2.9
Dimensions (in): 9.1 x 7.4 x 1.9
ISBN: 0764579509
Dewey Decimal Number: 005.7565
EAN: 9780764579509
ASIN: 0764579509
Publication Date: April 1, 2005
Availability: Usually ships in 1-2 business days
|
| Editorial Reviews:
Product Description
- 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 MySQL installation and configuration on either Windows or Linux
- Shows how to create a database, work with SQL, add and modify data, run queries, perform administrative tasks, and build database applications
- Demonstrates how to connect to a MySQL database from within PHP, Java, ASP, and ASP.NET applications
- Companion Web site includes SQL statements needed to create and populate a database plus three ready-to-use database applications (in PHP, Java, and ASP.NET)
|
| Customer Reviews:
 Hace honor a su titulo: BEGINNING September 30, 2008
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 August 25, 2007
0 out of 1 found this review helpful
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! August 29, 2006
3 out of 3 found this review helpful
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.
|
|
|
