Hace honor a su título: BEGINNING | Beginning MySQL (Programmer to Programmer)

the best reference for the biginners | Beginning MySQL (Programmer to Programmer) | Robert Sheldon, Geoff Moes

books:


	• Beginning MySQL (Programmer to Programmer) Robert Sheldon, Geoff Moes Wrox, 2005 - 864 pages average customer review:based on 3 reviews view larger image
	for more information click here

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.

for more information click here

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 .

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)

for more information click here