JDBC(TM) API Tutorial and Reference: Universal Data Access for the Java(TM) 2 Platform (2nd Edition) Review

Average Reviews:

(More customer reviews)Are you looking to buy JDBC(TM) API Tutorial and Reference: Universal Data Access for the Java(TM) 2 Platform (2nd Edition)? Here is the right place to find the great deals. we can offer discounts of up to 90% on JDBC(TM) API Tutorial and Reference: Universal Data Access for the Java(TM) 2 Platform (2nd Edition). Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

JDBC(TM) API Tutorial and Reference: Universal Data Access for the Java(TM) 2 Platform (2nd Edition) ReviewThe full database connectivity and usage of the Java language is covered. With excellent code samples that appeal to all levels of programmers. I have used it to develope an inhouse delivery system and I am not a professional programmer. Very up to date with coverage of all the latest features of the API and what is due soon. EXCELLENT.JDBC(TM) API Tutorial and Reference: Universal Data Access for the Java(TM) 2 Platform (2nd Edition) OverviewThis book provides the definitive description of the JDBCaA AAPI, the technology that enables universal data access for the JavaaA Aprogramming language. This new edition has been updated and expanded to cover all of the JDBC 2.0 API, including the JDBC 2.0 core API and the JDBC Standard Extension API, the package that facilitates building server-side applications.Containing in-depth explanations that go beyond the specification, this complete resource pairs a step-by-step tutorial with a comprehensive reference to all of the classes and interfaces.For those new to Java technology, the book includes an introduction to the Java programming language and to SQL. It builds on this basic knowledge to walk you through creating a JDBC application-from setting up a database and establishing a connection to retrieving values from result sets and using prepared statements. In addition, the authors provide many examples along the way that demonstrate how to execute common tasks. The book proceeds to more advanced topics, focusing on the new features of the JDBC 2.0 API, including scrollable and updatable result sets, batch updates, SQL3 data types, custom mapping, and more.You will also find an introduction to working with the JDBC metadata API as well as information on rowsets, the technology that makes it possible to handle data sets from any source such as JavaBeansaA Acomponents.From array to XADataSource, a useful alphabetical reference provides concise but complete information on each class and interface in the JDBC API. Each entry includes an overview as well as a list and explanation of the methods and fields.A chapter on mapping SQL types and types in the Java programming language, a summary of the new JDBC 2.0 features, and a glossary complete this indispensable resource for all database programmers. 0201433281B04062001

Want to learn more information about JDBC(TM) API Tutorial and Reference: Universal Data Access for the Java(TM) 2 Platform (2nd Edition)?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Oracle SQL High-Performance Tuning with CDROM Review

Average Reviews:

(More customer reviews)Are you looking to buy Oracle SQL High-Performance Tuning with CDROM? Here is the right place to find the great deals. we can offer discounts of up to 90% on Oracle SQL High-Performance Tuning with CDROM. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Oracle SQL High-Performance Tuning with CDROM ReviewIf the idea of slow database response scares you, this is a good place to start. You hear "tuning a database" a lot, but most of it comes too late. There are some queries that no disks, no CPU, and no amount of memory can speed up. Guy Harrison (well named) is expert on tuning SQL, and knows how to write about it in a way that makes it easy for you to benefit.
Besides giving you lots examples of how SQL and PL/SQL can work well, Guy shows you how to use the tools (explain plan, SQL*Trace, Tkprof) that let you know when you are getting close. Actually, he points out that you need to set performance goals early on, and keep testing to see if you are on track; if you don't do that early, it may be too late when you realize you need help. One of my favorite sections is on tuning joins and sub-queries and the accompanying graph showing 197,664 block gets if you do it wrong (wrong index), and 45 if you do it right (using pl/sql instead of correlated subqueries).
The title of this review aside, Guy has good sections on tuning an instance, looking at instance settings and hardware, that can be helpful if you get the application working well and still have slow response times, but most of the chances to have an application that works are available during planning and development, and this book defintely helps there. If you like working with Oracle, and want to know more, you will benefit from this book.Oracle SQL High-Performance Tuning with CDROM Overview61423-0 The complete developer's guide to optimizing Oracle SQL code. Optimizing SQL code is the #1 factor in improving Oracle database performance. Yet most guides to Oracle tuning virtually ignore SQL. Until now. Oracle SQL High-Performance Tuning zeroes in on SQL, showing how to achieve performance gains of 100% or more in many applications. Expert Oracle developer Guy Harrison presents a detailed overview of SQL processing, and then introduces SQL tuning guidelines that improve virtually any application. Learn how to:*Choose execution plans. *Work with joins. *Search for nulls and ranges. *Trace SQL statement execution. *Build indexes that support efficient queries. *Optimize virtually all type of SQL including: views, hierarchical queries, table scans, GROUP BY, updates, subqueries, distributed SQL, and more.As databases grow, and ad hoc queries to data warehouses increase, optimizing SQL becomes even more critical. Harrison offers practical guidance on using Oracle's parallel query facility for large-volume queries, and shows when to use Oracle's PL/SQL instead of standard SQL.The book is replete with examples, showing poorly tuned SQL, how to fix it-and specific performance measurements collected on a wide range of computer hardware, from high-end UNIX SMP hosts to 486 laptops running Personal Oracle.The CD-ROM contains an extraordinary collection of Oracle SQL tuning tools, including:*A complete freeware Tuning Toolkit for generating SQL execution plans in a Windows environment, and for monitoring server load and efficiency. *Trial versions of the SQLab tuning environment, Precise/SQL tuning tools, and SQL Navigator development environment. *Full-function 90-day trial versions of Personal Oracle for Windows 3.1 and Windows 95.If your Oracle applications must deliver supercharged performance, you can't afford to be without Guy Harrison's Oracle SQL High-Performance Tuning.

Want to learn more information about Oracle SQL High-Performance Tuning with CDROM?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Pro Active Record: Databases with Ruby and Rails (Expert's Voice) Review

Average Reviews:

(More customer reviews)Are you looking to buy Pro Active Record: Databases with Ruby and Rails (Expert's Voice)? Here is the right place to find the great deals. we can offer discounts of up to 90% on Pro Active Record: Databases with Ruby and Rails (Expert's Voice). Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Pro Active Record: Databases with Ruby and Rails (Expert's Voice) ReviewRight at the start of Pro Active Record the authors address a possible problem some may have with it: that there's not enough in Active Record to warrant a full book. They point out that the basics are well covered as sections elsewhere but that this is the first book to really dig into working with legacy schema and other `advanced' uses. That's fair enough, but after reading the book I am still left with the question of why, then, they dedicate the first half to covering ActiveRecord's most basic concepts?
Judging from postings on the rails email list, there's certainly a lot of confusion about ActiveRecord, associations, observers, how to work with legacy table names and primary keys, and so on. But in a book with a title prefix of "Pro" I was expecting to jump straight into the nitty gritty of topics like compound/composite primary keys and performance tuning, probably with some real world examples, and maybe with a serious exploration of AR's internals. As it is, such topics only get a quick treatment in the final chapter (the compound/composite primary keys section is a paragraph referring users to a plugin).
It's almost always instructive reading other developers' code and it would be unfair to claim that I didn't spot a couple of tips that may prove useful, but they were passing things. And sometimes I found myself wondering what happened to the tech review process, particularly in the coverage of the has_one association, where not only is the variable naming confusing, but they seem to be calling the each method on a single ActiveRecord instance.
I'm left wondering what the audience is for this book. The title and blurbs suggest it's pitched at people who want to go deeper into ActiveRecord than they have before, but the content is better suited for someone with some database experience who wants to pick up ActiveRecord to write some scripts. As it is, if you've worked with ActiveRecord before your time will be better spent writing plugins and exploring the internals for yourself, and if you've not you'll get most of the same material from a decent Rails book and some time exploring.
Disclaimer: I was sent a copy of this book for review by the publisher.Pro Active Record: Databases with Ruby and Rails (Expert's Voice) OverviewDespite it's less than catchy name, ActiveRecord is a key part of the "magic" that makes Ruby on Rails such a hit. Without ActiveRecord, there would be no Rails. ActiveRecord is the connection between a Rails application and its data. Ruby and Ruby on Rails developers who want to exploit all the features of Ruby, of Rails, of their chosen database must learn ActiveRecord.Pro ActiveRecord for Ruby picks up with ActiveRecord where most books on Ruby and the Rails framework leave off. Readers begin by learning about all the built-in assumptions that make it so wondrously easy to create freshly-built Rails applications from scratch. Next, readers learn how to adapt ActiveRecord to work with databases - and this includes just about all preexisting databases - that were designed without those assumptions in mind. Readers go on to learn how to tie ActiveRecord in with database-specific features such as stored procedures and large objects, how to migrate legacy database designs to work better with ActiveRecord, and how to extend ActiveRecord to provide new and innovative database functionality to their applications. Readers who absorb the knowledge given in this book will have a significant competitive advantage over those with only a superficial knowledge of the topic.

Want to learn more information about Pro Active Record: Databases with Ruby and Rails (Expert's Voice)?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Joe Celko's SQL for Smarties: Advanced SQL Programming Second Edition (The Morgan Kaufmann Series in Data Management Systems) Review

Average Reviews:

(More customer reviews)Are you looking to buy Joe Celko's SQL for Smarties: Advanced SQL Programming Second Edition (The Morgan Kaufmann Series in Data Management Systems)? Here is the right place to find the great deals. we can offer discounts of up to 90% on Joe Celko's SQL for Smarties: Advanced SQL Programming Second Edition (The Morgan Kaufmann Series in Data Management Systems). Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Joe Celko's SQL for Smarties: Advanced SQL Programming Second Edition (The Morgan Kaufmann Series in Data Management Systems) ReviewFirst of all, I couldn't recommend this book for beginners. It is, however, PERFECT for the SQL programmer with some experience who is looking to take his/her SQL abilities to the next level. There are great pure SQL solutions for problems that many programmers think must be done outside of SQL in a host language. One of the most important lessons from the book is this: think in terms of sets and set theory instead of in terms of columns and rows. Lots of other great info though. Be warned: the examples are all written in the SQL-92 ANSI standard. Examples will have to be modified if your vendor-specific implementation of SQL doesn't follow the standard precisely. Kudos to Joe.Joe Celko's SQL for Smarties: Advanced SQL Programming Second Edition (The Morgan Kaufmann Series in Data Management Systems) Overview

Want to learn more information about Joe Celko's SQL for Smarties: Advanced SQL Programming Second Edition (The Morgan Kaufmann Series in Data Management Systems)?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

The Definitive Guide to SQLite Review

Average Reviews:

(More customer reviews)Are you looking to buy The Definitive Guide to SQLite? Here is the right place to find the great deals. we can offer discounts of up to 90% on The Definitive Guide to SQLite. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

The Definitive Guide to SQLite ReviewMike Owens started writing about SQLite in Linux Magazine and C/C++ User's Journal, and he continues to show his clear and easy manner of explaining the features and use of this embedded database in this book, which Apress binds as a hardcover to show off its usefulness and longevity.
I run away from most books with "Definitive" in the title, especially when they aren't heavy enough to break toes if I drop them on my foot. However, the author doesn't waste any space or get distracted with long explanations. In the 440 pages, he effectively covers all of SQLite, including its various language bindings and APIs. Although he created the initial Python bindings, Perl gets the most coverage (if you don't count the third of the book that talks about the C API for completely embedding SQLite into your own programs).
The front of the book covers basic database concepts. At times the subject matter gets a bit complicated, but the author has a clear style and easily explains the tough subjects. Without his command of the topic (as you'll find lacking with many database books), the explanations could have spun wildly out of control, taking the author for a ride. There's no question who's in charge here, though.
I've been using SQLite for a couple years and regularly delve into its documentation, and even I learned several things from this book. The handy SQL reference will keep me from waiting for websites to load, and I expect to have this book close at hand when I'm working with SQLite. It's one of the best database books I've encountered in a long time.
If you need a book on SQLite, The Definitive Guide to SQLite is the only one you should even consider.The Definitive Guide to SQLite OverviewThese days, applications are expected to efficiently manage an ever growing range of data. Yet it's rarely practical to embed a traditional relational database such as Oracle or MySQL within an application, due to not only size constraints but also because of the additional administrative overhead these databases require. While embeddable databases are small enough to ensure little additional total increase in application size, they often have little to offer by way of capabilities and power. So what's a developer to do?For many, the answer is SQLite (http://www.sqlite.org/), an open source embeddable database with an amazingly small footprint (less than 250 Kb) but packing a powerful array of features. Capable of handling databases as large as 2 terabytes, SQLite offers a flexible set of datatypes, the ability to perform transactions, and is supported by languages such as C, PHP, Perl, and Python. Furthermore, because SQLite's databases are completely file-based, privileges are granted at the operating system-level, allowing for easy and fast user management.The Definitive Guide to SQLite is the first book to devote complete coverage to the latest version of this powerful database. Offering experienced database developers a thorough overview of its capabilities and APIs, yet cognizant of newcomers who may be making their first foray into the database environment with SQLite, this book acts as both an ideal tutorial and reference guide.

Want to learn more information about The Definitive Guide to SQLite?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

SQL Built-In Functions and Stored Procedures: The i5/iSeries Programmer's Guide Review

Average Reviews:

(More customer reviews)Are you looking to buy SQL Built-In Functions and Stored Procedures: The i5/iSeries Programmer's Guide? Here is the right place to find the great deals. we can offer discounts of up to 90% on SQL Built-In Functions and Stored Procedures: The i5/iSeries Programmer's Guide. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

SQL Built-In Functions and Stored Procedures: The i5/iSeries Programmer's Guide ReviewThis book concentrates on using the IBM mid-range computer systems with DB2 as the database.
SQL, is usually thought of as simply a bunch of commands used to manipulate data in a database. Most books talk about the big three SQL commands of SELECT, INSERT, and UPDATE as being just about all that SQL can do.
In reality, the "L" stands for "Language" and the full fledged SQL's in the big databases are full fledged languages. Like other languages, they have logic, loops, functions, and internal variables just like other languages.
While SQL is a standard, each implementation does things just a bit differently. This small book gives a very quick overview of the standard commands like SELECT, but spends most of its pages on doing stored procedures the IBM way.SQL Built-In Functions and Stored Procedures: The i5/iSeries Programmer's Guide OverviewStored procedures and built-in functions can greatly expand the power and usefulness of SQL, but surprisingly these highly useful tools remain untapped by many programmers. For programmers who are new to the subject or those who want to expand on what they already know, this book provides a terrific introduction to the creation and use of built-in functions and stored procedures under OS/400 and i5/OS. But what are they?Built-in functions are a part of practically every programming language and can be a big boost to productivity by identifying and isolating functions that need to be executed repeatedly. SQL makes particularly good use of its built-in functions. Stored procedures are programs that can be called from within SQL—and other programming languages, such as RPG—to process entire datasets. This book will put you on the fast track to using and writing both effectively.After you learn the basics of these powerful tools, you?ll go on to explore some of the stored procedures and functions included with SQL on the iSeries as part of OS/400 and i5/OS. Author Mike Faust even explains the process of developing custom built-in functions for your own use and has included a stored procedure that can be used to create a crosstab or pivot table representation of supplied data.This book is the tool you need to boost the power of your i5/OS SQL programming skills.With SQL Built-In Functions and Stored Procedures, you will:– Discover how to perform routine maintenance functions, such as copying a file or rebuilding an existing table without losing the data in the existing table.– Learn how to build data files, modify a library list, and compile programs.– Practice using example programs that not only teach, but also make excellent additionsto any programmer's library.– Learn how to use 11 different functions, including functions to edit numeric values for print with commas, decimal points, and currency symbols; a function that returns the distance in miles between two ZIP codes; functions to convert date and currency to a text string and more.– Gain access to complete code on the Web for each function, which you can use directly in your own programs.

Want to learn more information about SQL Built-In Functions and Stored Procedures: The i5/iSeries Programmer's Guide?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Rapid GUI Programming with Python and Qt (Prentice Hall Open Source Software Development) Review

Average Reviews:

(More customer reviews)Are you looking to buy Rapid GUI Programming with Python and Qt (Prentice Hall Open Source Software Development)? Here is the right place to find the great deals. we can offer discounts of up to 90% on Rapid GUI Programming with Python and Qt (Prentice Hall Open Source Software Development). Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Rapid GUI Programming with Python and Qt (Prentice Hall Open Source Software Development) ReviewFor any open source programming tool, there are always those who are quick to point out that free online documentation is of excellent quality and that a commercially published book adds questionable value. Indeed, the open process by which open source tools are made, which reveals the why's & wherefore's of the internal workings to anyone who looks, leads directly to the production of excellent online documentation; this is one of the great strengths of open source software. But everyone's needs are different. A college student or free software volunteer often has looser deadlines, less budget, and a more perfectionist attitude than, for example, a non-expert programmer, working in industry, trying to expeditiously solve a specific problem. A book of this genre is intended mainly for the latter audience, whereas the former may be disappointed at spending $50 when a web browser could have done the job. Cash-strapped college students, I know your pain; I used to be one. This book is not a particularly cost-effective study aid. If you live and breathe GUI progamming and can type out GTK2 and wxwidget classes by heart, then this book is probably a waste of time for you.
Having said that, I review this book with a view toward its value to its intended audience: Does buying this book and using it get the job done $50 cheaper, including the value of your own professional time, compared to the best available alternative? My experience is yes.
I am an electrical engineer, but not a programming expert. I have, at various times in my career, flipped bits in assembly language, suffered the rigors of Fortran, and slapped together contraptions in Matlab, VEE, Labview, etc. I have also had the misfortune of programming production test automation in Visual Basic, because that is what commercial instruments natively support. It is the shortcomings of VB that bring me to PyQT. I need to write test code that is portable, maintainable, and reliable. To give just one example, I don't want to fly across the Pacific Ocean to program workarounds for bugs in VB, because machines in the Chinese factory run Win98, and my development system in the US runs Win2k, and VB doesn't behave the same. But this is a book review, not a place to extol the virtues of PyQT nor criticize VB.
I have programmed in Python before, though for me Python has always been a language for one-off numerical or string processing tasks, where a spreadsheet is too limited and my bash script-fu is short of the task. I found the first three chapters on Python a helpful review, though it is not a complete instruction in Python. Compete beginners to Python will probably want to buy a separate book or work through the python.org tutorials. The author glosses over things that could trip up beginners; tellingly, he uses the term 'pythonic' without introduction. He is, however, careful to point out pitfalls that can waylay real-world production code, or would be of interest to experienced Perl/Ruby/VB programmers, like how Python handles the distinctions regarding {im}mutable types and {deep|shallow} copying.
I have never programmed QT before, and this book is indeed a complete introduction to QT. You don't need to know anything about QT nor how to program in C++ (QT's native language). Being able to read C++ syntax helps, though, because this book is not a QT reference, so you will probably have to look things up in the online QT references, which are written in C++.
It is something of a truism that the best way to learn a language is to read & understand someone else's well-written code, and then use that to write a program of your own. That is the approach used here, and the printed book format permits interleaving fragments of code with explanatory material in a way that doesn't work well on a computer screen. As such the text complements rather than duplicates the online documentation.
Regarding the book as a physical object, the quality is good but some extra features would have been nice. No CD is included, which I consider an oversight for a book at this price. Even the shortest examples lack source code listings, except as snippets woven into the text. You have to download the example code from a URL buried in the introduction, which is odd considering how important the example code is to this style of instruction. Occasional sidebar topics, icons, and cross-references help to organize the material, though not to the spoon-feeding level of "For {Dummies|Idiots}" books. The index is a bit above average for a book of this type, better than pure machine-generated grep output that sometimes passes for an index these days, but not as good as the best manual indices of decades past. The cover, binding, & paper stock are of decent quality. The book will stay open to just about any page when laid on a table, and the glue looks like it will, well probably, hold the sheaves in for many years. No color is used, nor edge printing to help find the chapters, which would have been helpful for a book this long.Rapid GUI Programming with Python and Qt (Prentice Hall Open Source Software Development) Overview
The Insider's Best-Practice Guide to Rapid PyQt 4 GUI Development
Whether you're building GUI prototypes or full-fledged cross-platform GUI applications with native look-and-feel, PyQt 4 is your fastest, easiest, most powerful solution. Qt expert Mark Summerfield has written the definitive best-practice guide to PyQt 4 development.

With Rapid GUI Programming with Python and Qt you'll learn how to build efficient GUI applications that run on all major operating systems, including Windows, Mac OS X, Linux, and many versions of Unix, using the same source code for all of them. Summerfield systematically introduces every core GUI development technique: from dialogs and windows to data handling; from events to printing; and more. Through the book's realistic examples you'll discover a completely new PyQt 4-based programming approach, as well as coverage of many new topics, from PyQt 4's rich text engine to advanced model/view and graphics/view programming. Every key concept is illuminated with realistic, downloadable examples—all tested on Windows, Mac OS X, and Linux with Python 2.5, Qt 4.2, and PyQt 4.2, and on Windows and Linux with Qt 4.3 and PyQt 4.3.

Coverge includes

Python basics for every PyQt developer: data types, data structures, control structures, classes, modules, and more

Core PyQt GUI programming techniques: dialogs, main windows, and custom file formats

Using Qt Designer to design user interfaces, and to implement and test dialogs, events, the Clipboard, and drag-and-drop

Building custom widgets: Widget Style Sheets, composite widgets, subclassing, and more

Making the most of Qt 4.2's new graphics/view architecture

Connecting to databases, executing SQL queries, and using form and table views

Advanced model/view programming: custom views, generic delegates, and more

Implementing online help, internationalizing applications, and using PyQt's networking and multithreading facilities


Want to learn more information about Rapid GUI Programming with Python and Qt (Prentice Hall Open Source Software Development)?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

SQLite Review

Average Reviews:

(More customer reviews)Are you looking to buy SQLite? Here is the right place to find the great deals. we can offer discounts of up to 90% on SQLite. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

SQLite ReviewThis is an old book, and doesn't cover the newer SQLite 3.x information.SQLite OverviewSQLite is a small, fast, embeddable database.What makes it popular is the combination of the database engine and interface into a single library as well as the ability to store all the data in a single file.Its functionality lies between MySQL and PostgreSQL, however it is faster than both databases.In SQLite, author Chris Newman provides a thorough, practical guide to using, administering and programming this up-and-coming database.If you want to learn about SQLite or about its use in conjunction with PHP this is the book for you.

Want to learn more information about SQLite?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Oracle Database 10g PL/SQL Programming Review

Average Reviews:

(More customer reviews)Are you looking to buy Oracle Database 10g PL/SQL Programming? Here is the right place to find the great deals. we can offer discounts of up to 90% on Oracle Database 10g PL/SQL Programming. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Oracle Database 10g PL/SQL Programming ReviewThe book is a large survey of the PL/SQL language and introduces many new things that have changed with 10g. But there is a major problem with the book, which runs throughout almost all Oracle Documentation.
The book is written more as a corporate training manual than that of a programming text book. As probably everyone who ever took a training class from their company knows, training is often done by people who not only are not educators, but may not actually understand or have even used the subject of the training. It is intentional that such people do not state the concepts abstractly - they only know concrete examples and maybe only the example in their pre-written material.
This book fits this description to a T. It does not specify the correct syntax except in examples. It does not specify the qualifications and conditions governing the language elements or the examples. As such, unless you are essentially copying an example almost verbatim, you have no real knowledge of whether your code will compile, let alone work as intended. As an example consider their discussion of SELECT statements. They speak about the Select clause, the INTO clause, etc. Nowhere do they state that the list of items in the INTO clause should separated by commas. Although most people could correctly guess that the comma is the separator, you need to find an example to show you that. The book is rampant with omissions like this. Two pages later, they use an OPEN - FOR construct in an example without introducing it. That it can be used dynamically, i.e. with the query in a character string constructed at run time, is not only not mentioned in this section, but is not even mentioned in the chapter on Dynamic SQL.
This should be looked upon as a book of (simple) examples. It should be no one's text or reference.Oracle Database 10g PL/SQL Programming OverviewCreate dynamic client/server applications using PL/SQL and the comprehensive information contained in this authoritative volume. Expert Oracle insiders cover the features of PL/SQL, explain scripting semantics and syntax, and fully detail the PL/SQL functionality of Oracle Database 10g. You'll learn how to write powerful PL/SQL programs, interact with Oracle databases, perform complex calculations, and handle error conditions.

Want to learn more information about Oracle Database 10g PL/SQL Programming?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Java Persistence with Hibernate Review

Average Reviews:

(More customer reviews)Are you looking to buy Java Persistence with Hibernate? Here is the right place to find the great deals. we can offer discounts of up to 90% on Java Persistence with Hibernate. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Java Persistence with Hibernate ReviewI feel a little odd rating this thing as low as two stars. After all, it does pack a lot of information into its 800+ pages. And that does make it a single point of reference ... sort of.
It's when I actually tried to use this fat tome to learn how to work with Hibernate that I encountered the first problem. I can't recommend that approach. This book is a terrible way to learn how to use Hibernate. It talks endlessly about all kinds of detail about everything you might want to do, and even provides many incomplete code snippets. But surprisingly it doesn't sit you down and walk you through a simple application actually using Hibernate. The authors do provide a full-blown application you can download and work through - but that won't be easy, dear reader, and it will take you a while to distill the basics from the advanced usage.
This seems to be a problem with most Hibernate books, for some reason - they all think they need to explain ORM to the world rather than simply show how to create an application. Explaining ORM AND showing how to build an application might be better.
So, OK, perhaps, I thought, this will become my master reference. Then I encountered the second problem. There's no good way to drill quickly to a nugget of information you need, which, after all, is the essence of a reference. Instead you will have to read through the theoretical explanations and design discussions to figure out if the trail leads you to the specific nugget you need to get your software working.
In the end I realized that the book is not good as a tutorial and not good as a reference and I was left to wonder what it might be good for. This surprised me, to be honest.
As far as I am aware, no practical Hibernate book has been written, so it would be unfair to single out this one. (The Manning book, Hibernate Quickly, is simply incorrect at too many points - you have to figure out the coding and config errors.) So I'm not singling out this one. However, in my view the praise for this book is directed at the terrific work done by the authors in creating and maintaining Hibernate rather than their work on this book. Their work in this book is unfocused and, while comprehensive and correct, ultimately difficult to use for any practical purpose.
If you want to learn how to use Hibernate, the best way I know is to work with some of the tutorials available on the Web or to download an app server and follow their documentation. You might not learn about "theta-style joins", but you will certainly learn to use Hibernate to create software much more quickly that way than by using this book.Java Persistence with Hibernate Overview
Persistence-the ability of data to outlive an instance of a program-is central to modern applications.Hibernate, the most popular Java persistence tool, provides automatic and transparent object/relational mapping making it a snap to work with SQL databases in Java applications. Hibernate applications are cheaper, more portable, and more resilient to change. Because it conforms to the new EJB 3.0 and Java Persistence 1.0 standard, Hibernate allows the developer to seamlessly create efficient, scalable Java EE applications.

Java Persistence with Hibernate explores Hibernate by developing an application that ties together hundreds of individual examples. You'll immediately dig into the rich programming model of Hibernate 3.2 and Java Persistence, working through queries, fetching strategies, caching, transactions, conversations, and more. You'll also appreciate the well-illustrated discussion of best practices in database design, object/relational mapping, and optimization techniques.

In this revised edition of the bestselling Hibernate in Action, authors Christian Bauer and Gavin King-the founder of the Hibernate project-cover Hibernate 3.2 in detail along with the EJB 3.0 and Java Persistence standard.


Want to learn more information about Java Persistence with Hibernate?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Head First SQL: Your Brain on SQL -- A Learner's Guide Review

Average Reviews:

(More customer reviews)Are you looking to buy Head First SQL: Your Brain on SQL -- A Learner's Guide? Here is the right place to find the great deals. we can offer discounts of up to 90% on Head First SQL: Your Brain on SQL -- A Learner's Guide. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Head First SQL: Your Brain on SQL -- A Learner's Guide ReviewBefore I talk about Head First SQL, let me tell you about other database books I have used in the classroom. I teach an enterprise databases sequence (DBs I and II) at a tribal college in Montana. On the course evaluations for this sequence, students have a common complaint: "Liked the class. Hated the book.", "The book was painful to read.", "Please get a different book!"
Each year my colleagues and I are on the watch for a better, more engaging database book. We have tried three books over the past five years, but the difference between those books is like the difference between shades of grey. In the classroom, most of my time is spent mediating the daunting abstractness of those books or breaking down huge lumps of difficult technical material written in plodding and pedantic prose. This year a spot of color showed up: Head First SQL!

I discovered Head First SQL too late to use it as the primary text for my Fall quarter DBs class, but I liked it so much, I added it as an optional textbook for the quarter and told my students it would be the main textbook for the Winter quarter. I did so because the energy of the class was waning rapidly, and the book I had originally chosen was not helping. I needed to add some excitement to homework and lectures. Within two days of using Head First SQL, the classroom became a far more engaging environment.

I compiled this list for anyone interested in learning databases and SQL, especially anyone who teaches it.

Eleven Things I like about Head First SQL:

1. The book starts where my students start. The first questions my students have are questions of relevance: Why do I want to know this? What have I done before that's like this? What will this material add to my career and my life? Head First SQL starts by ushering the student through those questions: What is a database? Who cares about databases? What will a database do for me?

2. My students are able to read SQL, think SQL, and write SQL after the first chapter. Head First SQL starts students on the command-line, the same command-line professional database administrators use during 80-95% of their workday. My students start out with good command-line habits like using a DESCRIBE statement to view database structure and columns before writing a SELECT statement that references those columns.

3. The book invites my students to make mistakes and anticipates the most common mistakes I see students make. On quizzes, students who've dug into the book don't make those mistakes again.

4. The book's sequence of topics fits the way I teach and the way my students learn: queries come before design and theory. Head First SQL does not set out to be a comprehensive database design book, but it does an excellent job of immersing the learner in the critical thinking that goes into database design and table design strategy. I applaud Lynn Beighley and the Head First Team. They have laid an excellent foundation for the learner to smoothly transition into abstract database design concepts such as normalization, primary and foreign keys, entity-relationship diagrams (ERDs), and E.F. Codd's 12 principles of relational design.
5. Students don't read the book. They work the book. They play the book. They do the book.

6. Like Socrates, Head First SQL pushes my class and I to ask deeper questions about data, information, table design, normalization. Three different times during fall quarter, we had substantive arguments about which data types to use for certain columns. To hear my students using critical thinking and applying it to table design strategy is rewarding.

7. Like a guide, an outfitter, a trusted companion, HF SQL walks beside the student. The books I have used before talk down to students, talk over their heads, or just plain pontificate.

8. Theater in a database classroom? Yes. My students and I act out things like "Confessions of a NULL" -- fun, mysterious, memorable -- a great way to turn an abstract concept into a concrete and palpable one.

9. At conferences, committee meetings, training seminars, my colleagues and I talk about student engagement and the new "three Rs": rigor, relationships, and relevance. Using Head First SQL in my classroom changed my class noticeably, and I attribute that change to Head First's focus on those three Rs. My students started showing up early for class, spent more time in the lab outside of class, and performed far better on quizzes.
10. My quizzes and tests consist of sample tables and data. The open-ended questions on those tests ask students to write SQL to solve problems--a daunting task but the best way to assess whether students really "get" the concepts. In the past, students scores have ranged from 10% to 87%. A score of 92% was rare. A score of 95% almost unattainable. With Head First SQL, that range increased to between 70% and 98%. If that's not proof of Head First SQL's effectiveness, I don't know what is.

11. You will laugh your [body part here] off! And be warned: no matter what body part you substitute into the brackets, you will laugh several other body parts off as well.
I highly recommend this book to anyone teaching or learning SQL, relational database design, or MySQL.
Head First SQL: Your Brain on SQL -- A Learner's Guide Overview
Is your data dragging you down? Are your tables all tangled up? Well we've got the tools to teach you just how to wrangle your databases into submission. Using the latest research in neurobiology, cognitive science, and learning theory to craft a multi-sensory SQL learning experience, Head First SQL has a visually rich format designed for the way your brain works, not a text-heavy approach that puts you to sleep. Maybe you've written some simple SQL queries to interact with databases. But now you want more, you want to really dig into those databases and work with your data. Head First SQL will show you the fundamentals of SQL and how to really take advantage of it. We'll take you on a journey through the language, from basic INSERT statements and SELECT queries to hardcore database manipulation with indices, joins, and transactions. We all know "Data is Power" - but we'll show you how to have "Power over your Data". Expect to have fun, expect to learn, and expect to be querying, normalizing, and joining your data like a pro by the time you're finished reading!


Want to learn more information about Head First SQL: Your Brain on SQL -- A Learner's Guide?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Oracle Database 11g SQL (Osborne ORACLE Press Series) Review

Average Reviews:

(More customer reviews)Are you looking to buy Oracle Database 11g SQL (Osborne ORACLE Press Series)? Here is the right place to find the great deals. we can offer discounts of up to 90% on Oracle Database 11g SQL (Osborne ORACLE Press Series). Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Oracle Database 11g SQL (Osborne ORACLE Press Series) ReviewI'm an experienced Oracle developer and I use this book all the time. I have several books on SQL, and this book is by far the best. It has good examples. I highly recommend it.Oracle Database 11g SQL (Osborne ORACLE Press Series) Overview
Write powerful SQL statements and PL/SQL programs

Learn to access Oracle databases through SQL statements and construct PL/SQL programs with guidance from Oracle expert, Jason Price. Published by Oracle Press, Oracle Database 11g SQL explains how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL/SQL programs, and much more. Inside, you'll find in-depth coverage of the very latest SQL features and tools, performance optimization techniques, advanced queries, Java support, and XML. This book contains everything you need to master SQL.

Explore SQL Plus and SQL Developer

Want to learn more information about Oracle Database 11g SQL (Osborne ORACLE Press Series)?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Hibernate in Action (In Action series) Review

Average Reviews:

(More customer reviews)Are you looking to buy Hibernate in Action (In Action series)? Here is the right place to find the great deals. we can offer discounts of up to 90% on Hibernate in Action (In Action series). Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Hibernate in Action (In Action series) ReviewFrom a documentation point of view, Hibernate is one of the most notable exception in the world of open-source LGPL'ed projects. Its website offers a plethora of information, from solid documentation (the reference has no less than 141 pages) and various FAQs to sample projects and third-party resources. The forum is quite active and you may get answers to tricky questions. Or a little bit of rough treatment in case you haven't RTFM - but that is understandable, given the number of questions that the authors have to answer every day.
Under these circumstances, one might wonder what Gavin King (Hibernate founder) and Christian Bauer (documentation/website maintainer and Hibernate core developer) can add in order to be able to write a 400-pages book about Hibernate. I mean - sure - only by joining the reference documentation, different FAQs and guides, one can easily 'extract' a hefty 'manuscript' with more than 200 pages.
Well, I am extremely glad to tell you that this is not the case. The book not only gets you up to speed with Hibernate and its features (which the documentation does quite well). It also introduces you to the right way of developing and tuning an industrial-quality Hibernate application. I consider myself a pretty seasoned Hibernate developer, being familiar with the API since its 1.2 version in Q1-2002 (if I remember well the first app when we used Hibernate). However, I was proved wrong by "Hibernate in action" which describes best practices and even API features that were unknown or vaguely known to me. That is, until now.
The first chapter, in the good tradition of all first chapters in the world, is an introduction. It's a very well written introduction about why do we need ORM solutions in OO applications. The chapter explains the O/R impedance mismatch, while declaring quickly that OODB suck (immature and not widely adopted). Wel'll also find out that EJB also suck from a persistence point of view (for various reasons). Which can be quite a surprise knowing that Gavin is one of the authors of EJB3.0 specs. Or, on the contrary, this will explain a lot of things in the new EJB specs.
Now that we have cleared the "why Hibernate" issue, let's continue to the second chapter. Which - tradition obliged - is a "Hello, world" and a "Let's get started" chapter. Here you go, almost 50 pages later you should be able to write simple Hibernate-based persistence layers and integrate within an application server, like for instance ... Jboss ! Humm, well, why not ? They are sponsors of the Hibernate project, after all.
In the 3rd chapter, our fresh knowledge will be put to good use by starting the development of an online auction application called CaveatEmptor. This app will follow our reading progression and will grow bigger and smarter chapter by chapter. But for the moment, we are at the inception phase. What gives : a little bit of analysis, a stylish class diagram of the domain model and the resulting mapping file. And if you thought (based on 2nd chapter) that the mapping file is very intuitive and simple, you're in for a big surprise : it is, indeed, intuitive and simple ! Quite bizarre for an open-source project. As a matter of fact, the mapping file is one of the pivotal elements of Hibernate, since it addresses directly the O/R impedance mismatch, a recipy for transparent linking your POJOs and the constrained relational model. No wonder that a big part of this chapter is aimed at explaining why and how the mapping works in Hibernate. You'll see how class associations and inheritance translate at the metadata and mapping level. You'll start to understand the things that you took for granted in the previous chapter and you'll have that pleasant "uuh, I see" chain reaction. Hold on, it's just the beginning.
Because chapter 4 is going to explain once and for all the lifecycle of persistent object in Hibernate, their behavior from a persistence point of view as well as the available fetching strategies. And if you thought you already knew everything by heart from the documentation ... well, maybe you do know everything by heart. Nevertheless, it's very well synthetized in chapter 4 and I'll recommend it anytime to a coworker eager for Hibernate knowlege.
In the next chapter (the 5th) the rollercoaster slows down a bit. That is, if you already know the behavior associated with the four possible isolation modes in transactions, what are the different types of locking, what (the hell) MVCC means and the importance of transaction scopes. Chances are you already know some of this stuff quite well, but everybody needs a refresher from time to time, especially when it's well explained and when it comes with versioning and caching (1st and 2nd level) in Hibernate as a desert. By the way, I thought that OSCache supports clustering, not only SwarmCache and JbossCache, as stated in the book. There's even a thoroughly explained example of using JbossCache as a level 2 clustered cache for Hibernate, but it shouldn't be too hard to convert to other types of caching systems.
Now, if I were the author of the book, I would have placed chapter 6 before chapter 5. But I am not the author, which is quite fortunate for you dear readers since Christian and Gavin are much more competent than me at writing books about Hibernate (and probably at some other unrelated domains). They have decided to go back to mapping in chapter 6, after the short transaction/caching intermezzo. Well, they should know better... it's time for a serious dose of advanced mapping. This chapter is attacking interesting subjects such as custom mapping types (simple or composite) and (finally) the mapping of collections. Special guests stars: the whole gang of "sets, bags, lists and maps", together with explanations about their relational equivalent (associations, associations and associations !). Oh and yes "polymorphic association" (section 6.4.3) - I wasn't even aware that Hibernate is able to do that... guess I'm not that 'seasoned' (as a Hibernate developer) after all.
The 7th chapter is about "Retrieving objects efficiently" : about 45 pages for the 'retrieving' part and 6 pages for the 'efficiently' part. Fair enough ! You'll learn how to master basic HQL queries (parameters, pagination ...). You'll get a grip on the query by criteria API, as well as on advanced stuff such as dynamic queries, filters, subqueries and native SQL (very powerful). At the end of the chapter there's the Hibernate-specific solution for the n+1 selects problem, query caching and result iterators.
Following this wealth of useful knowledge, the 8th chapter starts a bit dry. Nevertheless, after a short introduction about Hibernate in managed environments, you'll find yourself again in the land of advanced programming techniques : application-level transaction implementation ! This is mostly new stuff (at least for me) - a great collection of best practices for transactional behavior management in industrial-quality apps. Somewhat unrelated but still interesting, the chapter ends with legacy schemas integration and a smart implementation example for audit logging.
The 9th (and last) chapter is about the roundtrip development in Hibernate using the classical toolset : Middlegen and/or hbm2java and/or XDoclet. All the available techniques are presented in a very detailed, step-by-step manner.
Wait : don't close the book, there's more ! Ignore Appendix A (a short and rather uninteresting document about SQL fundamentals - that is, if you know SQL). Appendix B contains mildly un-fascinating ORM implementation strategies pour les connaisseurs (come on guys, I'm just a dumb user). But - Appendix C is a great collection of real-world stories and by all means read them all ! Especially the last one, a treasure of hard to find knowledge (no spoilers, please...).
In the end, I have to confess that there is something truly interesting about 'Hibernate In Action' : albeit very technical, it reads astonishingly easy - and this kind of books is unfortunately very rare nowadays. My congratulations to the authors for this excellent piece of work - it was worth the wait.
As for you dear potential reader, if you already know all the information detailed in the book, I bow before you, great Hibernate wizard. But if you don't, what are you waiting for ? Because, if you're going to read only one technical book this summer, make sure that it's 'Hibernate In Action' (or, at least chapters 6,7 and 8, if you are that good !).Hibernate in Action (In Action series) OverviewHibernate practically exploded on the Java scene. Why is this open-source tool so popular? Because it automates a tedious task: persisting your Java objects to a relational database. The inevitable mismatch between your object-oriented code and the relational database requires you to write code that maps one to the other. This code is often complex, tedious and costly to develop. Hibernate does the mapping for you.Not only that, Hibernate makes it easy. Positioned as a layer between your application and your database, Hibernate takes care of loading and saving of objects. Hibernate applications are cheaper, more portable, and more resilient to change. And they perform better than anything you are likely to develop yourself."Hibernate in Action" carefully explains the concepts you need, then gets you going. It builds on a single example to show you how to use Hibernate in practice, how to deal with concurrency and transactions, how to efficiently retrieve objects and use caching.The authors created Hibernate and they field questions from the Hibernate community every day-they know how to make Hibernate sing. Knowledge and insight seep out of every pore of this book."What's Inside"- ORM concepts- Getting started- Many real-world tasks- The Hibernate application development process

Want to learn more information about Hibernate in Action (In Action series)?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Joe Celko's Trees and Hierarchies in SQL for Smarties, (The Morgan Kaufmann Series in Data Management Systems) Review

Average Reviews:

(More customer reviews)Are you looking to buy Joe Celko's Trees and Hierarchies in SQL for Smarties, (The Morgan Kaufmann Series in Data Management Systems)? Here is the right place to find the great deals. we can offer discounts of up to 90% on Joe Celko's Trees and Hierarchies in SQL for Smarties, (The Morgan Kaufmann Series in Data Management Systems). Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Joe Celko's Trees and Hierarchies in SQL for Smarties, (The Morgan Kaufmann Series in Data Management Systems) ReviewI love and savor each of Celko?s books for their thoroughness, depth and surprises. However, with this book I am little disappointed because it showed his favorite solutions and omitted many common solutions that are better in various real-world situations. Most algorithms provided in the book are for overnight processing, not real-time update.

Omitted is the most common way hierarchies are represented in Data Warehouses using a "hierarchy bridge table". See Kimball?s book "Data Warehouse Toolkit" for more detail (yet not enough detail to give a Celko-like exploration of the topic). The bridge table solution trades away storage space for greater speed by creating a record for every path enumeration.

The book?s primary focus is on strict hierarchies. Not enough attention is given to convergent graphs and other arbitrary directed acyclic graphs, like bill of materials that reuse assemblies, where the nested sets model fails (p.164).

Also missing is maintenance of historical versions of the hierarchy, often required by financial applications.

Section 9.3 on the extremely powerful DB2 ?WITH? operator is too slim, especially since it is a SQL-99 standard and is now available with Microsoft SQL Server. If you work with hierarchies or acyclic graphs in DB2 or SQL Server take the time to learn how to use ?common subquery expressions?.

By all means if you work with hierarchies you must buy this book. No doubt the Second revison of this book will blow us away.
Joe Celko's Trees and Hierarchies in SQL for Smarties, (The Morgan Kaufmann Series in Data Management Systems) Overview

Want to learn more information about Joe Celko's Trees and Hierarchies in SQL for Smarties, (The Morgan Kaufmann Series in Data Management Systems)?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

Web Database Applications with PHP & MySQL, 2nd Edition Review

Average Reviews:

(More customer reviews)Are you looking to buy Web Database Applications with PHP & MySQL, 2nd Edition? Here is the right place to find the great deals. we can offer discounts of up to 90% on Web Database Applications with PHP & MySQL, 2nd Edition. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Web Database Applications with PHP & MySQL, 2nd Edition ReviewI have just started learning some PHP & MySQL development using "PHP & MySQL Web Development" published by Sams and "Web Database Applications with PHP & MySQL" from O'Reilly. Prospective readers might be wondering the difference between the two in deciding which one to buy, so I hope to shed some light on the issue.
Sams: The Welling and Thomson book is more "hands-on" in that it takes the reader step-by-step in developing an e-commerce website. The chapters are organized in a goal-oriented manner: PHP, MySQL, the basics of e-commerce, security, and design of the site.
O'Reilly: The Williams and Lane book is structured in a similar way by showing readers PHP and then MySQL. Examples to reinforce concepts are also provided. While the O'Reilly book also tries to take the reader in developing an e-commerce site, it is a bit more theoretical. Also, there are some differences in focus: the O'Reilly book has a section on using JavaScript while the Sams book has a final chapter on creating PDF files using PHP.
If I had to choose just one book, I would go with the Sams book due to its more gentle learning curve. However, I believe that the O'Reilly book is no slouch, and I will probably come to appreciate it more once I gain more experience in PHP and MySQL development.
One last word about my programming background: I knew a bit of Perl, Java, HTML, and JavaScript before tackling PHP and MySQL. I consider myself to be an "advanced beginner" (an oxymoron, of course). To get the most out of these two books, you should know HTML well enough to read it (you should at least recognize some tags) and it would definitely be helpful if you have some programming experience. You could very well make PHP your first programming language, but I would advise against it. Start with something like Perl (whose syntax is very similar to PHP's).
I highly recommend both books to prospective PHP and MySQL developers who are willing to spend some time and effort.Web Database Applications with PHP & MySQL, 2nd Edition Overview

Want to learn more information about Web Database Applications with PHP & MySQL, 2nd Edition?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

SQL: A Beginner's Guide, Second Edition Review

Average Reviews:

(More customer reviews)Are you looking to buy SQL: A Beginner's Guide, Second Edition? Here is the right place to find the great deals. we can offer discounts of up to 90% on SQL: A Beginner's Guide, Second Edition. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

SQL: A Beginner's Guide, Second Edition ReviewThis book helped me get my web development project well on the way. I am using PowerBuilder to build a web based application and I needed to learn SQL programming quickly for the database component. The author was easy to understand and uses lesson plans that make it easy to learn SQL at a reasonable pace. I was able to get up and running with the basics and am becoming more proficient as I implement more of the examples in the book.
I recommend this book to anyone new to SQL. I think it may be useful to experienced SQL developers also but I cannot speak for the more advanced users since I am so new.SQL: A Beginner's Guide, Second Edition OverviewHere is the foundation upon which you can build your relational database design and programming, then apply those skills to any SQL-based product. Carefully organized for beginners, you�ll learn step-by-step how to create a database, create tables, enforce data integrity, query and modify data, and implement advanced data access techniques.

Want to learn more information about SQL: A Beginner's Guide, Second Edition?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

PHP 5 / MySQL Programming for the Absolute Beginner Review

Average Reviews:

(More customer reviews)Are you looking to buy PHP 5 / MySQL Programming for the Absolute Beginner? Here is the right place to find the great deals. we can offer discounts of up to 90% on PHP 5 / MySQL Programming for the Absolute Beginner. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

PHP 5 / MySQL Programming for the Absolute Beginner ReviewI've been reading this book to learn PHP and it is undoubtedly the best book for beginners you're going to find. I've been trying to learn PHP since version 3 (yea, finally there is a book that I can understand). If you're new to programming, and new to PHP, do not listen to people who say 'oh, just go to www.php.net'
The online help manual for PHP is not geared towards beginners. It's geared towards the type of people who simply have to read the rules of a programming language and then can go and program with it effectively. Basically, it's for people who know what they're doing. They have the programming mind already. I am not that type of person and many people who are new to programming are not like that.
Andy Harris' book teaches you PHP, but you will have to have a solid foundation in HTML/CSS (which I have) and it says that in the book. The only errors I've noticed in the book so far are HTML and they're nothing major. If you know HTML you'll be able to see them right off the bat and correct them for yourself (it's not like the book is $50 or something, it's just a minor inconvenience you'll only encounter maybe two or three times in the entire 12 chapter book). Also, the examples in the book are sometimes different from the ones on the CD (which implies that the CD is much more up to date than the book). Those are usually only minor changes to the code.
In any case, while reading this book everything is explained and introduced in a way that is easy for me to understand. I think the way he introduces concepts is great. He doesn't simply say 'these are the rules and let me explain them' like the other books. No, he gradually works you up to them, preparing your mind. I find that this is more effective and this is a beginning programmer talking, after years of trying to find a good book. The one thing that I think is great is that this book uses examples that are relevant to what you will be programming. Too many times (back when PHP 3 and 4 came out) have I read those books that use boring examples that I'll never use (like some math formula for example). Instead, the examples in this book are challenging, yet fun and practical, and he goes over every part of the code so that you understand what each part is doing. Sometimes the examples are really big, but this isn't a problem. Even if there is an area where his explaining doesn't do it for me, if I simply go over everything in my mind and break things down on a piece of paper I'm able to understand. The only reason I'm able to understand is because the concepts have been introduced in a way that I can know what's going on. The only issue is then figuring out what a large example is doing and that's something you have to figure out for yourself. I haven't run into a problem I haven't been able to figure out so far.
This book is shaping my mind into a programmer's mind. I can now see the planning involved in each program and I'm finally starting to see the method. It's a lot more effective than other books that simply give you the syntax, explain it, and then give you a problem to do without giving you relevant examples on how to use what you just learning and shaping your mind so that you'll know when each tool is effective, when you'll need to use it, and how they work in different situations. I now know the reason why I couldn't get through those books. I knew the rules, but my mind didn't know how to think like a programmer. All those so-called beginner books don't teach you that at all. Andy Haris' book does. I feel like I can go on to other programming languages now because I finally read a book that taught me the method.
PHP5/MySQL Programming for the Absolute Beginner is not the PHP5 bible but it explains PHP5 enough so that by the time you're done you'll be able to do what you want and get out there and learn more without being intimidated. If you're a beginner to PHP5, don't waste your time with other books that won't introduce you to the mechanics of programming. Get this book!PHP 5 / MySQL Programming for the Absolute Beginner OverviewThis book is an introduction to programming with a specific focus on programming web servers with the PHP programming language. Much of the original content from the first edition (1931841322) will be retained, while also including updates relating to the upcoming PHP 5.0 release. Following the same format as the popular first edition, this book provides easy-to-follow instruction. Readers will use the concepts presented in the book to create games using PHP and MySQL. As each concept is put to the test, readers will acquire programming skills that will easily transition to real-world projects. A true beginner's guide, this book enables readers to acquire programming skills that they will be able to use in the next language that they tackle.

Want to learn more information about PHP 5 / MySQL Programming for the Absolute Beginner?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...

The Manga Guide to Databases Review

Average Reviews:

(More customer reviews)Are you looking to buy The Manga Guide to Databases? Here is the right place to find the great deals. we can offer discounts of up to 90% on The Manga Guide to Databases. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

The Manga Guide to Databases ReviewBACKGROUND: I spend a large part of my working day in a SQL Server database, so I have very strong database knowledge. My daughter is 9 years old and is a very strong reader, but could care less about how a computer actually works... as long as she can get to ClubPenguin.com or the other websites she likes to visit for fun.
STORY: A friend loaned me this book to show her, so I gave it to her and asked her to try it. If she read the first 10 pages and it was boring, she should stop. If she liked it, she could keep it until she was done. She opened it on the spot and was 20 pages in before she realized she still was standing in the middle of our kitchen. One day later, she was finished and said it was "cool" and that she liked it.
I asked her if she learned anything or if it was just a story and she started talking. She said a little bit and talked about tables and how information is stored in columns and rows. She talked in a 9 year old's language and vocabulary, but basically explained to me the concept and benefits of centralized data stored in a single database. She made a couple other comments whose specifics I can't remember, but clearly articulated database ideas. It was somewhat surreal hearing these things come from a 3rd grader's mouth. She didn't feel like she had learned very much. I told her I probably could count on my fingers how many people at my work (300 people total - manufacturing industry, not IT) knew more about databases than she did, based on what she had finished telling me.
SUMMARY: She felt like she read a fun Manga-style story. In reality, she did that but also learned and retained ideas that normally would be taught to much older people. This book took what could be a dry learning experience and changed it into a fun activity no different than if she was reading her Nancy Drew books or her Lego magazines. I see that there are other topics (statistics, physics, etc.) and I'll ask her if she's interested in seeing any of the other books. If she wants to, I absolutely would buy them.
And obviously, if you're read this far, I completely would recommend this book to anyone interested in learning about databases on an introductory level.The Manga Guide to Databases Overview
Want to learn about databases without the tedium? With its unique combination of Japanese-style comics and serious educational content, The Manga Guide to Databases is just the book for you.

Princess Ruruna is stressed out. With the king and queen away, she has to manage the Kingdom of Kod's humongous fruit-selling empire. Overseas departments, scads of inventory, conflicting prices, and so many customers! It's all such a confusing mess. But a mysterious book and a helpful fairy promise to solve her organizational problems-with the practical magic of databases.

In The Manga Guide to Databases, Tico the fairy teaches the Princess how to simplify her data management. We follow along as they design a relational database, understand the entity-relationship model, perform basic database operations, and delve into more advanced topics. Once the Princess is familiar with transactions and basic SQL statements, she can keep her data timely and accurate for the entire kingdom. Finally, Tico explains ways to make the database more efficient and secure, and they discuss methods for concurrency and replication.

Examples and exercises (with answer keys) help you learn, and an appendix of frequently used SQL statements gives the tools you need to create and maintain full-featured databases.

(Of course, it wouldn't be a royal kingdom without some drama, so read on to find out who gets the girl-the arrogant prince or the humble servant.)

This EduManga book is a translation of a bestselling series in Japan, co-published with Ohmsha, Ltd., of Tokyo, Japan.


Want to learn more information about The Manga Guide to Databases?

>> Click Here to See All Customer Reviews & Ratings Now

Read More...