Understanding DB2: Learning Visually with Examples (IBM Press)

3.45 avg rating
( 11 ratings by Goodreads )
 
9780133007046: Understanding DB2: Learning Visually with Examples (IBM Press)

The Easy, Visual Way to Master IBM® DB2 for Linux®, UNIX®, and Windows®—Fully Updated for Version 9.5

IBM DB2 9 and DB2 9.5 provide breakthrough capabilities for providing Information on Demand, implementing Web services and Service Oriented Architecture, and streamlining information management. Understanding DB2: Learning Visually with Examples, Second Edition, is the easiest way to master the latest versions of DB2 and apply their full power to your business challenges.

Written by four IBM DB2 experts, this book introduces key concepts with dozens of examples drawn from the authors' experience working with DB2 in enterprise environments. Thoroughly updated for DB2 9.5, it covers new innovations ranging from manageability to performance and XML support to API integration. Each concept is presented with easy-to-understand screenshots, diagrams, charts, and tables.

This book is for everyone who works with DB2: database administrators, system administrators, developers, and consultants. With hundreds of well-designed review questions and answers, it will also help professionals prepare for the IBM DB2 Certification Exams 730, 731, or 736.

Coverage includes

  • Choosing the right version of DB2 for your needs
  • Installing and configuring DB2
  • Understanding the DB2 environment, instances, and databases
  • Establishing client and server connectivity
  • Working with database objects
  • Utilizing breakthrough pureXML™ technology, which provides for nativeXML support
  • Mastering administration, maintenance, performance optimization, troubleshooting, and recovery
  • Understanding improvements in the DB2 process, memory, and storage models
  • Implementing effective database security
  • Leveraging the power of SQL and XQuery

"synopsis" may belong to another edition of this title.

From the Back Cover:

The Easy, Visual Guide to IBM DB2 V8.2

IBM DB2 Universal Database™ V8.2 for Linux®, UNIX®, and Windows® is a flexible, scalable, cost-effective, and easy-to-use enterprise database. Now, one book makes DB2 even easier. Understanding DB2 teaches DB2 V8.2 visually, step by step, with dozens of examples and case studies drawn from the authors' unsurpassed experience as DB2 consultants at IBM.

Understanding DB2 doesn't just present the big picture. It thoroughly introduces every DB2 concept, procedure, and tool you'll need to get results as an administrator, user, or developer. You'll find authoritative coverage of installation, configuration, objects, database instances, storage, connectivity, security, performance, backup and recovery, SQL fundamentals, and much more. Virtually every new concept is explained with screenshots, diagrams, or tables, all designed to help you learn faster and remember more.

For those preparing for certification, this book also contains over a hundred sample questions crafted by the authors to reflect the content and format of the IBM DB2 UDB Database Administration Certification exams, with answers and detailed explanations.

Coverage includes

  • Understanding the DB2 product family, DB2 commands, and the DB2 environment
  • Configuring client and server connectivity: walkthroughs of four typical scenarios
  • Managing DB2 storage: partitions, tablespaces, buffer pools, and more
  • Leveraging the power of SQL: queries, inserts, deletes, and updates
  • Implementing security: encryption, authentication, and authorization
  • Administering and maintaining data, from LOAD and EXPORT to backup/recovery
  • Providing high availability with online split mirroring and suspended I/O
  • DB2 architecture: process and memory models
  • Managing database performance and troubleshooting


About the Author:

Raul F. Chong, DB2 on Campus Program Manager at the IBM Toronto Laboratory, is a DB2 Certified Solutions Expert in administration and application development with ten years of experience in DB2. He has helped customers resolve DB2 migration, performance, and design issues; developed new DB2 solutions; taught DB2 workshops; contributed to DB2 exam tutorials; and was the lead author of the first edition of Understanding DB2.

Xiaomei Wang, a technical consultant at the IBM Toronto Laboratory, has nine years of DB2 experience. She has handled critical DB2 customer and business partner situations worldwide.

Michael Dang, DB2 Technical Sales Specialist, specializes in solution design, database sizing, product licensing, and Balanced Warehouse configurations. He formerly served as a DB2 Support Analyst and spent seven years as a DB2 DBA.

Dwaine R. Snow, DB2 Senior Product Manager, has worked with DB2 for seventeen years. He is the coauthor of Advanced DBA Certification Guide and Reference for DB2 Universal Database for Linux, UNIX, and Windows, DB2 UDB for Windows, and the first edition of Understanding DB2.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Chong, RaulWang, XiaomeiDang, MichaelSnow, Dwaine
Published by Prentice Hall
ISBN 10: 0133007049 ISBN 13: 9780133007046
New Quantity Available: > 20
Seller
INDOO
(Avenel, NJ, U.S.A.)
Rating
[?]

Book Description Prentice Hall. Book Condition: New. Brand New. Bookseller Inventory # 0133007049

More Information About This Seller | Ask Bookseller a Question

Buy New
£ 34.63
Convert Currency

Add to Basket

Shipping: £ 2.70
Within U.S.A.
Destination, Rates & Speeds

2.

Chong, Raul F.; Wang, Xiaomei; Dang, Michael; Snow, Dwaine
Published by IBM Press (2008)
ISBN 10: 0133007049 ISBN 13: 9780133007046
New Paperback Quantity Available: 1
Seller
Irish Booksellers
(Rumford, ME, U.S.A.)
Rating
[?]

Book Description IBM Press, 2008. Paperback. Book Condition: New. book. Bookseller Inventory # 0133007049

More Information About This Seller | Ask Bookseller a Question

Buy New
£ 50.12
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

3.

Chong, Raul F.; Wang, Xiaomei; Dang, Michael; Snow, Dwaine
Published by IBM Press (2008)
ISBN 10: 0133007049 ISBN 13: 9780133007046
New Softcover Quantity Available: > 20
Seller
Palexbooks
(Sanford, NC, U.S.A.)
Rating
[?]

Book Description IBM Press, 2008. Book Condition: New. Brand new! Please provide a physical shipping address. Bookseller Inventory # 9780133007046

More Information About This Seller | Ask Bookseller a Question

Buy New
£ 58.75
Convert Currency

Add to Basket

Shipping: £ 2.32
Within U.S.A.
Destination, Rates & Speeds

4.

Chong, Raul F.; Wang, Xiaomei; Dang, Michael; Snow, Dwaine
Published by IBM Press
ISBN 10: 0133007049 ISBN 13: 9780133007046
New PAPERBACK Quantity Available: 1
Seller
Cloud 9 Books
(Wellington, FL, U.S.A.)
Rating
[?]

Book Description IBM Press. PAPERBACK. Book Condition: New. 0133007049 New Condition. Bookseller Inventory # NEW6.0052553

More Information About This Seller | Ask Bookseller a Question

Buy New
£ 69.19
Convert Currency

Add to Basket

Shipping: £ 3.85
Within U.S.A.
Destination, Rates & Speeds

5.

Raul F. Chong
Published by IBM Press (2012)
ISBN 10: 0133007049 ISBN 13: 9780133007046
New Paperback Quantity Available: 1
Seller
Revaluation Books
(Exeter, United Kingdom)
Rating
[?]

Book Description IBM Press, 2012. Paperback. Book Condition: Brand New. 2nd edition. 1011 pages. 9.10x7.00x2.00 inches. In Stock. Bookseller Inventory # 0133007049

More Information About This Seller | Ask Bookseller a Question

Buy New
£ 71.34
Convert Currency

Add to Basket

Shipping: £ 6
From United Kingdom to U.S.A.
Destination, Rates & Speeds

6.

Xiaomei Wang, Dwaine R. Snow, Raul F. Chong and Mi
ISBN 10: 0133007049 ISBN 13: 9780133007046
New Quantity Available: 1
Seller
Castle Rock
(Pittsford, NY, U.S.A.)
Rating
[?]

Book Description Book Condition: Brand New. Book Condition: Brand New. Bookseller Inventory # 97801330070461.0

More Information About This Seller | Ask Bookseller a Question

Buy New
£ 103.61
Convert Currency

Add to Basket

Shipping: £ 3.08
Within U.S.A.
Destination, Rates & Speeds