Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 certifications for Application Developers.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
sripriya

New User


Joined: 19 Apr 2005
Posts: 26

PostPosted: Wed Feb 28, 2007 11:47 am    Post subject: DB2 certifications for Application Developers.
Reply with quote

Hi all,

Can I know the different levels in DB2 certification for Application Developers.


Thanks,
Sripriya.
Back to top
View user's profile Send private message

vicky10001
Warnings : 1

Active User


Joined: 13 Jul 2005
Posts: 136

PostPosted: Wed Feb 28, 2007 11:58 am    Post subject:
Reply with quote

You can see www.ibm.com
Back to top
View user's profile Send private message
sripriya

New User


Joined: 19 Apr 2005
Posts: 26

PostPosted: Wed Feb 28, 2007 12:07 pm    Post subject: Re: DB2 certifications for Application Developers.
Reply with quote

Thanks a lot Vicky.
Back to top
View user's profile Send private message
vicky10001
Warnings : 1

Active User


Joined: 13 Jul 2005
Posts: 136

PostPosted: Wed Feb 28, 2007 12:20 pm    Post subject:
Reply with quote

I think its usefull

700 - DB2 UDB V8.1 Family Fundamentals

http://www-03.ibm.com/certify/tests/obj700.shtml

This exam contains a total of 54 questions. Candidates are required to score 61% or better to pass the exam and will have 75 minutes to complete the exam.

Section 1 - Planning (15%)

Knowledge of DB2 UDB products (client, server, etc.)
Knowledge of the features in DB2 tools such as: DB2 Extenders, Configuration Assistant, Visual Explain, Command Center, Control Center, Relational Connect, Replication Center, Development Center, and Health Center
Knowledge of Datawarehouse and OLAP concepts
Knowledge of non-relational data concepts (extenders, etc)

Section 2 - Security (9%)

Knowledge of restricting data access
Knowledge of different privileges

Accessing DB2 UDB Data 15%

Ability to identify and locate DB2 UDB servers
Ability to access and manipulate DB2 UDB objects
Ability to create basic DB2 UDB objects

Working with DB2 UDB Data 31%

Knowledge of transactions
Given a DDL SQL statement, knowledge to identify results
Given a DML SQL statement, knowledge to identify results
Given a DCL SQL statement, knowledge to identify results
Ability to use SQL to SELECT data from tables
Ability to use SQL to SORT or GROUP data
Ability to use SQL to UPDATE, DELETE, or INSERT data
Ability to call a procedure

Working with DB2 UDB Objects 19%

Ability to demonstrate usage of DB2 UDB data types
Given a situation, ability to create table
Knowledge to identify when referential integrity should be used
Knowledge to identify methods of data constraint
Knowledge to identify characteristics of a table, view or index

Data Concurrency 11%

Knowledge to identify factors that influence locking
Ability to list objects on which locks can be obtained
Knowledge to identify characteristics of DB2 UDB locks
Given a situation, knowledge to identify the isolation levels that should be used


*****************************************************

Take the following three courses: Courses

Course title: DB2 Family Fundamentals
Course number: CF030 (North America), CF03 (Worldwide)
Course duration: 2 Days
Course abstract: Learn the functions and components of IBM DB2 UDB, a relational database manager, which may be installed on a variety of operating systems. DB2 UDB runs under z/OS and OS/390 on MVS, VM, AIX, Linux, HP-UX, Sun, and Windows operating systems. Discuss the DB2 UDB products and services. Focus on the services DB2 UDB provides and how they work, not on DB2 UDB internal workings.

Course title: SQL-Workshop
Course number: CF120 (North America), CF12 (Worldwide)
Course duration: 2 Days
Course abstract: Learn about SQL and how it applies to the entire DB2 UDB Family. This course is appropriate for individuals working in an OS/390, VM/VSE, AIX, or Windows environment. Complete extensive hands-on exercises to develop your skills to use the SQL you learn. Perform these exercises either by using the DB2 UDB for Linux, UNIX, or Windows product in a Windows environment or by using the DB2 UDB for z/OS product through a Time Sharing Option (TSO) interface to a z/OS system.

Course title: IBM DB2 UDB Essentials Curriculum
Course number: T14D1
Course abstract: This curriculum includes:

IBM DB2 UDB Essentials Part 1 - Fundamentals of DB2 UDB Programming
IBM DB2 UDB Essentials Part 2 - System and Database Administration
IBM DB2 UDB Essentials Part 3 - SQL Fundamentals
IBM DB2 UDB Essentials Part 4 - Advanced SQL

In Part 1, learn the fundamentals of IBM DB2. Get an introduction to the IBM DB2 UDB family and the key elements of database management services. Examine SQL comprehensively from the end user's perspective - write and run SQL and apply SQL to business intelligence. Then explore SQL and programming - the principal elements of SQL test environments, programming, compiling and execution.

In Part 2, focus on the roles and principal tasks of the system administrator and the database administrator in IBM DB2. Learn about administrative utilities and security. Get a comprehensive introduction to the areas of database modeling, database design, and distributed data processing, all of which are core concepts within IBM DB2 UDB.

In Part 3, get an introduction to the fundamental elements of SQL. Address simple query running before moving on to more complex procedures, such as retrieving data from multiple tables and creating single reports from multiple queries. Review scalar and column functions. Also, learn to run subqueries and maintain data. Learn to write basic Data Manipulation Language (DML) SQL statements and basic Data Definition Language (DDL) SQL statements.

In Part 4, learn how to make use of advanced SQL techniques to access DB2 databases in different environments. Examine creating SQL objects, CASE, CAST and summary tables, joins, subqueries, scalar functions, recursive SQL, User-defined Distinct Types (UDT) / User-Defined Functions (UDF), and general performance guidelines.

For information on pricing, scheduling and course registration (note course code number):

IT Training

http://www.ibmmainframes.com/viewtopic.php?t=2300

OR self study with the following publications: Publication

Publication title: Understanding DB2 ? Learning Visually with Examples
- by Chong/Liu/Qi/Snow
Publication order number: ISBN: 0131859161


Publication title: DB2 UDB v8.1 for Linux, UNIX, and Windows Database Administration Certification Guide
- by Baklarz & Wong
Publication order number: Prentice Hall: ISBN: 0-13-046361-2 Textbook Binding - 912 pages, 5th edition (Feb 2003)


Publication title: Teach Yourself DB2 Universal Database in 21 Days
- by Visser & Wong
Publication order number: Sams: ISBN: 0672325829
Paperback - 640 pages, 2nd edition (Aug 2003)


Publication title: DB2 Universal Database V8.1 Certification Exam 700 Study Guide
- by Sanders
Publication order number: Prentice Hall PTR: ISBN 0-13-142465-3
Paperback - 448 pages, 1st edition (Sept 2003)


Publication title: DB2 UDB V8.1 Application Development Certification Guide
- by Sanyal, et. al
Publication order number: Prentice Hall: ISBN 0-13-046391-4
2nd edition (April 2003)


Publication title: The Official Introduction to DB2 UDB for z/OS Version 8
- by Sloan
Publication order number: Prentice Hall: ISBN: 0-13-147750-1 Textbook Binding - 496 pages, 1st edition (Apr 2004)

To order any publications, including certification guides, visit your favorite bookstore or visit one of the following online bookstores:

Discount IBM Developer Bookstore
Barnes & Noble online bookstore



OR self study with the following tutorials: Tutorial

Tutorial: DB2 UDB V8.1 Database Associate Certification Preparation
Abstract: Six tutorials are available to help you prepare for the DB2 UDB V8.1 Family Fundamentals Certification Exam 700. These tutorials provide a solid base for each section of the exam including planning, security, accessing DB2 UDB data, working with DB2 UDB data, working with objects, and data concurrency. These tutorials are available at no cost.

DB2 UDB V8.1 Database Associate Certification Preparation




Test registration

Pearson VUE
(testing worldwide)




Prometric, Inc., formerly Sylvan Prometric (testing worldwide)
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Application not run by time HH:MM tri... jzhardy IBM Tools 1 Sun Apr 09, 2017 3:22 pm
No new posts TWS EQQYCAIN - not sure how to get ap... mbenaud IBM Tools 0 Wed Dec 14, 2016 8:45 pm
No new posts Clone Application ID in TWS Smita.t2 IBM Tools 9 Fri Oct 30, 2015 2:25 pm
No new posts Urgent Openings in IBM India for PL1 ... subratarec Mainframe Jobs 0 Sun Aug 23, 2015 8:31 pm
This topic is locked: you cannot edit posts or make replies. Opening in UST Global for Mainframe D... Akhil Madhavan Mainframe Jobs 0 Tue May 19, 2015 8:59 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us