- Paperback: 752 pages
- Publisher: Prentice Hall; 1 edition (2 Nov 2001)
- Language English
- ISBN-10: 0130661902
- ISBN-13: 978-0130661906
- Product Dimensions: 23.4 x 18 x 3.4 cm
- Amazon Bestsellers Rank: 1,974,602 in Books (See Top 100 in Books)
- See Complete Table of Contents
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details. |
Product details |
More About the Author
Product Description
Product Description
This book introduces the reader to the MySQL Open Source database system and focuses on programming in the SQL language that is at the core of MySQL.
From the Back Cover
The comprehensive, code-rich MySQL guide for expert developers.
- Contains in-depth explanations and example code for designing and building enterprise-level systems
- Includes advanced coverage of security, data storage, optimization, distributed databases, and other complex topics
- Presented by leading open-source expert Leon Atkinson—author of the best-selling Core PHP Programming
Experienced developers worldwide are choosing MySQL as a low-cost, open-source foundation for their key Web applications. Now, here's a book that gives them all the code and insight they need to build enterprise-class MySQL applications—fast.
Core MySQL starts by introducing the fundamentals of MySQL: SQL queries, database design, normalization, transactions, and concurrency. It then systematically reviews each of MySQL's most important features, and presents efficient techniques for interacting with MySQL databases directly from C, Java, PHP, Perl, Python, and other programming environments. Coverage includes:
- Installing and interacting with MySQL—including a detailed introduction to MySQL's SQL implementation
- Data types, variables, column types, built-in functions, and command-line utilities
- Comprehensive coverage of using MySQL's C API
- MySQL administration, backup, and disaster recovery
- Application optimization and security
- Distributed database development
- Extending MySQL with added functionality
- Building databases that can be transitioned to other database platforms
Thoroughly reviewed by MySQL lead developer Michael Widenius, Core MySQL gives professionals exactly what they've been searching for: an authoritative, thorough, example-rich guide to enterprise-class MySQL application development.
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Reviews
There are no customer reviews yet on Amazon.co.uk.
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
8 reviews
10 of 10 people found the following review helpful
Fine reference book. But only covers basics
2 July 2002
Format:Paperback
If you are new to both the SQL language and MySQL database, this is the book
for you. Or if you are a MySQL developer wanting to have a desk reference of
SQL statements, MySQL command line utility usages and MySQL data access APIs,
this book can also serve you. But if you are a seasoned developer wanting to
learn special tricks and techniques in administrating and managing MySQL
database servers, this book will be a disappointment. One of the major
weaknesses of this book is the lack of well thought of, ready to use examples.
for you. Or if you are a MySQL developer wanting to have a desk reference of
SQL statements, MySQL command line utility usages and MySQL data access APIs,
this book can also serve you. But if you are a seasoned developer wanting to
learn special tricks and techniques in administrating and managing MySQL
database servers, this book will be a disappointment. One of the major
weaknesses of this book is the lack of well thought of, ready to use examples.
The book started from a general introduction to what is database powered
applications and various types of databases. The author also discussed how
relational database and the SQL query language fit into the big picture. But
most of this stuff is well known to developers with proper computer science
background.
Then the author spend more than 150 pages documenting MySQL references such as
data types and SQL statements usages. Those references are readily available
from the MySQL online documentation or any other decent SQL text books. The
next two chapters in this section addresses MySQL command line utilities for
database administration and the C API for MySQL internal functions. The author
could have given handy examples on how to use those utilities and APIs in real
world applications. But instead, the book copied from MySQL documentation and
made itself only a reference book.
Part 3 of the book addressed how to access MySQL from outside applications.
The author discussed APIs for C, Java, VB/ODBC, PHP, Perl, Python and MySQL++.
But for each language, there is only "Hello World" type of introductions.
For readers who want to use those APIs in real world applications, further
research and readings are required.
Part 4 "Advanced Topics" is probably the best section of this book. The
author discusses interesting topics such as storage formats, disaster recovery,
optimization, distributed systems and object mapping.
4 of 4 people found the following review helpful
MySQL and JavaBeans
19 Mar 2002
Format:Paperback
.... Connecting from a different machine is covered just fine in the book. A simple matter of the URL and port 3306.
The book was a great help in configuring MySQL in a J2EE environment. This is easily the best book out at this time. Looks like some other references are coming soon which may turn out to be better. However, as of this writing, I couldn't have succeeded with the JavaBean config without Core MySQL.
2 of 2 people found the following review helpful
Easy and quick to understand; needs real examples
25 Jun 2002
Format:Paperback
It is very good at covering the "core" of MySQL and gives an introduction to relational databases in general (the relational model, SQL, normalization, etc.).
My personal opinion is that Atkinson should have assumed the reader was already familiar with the relational model and spent more book space on MySQL. Atkinson's info on relational databases is decent but lacks depth and takes away space that could be used to give real examples of the uses of MySQL.
I'm giving this book a five star because I feel the other reviewers were unfair.
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
