|
| | 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 systems—since 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 |
|
|
