MC Press Online
Welcome to the MC Press Online!
Need help withour eBooks?
Contact PublishersRow.com
Click here, to go to our main store

  MC Press Online eBookStore  

DB2 10.1 Fundamentals: Certification Study Guide (Exam 610)
preview of book DB2 10.1 Fundamentals: Certification Study Guide (Exam 610)
text of book DB2 10.1 Fundamentals: Certification Study Guide (Exam 610)

DB2 10.1 Fundamentals: Certification Study Guide (Exam 610)

Author:
Publisher: MC Press Online
Publication Date: 2014
Category: Certification
Number of Pages: 536

Free Preview    Email to Friend   Add to wish list
 Available as: (for format`s description click on its name)
Individual E-Version (PDF) Individual E-Version (PDF) ISBN: 9781583473498  
$79.56
 
 Reg.: $
79.95 per N pages
 
 Online  Open CopyPrint    
all time
Printed Edition   see MC Press Online    
About this title
In DB2 10.1 Fundamentals: Certification Study Guide, Roger E. Sanders--one of the world's leading DB2 authors and an active participant in the development of 21 DB2 certification exams--covers everything you need to know to take and pass IBM's DB2 10.1 Fundamentals certification exam (Exam 610).

This comprehensive study guide takes you through each of the topics covered on the exam: planning; security; working with databases and database objects; working with data using SQL and XQuery; working with DB2 tables, views, and indexes; and data concurrency--just to name a few.

For some time, technical certification has been an important trend in the IT industry. Possessing certification credentials is an excellent way to show you have a solid understanding of a technology or software product. Consequently, taking and passing the DB2 10.1 Fundamentals exam provides validation that you have mastered the basics of DB2 Version 10.1. It also earns you IBM Certified Database Associate certification.

In addition to easy-to-understand explanations of every topic on the test, this book contains 150 practice questions that closely model the actual 610 exam--along with an answer key that explains why each chosen answer is correct (and why the other answers are wrong). No other resource gives you this much help in preparing for the DB2 10.1 Fundamentals exam!

Whatever DB2 10.1 certification path you plan to pursue, taking--and, more importantly, passing--the DB2 10.1 Fundamentals exam is the first step. And this book is the best place to find the information you need to know to get started.

Upon completion of this book, you will be able to:
  • Meet the objectives outlined for the DB2 10.1 Fundamentals certification exam
  • Describe new features and functionality introduced with DB2 10.1
  • Assess your ability to pass the DB2 10.1 Fundamentals certification exam
  • Navigate and use the DB2 10.1 Fundamentals exam testing software
  • Obtain IBM Certified Database Associate for DB2 10.1 certification
About author
Roger E. Sanders
Roger E. Sanders is the president of Roger Sanders Enterprises, Inc., and the author of 22 books on relational database technology (21 on DB2 for Linux, UNIX, and Windows; one on ODBC). He has worked with DB2 for Linux, UNIX, and Windows--IBM's relational database management product for open systemssince it was first introduced on the IBM PC as part of OS/2 1.3 Extended Edition (1991), and he has been designing and developing databases and database applications for more than 20 years.

Roger authored a regular column ("Distributed DBA") in IBM Data Magazine (formerly DB2 Magazine) for 10 years, and he has written numerous tutorials and articles for IBM's developerWorks website as well as for publications such as Certification Magazine and IDUG Solutions Journal (the official magazine of the International DB2 User's Group). He has delivered a variety of educational seminars and presentations at DB2-related conferences and has participated in the development of 21 DB2 certification exams.

From 2008 to 2014, Roger has been recognized as an IBM Champion for his contributions to the IBM Data Management community; in 2010 he received recognition as an IBM developerWorks Contributing Author, in 2011 as an IBM developerWorks Professional Author, and in 2012 as an IBM developerWorks Master Author, Level 2 for his contributions to the IBM developerWorks community. (Only four individuals worldwide have received this last distinction.) Roger lives in Fuquay Varina, North Carolina.

Contents
CONTENTS

Introduction
About This Book
Audience
Conventions Used

Chapter 1: IBM DB2 Certification
DB2 10 and 10.1 Certification Roles
Additional DB2 9.7 Certification Roles
The Certification Process

Chapter 2: Planning
The DB2 Family
Database Workloads
Managing Nonrelational Data
DB2's Comprehensive Tool Set

Chapter 3: Security
Controlling Database Access
Authentication
Authorities and Privileges
Granting Authorities and Privileges
Revoking Authorities and Privileges
Row and Column Access Control (RCAC)
Label-Based Access Control (LBAC)
A Word About Trusted Contexts

Chapter 4: Working with Databases and Database Objects
Servers, Instances, and Databases
Other DB2 Objects
Creating a DB2 Database
Establishing a Database Connection
Temporal Data Management and Time Travel Tables

Chapter 5: Working with DB2 Data Using SQL
Structured Query Language (SQL)
SQL Data Manipulation Language (DML) Statements
A Closer Look at the SELECT Statement and Its Clauses
Using a Cursor to Obtain Results from a Result Data Set
Working with Temporal (Time Travel) Tables
Working with XML Data
Working with User-Defined Functions (UDFs)
Working with Stored Procedures
Transactions and Transaction Boundaries

Chapter 6: Working with DB2 Tables, Views, and Indexes
DB2's Data Types
Understanding Data Constraints
Creating Tables
Altering Tables
A Closer Look at Temporary Tables
A Closer Look at Views
A Closer Look at Indexes
A Closer Look at Triggers

Chapter 7: Data Concurrency
Understanding Data Consistency

Appendix A: DB2 10.1 Fundamentals Exam (Exam 610) Objectives
Appendix B: Practice Questions
Appendix C: Answers to Practice Questions
Index
Related titles
DB2 10 for z/OS Database Administration: Certification Study Guide (Exam 612)DB2 10 for z/OS Database Administration: Certification Study Guide (Exam 612)
DB2 9 for DevelopersDB2 9 for Developers
DB2 9 for Linux, UNIX, and Windows Advanced Database Administration: Certification Study Guide (Exam 734)DB2 9 for Linux, UNIX, and Windows Advanced Database Administration: Certification Study Guide (Exam 734)
DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide (Exam 731)DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide (Exam 731)
DB2 9 System Administration for z/OS: Certification Study Guide (Exam 737)DB2 9 System Administration for z/OS: Certification Study Guide (Exam 737)
DB2 9.7 for Linux, UNIX, and Windows Database Administration (Exam 541)DB2 9.7 for Linux, UNIX, and Windows Database Administration (Exam 541)
 
  Special Offer Code  
Enter your Special Offer Code here:
  Search for  

  Our Products  
Browse all »»
DB2 10 for z/OS Database Administration (Exam 612), Chapter 14: Accessing Distributed Data
Advanced Guide to PHP on IBM i
From Idea to Print, Chapter 06: Using Tables, Artwork, and Sidebars

If download option is selected, Adobe Acrobat 5.0 or lateris requiredto read our e-books*


*Windows PC, Mac OS9/OSX, and Linux