Databases Books

Microsoft SQL Server 2005 Unleashed

Ray Rankins, Paul Bertucci, Chris Gallelli, Alex T. Silverstein

Amazon Price: $35.99 List Price: $59.99 Usually ships in 24 hours By: Sams Amazon Marketplace: 46 new & used starting at $29.60

Buy at Amazon.com

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

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

Editorial Review:

<>Microsoft SQL Server 2005 Unleashed offers comprehensive coverage of SQL Server 2005 that goes beyond the basic syntax and information you’ll find in the product manuals, providing in-depth information derived from the authors’ real-world experience to help you build upon your working knowledge of the product and take your experience and knowledge to a higher level. This book focuses primarily on the information needed by system and database administrators, as well as for users with overlapping duties as both DBA and developer. Included is extensive coverage of the new features and upgraded tools and capabilities of SQL Server 2005, including .NET Framework integration, Integration Services, Service Broker, Database Mirroring and Snapshots, and Reporting Services.

Detailed information on…

• Installing, upgrading, and administering SQL Server 2005
• Database maintenance, backup, and recovery
• Creating and managing tables, views, stored procedures, triggers, and user-defined functions
• Database and index design
• SQL Server query optimization, and performance monitoring and tuning
• Transactions, transaction management, and distributed transactions
• SQL Server Management Studio—NEW!
• SQL Server Notification Services; Integration Services—NEW!; Analysis Services; Reporting Services—NEW!; Web Services—NEW!
• SQL Server Service Broker—NEW!
• SQL Server and Microsoft .NET Framework integration, including CLR-based stored procedures, functions, and triggers—NEW!
• SQL Server high availability and SQL Server clustering and replication
• Database Mirroring—NEW!
• Database Snapshots—NEW!
• Using XML in SQL Server 2005
• SQL Server tools and utilities

CD-ROM includes

• 8 bonus chapters covering topics such as Notification Services, Service Broker, and Full-Text Search
• Code samples, scripts, and sample databases
• A PDF version of the entire book

Introduction

Part I Welcome to Microsoft SQL Server

1 SQL Server 2005 Overview

2 What’s New in SQL Server 2005

Part II SQL Server Tools and Utilities

3 SQL Server Management Studio

4 SQL Server Command-Line Utilities

5 SQL Server Profiler

Part III SQL Server Administration

6 SQL Server System and Database Administration

7 Installing SQL Server 2005

8 Upgrading to SQL Server 2005

9 Client Installation and Configuration

10 Security and User Administration

11 Database Backup and Restore

12 Database Mail

13 SQL Server Scheduling and Notification

14 SQL Server High Availability.

15 Replication

16 Database Mirroring

17 SQL Server Clustering

Part IV Database Administration

18 Creating and Managing Databases

19 Creating and Managing Tables

20 Creating and Managing Indexes

21 Implementing Data Integrity

22 Creating and Managing Views in SQL Server

23 Creating and Managing Stored Procedures

24 Creating and Managing User-Defined Functions

25 Creating and Managing Triggers

26 Transaction Management and the Transaction Log

27 Database Snapshots

28 Database Maintenance

Part V SQL Server Performance and Optimization

29 Indexes and Performance

30 Understanding Query Optimization

31 Query Analysis

32 Locking and Performance

33 Database Design and Performance

34 Monitoring SQL Server Performance

Part VI SQL Server Application Development

35 What’s New for Transact-SQL in SQL Server 2005

36 SQL Server and the .NET Framework

37 Using XML in SQL Server 2005

38 SQL Server Web Services

Part VII SQL Server Business Intelligence Features

39 SQL Server 2005 Analysis Services

40 SQL Server Integration Services

41 SQL Server 2005 Reporting Services

Bonus Chapters on the CD

42 Managing Linked and Remote Servers

43 Configuring, Tuning, and Optimizing SQL Server Options

44 Administering Very Large SQL Server Databases

45 SQL Server Disaster Recovery Planning

46 Transact-SQL Programming Guidelines, Tips, and Tricks

47 SQL Server Notification Services

48 SQL Server Service Broker

49 SQL Server Full-Text Search

Index

Microsoft SQL Server 2005 Reporting Services 2005

Brian Larson

Amazon Price: $29.99 List Price: $49.99 Usually ships in 24 hours By: McGraw-Hill Osborne Media Amazon Marketplace: 27 new & used starting at $24.50

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Networking -> Data in the Enterprise -> Client-Server Systems
Subjects -> Computers & Internet -> Databases -> SQL -> General
Subjects -> Computers & Internet -> Databases -> Database Management Systems

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

A great way to learn the basics 5 out of 5 stars.
2 of 2 people found this review helpful.

I just worked my way cover-to-cover and did every exercise. Sure, there are some errors in the book and sometimes it is not as clear as I would like and it does help to be a DBA but I think the book is rather above average in its accuracy. The book is not useful as a reference. But I highly recommend it as a great start. If you are not going to download the problems and do the exercises, then do not buy this book. The value is in doing the exercises.

Editorial Review:

Microsoft's Reporting Services product is a vital part of the SQL Server 2005 business intelligence platform, but it works with virtually any data source. This hands-on guide explains how to transform data into insightful and interactive Web-based reports using Microsoft SQL Server 2005 Reporting Services. With coverage of everything from installation to administration, the book demonstrates how to use this powerful server-based reporting solution to improve business decision-making and facilitate company-wide -- even worldwide -- communication.

Sams Teach Yourself SQL in 10 Minutes (3rd Edition) (Sams Teach Yourself)

Ben Forta

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

Buy at Amazon.com

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

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

THIS AUTHOR IS SERIOUS!!!........within 10 minutes you can teach yourself a new language 5 out of 5 stars.
3 of 3 people found this review helpful.

SQL in 10 minutes?? ......I thought this guy was kidding. He wasn't. The main reason why I couldn't get a job was because I didn't know SQL, within one hour I read the book, tried all the examples, wrote SQL on my resume, applied for a job and got the job the next day requiring SQL experience :)

This language is so easy to learn, it feels more like an application than a programming language. It seems as though the whole language is really just 3 words, select, from & where, although I'm still new and theres probably a tonne more but I didn't need to know that to get the job.

Compare it to learning c,c++, Fortran and other languages for the first time where you learn to define variables, learn the functions, test cases, inputs, outputs, etc, etc. SQL you pretty much type in the inputs and you receive the outputs...its a really intuitive language, anyone can start learning within minutes. Highly recommend this book, its also probably the best quick reference out there if you need to solve a particular problem.

Editorial Review:

Sams Teach Yourself SQL in 10 Minutes has established itself as the gold standard for introductory SQL books, offering a fast-paced accessible tutorial to the major themes and techniques involved in applying the SQL language. Fortare clear and his writing style is crisp and concise. As with earlier editions, this revision includes coverage of current versions of all major commercial SQL platforms. New this time around is coverage of MySQL, and PostgreSQL. All examples have been tested against each SQL platform, with incompatibilities or platform distinctives called out and explained.

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

Solid Quality Learning

Amazon Price: $35.99 List Price: $59.99 Usually ships in 24 hours By: Microsoft Press - Model: 0-7356-2271-X Amazon Marketplace: 45 new & used starting at $29.97

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Certification Central -> Publisher -> Microsoft Press
Subjects -> Computers & Internet -> Certification Central -> MS SQL Server
Subjects -> Computers & Internet -> Certification Central -> General

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

Book and Software dont work together 1 out of 5 stars.
2 of 2 people found this review helpful.

Many examples in this book can not be compleated with the "Evaluation Software" the is included with the book. Chapters 14, and 15 both reference features not included in this version of the software.

The book has been reading very nicely and I believe that I have learned a lot from it but I have become very frustrated with the way the not all the examples/practice areas can be accessed with the limitations of the included software

Editorial Review:

Announcing an all-new MCTS Training Kit designed to help maximize your performance on Exam 70-431, a core exam for the new Microsoft IT Professional certifications. This kit packs the tools and features wanted mostincluding in-depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and a robust testing suite. It also provides real-world scenarios, case study examples, and troubleshooting labs for skills and expertise that you can apply to the job. Focusing on SQL Server 2005, this official study guide covers topics such as installing and configuring SQL Server, implementing database mirroring, managing database snapshots, working with XML and flat files, managing replication, backing up and restoring a database, and more.

Fundamentals of Database Systems (5th Edition)

Ramez Elmasri, Shamkant B. Navathe

Amazon Price: $93.88 List Price: $118.00 Usually ships in 24 hours By: Addison Wesley Amazon Marketplace: 59 new & used starting at $82.00

Buy at Amazon.com

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

Customer Reviews:
Total reviews: 50 Average rating: 3.5 of 5

Editorial Review:

Responding to the requests of database professors nationwide,the leading textbook for the introductory database management course is being fully revised in time for the startof Fall 1999 classes. Fundamentals of Database Systems, Third Edition is updated to reflect the latest developments indatabase research and practice. It combines clear explanations of theory and real systems, broad coverage of modeling and design of databases, and excellent examples with up-to-date introductions to modern database technology.

Features of the Third Edition

Presents clear and complete discussion of the relational approach including modeling, design, and query languages

Reorganized material on data modeling to clearly separate entity relationship modeling, extended entity relationship modeling, and object-oriented modeling

NEW! Gives examples of real database systems - Oracle and Microsoft Access - in Ch. 10

NEW and EXPANDED! Provides coverage of the object-oriented and object relational approach to data management including ODMG and SQL3

NEW! Includes discussion of decision support applications of data warehousing and data mining, as well as emerging technologies of web databases, multimedia, and mobile databases

NEW! Covers advanced modeling in the areas of active, temporal, and spatial databases

NEW! Discusses current database application areas of GIS, genome, and digital libraries

Microsoft® Office Access(TM) 2007 Inside Out (Microsoft Office Access Inside Out)

John Viescas, Jeff Conrad

Amazon Price: $29.99 List Price: $49.99 Usually ships in 24 hours By: Microsoft Press - Model: 9780735623255 Amazon Marketplace: 40 new & used starting at $25.83

Buy at Amazon.com

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

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

Very helpful, well organized text 5 out of 5 stars.
7 of 7 people found this review helpful.

I opened to Queries, immediately I was able to use what I read in a short time to my work. It's well organized, you can go directly to the chapter of the subject you need to know about. If you don't create tables or databases but just need how to query, you can go directly to that. It's probably the most comprehensive book on Access 2007 out there. I highly recommend.

Editorial Review:

Learn everything you need to know for working with Microsoft Office Access 2007from the inside out! This book packs hundreds of time-saving solutions, troubleshooting tips, and workarounds for using Office Access 2007all in concise, fast-answer format. Whether you are upgrading from Office 97 or Office 2003, youll be able to dig in to the work-ready resources that help you take your Access 2007 experience to the next level. This information-packed complete reference shows you how to get the most out of Access 2007 and find out whats new. You will learn how to design more-efficient databases, streamline data entry, find the information you need, and work with tools to produce effective forms, reports, and queries. In addition, youll begin to explore strategies for database design and advanced table design.

Microsoft Office Access(TM) 2007 Step by Step (Step By Step (Microsoft))

Steve Lambert, M Dow Lambert

Amazon Price: $16.49 List Price: $24.99 Usually ships in 24 hours By: Microsoft Press Amazon Marketplace: 46 new & used starting at $14.98

Buy at Amazon.com

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

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

the fog is clearing 4 out of 5 stars.
24 of 25 people found this review helpful.

This is a good book for a beginner. The examples are very good at walking you through the basics. The terminology/screen shots actually match what Access 2007 looks like. Some of the other books out there don't. Trust me, that creates alot of confusion. This book helps lay the foundation for creating very simple databases. If you have something more complicated in mind, you will need another book. What that book is....I'm not sure. After 2 books, I'm still looking.

Editorial Review:

The smart way to learn Office Access 2007one step at a time! Work at your own pace through the easy numbered steps, practice files on CD, helpful hints, and troubleshooting help to master the fundamentals of working with the latest version of Access, including how to navigate the new user interface. You will discover how to create a database, produce forms, reports, and queries, and how to filter data. Youll also learn how to restrict data access, how to customize your database and how to use VBA to create Web pages based on your dataplus more. With Step by Step, you can take just the lessons you need or work from cover to cover. Either way, you drive the instruction!

IBM Cognos 8 Business Intelligence: The Official Guide

Dan Volitich

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

Buy at Amazon.com

Browse similar items by category:
Subjects -> Business & Investing -> Industries & Professions -> MIS
Subjects -> Computers & Internet -> Software -> Databases
Subjects -> Computers & Internet -> Software -> Business -> General

Customer Reviews:
Total reviews: 3 Average rating: 3.5 of 5

Editorial Review:

The Only Authorized Guide to IBM Cognos 8 Business Intelligence

Develop, deploy, and maintain a complete BI solution across your enterprise. IBM Cognos 8 Business Intelligence: The Official Guide shows you how to take full advantage of the robust service-oriented architecture and simplified role-based user interfaces. Learn how to create, share, and analyze data-rich reports that lead to increased productivity and better business decisions. Featuring real-world insight and expert tips, this is a must-have guide for IBM Cognos 8 Business Intelligence users of all levels, from administrators to end users.

• Measure and monitor performance using dashboards and scorecards
• Assign user roles and privileges
• Provide complete and consistent access to a broad range of data sources via Cognos Connection
• Use Cognos 8 Go! to extend BI to Office applications, mobile devices, and search engines
• Enable business users to create reports with Query Studio
• Develop new insights by exploring data in multiple dimensions and perspectives with Analysis Studio
• Build Dimensional Reports with Report Studio
• Use Event Studio to identify and deliver mission-critical information
• Create, modify, organize, and publish a model from Cognos Framework Manager
• Implement sound security measures
• Take advantage of the management tools in Cognos Administration to ensure maximum reliability and availability

Oracle Database 10g Performance Tuning Tips & Techniques

Richard Niemiec

Amazon Price: $35.99 List Price: $59.99 Usually ships in 24 hours By: McGraw-Hill Osborne Media Amazon Marketplace: 32 new & used starting at $31.78

Buy at Amazon.com

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

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

A "Must Have" Oracle Book 5 out of 5 stars.
1 of 4 people found this review helpful.

A "must have" Oracle book for anyone who works with Oracle on a day-to-day basis. The database efficiencies I have been able to obtain for my clients by simply using Rich's book as a point of reference are well worth the cost in purchasing it.

Adam Suber, Event Chairperson, Southeastern Michigan Oracle Professionals (SEMOP) Group.

Excelent book with adequate technical deep 5 out of 5 stars.
1 of 5 people found this review helpful.

This book manages all concepts, basical and advanced, and the reader can review and fortify concepts. The OCM Author with explains in an easy mode Oracle Products. Excellent book.

Editorial Review:

"Offers hundreds of hints, tips, and tricks of the trade that can be useful to any DBA wanting to achieve maximum performance of Oracle applications. No Oracle library would be complete without this book." --Ken (Dr. DBA) Jacobs, Vice President of Product Strategy for Server Technologies, Oracle Corporation

"Rich is the first and last stop for Oracle Database technology and performance tuning. His knowledge is a vital tool that you need to successfully negotiate the waters of Oracle database development." --Mike Frey, Principal Architect, Navteq

Modern Database Management (8th Edition)

Jeffrey A. Hoffer, Mary Prescott, Fred McFadden

Amazon Price: $132.95 List Price: $166.67 Usually ships in 24 hours By: Prentice Hall Amazon Marketplace: 113 new & used starting at $7.95

Buy at Amazon.com

Browse similar items by category:
Subjects -> Business & Investing -> Industries & Professions -> MIS
Subjects -> Business & Investing -> Management & Leadership -> Motivational
Subjects -> Computers & Internet -> Software -> Databases

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

IT'S POORLY ORGANIZED AND DIFFICULT TO FOLLOW; NOT INTRO BK 1 out of 5 stars.
9 of 35 people found this review helpful.

This is a required textbook for an Intro to DB course. Once again, the University of Texas at Dallas has followed a constant pattern of requiring textbooks that are 1) Poorly organized/written books, 2) expensive and 3)The professor haven't read the book themselves AND are not using/following a required book when teaching their course! This said, my review of this book.

IT'S POORLY ORGANIZED AND DIFFICULT TO FOLLOW; NOT AN INTRO DB BOOK!

For example: "Relational Database" - The book begin this topic on "PAGE 11", but does not define nor clearly explain what this is; the book glorify how "...preliminary studies convinced management of the potential advantage of this approach...modern company should implement..." Then, it talks about "Implementing the Relational Database." Ok, but what the f**k is a Relational database! This continues on until finally at "PAGE 259" when it FINALLY defines what this is.

Good luck!

Editorial Review:

Modern Database Management is the leading text in the business database market. It's noted for its focus on the latest principles, concepts and technologies and what leading practitioners say is most important for database developers.