Showing posts with label sql. Show all posts
Showing posts with label sql. Show all posts

Oracle SQL High-Performance Tuning with CDROM Review

Oracle SQL High-Performance Tuning with CDROM
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

Pro Active Record: Databases with Ruby and Rails (Expert's Voice)
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...

Oracle PL/SQL Programming Review

Oracle PL/SQL Programming
Average Reviews:

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

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

Oracle PL/SQL Programming ReviewI recommend this book wholeheartedly for beginners as well as veterans of PL/SQL. Especially against the Oracle Press book by author Scott Urman. That book (though it covers the basics), it does not give you the tips and tricks or insight as does Steve's book.
The O'Reilly series book is well crafted, with excellent examples. The style of writing is humorous as well as straight forward. And it is a companion amongst other Oracle books by O'Reilly. O'Reilly Publishing seems to know Oracle better than Oracle Press knows itself.
GioOracle PL/SQL Programming Overview
The first edition of Oracle PL/SQL Programming quickly became anindispensable reference for both novice and experienced PL/SQLdevelopers. Packed with examples and recommendations, it helpedeveryone using PL/SQL (from the Oracle Forms developer to the databaseadministrator) make the most of this powerful language.

Oracle8 presents PL/SQL programmers with new challenges by increasing both the possibilities and complexities of the language.This newedition updates the original book for Oracle8, adding chapters describingthe new PL/SQL object features (object types, collections, object views, and external procedures). The second edition also contains a much-requestedchapter on tuning PL/SQL, as well as expanded discussions of debuggingand tracing PL/SQL execution.

The book comes with a companion diskette containing the Companion UtilitiesGuide for Oracle PL/SQL Programming, an online tool developed by RevealNet,Inc. The online guide contains more than 100 file of source code anddocumentation prepared by the authors.

Even if you've already read the first edition of Oracle PL/SQL Programming,you'll find an enormous amount of new and revised information in thissecond edition and on its companion diskette. If you're new to PL/SQL,you'll soon find yourself on the road to mastery.

NOTE: To make room for the new material, some summaries and code from the first edition have been moved to the companion disk.

Oracle PL/SQL Programming is divided into seven parts:

Foreword Preface

Part I: Programming in PL/SQL
1. Introduction to PL/SQL2. PL/SQL Language Fundamentals3. Effective Coding Style
Part II: PL/SQL Language Elements 4. Variables and Program Data5. Conditional and Sequential Control6. Database Interaction and Cursors7. Loops8. Exception Handlers9. Records in PL/SQL10.PL/SQL Tables Part III: Built-in Functions and Packages 11. Character Functions12. Date Functions13. Numeric, LOB, and Miscellaneous Functions14. Conversion Functions
Part IV: Modular Code 15. Procedures and Functions16. Packages17. Calling Stored PL/SQL Functions from SQL
Part V: PL/SQL Oracle8 Features 18. Object Types19. Nested Tables and VARRAYs20. Object Views21. External Procedures
Part VI: Making PL/SQL Programs Work 22. Code Design Tips23. Managing Code in the Database24. Debugging PL/SQL25. Tracing PL/SQL26. Tuning PL/SQL
Part VII: Appendixes A. What's on the Companion Disk?B. Calling Stored Procedures from PL/SQL Version 1.1C. Built-in Packages


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

>> 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

Joe Celko's SQL for Smarties: Advanced SQL Programming Second Edition (The Morgan Kaufmann Series in Data Management Systems)
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

The Definitive Guide to SQLite
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

SQL Built-In Functions and Stored Procedures: The i5/iSeries Programmer's Guide
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...

Microsoft SQL Server 2008 Management and Administration Review

Microsoft SQL Server 2008 Management and Administration
Average Reviews:

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

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

Microsoft SQL Server 2008 Management and Administration ReviewProduction database administrators have to know at least a little about a lot of things:
* How to install or upgrade SQL Servers
* How to build clusters
* How to plan for disaster recovery and high availability
* How to do performance tuning
* How to secure and protect databases
The production role revolves around management, not creation. Sure, they do need to know T-SQL and be able to debug problem code, but the majority of their day is making the trains run on time - not designing the seats inside the train cars.
Windows administrators who are forced into the SQL Server DBA role need this same type of information. They get handed a database server to manage, often with a database from a third party vendor like Citrix or Blackberry. They have to manage the server, make sure it performs as needed, and back it up safely - but they'll never touch a line of T-SQL code that runs on the server.
Ross Mistry and Hilary Cotter's book Microsoft SQL Server 2008 Management and Administration is a great companion for production DBAs and accidental DBAs. It covers this wide variety of topics in a good depth, and leaves topics like beginning T-SQL or how to write stored procedures out to other books.Microsoft SQL Server 2008 Management and Administration OverviewIf you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based reference you've been searching for. Authored by a world-class expert on SQL Server in the enterprise, this book goes far beyond the basics, taking on the complex tasks that DBAs need to make the most of Microsoft's flagship database platform. SQL Server MVP, Ross Mistry presents proven techniques for SQL Server 2008 installation, upgrades, backup/restore, data transfer, indexing, high availability, security, and much more. He draws on extensive testing in high-profile production environments to offer step-by-step solutions and powerful tips you won't find anywhere else. Every chapter begins with a section identifying SQL Server 2008's most significant new improvements, and concludes with a convenient summary of best practices. Each chapter also outlines the benefits of leveraging Windows Server 2008.

Understand how to:
Master DBA tips, tricks, and best practices proven in actual enterprise environments

Want to learn more information about Microsoft SQL Server 2008 Management and Administration?

>> Click Here to See All Customer Reviews & Ratings Now
Read More...

SQLite Review

SQLite
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...

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

Head First SQL: Your Brain on SQL -- A Learner's Guide
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

Oracle Database 11g SQL (Osborne ORACLE Press Series)
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

Hibernate in Action (In Action series)
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...

Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET Review

Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL and .NET
Average Reviews:

(More customer reviews)
Are you looking to buy Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET? Here is the right place to find the great deals. we can offer discounts of up to 90% on Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET. Check out the link below:

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

Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET ReviewThis book contains much useful information on SQL Server 2005 T-SQL enhancements, but it regularly employs functions and constructs in its examples that are only explained in later passages. Specifically, when attempting to absorb a new concept by examining a code example, you must also contend with looking up items which have not yet been covered. This is a mild stumbling block but it hurts the flow of the book.
Also, the practice database (Asset5) did not attach properly (on my SQL Server 2005 STD edition install regarding appropriate permissions to modify objects) and the most direct workaround was: (1) To use the included, but unreferenced script to initialize the database and all its objects using a "new name" for the database (2) Attach the original database - Asset5 (3) Use the data import feature to populate the "new name" database tables (4) Drop the attached database Asset5 (5) Rename the "new name" database to Asset5. I did first attempt to modify the permissions associated with the login I was using - unsuccessfully...
By way of comparison I am using Oracle Press' "Oracle 9i The Complete Reference" by Koch and Loney as a standard of clarity and conceptual organization for PL-SQL. It is on this basis that I assign this book 3 stars, but admit that I have yet to discover a better book for advanced T-SQL topics. Please feel free to forward me better titles.
As an aside, Murach's SQL for SQL Server is the best introductory text I have found for T-SQL.
Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET Overview
Create and Use Stored Procedures for Optimal Database Performance

Develop complex stored procedures to retrieve, manipulate, update, and delete data. Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET identifies and describes the key concepts, techniques, and best practices you need to master in order to take full advantage of stored procedures using SQL Server's native Transact-SQL and .NET CLR languages. You'll learn to incorporate effective Transact-SQL stored procedures into client or middleware code, and produce CLR methods that will be compiled into CLR stored procedures. This is a must-have resource for all SQL Server 2005 developers.

Essential Skills for Database Professionals
Group and execute T-SQL statements using batches, scripts, and transactionsCreate user-defined, system, extended, temporary, global temporary, and remote stored procedures Develop and manage stored procedures using C# and Visual Basic .NETImplement database access using ADO.NETCreate CLR user-defined functions and triggersImplement reliable debugging and error handling techniques and security measuresManage source code in a repository such as Visual SourceSafeCreate stored procedures for web search enginesUse system and extended stored procedures to interact with the SQL Server environment




Want to learn more information about Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET?

>> 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

Joe Celko's Trees and Hierarchies in SQL for Smarties, (The Morgan Kaufmann Series in Data Management Systems)
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...

PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide Review

PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide
Average Reviews:

(More customer reviews)
Are you looking to buy PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide? Here is the right place to find the great deals. we can offer discounts of up to 90% on PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide. Check out the link below:

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

PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide ReviewAlthough I have some background with programming (Basic, Pascal, COBAL) and desktop db business applications, I had been somewhat intimidated by the idea of server-side programming.
I can only tell you that I did in fact take this book one chapter at a time, sometimes re-reading some sections several times, and marking-up certain parts with a hi-liter and a red pen. I followed the tutorials, downloaded the scripts from the book's associated website, and even got help directly from the author at his website's forum.
Don't misunderstand me, that I marked-up the book, did homework, and asked questions was a reflection of how the book did engage me - AND TAUGHT ME. The book is well written, methodical, detailed, and its intended audience seemed to be someone with my background (pretty fluent in HTML, handy with CSS, has a basic understanding of databases and programming concepts, and who enjoys the learning process under a good professor).
This book will get you started and on your way - correctly. It was the perfect launch site for me (once you get through this book you will be in a good position to evaluate what you need to learn next). As for me, this book (alone) taught me to write programs/scripts to login users, develop MySQL databases, write database reports, do user input forms and process them at the back-end updating the database tables, sessions, cookies, etc. etc.
Select this book. Your php output will be, primarily, html markup. So if you don't know HTML - spend some time with that first -- along with CSS (I recommend CSS The Missing Manual by David S. McFarland).
PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide OverviewIt hasn't taken Web developers long to discover that when it comes to creating dynamic, database-driven Web sites, MySQL and PHP provide a winning open source combination. Add this book to the mix, and there's no limit to the powerful, interactive Web sites that developers can create. With step-by-step instructions, complete scripts, and expert tips to guide readers, veteran author and database designer Larry Ullman gets right down to business: After grounding readers with separate discussions of first the scripting language (PHP) and then the database program (MySQL), he goes on to cover security, sessions and cookies, and using additional Web tools, with several sections devoted to creating sample applications. This guide is indispensable for intermediate- to advanced level Web designers who want to replace their static sites with something dynamic. In this edition, the bulk of the new material covers the latest versions of both technologies: PHP 6 (due out in 2008) and MySQL 5 (available now). The book's publication date is likely to beat the official release of PHP 6, making it one of the first books available on the subject.

Want to learn more information about PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide?

>> Click Here to See All Customer Reviews & Ratings Now
Read More...

SQL: A Beginner's Guide, Second Edition Review

SQL: A Beginner's Guide, Second Edition
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...

The Guru's Guide to Transact-SQL Review

The Guru's Guide to Transact-SQL
Average Reviews:

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

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

The Guru's Guide to Transact-SQL ReviewAh, where to begin. This book is a masterpiece. It is over the top. It distills, in one volume, all that's worth knowing about advanced Transact-SQL. If you've read the Books Online, this book is a natural next step in your T-SQL education. It took me from a rank amateur to an advanced coder within days. It gave me insights into new ways of coding that I'd never have thought of on my own. It showed me how to work in harmony with T-SQL and SQL Server, rather than try to get them to do things they weren't designed to do.
The best chapters, are, IMHO, these:
- DML Insights
- DDL Insights
- The Mighty SELECT
- Statistical Functions
- Transactions
- Cursors
- Sets
- Arrays
- Stored Procedures and Triggers
- T-SQL Performance Tuning
- Administrative T-SQL
- OLE Automation
- Undocumented T-SQL
There's so much good info in this book, it's hard to pick a list of the "best chapters." To be sure, there's not a weak chapter in the book, and you should read every last one of them.
[...] This book is a must-read for anyone serious about coding in Transact-SQL.The Guru's Guide to Transact-SQL OverviewSince its introduction over a decade ago, the Microsoft SQL Server query language, Transact-SQL, has become increasingly popular and more powerful. The current version sports such advanced features as OLE Automation support, cross-platform querying facilities, and full-text search management. This book is the consummate guide to Microsoft Transact-SQL. From data type nuances to complex statistical computations to the bevy of undocumented features in the language, The Guru's Guide to Transact-SQL imparts the knowledge you need to become a virtuoso of the language as quickly as possible. In this book, you will find the information, explanations, and advice you need to master Transact-SQL and develop the best possible Transact-SQL code. Some 600 code examples not only illustrate important concepts and best practices, but also provide working Transact-SQL code that can be incorporated into your own real-world DBMS applications. Your journey begins with an introduction explaining language fundamentals such as database and table creation, inserting and updating data, queries, joins, data presentation, and managing transactions. Moving on to more advanced topics, the journey continues with in-depth coverage of: Transact-SQL performance tuning using tools such as Query Analyzer and Performance Monitor Nuances of the various T-SQL data types Complex statistical calculations such as medians, modes, and sliding aggregates Run, sequence, and series identification and interrogation Advanced Data Definition Language (DDL) and Data Management Language (DML) techniques Stored procedure and trigger best practices and coding methods Transaction management Optimal cursor use and caveats to look out for Full-text search Hierarchies and arrays Administrative Transact-SQL OLE Automation More than 100 undocumented commands and language features, including numerous unpublished DBCC command verbs, trace flags, stored procedures, and functions Comprehensive, written in understandable terms, and full of practical information and examples, The Guru's Guide to Transact-SQL is an indispensable reference for anyone working with this database development language. The accompanying CD-ROM includes the complete set of code examples found in the book as well as a SQL programming environment that will speed the development of your own top-notch Transact-SQL code.

Want to learn more information about The Guru's Guide to Transact-SQL?

>> Click Here to See All Customer Reviews & Ratings Now
Read More...

Oracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2 (Animal Guide) Review

Oracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2 (Animal Guide)
Average Reviews:

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

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

Oracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2 (Animal Guide) ReviewThere are always 2-3 books every developer has in their area of expertise and if you're using PL/SQL, the Feuerstein book is one of them.
I'm not sure how much someone can get out of it if they never did work coding before and you're trying to learn it but I can think of many many times I needed an example for a specific problem and the book had a great example of how to do it.
Also I warn people to be careful because especially for the later chapters, they evolve to the answer to the problem and the cognitive method for this book is to follow along to the end to see how it got there - I think to some of the reviewers this is verbose but this really sinks the PL/SQL concept into your brain effectively and in my experience it's clearly worthwhile. I'm amazed (as always) how clear the evolution is if you take the time to follow it.
I might also add if you're not doing PL/SQL for work but trying to learn it, the evolution might not make sense it's very obvious to me the author has hard core real experience to approach the topics the way he does it.
For people in the field, I'd even say if you're a brand new developer on a job or programmed in something else and are approaching PL/SQL for the first time, the examples are more than clear enough and the opening chapters cover relatively universal and simple concepts so I believe the book is extremely beneficial for beginners as well as very advanced PL/SQL developers.Oracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2 (Animal Guide) Overview
This book is the definitive reference on PL/SQL, considered throughout the database community to be the best Oracle programming book available. Like its predecessors, this fifth edition of Oracle PL/SQL Programming covers language fundamentals, advanced coding techniques, and best practices for using Oracle's powerful procedural language. Thoroughly updated for Oracle Database 11g Release 2, this edition reveals new PL/SQL features and provides extensive code samples, ranging from simple examples to complex and complete applications, in the book and on the companion website. This indispensable reference for both novices and experienced Oracle programmers will help you:



Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing PL/SQL code
Optimize PL/SQL performance with the aid of a brand-new chapter in the fifth edition
Explore datatypes, conditional and sequential control statements, loops, exception handling, security features, globalization and localization issues, and the PL/SQL architecture
Understand and use new Oracle Database 11g features, including the edition-based redefinition capability, the function result cache, the new CONTINUE statement, fine-grained dependency tracking, sequences in PL/SQL expressions, supertype invocation from subtypes, and enhancements to native compilation, triggers, and dynamic SQL
Use new Oracle Database 11g tools and techniques such as PL/Scope, the PL/SQL hierarchical profiler, and the SecureFiles technology for large objects
Build modular PL/SQL applications using procedures, functions, triggers, and packages


Want to learn more information about Oracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2 (Animal Guide)?

>> Click Here to See All Customer Reviews & Ratings Now
Read More...

MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification) Review

MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)
Average Reviews:

(More customer reviews)
Are you looking to buy MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)? Here is the right place to find the great deals. we can offer discounts of up to 90% on MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification). Check out the link below:

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

MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification) ReviewTaking the test which this study guide is focus to is a very important step before give any content's feedback (i'm still preparing myself for the test) But i will give my 1st impression about the book anyway.
Pros:
Very well organized book. Chapters and content are divided in small chunks of information (lessons). For busy people (like me) or those which like to do self study at own pace this is a big aid.
I like the writing style also. Not boring, not too technical altought you should have a previous SQL 2000 background if you want to take full advantage of this book.
I did like chapter 11, the backup and restore processes. This is a must for every SQL admin. and it is well covered. The same for the Maintenance Plan and Job topics (Ch 14)
The 15% off in the test price is a good bonus. You should consider this if you're in a low budget. Cons or critics:
The test engine is an added value but... i don't know ... after taking a few custom tests ... i am not pretty sure about their content's difficulty. I mean, IMO, questions seems too easy for me. I've took a lot of Microsoft tests before (i'm MCSA) and i've never seen easy questions like these in most of them. You must read a lot and think well before mark an answer and i don't feel that when i'm taking this book's test engine. Do not misunderstand what i'm saying, a free Test Engine is a nice bonus, i just want to give a non parcial review. I'm a customer too and we must rely in good study sources to avoid test failures.
Chapter 5: just a brief T-SQL review; use a Sybex SQL 2000 Design book for better preparation or buy the Ben Forta book instead (ISBN: 0672325675), you won't regret and it will help you a lot.
Chapter 12: hey! what happened with the pics here? ... too much words and just a few pics for this topic. Fragmentation concepts are easier to understand when you see how they works; here's when drawings and pics enter into action.
Final comment.
Currently, this is the only book for this test in the market. Sybex and the others are still in press, so there are not much choices either but overall, is a good election anyway; easy to read and very well organized. Find a good PC or laptop, VMWARE or Virtual PC and that's all you need for your study track (SQL 2005 evaluation version is included)
Need extra info? Try SQL 2005 Stanek pocket book ...
UPDATED 7/26/2006:
I already have the new Sybex book for this test. And 'till now, what i've read so far ... i've not found it better than Solid's book. Some Sybex chapters are just a re impression of their old 70-228 book. I keep you informed ...
MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification) Overview
Exam Prep Guide

Ace your preparation for the skills measured by MCTS Exam 70-431-and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you've learned by applying your knowledge to real-world case scenarios and practices. This official Microsoft study guide is designed to help you make the most of your study time.

Maximize your performance on the exam by learning to:

Install and configure SQL Server
Create tables and indexes, define columns, and implement constraints
Implement functions, stored procedures, and triggers by using Transact-SQL
Work with relational and XML data
Monitor, troubleshoot and tune queries
Maintain database availability with log shipping, database mirroring, and replication
Prepare a backup strategy and restore a database

Practice Tests

Assess your skills with practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers?including a customized learning path that describes how and where to focus your studies.

Your training kit includes:

15% exam discount from Microsoft. Offer expires 12/31/10. Details inside.
Official self-paced study guide.
Practice tests with multiple, customizable testing options and a learning plan based on your results.
450 practice and review questions.
Case scenarios, practice exercises, and best practices.
180-day evaluation version of Microsoft SQL Server 2005 Enterprise Edition.
Fully searchable eBook.

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.


Want to learn more information about MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)?

>> Click Here to See All Customer Reviews & Ratings Now
Read More...

The Manga Guide to Databases Review

The Manga Guide to Databases
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...

Microsoft SQL Server 2008 For Dummies (For Dummies (Computer/Tech)) Review

Microsoft SQL Server 2008 For Dummies (For Dummies (Computer/Tech))
Average Reviews:

(More customer reviews)
Are you looking to buy Microsoft SQL Server 2008 For Dummies (For Dummies (Computer/Tech))? Here is the right place to find the great deals. we can offer discounts of up to 90% on Microsoft SQL Server 2008 For Dummies (For Dummies (Computer/Tech)). Check out the link below:

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

Microsoft SQL Server 2008 For Dummies (For Dummies (Computer/Tech)) ReviewThe author is a good writer, he's well organized, he get's his point across well - the problem is that he doesn't do it enough. This is a nice introduction to MS SQL but its simply too short and ultimately too lightweight for the subject. There are other good beginners manuals out there that, if they aren't as entertaining, are more useful. Dummies cut the legs out from under this text by keeping it so compact - too bad, if he'd had more room he undoubtedly could have created a excellent manual.Microsoft SQL Server 2008 For Dummies (For Dummies (Computer/Tech)) OverviewIf you're a database administrator, you know Microsoft SQL Server 2008 is revolutionizing database development. Get up to speed on SQL Server 2008, impress your boss, and improve your company's data management — read Microsoft SQL Server 2008 For Dummies!
SQL Server 2008 lets you build powerful databases and create database queries that give your organization the information it needs to excel. Microsoft SQL Server 2008 For Dummies helps you build the skills you need to set up, administer, and troubleshoot SQL Server 2008. You'll be able to:
Develop and maintain a SQL Server system
Design databases with integrity and efficiency
Turn data into information with SQL Server Reporting Services
Organize query results, summarizing data with aggregate functions and formatting output
Import large quantities of data with SSIS
Keep your server running smoothly
Protect data from prying eyes
Develop and implement a disaster recovery plan
Improve performance with database snapshots
Automate SQL Server 2008 administration

Microsoft SQL Server 2008 For Dummies is a great first step toward becoming a SQL Server 2008 pro!

Want to learn more information about Microsoft SQL Server 2008 For Dummies (For Dummies (Computer/Tech))?

>> Click Here to See All Customer Reviews & Ratings Now
Read More...