Books : Computers & Internet : Databases : Specific Databases : IBM DB2

• Home
• US Store
• Electronics
• Computers
• Sitemap

Books : Computers & Internet : Databases : Specific Databases : IBM DB2

• DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification: Certification Study Guide

  Roger E. Sanders, Dwaine R Snow

  

  Database administrators versed in DB2 wanting to learn more about advanced database administration activities and students wishing to gain knowledge to help them pass the DB2 9 UDB Advanced DBA certification exam will find this exhaustive reference invaluable. Written by two individuals who were part of the team that developed the certification exam, this comprehensive study guide prepares the student for challenging questions on database design; data partitioning and clustering; high availability diagnostics; performance and scalability; security and encryption; connectivity and networking; and much more. Providing sample questions in each chapter, a complete practice test modeled after the actual exam, and an extensive answer key providing full explanations for each correct answer, readers will find this to be a key resource in stimulating the learning process.

  
   

• Understanding DB2(R): Learning Visually with Examples (2nd Edition)

  Raul F. Chong, Xiaomei Wang, Michael Dang, Dwaine R. Snow

  

  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
  
   

• Implementing Database Security and Auditing: Includes Examples for Oracle, SQL Server, DB2 UDB, Sybase

  Ron Ben Natan

  
  This book is about database security and auditing. You will learn many methods and techniques that will be helpful in securing, monitoring and auditing database environments. It covers diverse topics that include all aspects of database security and auditing - including network security for databases, authentication and authorization issues, links and replication, database Trojans, etc. You will also learn of vulnerabilities and attacks that exist within various database environments or that have been used to attack databases (and that have since been fixed). These will often be explained to an "internals" level. There are many sections which outline the "anatomy of an attack" - before delving into the details of how to combat such an attack. Equally important, you will learn about the database auditing landscape - both from a business and regulatory requirements perspective as well as from a technical implementation perspective.
  
  * Useful to the database administrator and/or security administrator - regardless of the precise database vendor (or vendors) that you are using within your organization.
  * Has a large number of examples - examples that pertain to Oracle, SQL Server, DB2, Sybase and even MySQL..
  * Many of the techniques you will see in this book will never be described in a manual or a book that is devoted to a certain database product.
  * Addressing complex issues must take into account more than just the database and focusing on capabilities that are provided only by the database vendor is not always enough. This book offers a broader view of the database environment - which is not dependent on the database platform - a view that is important to ensure good database security.
  
   

• DB2 9 Fundamentals Certification Study Guide

  Roger E. Sanders

  
  Starting with the certification process itself and ending with the concept of isolation levels and locking, this guide covers everything needed to know to pass the DB2 9 Fundamentals Certification Exam (Exam 730). The prerequisite for all intermediate and follow-on DB2 certifications, XML usage, basic table creation, a rich set of sample questions, and detailed answers are all included, forming the foundation for understanding the newest version of IBM’s flagship database product. Regardless of what future certification path the reader is planning on pursuing, this study guide will chart a course for proficiency in DB2 9.
  
   

• DB2 9 for z/OS Database Administration: Certification Study Guide

  Susan Lawson, Daniel Luksetich

  
  In order to become an IBM Certified Database Administrator - DB2 9 DBA for z/OS, you must pass two exams: DB2 9 Fundamentals Exam (Exam 730), and DB2 9 Database Administrator for z/OS (Exam 732)—the primary focus focus of this book.
  
  
  
  Written by two members of the team who participated in the actual writing of the exam, this specialized study guide covers every topic that you will need to know to pass Exam 732, including database design and implementation, operation and recovery, security and auditing, performance, as well as installation and migration/upgrade. But that is only the beginning. It also covers the new features of DB2 9 for both database and application development.
  
  
  
  This comprehensive guide includes an extensive set of practice questions in each chapter that closely model the actual exam, along with an answer key with a description of why the answer is the correct one. No other source gives you this much help in passing the exam.
  
  
  
  Whether you plan to take Exam 732 or just want to master the skills needed to be an effective database administrator on z/OS systems, this is the only book you’ll need.
  
  
  
  With the DB2 9 for z/OS Database Administration Certification Study Guide, you will:
  
  
  
  • Discover the changes to DB2 9 that you’ll need to know in order to be successful when taking the exam
  
  
  
  • Learn how to effectively administer a DB2 database
  
  
  
  • Receive an explanation of every objective included on the test…by someone involved in the creation of the actual exam
  
  
  
  • Find 85 practice questions based on the actual exam’s format and approach, along with comprehensive answers to help you gain understanding
  
  
  
  Publisher’s Note: While this book covers much of the information needed to prepare for Exam 730, a far more in-depth review of topics specifically related to Exam 730 can be found in the MC Press companion book: DB2 9 Fundamentals Certification Study Guide by Roger E. Sanders.
  
  
  
   

• DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition)

  George Baklarz, Paul C. Zikopoulos

  

  DB2^® 9 builds on the world's number one enterprise database to simplify the delivery of information as a service, accelerate development, and dramatically improve operational efficiency, security, and resiliency.

  Now, this new edition offers complete, start-to-finish coverage of DB2 9 administration and development for Linux^®, UNIX^®, and Windows^® platforms, as well as authoritative preparation for the latest IBM DB2 certification exam.

  Written for both DBAs and developers, this definitive reference and self-study guide covers all aspects of deploying and managing DB2 9, including DB2 database design and development; day-to-day administration and backup; deployment of networked, Internet-centered, and SOA-based applications; migration; and much more. You'll also find an unparalleled collection of expert tips for optimizing performance, availability, and value.

  Coverage includes:

  • Important security and resiliency enhancements, including advanced access control; fine-grained, label-based security; and the new security administrator role
  • Breakthrough pureXML^™ features that make it easier to succeed with service-oriented architecture
  • Operational improvements that enhance DBA efficiency--including self-tuning memory allocation, automated storage management, and storage optimization
  • Table-partitioning features that improve scalability and manageability
  • Powerful improvements for more agile and rapid development, including the new Eclipse-based Developer Workbench and simple SQL or XQuery access to all data

  Whatever your role in working with DB2 or preparing for certification, DB2 9 for Linux, UNIX, and Windows, Sixth Edition is the one book you can't afford to be without.

  Download Complete DB2 V9 Trial Version

  Visit ibm.com/db2/9/download.html to download a complete trial version of DB2, which enables you to try out dozens of the most powerful features of DB2 for yourself: everything from pureXML support to automated administration and optimization.

  • Straight from IBM, the ultimate guide to running DB2 9 and preparing for the latest IBM DB2 certification exam!
  • Covers powerful DB2 9 enhancements ranging from automated management to improved compression
  • Covers the full spectrum of DBA responsibilities, including server management, data placement, XML concepts, activity analysis, high availability, and security
  • Presents expert tips and best practices from the DB2 customer support organization
  
   

• DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide

  Roger E. Sanders

  
  In DB2 9 for Linux, UNIX, and Windows Database Administration Certification Study Guide, Roger E. Sanders—one of the world’s leading DB2 authors and an active participant in the development of IBM’s DB2 certification exams—covers everything a reader needs to know to pass the DB2 9 UDB DBA Certification Test (731).
  
  
  
  This comprehensive study guide steps you through all of the topics that are covered on the test, including server management, data placement, database access, analyzing DB2 activity, DB2 utilities, high availability, security, and much more. Each chapter contains an extensive set of practice questions along with carefully explained answers.
  
  
  
  Taking and passing the DB2 9 UDB DBA Certification Test (731) provides validation that you have mastered the next level of DB2 9. Passing this exam also earns you the IBM Certified Database Administrator certification. The book includes a complete practice test of 150 questions that closely models the actual exam along with an answer key with a full description of why the answer is the correct one. No other source gives you this much help in passing the exam.
  
  
  
  With the DB2 9 for Linux, UNIX, and Windows Database Administration Certification Study Guide 8, you will:
  
  
  
  • Gain the knowledge necessary to pass the DB2 9 UDB DBA Certification
  
  
  
  • Test (731) Learn how to effectively implement and administer a DB2 database with XML data
  
  
  
  • Create, maintain, and administer database objects like tables, views, and indexes
  
  
  
  • Receive an explanation of every topic included on the test…by someone involved in the creation of the actual exam
  
  
  
  • Find 150 practice questions based on the actual exam’s format and approach, along with comprehensive answers to the test questions to help you gain understanding
  
  
  
   

• DB2 for the COBOL Programmer, Part 1, 2nd Ed.

  Curtis Garvin, Steve Eckols

  
  This book makes it easy for you to master the essentials of DB2 programming. Written from the programmer's point of view, it focuses right from the start on what you need to know to access and process DB2 data in your application programs using embedded SQL

  You'll learn: the basics of how DB2 works so you can program more easily and logically...how to design and code DB2 programs...how to use inner joins, outer joins, and unions to combine data from two or more tables...how to use column functions to extract summary data from a table...how to work with variable-length data and nulls...how to use error handling techniques and ROLLBACK to protect DB2 data...how to use locking and concurrency features so you don't tie up the whole system...how to develop DB2 programs interactively (using DB2I, a TSO facility) or in batch...how to create test data using SPUFI and QMF...and more!

  
   

• DB2(R) SQL PL: Essential Guide for DB2(R) UDB on Linux(TM), UNIX(R), Windows(TM), i5/OS(TM), and z/OS(R) (2nd Edition)

  Zamil Janmohamed, Clara Liu, Drew Bradstock, Raul F. Chong, Michael Gao, Fraser McArthur, Paul Yip

  
  
   

• DB2 9 for Developers

  Philip K. Gunning

  
  Written by an "in-the-trenches" consultant, this guide hails the newest version of DB2 as a major release, highlighting the large number of totally new features, most notably the addition of XML capabilities. Packed with the information DB2 developers and administrators need to know when implementing version 9, the discussion covers upgrading from prior releases of DB2, converting relational data to XML data, and how DB2 supports industry standard schemas. With detailed examples and useful scripts, users learn how to develop DB2 XML applications, design an XML database, and tune the DB2 XML hybrid database. Extensive information on DB2 optimization of SQL and XML is a particularly useful feature of the book and includes a rundown on import and export utilities that database managers can use in their own installations. Going far beyond the standard manuals and certification guides, this is a truly comprehensive resource that teaches the "why" and "how" of a well-designed and well-implemented DB2 database.
  
   

• DB2 for the COBOL Programmer, Part 2, 2nd Ed.

  Curtis Garvin, Anne Prince, Steve Eckols

  
  This new edition of DB2,Part 2, covers the version 4.1 and 5 enhancements to DB2 so programmers can take advantage of all the new and improved features that help them the most. It presents the advanced skills needed to become a top senior programmer or programmer/analyst.

  Specifics covered in the 2nd edition:

  How to use stored procedures that move SQL code off of the client and onto the database server to reduce network overhead

  How to use dynamic SQL so your programs can generate and execute SQL statements as they run

  How data sharing works on the parallel sysplex and other System/390 configurations

  How to work with DB2 data, where the data is managed by a DB2 subsystem on a system thats connected over a network

  How to process DB2 data in CICS programs

  Advanced locking concepts that show how locking and data sharing affect each other and what impact that has on program efficiency

  The concepts and practices of DB2 database administration that let the programmer design databases, manage database objectives, and set up a quality assurance environment

  
   

• DB2 Developer's Guide (5th Edition)

  Craig S. Mullins

  

  Learn the best techniques and tricks from expert author Craig Mullins. Apply these real-world pieces of advice, undocumented tips, solutions, projects, and techniques to your own database management system. Mullins gives you what you need to take your DB2 development to the next level.

  Written by a developer for developers, DB2 Developer¿s Guide, Fifth Edition provides a solutions-oriented approach to learning the foundation and capabilities of this latest version of the world¿s number one database management system.

  LEARN THE CONCEPTS AND BUILD THE APPLICATIONS

  • Implement innovative shortcuts, tips, tricks, techniques, and development guidelines to optimize all facets of DB2 development and administration
  • Understand the guidelines for binding DB2 application plans and packages
  • Use expert advice to implement distributed DB2 applications
  • Connect your DB2 databases to the World Wide Web
  • Review exhaustive coverage of V6 topics¿including triggers, user-defined functions, stored procedure extensions, predictive governing, hiperspace bufferpools, the REBUILD utility, the DSSIZE parameter, user-defined distinct types, auxiliary tables, and more
  • Read implementation information and guidance for large objects to store multimedia data¿such as audio, video, and images¿in your DB2 for OS/390 databases (BLOBs, CLOBs, DBCLOBs, and DB2 extenders)
  • Learn how and why to use the new EXPLAIN tables - DSN_STATEMNT_TABLE and DSN_FUNCTION_TABLE
  • Discover how to implement a procedural DBA function to manage triggers, stored procedures, and UDFs
  
   

• DB2 for the COBOL Programmer: Part 2 : An Advanced Course

  Steve Eckols

  
  Already know the basics of writing DB2 programs? There's still plenty to learn. Part 2 teaches you all the advanced features you're going to want to use as you continue working in DB2. From data manipulation to DB2 processing in CICS to dynamic SQL, this book boosts your DB2 skills...and serves as a quick reference when you're faced with new programming requirements.( 15 chapters, 393 pages, 164 illustrations)
  
   

• Business Intelligence for the Enterprise (IBM DB2 Certification Guides)

  Mike Biere

  
  
   

• Beginning DB2: From Novice to Professional (Expert's Voice)

  Grant Allen

  

  IBM’s DB2 Express Edition is one of the most capable of the free database platforms available in today’s marketplace. In Beginning DB2, author Grant Allen gets you started using DB2 Express Edition for web sites, desktop applications, and more. The author covers the basics of DB2 for developers and database administrators, shows you how to manage data in both XML and relational form, and includes numerous code examples so that you are never in doubt as to how things work. In this book, you’ll find

  • A friendly introduction to DB2 Express Edition, an industrial–strength, relational database from IBM
  • Dozens of examples so that you are never in doubt as to how things work
  • Coverage of important language interfaces, such as from PHP, Ruby, C#, Python, and more
  • Aimed at developers who want a robust database to back their applications

  
  

  What you’ll learn

Who is this book for?

Application developers, including web application developers, looking for a robust, zero–cost database to back their applications. Database administrators looking to get up to speed quickly with DB2.

About the Apress Beginning Series

The Beginning series from Apress is the right choice to get the information you need to land that crucial entry–level job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from “novice to professional.” You’ll start your journey by seeing what you need to know—but without needless theory and filler. You’ll build your skill set by learning how to put together real–world projects step by step. So whether your goal is your next career challenge or a new learning opportunity, the Beginning series from Apress will take you there—it is your trusted guide through unfamiliar territory!