| 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 |
|
|