Rating:
(6 reviews)
Author: Robert Sheldon
ISBN : 0764579509
New from $22.95
Format: PDF, EPUB
Direct download links available Beginning MySQL [Paperback] Free Download from 4shared, mediafire, hotfile, and mirror link
- 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)
Books with free ebook downloads available Beginning MySQL Free Download
- Paperback: 864 pages
- Publisher: Wrox; 1 edition (April 1, 2005)
- Language: English
- ISBN-10: 0764579509
- ISBN-13: 978-0764579509
- Product Dimensions: 1.8 x 6.7 x 9.5 inches
- Shipping Weight: 2.9 pounds (View shipping rates and policies)
Beginning MySQL Free Download
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.
-
Download Link 2