Databases Books - Page 6

Microsoft ® Office 2007 Business Intelligence

Doug Harts

Amazon Price: $26.39 List Price: $39.99 Usually ships in 24 hours By: McGraw-Hill Osborne Media Amazon Marketplace: 38 new & used starting at $17.02

Buy at Amazon.com

Browse similar items by category:
Subjects -> Business & Investing -> Small Business & Entrepreneurship -> New Business Enterprises
Subjects -> Business & Investing -> General
Subjects -> Business & Investing -> General AAS

Customer Reviews:
Total reviews: 8 Average rating: 5.0 of 5

Editorial Review:

Extract and analyze mission-critical enterprise data using Microsoft Office 2007

This authoritative volume is a practical guide to the powerful new collaborative Business Intelligence tools available in Office 2007. Using real-world examples and clear explanations, Microsoft Office 2007 Business Intelligence: Reporting, Analysis, and Measurement from the Desktop shows you how to use Excel, Excel Services, SharePoint, and PerformancePoint with a wide range of stand-alone and external data in today's networked office. You will learn how to analyze data and generate reports, scorecards, and dashboards with the Office tools you're already using to help you in your everyday work.

• Create Excel PivotTables and PivotCharts and apply Conditional Formatting
• Convert Excel spreadsheets into Excel Tables with Conditional Formatting and Charting
• Connect external data to Excel using Office Data Connections and SharePoint
• Create SharePoint dashboards that display data from multiple sources
• Add Key Performance Indicators and Excel Services reports to your dashboards
• Harness advanced SQL Server 2005 data analysis tools with the Excel Data Mining Add-In and Visio Cluster Diagrams
• Generate integrated PerformancePoint Scorecards
• Create Visio PivotDiagrams and Windows Mobile spreadsheets

Microsoft® SQL Server(TM) 2005 Integration Services Step by Step

Paul Turley, Joe Kasprzak, Scott Cameron, Satoshi Iizuka, Pablo Guzman, Hitachi Consulting

Amazon Price: $29.69 List Price: $44.99 Usually ships in 24 hours By: Microsoft Press - Model: 9780735624054 Amazon Marketplace: 51 new & used starting at $8.18

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> Relational Databases
Subjects -> Computers & Internet -> Databases -> SQL -> General

Customer Reviews:
Total reviews: 7 Average rating: 3.0 of 5

Terrible CD companion 1 out of 5 stars.
3 of 5 people found this review helpful.

Terrible CD companion. Most samples have errors, don't run as installed due to incorrect paths and missing connection strings and database auth's. Very frustrating book to learn from if used as a STEP by STEP as the title indicates. Seek a different learning source.

Editorial Review:

Get hands-on, practical guidance for using Microsoft SQL Server Integration Services, the next generation data integration platform from Microsoft. Integration Services is a powerful tool for business intelligence, so understanding the essentials--how to develop and deploy SSIS packages, as well as how to apply these skills to data warehousing solutions--is critical to harnessing the full benefits of SQL Server. This step-by-step tutorial teaches you all the essentials for getting started, including data transformation, scripting, security, and best practices for developing enterprise-class data integration applications. With STEP BY STEP, you work at your own pace through hands-on, learn-by-doing exercises. Whether you're a beginning programmer or new to this version of the technology, you'll understand the fundamental techniques for using SQL Server 2005 Integration Services. A companion CD includes data sets and sample code.

Adobe ColdFusion 8 Web Application Construction Kit, Volume 2: Application Development

Ben Forta, Raymond Camden, Charlie Arehart, John C. Bland, Leon Chalnick, Ken Fricklas, Paul Hastings, Mike Nimer, Sarge Sargent, Robi Sen

Amazon Price: $49.40 List Price: $59.99 Usually ships in 24 hours By: Adobe Press Amazon Marketplace: 43 new & used starting at $44.51

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Home Computing -> Internet -> General AAS
Subjects -> Computers & Internet -> Databases -> Database Design
Subjects -> Computers & Internet -> Databases -> General

Customer Reviews:
Total reviews: 4 Average rating: 3.0 of 5

Disappointed Forta Fan 2 out of 5 stars.
9 of 11 people found this review helpful.

I have almost every book that Ben Forta has written on ColdFusion and have been a big fan of his teaching and writing style but this book is a big disappointment to me.

Firstly, I did not purchase volume 1 since I already have a basic working knowledge CF thanks to his previous books and at the current prices didn't think I needed a reprise. Vol 2 appeared to cover the new CF8 features but it appparently is not a stand-alone version since there were no instructions as to where to obtain and install the sample code and tutorials used in the book. I finally found the link on the back cover, visited the Forta/book site and accessed the forum. I found the supporting files to Vol 2, downloaded and installed them, then discovered that I apparently needed databases and files included in previous books. Not only that, but to "reduce the price" of the book, half the chapters are online.

Chapt 29 spent a great deal of Page space (which seems to be at a premium) expounding on the need to create a good user experience (navigation techniques, fast downloads, etc) - this book was supposed to be on CF8, not best practices in website design. I would have preferred he used the valuable page space for CF8 features and techniques.

I still haven't located what appear to be missing files in a missing directory called "imageserver", (which displays a "page not found" message when trying to view the example code files in Chapter 33) even after spending some frustrating time surfing the online forum.

I expected a book devoted to the new and upgraded CF8 features and not revisiting previous code examples (like Next N) unless the new features impact the former way of doing things, which are covered in a previous Forta books like: Macromedia ColdFusion MX 7 Web Application Construction Kit and Advanced Macromedia ColdFusion MX Application Development (3rd Edition).

I paid almost $50 for one volume of a 3 volume book which is mostly a rewrite of the previous content and half of that is only available on line. I would rather have paid a bit more for new valuable content on the changes in CF8.

When I purchase a book, I expect a book that I can read sitting in a chair - not sitting at a computer reading a pdf file or printing it out on a ream of paper!

Forta's other books are great but this book is not worth the price.

Editorial Review:

ColdFusion 8 Web Application Construction Kit, Volume 2: Application Development begins by introducing important code organization and management techniques, and then progresses to topics that include integrating with all sorts of other technologies (including PDF, Adobe Flex, Ajax, advanced SQL and databases), debugging, and optimizing performance. From design and planning, to application deployment and troubleshooting, this instructional reference is all you need to successfully work, create, and progress with ColdFusion 8, the the most important ColdFusion since the product was created back in 1995

Oracle Database 10g Real Application Clusters Handbook (Osborne Oracle Press)

K Gopalakrishnan

Amazon Price: $37.79 List Price: $59.99 Usually ships in 24 hours By: McGraw-Hill Osborne Media Amazon Marketplace: 36 new & used starting at $31.33

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> Oracle -> General
Subjects -> Computers & Internet -> Databases -> Oracle -> General AAS

Customer Reviews:
Total reviews: 22 Average rating: 4.5 of 5

Gopalakrishnan does it again.. 5 out of 5 stars.
1 of 1 people found this review helpful.

RAC Handbook is an excellent RAC book for new and experienced DBAs. The book is not one of the several 600 page RAC books that contain pages of not-so valuable information. The RAC Handbook is around 400 pages and it is packed with excellent detail on how to install RAC and troubleshoot common performance issues. The author of this book, K Gopalakrishnan is also the author of "Oracle Wait Interface: A Practical Guilde to Performance Diagnostics & Tuning" by Oracle Press. This book won an Oracle award and it one of the best performance tuning books. The RAC Handbook features an excellent chapter on Cache Fusion and several easy to understand examples of how blocks are transferred amongst multiple nodes. The RAC Handbook also has a decent chapter on ASM which could have been a little longer and could have gone into more detail. The chapter on RAC installation will walk you though using the cluster verify utilities which can and will alleviate many headaches that can be experienced during a RAC installation. This book is a great read for anyone that wants to build their RAC skills. Gopalakrishnan is an excellent author and I trust his research.

Editorial Review:

Learn cutting-edge technology from Oracle experts

Written by Oracle insiders, this comprehensive guide covers everything you need to know about Real Application Clusters -- low-cost hardware platforms that can rival and exceed the quality of service, availability, and scalability of the most expensive mainframe systems.

• Concepts covered are applicable to all previous versions of Oracle
• Tuning and troubleshooting tips, providing insight on the most advanced diagnostics available
• Detailed coverage of advanced RAC concepts
• Working code for all examples available online

Inside Microsoft® SQL Server(TM) 2005: Query Tuning and Optimization

Kalen Delaney, Sunil Agarwal, Craig Freedman, Ron Talmage, Adam Machanic

Amazon Price: $31.49 List Price: $49.99 Usually ships in 24 hours By: Microsoft Press Amazon Marketplace: 34 new & used starting at $31.01

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> SQL -> General
Subjects -> Computers & Internet -> Databases -> SQL -> General AAS

Customer Reviews:
Total reviews: 8 Average rating: 4.5 of 5

Books Online gone prolix 2 out of 5 stars.
17 of 19 people found this review helpful.

I was disappointed with this book, which I bought together with SQL Tuning by Dan Tow, hoping to get well-digested expert advice. SQL Tuning was all that I hoped for, and I highly recommend it.

This book, though, has that creepy quality so common to MSFT Press books, where very knowledgeable people, usually connected with the MSFT development teams, list feature after feature in long, passive-voice descriptions, failing to discriminate for the reader and advise as to what is useful and what is not. You have the sense that they spent lots of time at trade shows touting the latest horde of "features", and little time coding under the strain of deadlines and client expectations. To them, every SQL Server nuance is always useful and wonderful and should get fair mention :(

This is a simple example, but SQL Tuning tells me that table scans are normally fine when selecting above 20% of rows, and index seeks are good for row counts under a percent, the space between depending on circumstance (which gray space the book goes on to address). This book, meanwhile, provides no real guidance, and tells me that table scans can be good, and indexes are useful too, and that SQL Server handles both nicely, and that the optimizer selects one or the other, and that it uses iterators, and that they are important, and that you can see what the optimizer has selected, and that you can change that if you want, and that you can automate the change, and that you can document the change, and here are the 4 related undocumented stored procs, and that this is new for 2005, and that there are other related matters, and that SQL Server has all this. Thanks!

Seems they are always plugging the product and never can admit to having suffered with its complexity. The recommendations, if you get them, are always muted by a kool-aid soaked affinity for SQL Server, which does all things well and will never fail to offer just the feature you need to succeed.

The book runs very long and strikes me as a big core dump on 3,000 topics, none of which seem prioritized or emphasized in distinct categories. Sure, the book has distinct chapters into which related material is dumped, but this fails to serve as **guidance**, which is what you are buying the book for. Not written by people in the trenches. Not recommended unless you want to buy some additional MSFT documentation.

Editorial Review:

Dive deep into the internals of query tuning and optimization in SQL Server 2005 with this comprehensive reference. Understanding the internals of SQL Server helps database developers and administrators to better create, access, and effectively process information from enterprise data. Written by experts on SQL Server, this volume from the Inside Microsoft SQL Server series of books focuses on query tuning and optimization. You'll take an in-depth look at the best ways to make queries more efficient and effective, while maximizing existing resources. Includes extensive code samples and table examples to help database developers and administrators understand the intricacies and help promote mastery of query tuning and optimization.

Learning MySQL (Learning)

Seyed M.M. (Saied) Tahaghoghi, Hugh Williams

Amazon Price: $29.69 List Price: $44.99 Usually ships in 24 hours By: O'Reilly Media, Inc. Amazon Marketplace: 55 new & used starting at $19.34

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Computer Science -> Software Engineering -> General AAS
Subjects -> Computers & Internet -> Databases -> Relational Databases
Subjects -> Computers & Internet -> Databases -> Specific Databases -> MySQL & mSQL

Customer Reviews:
Total reviews: 11 Average rating: 4.0 of 5

Editorial Review:

Whether you're running a business, keeping track of members and meetings for a club, or just trying to organize a large and diverse collection of information, you'll find the MySQL database engine useful for answering questions such as: Which are my top ten fastest-selling products? How frequently does this person come to our facility? What was the highest, lowest, and average score of the team last season?

MySQL, the most popular open-source database, offers the power of a relational database in a package that's easy to set up and administer, and "Learning MySQL" provides all the tools you need to get started. This densely packed tutorial includes detailed instructions to help you set up and design an effective database, create powerful queries using SQL, configure MySQL for improved security, and squeeze information out of your data.

After covering the basics, the book travels far into MySQL's subtleties, including complex queries and joins, how to interact with the database over the Web using PHP or Perl, and important house-keeping such as backups and security.

Topic include: Installation on Linux, Windows, and Mac OS X Basic and advanced querying using SQL User management and security Backups and recovery Tuning for improved efficiency Developing command-line and web database applications using the PHP and Perl programming languages

The authors, Saied Tahaghoghi and Hugh E. Williams, have careers in academia and business, and share a keen interest in research into search technologies.

Whether you've never touched a database or have already completed some MySQL projects, you'll find insights in "Learning MySQL" that will last a career.

Oracle Automatic Storage Management: Under-the-Hood & Practical Deployment Guide (Oracle)

Nitin Vengurlekar, Murali Vallath, Rich Long

Amazon Price: $31.49 List Price: $49.99 Usually ships in 24 hours By: McGraw-Hill Osborne Media Amazon Marketplace: 39 new & used starting at $26.35

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> Oracle -> General
Subjects -> Computers & Internet -> Databases -> Oracle -> General AAS

Customer Reviews:
Total reviews: 5 Average rating: 5.0 of 5

Editorial Review:

Build and manage a scalable storage infrastructure with Oracle Automatic Storage Management

Streamline data management and provisioning using Oracle Automatic Storage Management (Oracle ASM) and the detailed information contained in this exclusive Oracle Press resource. Written by a team of database experts, Oracle Automatic Storage Management: Under-the-Hood & Practical Deployment Guide explains how to build and maintain a dynamic, highly available Oracle database storage environment. Inside, you'll learn how to configure storage for Oracle ASM, build disk groups, use data striping and mirroring, and optimize performance. You'll also learn how to ensure consistency across server and storage platforms, maximize data redundancy, and administer Oracle ASM from the command line.

• Manage Oracle ASM Instances and configure Oracle RDBMS instances to leverage Oracle ASM
• Define, discover, and manage disk storage under Oracle ASM
• Create external, normal-redundancy, and high-redundancy disk groups
• Add and remove Oracle ASM storage without affecting RDMS instance availability
• Learn how Oracle ASM provides even I/O distribution
• Work with Oracle ASM directories, files, templates, and aliases
• Improve storage performance and integrity using the ASMLIB API
• Simplify system administration with the Oracle ASM command line interface
• Understand key internal Oracle ASM structures and algorithms

Programming the Microsoft® ADO.NET Entity Framework (PRO-Developer)

David Sceppa

Amazon Price: $26.39 List Price: $39.99 Not yet published By: Microsoft Press

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> General
Subjects -> Computers & Internet -> Databases -> General AAS
Subjects -> Computers & Internet -> Microsoft -> Development -> .NET

Delivering Business Intelligence with Microsoft SQL Server 2005

Brian Larson

Amazon Price: $31.49 List Price: $49.99 Usually ships in 24 hours By: McGraw-Hill Osborne Media Amazon Marketplace: 31 new & used starting at $23.31

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> SQL -> General
Subjects -> Computers & Internet -> Databases -> SQL -> General AAS

Customer Reviews:
Total reviews: 20 Average rating: 4.0 of 5

Not As Useful If You Already Work In BI 3 out of 5 stars.
4 of 4 people found this review helpful.

I've already got experience with tools such as Cognos, ProClarity, Informatica and others. I bought this book to figure out how to use Microsoft's BI tools.

The book really is a case study book where you are the business analyst, the data modeler, the systems analyst the ETL guy and the report developer. It is written with a "learn by doing" premise. If you haven't done all of the business requirements exercises, data modeler tasks, etc... you won't be able to do the Integration Services exercises or the MDX exercises in the book. In other words, you must 1) read the book in the order of its chapters and 2) do the exercises in the chapter order.

Additionally, many chapters are a review of the theory (like snowflake vs. star), business requirements gathering and why you have data marts stuff like that. If you already know how to do these things, or you know that you don't have to take on that role, then you probably won't find this book as useful.

Editorial Review:

Transform disparate enterprise data into actionable business intelligence

Put timely, mission-critical information in the hands of employees across your organization using Microsoft SQL Server 2005 and the comprehensive information in this unique resource. Delivering Business Intelligence with Microsoft SQL Server 2005 shows you, step-by-step, how to author, customize, and distribute information that will give your company the competitive edge. It's all right here--from data mining, warehousing, and scripting techniques to MDX queries, KPI analysis, and the all-new Unified Dimensional Model. Real-world examples, start-to-finish exercises, and downloadable code throughout illustrate all of the integration, analysis, and reporting capabilities of SQL Server 2005.

Adobe ColdFusion 8 Web Application Construction Kit, Volume 3: Advanced Application Development (Web Application Construction Kit)

Ben Forta, Charlie Arehart, Jeffrey Bouley, Jeff Tapper, Matt Tatam, Raymond Camden, Robi Sen, Sarge Sargent

Amazon Price: $48.81 List Price: $59.99 Usually ships in 24 hours By: Adobe Press Amazon Marketplace: 45 new & used starting at $39.75

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Home Computing -> Internet -> General AAS
Subjects -> Computers & Internet -> Databases -> Database Design
Subjects -> Computers & Internet -> Databases -> General

Customer Reviews:
Total reviews: 1 Average rating: 3.0 of 5

Good series, this volume is not as great as other in the series... 3 out of 5 stars.
8 of 9 people found this review helpful.

I got this book, along with Volume 1 and 2, and I will say that I was more than a little disappointed. The biggest issue that I have is that half the book is not included in the book. Basically, in the front of this volume, it says that chapters 41-54 are only on-line. For me, I like having the books for reference when I am not at my computer, so having those sections on-line only are more than a little annoying!

I also noticed more typo's in this volume than the other two. The actual content in the book is fairly helpful and have helped me out.

-Matt

Editorial Review:

The ColdFusion Web Application Construction Kit is the best-selling ColdFusion series of all time—used by more ColdFusion developers to learn the product than any other books. Volume 3, Advanced Application Development introduces advanced ColdFusion features and technologies, including ensuring high availability, security and access control implementations, Java and .NET integration, using feeds and web services, connecting to IM networks, and server OS integration.
Complete coverage of ColdFusion 8 starts in Volume 1, Getting Started (ISBN 0-321-51548-X) and Volume 2 Application Development (ISBN 0-321-51546-3).