Databases Books - Page 5

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes (Sams Teach Yourself)

Ben Forta

Amazon Price: $13.59 List Price: $19.99 Usually ships in 24 hours By: Sams Amazon Marketplace: 46 new & used starting at $11.69

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: 4 Average rating: 5.0 of 5

Editorial Review:

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through 10-minute lessons, you’ll learn everything you need to know to take advantage of Microsoft SQL Server’s T-SQL language.

 

This handy pocket guide starts with simple data retrieval and moves on to more complex topics, including the use of joins, subqueries, full text-based searches, functions and stored procedures, cursors, triggers, table constraints, XML, and much more.

 

You’ll learn what you need to know methodically, systematically, and simply–in highly focused lessons designed to make you immediately and effortlessly productive.

 

Tips point out shortcuts and solutions

 

Cautions help you avoid common pitfalls

 

Notes explain additional concepts, and provide additional information

 

10 minutes is all you need to learn how to…

• Use T-SQL in the Microsoft SQL Server environment
• Construct complex T-SQL statements using multiple clauses and operators
• Filter data so you get the information you need quickly
• Retrieve, sort, and format database contents
• Join two or more related tables
• Make SQL Server work for you with globalization and localization
• Create subqueries to pinpoint your data
• Automate your workload with triggers
• Create and alter database tables
• Work with views, stored procedures, and more

 Register your book at www.samspublishing.com/register to download examples and source code from this book.

Crystal Reports XI: The Complete Reference (Complete Reference Series)

George Peck

Amazon Price: $40.67 List Price: $62.99 Usually ships in 24 hours By: McGraw-Hill Osborne Media Amazon Marketplace: 39 new & used starting at $29.76

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Software -> Business -> Accounting -> General
Subjects -> Computers & Internet -> Software -> Business -> Seagate Crystal Reports
Subjects -> Computers & Internet -> Software -> Business -> General

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

Lots of information, but not as helpful as it should be 3 out of 5 stars.
2 of 3 people found this review helpful.

This book does have a lot of information. However, of course it's not 100% complete, if that means answering every question anyone will have.

There is a lot of information in this book. However, time and time again I find it not answering my questions. It needs a lot more "fill in the gaps" information about how Crystal Reports works, and the context for what is going on. The author needs to step back in many cases and consider what questions a newbie might have about the topic being discussed.

Editorial Review:

This best-seller has been fully updated for Crystal Reports XI (extreme insight) -- the first jointly developed release of this leading report writing and analysis software since the acquisition of Crystal Decisions by Business Objects. Readers will learn to create visually appealing reports that communicate content effectively using helpful features such as charts, complex formulas, custom functions, sorting and grouping, Business Views, and more. Publishing and viewing reports on the Web is also explained in detail. NEW coverage includes: All the new user interface elements; New Dynamic/Cascading Parameter Fields; and, Using Crystal Reports with Business Objects Enterprise XI.

BusinessObjects XI (Release 2): The Complete Reference

Cindi Howson

Amazon Price: $44.09 List Price: $69.99 Usually ships in 24 hours By: McGraw-Hill Osborne Media Amazon Marketplace: 41 new & used starting at $34.95

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Relational Databases
Subjects -> Computers & Internet -> Databases -> General
Subjects -> Computers & Internet -> Databases -> General AAS

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

Wretched 1 out of 5 stars.
5 of 8 people found this review helpful.

I bought the book hoping to get a sound overview of BusinessObjects - what it is, how it works, and how to use it. Instead, I found a combination of marketing gibberish and user documentation that has been recycled and updated so many times that it no longer makes any sense.

This book might be useful for folks who already know some version of BusinessObjects and are looking for a refresher. But if you're trying to learn what BusinessObjects is all about, this book is a very expensive waste of money.

Editorial Review:

This book is a must read for anyone deploying BusinessObjects. It covers everything from planning your upgrade to the latest release, to best practices in universe design, and powerful report creation that maximizes business insight. This book covers the most frequently used features for the full BI suite, in one comprehensive book. There's in depth coverage of Designer, security via the Central Management Console, InfoView, Web Intelligence, and Desktop Intelligence. It goes beyond step-by-step instructions to cover how and why in a business context. Transition notes are interspersed for version 5 and 6 customers to understand the biggest changes in XI Release 2. If you drive BI requirements in your company or are a data warehouse program manager, Business Objects administrator, report author or consumer, this book is for you.. .

SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach (Recipes: a Problem-Solution Approach)

Joseph Sack

Amazon Price: $37.79 List Price: $59.99 Usually ships in 24 hours By: Apress Amazon Marketplace: 40 new & used starting at $33.44

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: 2 Average rating: 5.0 of 5

Editorial Review:

SQL Server 2008 Transact–SQL Recipes: A Problem–Solution Approach is an example–based guide to the Transact–SQL language that is at the core of SQL Server 2008. Learn to create databases, insert and update data, generate reports, secure your data, and more. Author Joseph Sack takes common Transact–SQL tasks and breaks them down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on.

• Focused on solutions: Look up what you need to do. Learn how to do it. Do it.
• Current: Newly updated for SQL Server 2008.
• Comprehensive: Covers 30 different Transact–SQL problem domains.

What you’ll learn

• Create databases, tables, and indexes.
• Query and manipulate data.
• Store and manage XML inside the database.
• Move business logic into the database.
• Encrypt data and capture changes for compliance purposes.
• Implement Full–Text Search.
• Interface with Service Broker.
• And more!

Who is this book for?

Developers who use Microsoft SQL Server 2008 as their back–end database. Database administrators who create, manage, and secure those databases.

Beginning Database Design: From Novice to Professional

Clare Churcher

Amazon Price: $23.09 List Price: $34.99 Usually ships in 24 hours By: Apress Amazon Marketplace: 41 new & used starting at $19.91

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Design
Subjects -> Computers & Internet -> Databases -> Beginning & Introductory
Subjects -> Computers & Internet -> Databases -> General

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

Great for the nuts and bolts of DB design 5 out of 5 stars.
7 of 7 people found this review helpful.

The more I get into database design, the more I keep coming back to this book, as well as Database Design Demysified. The two books are oriented toward small to medium databases, and that's the best way to learn the fundamentals. In my work for the government, I've only seen one or two decently designed databases. The true examples in the book of databases gone wrong are amazing and oh so common. Some much needed humor enlivens a dry subject in both books, and neither throws a lot of jargon at you. Database Modeling and Design (T Teorey) could never teach me how to design a good database! It just never gets down to the nitty gritty details of what works and what doesn't, and why. The two good books are complementary- I reccommend you get them both. Good Luck!

Editorial Review:

Beginning Database Design: From Novice to Professional provides short, easy-to-read explanations of how to get database design right the first time. This book offers numerous examples to help you avoid the many pitfalls that entrap new and not-so-new database designers. Through the help of use cases and class diagrams modeled in the UML, youll learn how to discover and represent the details and scope of the problem in question.

Database design is not an exact science, and solid database design principles and examples help demonstrate the consequences of simplifications and pragmatic decisions. The rationale is to try to keep it simple, but allow room for development as situations change or resources permit. The book also features an introduction for implementing the final design in a relational database.

Bioinformatics for Dummies

Jean-Michel Ph. D. Claverie, Cedric Ph.D. Notredame, Jean-Michel Claverie, Cedric Notredame

List Price: $29.99 By: For Dummies Amazon Marketplace: 38 new & used starting at $0.65

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Computer Science -> General
Subjects -> Computers & Internet -> Computer Science -> General AAS
Subjects -> Computers & Internet -> Databases -> General

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

Editorial Review:

  Bioinformatics – the process of searching biological databases, comparing sequences, examining protein structures, and researching biological questions with a computer – is one of the marvels of modern technology that can save you months of lab work. And the most amazing part is that, if you know how, you can use highly sophisticated programs over the Internet without paying a dime and sometimes, without installing anything new on your own computer. All you need to know is how to use these technological miracles.

That’s where Bioinformatics For Dummies comes in. If you want to know what bioinformatics is all about and how to use it, without wading through pages of computer gibberish or taking a course full of theory, this book has the answers in plain English.  You’ll find out how to

• Use Internet resources
• Understand bioinformatics jargon
• Research biological databases
• Locate the sequences you need
• Perform specific tasks, step by step

Written by two experts who helped develop the science, Bioinformatics For Dummies is all about getting things done. If you’re just getting your feet wet, start at the beginning with a quick review of those necessary parts of microbiology and an overview of the tools available. If you already know what you want to do, you can go directly to a chapter that shows you how. Get the lowdown on

• Researching and analyzing DNA and protein sequences
• Gathering information from all published sources
• Searching databases for similar sequences and acquiring information about gene functions through sequence comparisons
• Producing and editing multiple sequence comparisons for presentation
• Predicting protein structures and RNA structures
• Doing phylogenetic analysis

With an Internet connection and Bioinformatics For Dummies, you’ll discover how to peruse databases that contain virtually everything known about human biology. It’s like having access to the world’s largest lab, right from your desk. This book is your lab assistant – one that never takes a day off, never argues when you ask it for help, and won’t demand a benefits package.

Oracle Database 10g: The Complete Reference (Osborne ORACLE Press Series)

Kevin Loney

Amazon Price: $46.61 List Price: $73.99 Usually ships in 24 hours By: McGraw-Hill Osborne Media Amazon Marketplace: 60 new & used starting at $14.99

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

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

Perfect 5 out of 5 stars.
3 of 4 people found this review helpful.

This is the best book about Oracle 10g I have ever used. It can be read from one end to the other getting comprehensive knowledge of Oracle features. Or you can use it as a reference looking up just in one chapter. Each chapter is independent and clearly explain about the topic in such a manner that you can easily understand it even if you have not read the rest of the book.

I would say this is a must have book if your going to use Oracle 10g. As some one else said it is not a book about configuration, it is a book about the features.

Editorial Review:

Get a thorough understanding of Oracle Database 10g from the most comprehensive Oracle database reference on the market, published by Oracle Press. From critical architecture concepts to advanced object-oriented concepts, this powerhouse contains nearly 50 chapters designed to enlighten you. Upgrade from earlier versions, use SQL, SQL Plus, and PL/SQL. Get code examples and access popular documentation PDFs--plus a full electronic copy of the book on the included CD-ROM. Go beyond the basics and learn security, text searches, external tables, using Java in Oracle, and a great deal more.

Microsoft Access 2003 Forms, Reports, and Queries (Business Solutions)

Paul McFedries

Amazon Price: $23.09 List Price: $34.99 Usually ships in 24 hours By: Que Amazon Marketplace: 42 new & used starting at $9.02

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Computer Science -> Software Engineering -> Information Systems
Subjects -> Computers & Internet -> Databases -> General
Subjects -> Computers & Internet -> Databases -> General AAS

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

Editorial Review:

Develop your Access 2003 expertise instantly with proven techniques!

Let's face it: Microsoft Access is a large, intimidating program. Unlike Word or Excel where you can perform basic tasks without much in the way of training, Access presents challenges from the outset. Most people never progress beyond creating simple tables and using Wizards to create basic forms and reports. At the same time, everyone — from managers to researchers to administrative assistants — needs information and knows that what they seek is embedded somewhere in their Access tables. Without a more sophisticated knowledge of how to extract and present that data, they are forced to rely on office gurus and overworked IT people to provide canned reports or one-size-fits-all solutions.

This book changes all that by giving you the skills to extract the data you need (queries), build efficient front-ends for that data (forms), and publish the results in an attractive and easy-to-read format (reports). To that end, this book shuns the big Access picture and instead focuses intently on queries, forms, and reports. This in-depth approach will give you the knowledge and understanding you need to get at the data and prove the old saw that knowledge is indeed power.

Focuses like a laser on the three technologies that you must master to get the most out of Access: queries, forms, and reports.

Shuns database theory in favor of practical know-how that you can put to use right away.

Packed full of real-world examples and techniques to help you learn and understand the importance of each section.

Crystal Reports 2008: The Complete Reference (Complete Reference Series)

George Peck

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

Buy at Amazon.com

Browse similar items by category:
Subjects -> Business & Investing -> Reference -> Writing
Subjects -> Business & Investing -> Skills -> Communications
Subjects -> Business & Investing -> General

Editorial Review:

Your One-Stop Guide to Enterprise Reporting with Crystal Reports 2008

Transform disconnected corporate data into compelling, interactive business intelligence using all of the powerful tools available in Crystal Reports 2008. Through detailed explanations, real-world examples, and expert advice, this comprehensive guide shows you how to create, maintain, and distribute dynamic, visually appealing enterprise database reports.

Crystal Reports 2008: The Complete Reference explains how to select and gather pertinent business data, organize it into manageable groups, and assemble it into user-friendly business reports. You will learn how to improve report interactivity with sort controls and the parameter panel; solve complex reporting problems with cross-tabs and subreports; integrate Crystal Xcelsius dashboards; reduce development time; and publish your results to Web and Windows applications.

• Integrate pictures, multimedia files, graphs, and charts
• Allow user-controlled report sorting with new sort controls
• Develop sophisticated formulas and custom functions with the Formula Workshop
• Embed Flash files, including Xcelsius 2008 interactive dashboards
• Create complex cross-tab reports with new derived rows and columns
• Export reports into Word, Excel, Acrobat, and updated XML formats
• Enhance Web interactivity with the new parameter panel and optional parameter fields
• Work with SQL databases, OLAP cubes, and proprietary systems
• Centralize design elements and auto-update reports using the repository
• Schedule and distribute reports with the latest BusinessObjects Enterprise XI 3.0
• Embed reports in Web and Windows applications using Visual Studio 2008

Data Manipulation with R (Use R)

Phil Spector

Amazon Price: $47.94 List Price: $54.95 Usually ships in 24 hours By: Springer Amazon Marketplace: 39 new & used starting at $46.58

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> General
Subjects -> Computers & Internet -> Databases -> General AAS
Subjects -> Computers & Internet -> Programming -> Languages & Tools -> General

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

Editorial Review:

Since its inception, R has become one of the preeminent programs for statistical computing and data analysis. The ready availability of the program, along with a wide variety of packages and the supportive R community make R an excellent choice for almost any kind of computing task related to statistics. However, many users, especially those with experience in other languages, do not take advantage of the full power of R. Because of the nature of R, solutions that make sense in other languages may not be very efficient in R. This book presents a wide array of methods applicable for reading data into R, and efficiently manipulating that data.

In addition to the built-in functions, a number of readily available packages from CRAN (the Comprehensive R Archive Network) are also covered. All of the methods presented take advantage of the core features of R: vectorization, efficient use of subscripting, and the proper use of the varied functions in R that are provided for common data management tasks.

Most experienced R users discover that, especially when working with large data sets, it may be helpful to use other programs, notably databases, in conjunction with R. Accordingly, the use of databases in R is covered in detail, along with methods for extracting data from spreadsheets and datasets created by other programs. Character manipulation, while sometimes overlooked within R, is also covered in detail, allowing problems that are traditionally solved by scripting languages to be carried out entirely within R. For users with experience in other languages, guidelines for the effective use of programming constructs like loops are provided. Since many statistical modeling and graphics functions need their data presented in a data frame, techniques for converting the output of commonly used functions to data frames are provided throughout the book.

Using a variety of examples based on data sets included with R, along with easily simulated data sets, the book is recommended to anyone using R who wishes to advance from simple examples to practical real-life data manipulation solutions.