Database Management Systems Books

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: 62 new & used starting at $9.85

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: 140 Average rating: 4.5 of 5

Precisely what it promises to be: an introduction to SQL 5 out of 5 stars.
0 of 0 people found this review helpful.

Ben Forta has a commendable honesty about him. He explains the intent of his books clearly in their Introductions and then proceeds to deliver just that. In this instance, Forta is clear that the book is for those new to SQL and who quickly want to learn how to get the most out of SQL. He is equally clear that the book does not cover every last aspect of SQL.

The book is becoming a bit long in tooth since it has not been updted since 2004. DBMSs covered are IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL (Version 4), Oracle, PostgreSQL, Sybase Adaptive Server. Some of the information is now outdated and MySQL v5 has added new capabilities. On the whole, though, everything Forta presents here is still usable.

In 22 chapters, Forta teaches the reader the basics of SQL, more than enough to deal with perhaps 80% or more of common SQL requirements. Beyond that and you're in the realm of system architects and administrators who are simply not the audience for this book.

Be sure to download the sample databases and errata from the author's website.

On the whole, one of the best introductions to SQL available.

Jerry

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. Forta's examples are 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: $37.79 List Price: $59.99 Usually ships in 24 hours By: Microsoft Press - Model: 0-7356-2271-X Amazon Marketplace: 41 new & used starting at $31.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: 40 Average rating: 4.0 of 5

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 that exam candidates want most—including 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, monitoring and troubleshooting, and creating and implementing database objects.

Ace your exam preparation and ramp up quickly on SQL Server 2005 database administration by working at your own pace through the lessons, hands-on exercises, and practice tests. The flexible, best-of-class test engine on CD features 300 practice questions and pre-assessment and post-assessment capabilities. Choose timed or untimed testing mode, generate random tests, or focus on discrete objectives or chapters, and get detailed explanations for right and wrong answers—including pointers back to the book for further study. You also get a 180-day evaluation version of SQL Server 2005 Enterprise Edition and a 15 percent exam discount voucher—making this kit an exceptional value and a great career investment.

Microsoft SQL Server 2005 Unleashed

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

Amazon Price: $37.79 List Price: $59.99 Usually ships in 24 hours By: Sams Amazon Marketplace: 57 new & used starting at $29.98

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: 16 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: $31.49 List Price: $49.99 Usually ships in 24 hours By: McGraw-Hill Osborne Media Amazon Marketplace: 45 new & used starting at $24.52

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: 46 Average rating: 4.0 of 5

Save your money.... 1 out of 5 stars.
1 of 2 people found this review helpful.

There's obviously 2 versions of this book: Version 1 uses the Adventureworks data; Version 2 uses Galactic Shipping data.....Installing the Galactic database and info is IMPOSSIBLE!!! Make sure you get the first version or you will truly be sorry (like I am!!!)....Other than that, the book is great.....but finding the download and installing it is truly more trouble than it's worth.......BEWARE!!!

Sql server 2005 Reportin Service, Brian Larson 1 out of 5 stars.
0 of 2 people found this review helpful.

SAVE YOUR MONEY!!! This is a book seems to be targetting retarded. There is a chapter on datbase concepts - if some one does not know, it is unlikely they will be reading reporting services. Too much fluff and descriptions are buried in the fluff. If you skip the fluff, you may find yourself difficult to connect dots. Too much details on formatting fonts, colors which is completly useless.

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.

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

Lynn Beighley

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

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> Specific Databases -> MySQL & mSQL
Subjects -> Computers & Internet -> Databases -> Data Mining

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

Editorial Review:

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!

Pro Oracle Application Express (Expert's Voice in Oracle)

John Scott, Scott Spendolini

Amazon Price: $34.64 List Price: $54.99 Usually ships in 24 hours By: Apress Amazon Marketplace: 37 new & used starting at $32.00

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

Editorial Review:

Application Express, or APEX, is one of the most innovative products to come out of Oracle in years. APEX is an application development framework for developing database–backed applications. It’s easy enough to get started in that power users can quit storing data in random spreadsheets and instead centralize their data in the powerful Oracle database, all without developer help. Developers arent left out, however. Those who choose to can go deep and leverage the full power and flexibility of Oracles database engine.

Getting started with APEX is easy. Learning how to take full advantage of APEX is the problem. It was the problem, that is, until this book came along. In Pro Oracle Application Express, authors John Scott and Scott Spendolini open the “hood” of APEX and expose the full power behind its easy–to–use GUI interface. They show you what you need to know to produce powerful, professionally polished applications, things such as user-authentication models, approaches to layout and navigation, how to integrate Ajax, how to deal with localization issues such as time zones and translations, how to customize the look and feel of an APEX web site, and much, much more.

The authors are well–qualified to write on APEX. John Scott runs ShellPrompt, a hosting service that handles many large-scale APEX applications, some of which he is paid to develop. John is a hard–core APEX developer. His coauthor, Scott Spendolini, is one of the original creators of APEX. Both John and Scott now base their fulltime careers on developing APEX applications. Pro Oracle APEX is your opportunity to learn APEX from the very best.

SQL Cookbook (Cookbooks (O'Reilly))

Anthony Molinaro

Amazon Price: $26.37 List Price: $39.95 Usually ships in 24 hours By: O'Reilly Media, Inc. Amazon Marketplace: 50 new & used starting at $19.43

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> Specific Databases -> MySQL & mSQL
Subjects -> Computers & Internet -> Databases -> Data Mining

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

Editorial Review:

You know the rudiments of the SQL query language, yet you feel you aren't taking full advantage of SQL's expressive power. You'd like to learn how to do more work with SQL inside the database before pushing data across the network to your applications. You'd like to take your SQL skills to the next level.

Let's face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT FROM WHERE . But there is "so" much more you can do with the language. In the "SQL Cookbook," experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. You'll learn about:

Window functions, arguably the most significant enhancement to SQL in the past decade. If you're not using these, you're missing out

Powerful, database-specific features such as SQL Server's PIVOT and UNPIVOT operators, Oracle's MODEL clause, and PostgreSQL's very useful GENERATE_SERIES function

Pivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result set

"Bucketization," and why you should never use that term in Brooklyn.

How to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniques

The technique of "walking a string," which allows you to use SQL to parse through the characters, words, or delimited elements of a string

Written in O'Reilly's popular Problem/Solution/Discussion style, the "SQL Cookbook" is sure to please. Anthony's credo is: "When it comes down to it, we all go to work, weall have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days." The "SQL Cookbook" moves quickly from problem to solution, saving you time each step of the way.

SQL Pocket Guide (Pocket References)

Jonathan Gennick

Amazon Price: $10.19 List Price: $14.99 Usually ships in 24 hours By: O'Reilly Media, Inc. Amazon Marketplace: 50 new & used starting at $2.25

Buy at Amazon.com

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

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

Editorial Review:

SQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business applications. Chances are very good that if you're involved with software development, you're using SQL to some degree. And if you're using SQL, you should own a good reference or two.

Now available in an updated second edition, our very popular "SQL Pocket Guide" is a major help to programmers, database administrators, and everyone who uses SQL in their day-to-day work. The "SQL Pocket Guide" is a concise reference to frequently used SQL statements and commonly used SQL functions. Not just an endless collection of syntax diagrams, this portable guide addresses the language's complexity head on and leads by example. The information in this edition has been updated to reflect the latest versions of the most commonly used SQL variants including:

Oracle Database 10g, Release 2 (including

the free Oracle Database 10g Express Edition (XE))

Microsoft SQL Server 2005

MySQL 5

IBM DB2 8.2

PostreSQL 8.1 database

Professional Microsoft SQL Server 2008 Administration (Wrox Programmer to Programmer)

Brian Knight, Ketan Patel, Wayne Snyder, Ross LoForte, Steven Wort

Amazon Price: $31.49 List Price: $49.99 Usually ships in 24 hours By: Wrox Amazon Marketplace: 38 new & used starting at $24.99

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

Editorial Review:

Loaded with unique tips, tricks and workarounds for handling the most difficult SQL Server admin issues, Professional Microsoft SQL Server 2008 Administration is a how-to guide for experienced DBAs. Understand how to manage and monitor the SQL Server, automated administration, security, change management, performance tuning, scaling and replication, clustering, and backup and recovery. This updated edition includes new information about Change Data Capture, Performance Studio, Query Governor, and new techniques for monitoring and policy management so that you can have the latest and most comprehensive information at your fingertips.

Oracle Database 10g Performance Tuning Tips & Techniques

Richard Niemiec

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

Buy at Amazon.com

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

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

Great book! 5 out of 5 stars.
2 of 3 people found this review helpful.

Great book for Oracle database professionals who want to deepen their understanding of the manifold factors that affect performance. I learned a ton of instantly useful information during my first pass through the book. I now keep this book within arm's reach as a reference, using it frequently to address tuning issues as they arise.

Good examples, a must read for any Oracle DBA 5 out of 5 stars.
1 of 1 people found this review helpful.

I love reading this book. I typically read a few pages before bed. It's filled with lots of practical examples and suggestions. Very thorough explanations. Some of the examples could do with a little more explaining but overall it's still very useful.

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