Mastering Oracle SQL, 2nd Edition Review

Average Reviews:

(More customer reviews)[A REVIEW OF THE SECOND EDITION]
Those of you dealing with the latest Oracle 10g, and perhaps frustrated with the quality of the Oracle documentation, might want to consult this second edition. Its greatest difference compared to the first edition is simply that it deals with 10g, whereas the latter talks about 9g. Mishra and Beaulieu explain, with extensive detail and examples, the new features. Like support for unix-like regular expressions within SQL statements. Given that many Oracle users probably hail from a unix/C background, they will welcome this.
Also, for mapping between XML and SQL data types, 10g now integrates XML. This will reduce the impedance mismatch between the object oriented and relational outlooks that bedevil many programmers who have to deal with both.
The only problem I found with this book is its lack of mention of competing databases. Because the authors explicitly assume that you have already committed to using Oracle as your database. Fair enough. But perhaps occasional comments in the text, about how a given command or feature is not possible in another database would be useful and appreciated by Oracle users. Heck, to be fair, on this point, the book is at no relative disadvantage. For example, I have texts on dB2 and MySQL that likewise say zilch about their competitors.

Click Here to see more reviews about: Mastering Oracle SQL, 2nd Edition


The vast majority of Oracle SQL books discuss some syntax, provide the barest rudiments of using Oracle SQL, and perhaps include a few simple examples. It might be enough to pass a survey course, or give you some buzz words to drop in conversation with real Oracle DBAs. But if you use Oracle SQL on a regular basis, you want much more. You want to access the full power of SQL to write queries in an Oracle environment. You want a solid understanding of what's possible with Oracle SQL, creative techniques for writing effective and accurate queries, and the practical, hands-on information that leads to true mastery of the language. Simply put, you want useful, expert best practices that can be put to work immediately, not just non-vendor specific overview or theory.

Updated to cover the latest version of Oracle, Oracle 10g, this edition of the highly regarded Mastering Oracle SQL has a stronger focus on technique and on Oracle's implementation of SQL than any other book on the market. It covers Oracle s vast library of built-in functions, the full range of Oracle SQL query-writing features, regular expression support, new aggregate and analytic functions, subqueries in the SELECT and WITH clauses, multiset union operators, enhanced support for hierarchical queries: leaf and loop detection, and the CONNECT_BY_ROOT operator, new partitioning methods (some introduced in Oracle9i Release 2), and the native XML datatype, XMLType.

Mastering Oracle SQL, 2nd Edition fills the gap between the sometimes spotty vendor documentation, and other books on SQL that just don't explore the full depth of what is possible with Oracle-specific SQL. For those who want to harness the untapped (and often overlooked) power of Oracle SQL, this essential guide for putting Oracle SQL to work will prove invaluable.

Get 27% OFF

Click here for more information about Mastering Oracle SQL, 2nd Edition

Read More...

Starting Out with Java: From Control Structures through Data Structures (2nd Edition) (Gaddis Series) Review

Average Reviews:

(More customer reviews)If you're new to programming and are considering which book to buy, it is essential to consider that many good books (such as Head First Java, Core Java, Just Java, and The Java Tutorial) are meant for experienced programmers who need insight into Java's more complicated concepts. These aren't textbooks for students. But Tony Gaddis's books are, and this book is no exception; in fact, it is the best Java textbook I have ever bought. This book is loaded with examples, exercises, case studies, and projects. It has everything from loops to linked lists, and it does not neglect GUIs by placing GUI topics to an optional section at the end of the chapter or in the last chapters of the book. This book will also serve you well as a reference book and as preparation for the SCJP certificate. I have also bought Gaddis's Starting Out with C++ From Control Structures through Objects, 5th Edition, and I am quite willing to recommend, sight unseen, any book that Gaddis writes.

Click Here to see more reviews about: Starting Out with Java: From Control Structures through Data Structures (2nd Edition) (Gaddis Series)

Starting Out with Java: From Control Structures through Data Structures is designed to be used in a 2 or 3 semester/quarter sequence for beginning programmers.Tony Gaddis emphasizes problem-solving and program design by teaching the Java programming language through a step-by-step detailed presentation. He introduces procedural programming early and covers control structures and methods before objects.Students are engaged and have plenty of opportunity to practice using programming concepts through practical tools that include end-of-section and chapter exercises, case studies and programming projects.

Get 27% OFF

Click here for more information about Starting Out with Java: From Control Structures through Data Structures (2nd Edition) (Gaddis Series)

Read More...

SQL in a Nutshell (In a Nutshell (O'Reilly)) Review

Average Reviews:

(More customer reviews)This book is designed as a reference -- the book that you keep
near your workstation after you learn the basics, because you
haven't got everything memorised yet. It's great for that. I
refer to it when I have a question.
But actually I picked up this book with no prior knowledge of
SQL (except that I knew it was for doing database stuff) and
learned enough to get started in a couple of days. The intro
is great for that.
The great thing about this book is that it covers the four
major SQL implementations in a relatively unbiased fashion.
This is nice because if you switch from one to another you
don't have to go looking for a new book. (Otherwise, you
would; as you will see from reading this book, the various
implementations differ considerably and also differ from
the unimplemented standard, which the book also covers.)
This book is not, and is not intended to be, a tutorial for
people who are utterly unfamiliar with the very concept of
a database, but it's okay to be utterly unfamiliar with SQL.
This book also is not a strategy guide for how to plan and
organise your database; this is an _implementation_ book.
As such, it doesn't cover things like deciding which data
to put in which table, when to create another table and
when to create an entirely separate database, or that sort
of thing. What it does tell you is what query syntax you
need to create and interact with your database, your tables,
and the data in your tables. It also explains datatypes,
because they vary considerably between the different SQL
implementations, and table types and the various attributes
(indeces and whatnot).
Additionally, this book is not a security guide. It does
include information about permissions, but only in terms of
the syntax used, not in terms of strategy.

Click Here to see more reviews about: SQL in a Nutshell (In a Nutshell (O'Reilly))


For programmers, analysts, and database administrators, SQL in a Nutshell is the essential reference for the SQL language used in today's most popular database products. This new edition clearly documents every SQL command according to the latest ANSI standard, and details how those commands are implemented in Microsoft SQL Server 2008, Oracle 11g, and the MySQL 5.1 and PostgreSQL 8.3 open source database products. You'll also get a concise overview of the Relational Database Management System (RDBMS) model, and a clear-cut explanation of foundational RDBMS concepts -- all packed into a succinct, comprehensive, and easy-to-use format. This book provides:

Background on the Relational Database Model, including current and previous SQL standards
Fundamental concepts necessary for understanding relational databases and SQL commands
An alphabetical command reference to SQL statements, according to the SQL2003 ANSI standard
The implementation of each command by MySQL, Oracle, PostgreSQL, and SQL Server
An alphabetical reference of the ANSI SQL2003 functions, as well as the vendor implementations
Platform-specific functions unique to each implementation

Beginning where vendor documentation ends, SQL in a Nutshell distills the experiences of professional database administrators and developers who have used SQL variants to support complex enterprise applications. Whether SQL is new to you, or you've been using SQL since its earliest days, you'll get lots of new tips and techniques in this book.

Get 34% OFF

Click here for more information about SQL in a Nutshell (In a Nutshell (O'Reilly))

Read More...

21 Recipes for Mining Twitter Review

Average Reviews:

(More customer reviews)This is a very short, very practical way to get you started exploring the Twitter APIs on your own. It offers a decent amount of code no experienced developer should have much trouble understanding and applying to his or her own needs. The cost per page is not exactly attractive and some readers may want a more in-depth less cookbook-like experience. If you are in a hurry to extract data from Twitter, this book may be for you - for less than $20 for the electronic edition, it will spare you more than that in time spent figuring out libraries and APIs. Plus, it offers some intro on many other interesting libraries that can be applied to a lot of problems besides Twitter mining.

Click Here to see more reviews about: 21 Recipes for Mining Twitter


Millions of public Twitter streams harbor a wealth of data, and once you mine them, you can gain some valuable insights. This short and concise book offers a collection of recipes to help you extract nuggets of Twitter information using easy-to-learn Python tools. Each recipe offers a discussion of how and why the solution works, so you can quickly adapt it to fit your particular needs. The recipes include techniques to:

Use OAuth to access Twitter data
Create and analyze graphs of retweet relationships
Use the streaming API to harvest tweets in realtime
Harvest and analyze friends and followers
Discover friendship cliques
Summarize webpages from short URLs

This book is a perfect companion to O'Reilly's Mining the Social Web.

Click here for more information about 21 Recipes for Mining Twitter

Read More...

Object-Oriented Discrete-Event Simulation with Java - A Practical Introduction (SERIES IN COMPUTER SYSTEMS (previously: The Plenum Series in Computer (Series in Computer Science) Review

Average Reviews:

(More customer reviews)Some of the concepts were new to me and some were not. The old ideas were the ones that I came across in a first Java programming course or in a discrete-event simulation course. Book is easy to read, concise, not a textbook. Useful for someone that has not studied anything about discrete-event simulation.

Click Here to see more reviews about: Object-Oriented Discrete-Event Simulation with Java - A Practical Introduction (SERIES IN COMPUTER SYSTEMS (previously: The Plenum Series in Computer (Series in Computer Science)

This book introduces the application of the Java programminglanguage in discrete-event simulation. In addition, the fundamentalconcepts and practical simulation techniques for modeling differenttypes of systems to study their general behavior and their performanceare introduced. The approaches applied are the process interactionapproach to discrete-event simulation and object-oriented modeling.Java is used as the implementation language and UML as the modelinglanguage. The first offers several advantages compared to C++, themost important being thread handling, graphical user interfaces (GUI),and Web computing. The second language, UML (Unified ModelingLanguage), is the standard notation used today for modeling systems asa collection of classes, class relationships, objects, and objectbehavior. The book concentrates on object-oriented modeling andimplementation aspects of simulation models using Java and practicalsimulation techniques. In addition, the book illustrates the dynamicbehavior of systems using the various simulation models as casestudies.

Click here for more information about Object-Oriented Discrete-Event Simulation with Java - A Practical Introduction (SERIES IN COMPUTER SYSTEMS (previously: The Plenum Series in Computer (Series in Computer Science)

Read More...