Tournament of Books 2015
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Original Essays | January 12, 2015

    Christopher Scotton: IMG Five Hundred Mountains Destroyed for a @*&%$! Allegory!



    I found a hole in the perimeter fence on a Sunday when the haul trucks were idle and I could work my way up the shoulder of mountain undetected.... Continue »

    spacer
Qualifying orders ship free.
$72.50
New Hardcover
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
1 Remote Warehouse Database- Design

Other titles in the IBM Press series:

DB2 Essentials: Understanding DB2 in a Big Data World

by

DB2 Essentials: Understanding DB2 in a Big Data World Cover

 

Synopses & Reviews

Publisher Comments:

The Easy, Visual Introduction to IBM DB2 Version 10.5 for Linux, UNIX, and Windows

Foreword by Judy Huber, Vice President, Distributed Data Servers and Data Warehousing; Director, IBM Canada Laboratory

This book covers everything you need to get productive with the latest version of IBM DB2 and apply it to today’s business challenges. It discusses key features introduced in DB2 Versions 10.5, 10.1, and 9.7, including improvements in manageability, integration, security, Big Data support, BLU Acceleration, and cloud computing.

DB2 Essentials illuminates key concepts with examples drawn from the authors’ extensive experience with DB2 in enterprise environments. Raul F. Chong and Clara Liu explain how DB2 has evolved, what’s new, and how to choose the right products, editions, and tools. Next, they walk through installation, configuration, security, data access, remote connectivity, and day-to-day administration.

Each chapter starts with an illustrative overview to introduce its key concepts using a big picture approach. Clearly explained figures are used extensively, and techniques are presented with intuitive screenshots, diagrams, charts, and tables. Case studies illustrate how “theory” is applied in real-life environments, and hundreds of review questions help you prepare for IBM’s newest DB2 certification exams.

Coverage includes

• Understanding the role of DB2 in Big Data

• Preparing for and executing a smooth installation or upgrade

• Understanding the DB2 environment, instances, and databases

• Configuring client and server connectivity

• Working with database objects

• Getting started with BLU Acceleration

• Implementing security: authentication and authorization

• Understanding concurrency and locking

• Maintaining, backing up, and recovering data

• Using basic SQL in DB2 environments

• Diagnosing and solving DB2 problems

This book is for anyone who plans to work with DB2, including DBAs, system administrators, developers, and consultants. It will be a great resource whether you’re upgrading from an older version of DB2, migrating from a competitive database, or learning your first database platform.

Synopsis:

DB2 Essentials, 3E: Understanding DB2 in a Big Data World is the easiest way to master the newest versions of DB2 for Linux®, UNIX®, and Windows, and apply their full power to today’s business challenges. This highly visual guide introduces you to key concepts with dozens of examples drawn from the authors’ experience working with IBM DB2 in enterprise environments. It has been thoroughly updated to reflect major improvements in both DB2 Version 10 and Version 9.7, including innovations in manageability, integration, Big Data support, and cloud computing.

 

This easy tutorial is built around visual learning. Each chapter starts with a large picture to introduce its key concepts. Figures are used extensively, and are fully and clearly explained; each concept is presented with intuitive screenshots, diagrams, charts, and tables. Many examples and case studies illustrate how “theory” is applied in real-life scenarios and production environments. Hundreds of review questions help you prepare for IBM’s newest DB2 certification exams; solutions are provided in an appendix.

 

Building on the previous edition (Understanding DB2), DB2 Essentials is now the first of two volumes. “Essentials” covers everything DB2 newcomers need to get productive, including:

  • A brief history of IBM DB2, new features in the current version, and available products, editions, and tools
  • Installing DB2
  • Creating instances, databases, and database objects
  • Setting up security and choosing the right security options
  • Managing data access (including introductions to SQL and data concurrency)
  • Setting up remote connectivity
  • Administering DB2 databases with the most useful DB2 utilities

About the Author

Raul F. Chong is a Senior DB2, Big Data and Cloud Program Manager and Technical Evangelist based at the IBM Canada Laboratory. He leads the development and design of several offerings for the Information Management (IM) brand of IBM, with the goal of increasing awareness and growing communities around IBM IM products, such as IBM InfoSphere BigInsights, IBM InfoSphere Streams, DB2 database software, IBM Data Studio, InfoSphere Data Architect, and pureQuery technology. As part of the IM Cloud Computing Center of Competence at the Toronto Lab, Raul leads the development and deployment of projects by the community using DB2 on the Cloud, such as bigdatauniversity.com and db2oncampus.org. As a technical evangelist, Raul travels worldwide delivering presentations and workshops targeting customers, IBM business partners, and the Academia. Raul develops and leads the development of collateral material such as articles, books, videos, courses, and DVDs that help educate users in IBM IM products. He has also participated actively in the development of training material and offerings of IBM IM Certification programs. Raul joined IBM in 1997 and has worked as a DB2 consultant, DB2 technical support specialist, and DB2 Information Developer. Raul has summarized many of his DB2 experiences through the years in the first and second editions of the book Understanding DB2—Learning Visually with Examples for which he is the lead author. He has also co-authored the book DB2 SQL PL Essential Guide for DB2 UDB on Linux, UNIX, Windows, i5/OS, and z/OS (ISBN 0131477005), and other books that are part of the DB2 on Campus book series. In his spare time, Raul enjoys playing with his two little daughters. Raul is fluent in Spanish as he was born and raised in Peru, but he keeps some of the Chinese traditions from his grandparents. He also enjoys reading history and archeology books.

Clara Liu was recently appointed to be the Program Manager of IBM Cross Brand Technical Initiatives. She manages leading edge strategic projects across IBM brands. Her prior management role was with the DB2 Planning team. Her previous consulting experience gave her an insight and solid understanding of customers’ needs. Based on market demand, competition pressure, and objectives of maximizing return of investment, she drives software enhancements into the product with the right balance between leading edge technology and business needs. In many DB2, Warehouse, PureData Systems versions and releases, Clara held key responsibilities such as planning product enhancements, managing product offer portfolio and license entitlement, making software available on fulfillment systems for customers, and planning for smooth migration paths for customers when products reach end of life. Over the years, she delivered many product hands-on and video demonstrations with her team. Those are great assets for the IBM Sales and Marketing team and customers who want to ‘see’ and ‘play’ with the technologies. Due to the board involvement in numerous phases of the database product life cycle, Clara has established great networking within the development organization as well as across the business teams. As a mother of two, Clara had coauthored five books (including this one), all focusing in her technical expertise, DB2 for Linux, UNIX, and Windows.

Table of Contents

1. Introduction to DB2

2. DB2 at a Glance: The Big Picture

3. Installing DB2

4. Using Administration and Database Development Tools and Utilities

5. Understanding the DB2 Environment, DB2 Instances, and Databases

6. Configuring Client and Server Connectivity

7. The DB2 Storage Model

8. Working with Database Objects

9. Leveraging the Power of SQL and XQuery

10. Implementing Security

11. Understanding Concurrency and Locking

Appendix A. Solutions to the Review Questions

Appendix B. Use of Uppercase Versus Lowercase in DB2 Resources

Product Details

ISBN:
9780133461909
Author:
Chong, Raul F.
Publisher:
IBM Press
Author:
Chong, Raul
Author:
Liu, Clara
Subject:
Database design
Subject:
Database Management - General
Subject:
DB2; DB2 Version 10; DB2 Unix; DB2 Linux; DB2 Windows; DB2 Oracle; DB2 certification; DB2 migration; DB2 DBA; DB2 administration; DB2 development; DB2 Big Data; DB2 review; DB2 upgrade
Copyright:
Series:
IBM Press
Publication Date:
20131010
Binding:
HARDCOVER
Language:
English
Pages:
784
Dimensions:
9.42 x 7.38 x 1.74 in 1372 gr

Related Subjects

Computers and Internet » Database » Applications
Computers and Internet » Database » Design
Computers and Internet » Software Engineering » Software Management

DB2 Essentials: Understanding DB2 in a Big Data World New Hardcover
0 stars - 0 reviews
$72.50 In Stock
Product details 784 pages IBM Press - English 9780133461909 Reviews:
"Synopsis" by ,

DB2 Essentials, 3E: Understanding DB2 in a Big Data World is the easiest way to master the newest versions of DB2 for Linux®, UNIX®, and Windows, and apply their full power to today’s business challenges. This highly visual guide introduces you to key concepts with dozens of examples drawn from the authors’ experience working with IBM DB2 in enterprise environments. It has been thoroughly updated to reflect major improvements in both DB2 Version 10 and Version 9.7, including innovations in manageability, integration, Big Data support, and cloud computing.

 

This easy tutorial is built around visual learning. Each chapter starts with a large picture to introduce its key concepts. Figures are used extensively, and are fully and clearly explained; each concept is presented with intuitive screenshots, diagrams, charts, and tables. Many examples and case studies illustrate how “theory” is applied in real-life scenarios and production environments. Hundreds of review questions help you prepare for IBM’s newest DB2 certification exams; solutions are provided in an appendix.

 

Building on the previous edition (Understanding DB2), DB2 Essentials is now the first of two volumes. “Essentials” covers everything DB2 newcomers need to get productive, including:

  • A brief history of IBM DB2, new features in the current version, and available products, editions, and tools
  • Installing DB2
  • Creating instances, databases, and database objects
  • Setting up security and choosing the right security options
  • Managing data access (including introductions to SQL and data concurrency)
  • Setting up remote connectivity
  • Administering DB2 databases with the most useful DB2 utilities
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.