Craig S. Mullins' Book Recommendations

Data- and Database-Related Books 

This page contains a listing of my favorite data management related books. Follow the links to order the books from Amazon.com.                                                                          Return to Home Page

Amazon.com 100 Hot Books

Revised March 2012

 

   

DB2 Developer's Guide, 6th edition

Industry-leading text on DB2 for z/OS containing in-depth coverage of all aspects of DB2 database administration, programming, and management. This is the most comprehensive book on mainframe DB2 available.  For more information on the book click here.

Be sure to order the 6th edition using the link on the left. This edition covers up through and including DB2 Version 10.

 

 

Database Administration: The Complete Guide to Practices and Procedures

This book provides the industry’s first non-product based description of database administration techniques and practices. The book defines the job of DBA and what is required of a DBA in clear, easy-to-understand language. For more information on the book click here.

Other Recommended DB2 Books

DB2 9 System Administration for z/OS: Certification Study Guide - Written with system administrators in mind, this reference offers information about both DB2 and z/OS operating systems as well as guidance for preparing for the IBM Certification Test 737.

Understanding DB2: Learning Visually with Examples by Raul Chong and Clara Liu  - A step by step instruction manual to learning DB2 UDB for Linuix, Unix, and Windows.

Understanding DB2 9 Security by Rebecca Bond, et al - a comprehensive guide to securing DB2 and leveraging the powerful new security features of DB2 9.

Recommended SQL Books

SQL Performance Tuning by Peter Gulutzan and Trudy Pelzer - this book provides a comprehensive overview of SQL performance tuning giving guidance and advice on how to properly code and tune SQL for the major DBMS products (including Oracle, DB2, Sybase, Microsoft SQL Server, Informix, Ingres, MySQL, and InterBase). Very useful and well written.

SQL Tuning by Dan Tow - another useful book covering the topic of tuning SQL. If you can only afford one, get the one by Gulutzan and Pelzer, but this is a fine addition to the SQL literature.

SQL for Smarties by Joe Celko - intended for SQL programmers with some experience, this book offers a clear and useful technical discussion of SQL along with practical explanations. If you are looking for SQL queries that solve your most vexing problems, the answer is most likely in this great book.

SQL Hacks by Andrew Cumming & Gordon Russell - takes a different approach than most SQL books by offering 100 concise "hacks" that solve common problems using SQL code.

SQL in a Nutshell, 2nd ed by Kevin Kline - a nice SQL syntax reference for anyone who uses more than one of the popular SQL database management systems.

The Art of SQL by Stephane Faroult - a guide to SQL written using the approach of "The Art of War" by Sun-Tzu.

Recommended Oracle Books

Oracle Database 11g The Complete Reference - explains how to use all the features of Oracle 11g, execute powerful SQL queries, construct PL/SQL and SQL*Plus statements, and work with large objects and object-relational databases. Learn how to implement the latest security measures, tune database performance, and deploy grid computing techniques. Also includes a nice cross-referenced appendix containing Oracle commands, keywords, features, and functions.

OCP Instructors Guide for Oracle DBA Certification by Chris Foot - this book is written by one of the top Oracle instructors in the world and it shows. Chris' experience teaching shines through as he clearly explains the topics that are most troubling to Oracle students.

Oracle Expert: One on One by Thomas Kyte - this book contain a wealth of knowledge on developing Oracle applications, as well as great advice on designing and administering Oracle databases. There are sections on general design and implementation practices, application architecture, locking and concurrency, transactions and rollbacks, importing and exporting, and lots more of interest to developers.

Oracle Insights: Tales of the Oak Table - a completely unique book. It is both entertaining and educational, a tough trick to pull off. Written by a cadre of eleven Oracle experts who have dubbed themselves The Oak Table Network, Oracle Insights offers up just what its title implies. One chapter of the book is devoted to a history of Oracle Corp., another covers the dreaded disease of "compulsive tuning disorder," and there is even a full frontal attack on RAID free, four, and five.

Learning Oracle PL/SQL by Bill Pribyl and Steven Feuerstein - clearly teaches PL/SQL in a variety of ways such that it is useful to a variety of audiences including beginning programmers, new Oracle database administrators, and developers familiar with other databases who now need to learn Oracle. 

 

Recommended SQL Server Books

Microsoft SQL Server 2008 R2 Unleashed - a comprehensive guide to SQL Server 2008 and 2008 R2. It offers nice coverage of SQL Server’s core database server and management capabilities, plus complete introductions to Integration, Reporting, and Analysis Services, application development, and much more.

The Guru's Guide to SQL Server Stored Procedures, XML, and HTML by Ken Henderson - for advanced SQL Server programmers, this book explores the nuances and quirks in SQL Server's stored procedure programming language, Transact-SQL.

MySQL Book Recommendations

MySQL Tutorial by Luke Welling and Laura Thomson - a nice, inexpensive, task-oriented introduction to the capabilities, features, and functionality of the most popular open source DBMS.

MySQL Clustering by Alex Davies and Harrison Fisk - when you need to move beyond the basics this book offers a comprehensive guide to implementing and administering MySQL's clustering technology.

Other Database Book Recommendations

An Introduction to Database Systems, 8th Ed by C.J. Date - a classic in the field of IT and database management. Every database professional should own a copy of this book. It clearly illustrates the theory behind relational databases, as well as their practicality. 

Database In Depth by C.J. Date - this new book represents Date's latest thinking on the fundamental principles of relational database systems. The book is concise, and to the point. If Date’s other voluminous books intimidate you, this book’s 208 pages should be easier to handle.

Practical Issues in Database Management by Fabian Pascal - provides an up-to-date understanding of the practical aspects of crucial, yet little-understood core database issues. The author identifies fundamental concepts, principles, and techniques and assesses the treatment of those issues in SQL. This book is thought-provoking, enlightening, and entertaining.

The Data Warehouse Toolkit by Ralph Kimball - this quintessential guide to dimensional data warehouse modeling and development utilizes case studies from a variety of business applications

Implementing Database Security and Auditing by Ron Ben-Natan - this book is a guide to implementing security and auditing for heterogeneous database environments. It discusses database vulnerabilities and how to combat them. The section on regulatory compliance is particularly helpful in this day-and-age of Sarbanes-Oxley, etc.

Data Modeling and Database Design Book Recommendations

Data Modeling Essentials by Graeme Simsion & Graham Witt  - a nice, well-written guide to data modeling that can serve as the foundation for learning data modeling concepts, or as a comprehensive reference for more experienced data modelers.

Handbook of Relational Database Design by Candace Fleming and Barbara von Halle - this book offers a practical and proven approach to designing relational databases. If you are a DBA or need to design relational databases as part of your job, this book belongs on your desk. Somewhat dated, but still quite useful. 

Data Model Patterns by David Hay - this book analyzes data structures common to many businesses. It shows the patterns inherent in many data models so you do not have to start over from scratch. Includes B&W diagrams, and a set of ready-to-use models for typical applications in many industries.

Mainframe Book Recommendations

Murach's OS/390 and z/OS JCL by Menendez and Lowe- a great JCL reference book for IBM mainframe programmers and DBAs

CICS Desk Reference by Menendez and Lowe - every CICS technician, programmer, and DBA who interacts with CICS needs this book on their desk; it provides a great one-stop place to lookup all things CICS.

Exploring IBM eServer zSeries and S/390 Servers by Hoskins and Frank - a very nice introduction to, and history of, the venerable IBM mainframe computer  

An Introduction to IMS by Metlz, et al - offers a good, technical overview of IBM's stalwart hierarchical DBMS

Java for S/390 and AS/400 COBOL Programmers by Coulthard and Farr - this book offers a great way for us dinosaurs to learn how to code Java

Murach's Structured COBOL by Murach, Prince and Menendez - Mike Murach and his team offer a fantastic COBOL book that is great for both learning COBOL and as a reference for more seasoned veterans

VSAM Access Method Services by James Martin - the classic reference book for mainframers who need to use, program against, or manage VSAM files (either natively, or in conjunction with DB2 or IMS)

 


© 2012 Craig S. Mullins,  All Rights Reserved.
 

hit counter html code