Login     Signup
   info@zetlantechnologies.com        +91-8680961847

  /   IBM Certification   /   IBM Data Analytics Certification   /   IBM Db2 12 for z/OS Fundamentals Certification

IBM Associate Certified DBA - DB2 12 for z/OS Fundamentals


Certification overview, objectives, exam preparation and registration





Certification Overview


This Associate DBA certification is an entry level exam for a user of Db2 12 for z/OS. This individual is knowledgeable about the fundamental concepts of Db2 12 for z/OS through either hands-on experience or formal and informal education. The database associate should have an in-depth knowledge of the basic to intermediate tasks required in day-to-day administration, basic SQL (Structured Query Language), understand how to create databases and database objects, and have a basic knowledge of database security and transaction isolation.


Requirements

  • Exam C1000-122 : Db2 12 for z/OS DBA Fundamentals


Exam Objectives

The IBM Certified Administrator - IBM Db2 12 for z/OS is an intermediate-level certification for experienced system administrator who has extensive knowledge and experience of Db2 12 for z/OS. This administrator can perform tasks related to installation and configuration. The administrator also handles daily management and operation, security, performance, updates (including installation of fix packs and patches), customization and/or troubleshooting.



Number of questions : 63

Number of questions to pass : 44


Time allowed : 90 minutes

Status : Live



IBM Associate Certified DBA - Db2 12 for z/OS Fundamentals

C1000-173




Group : Data, Analytics, and AI

Certification status : Live

Credential code : C8003803

Replaces Credential code : N/A

Being Replaced By : C9006800

Required exam : Db2 12 for z/OS DBA Fundamentals

Exam status : Live


An Assessment Exam is an online test that results in a score report to help you gauge your preparedness. They can be booked through Pearson VUE.


The Sample Test is designed to give you an idea of the type of questions you can expect to see on the exam.


Exam Languages : English

Price Per Exam : $200 USD



Course Details

1. Planning

  • Connect to DB2 servers
  • Understand Db2 databases and the different types of tables and table spaces
  • Demonstrate knowledge of subsystem parameters
  • Understand DB2 architecture
  • Understand data sharing concepts

  • Understand DML SQL statement
  • Demonstrate knowledge of the most commonly used special registers, global variables and session variables
  • Demonstrate knowledge of built-in functions
  • Demonstrate an understanding of restricting data access
  • Understand Data Control Language (DCL) SQL statement

  • Demonstrate a basic knowledge of DB2 and DSN
  • Understand the basics of Db2 utilities
  • Demonstrate a basic knowledge of troubleshooting
  • Understand continuous delivery and function levels

  • Understand transaction management
  • Demonstrate knowledge of locking and isolation levels

  • Demonstrate knowledge of stored procedures and user defined functions
  • Understand the use of temporary tables
  • Demonstrate knowledge of triggers and how to use them
  • Demonstrate knowledge of program preparation and BIND options
  • Understand the basics of referential integrity and constraints
  • Demonstrate knowledge of non-relational data concepts
  • Demonstrate knowledge of Temporal (Time Travel) and Archive Tables
  • Understand the basic differences between writing static and dynamic SQL

  • Understand DDL SQL statements
  • Demonstrate the ability to look up information in the Db2 Catalog


Fees Structure : 15500 INR / 185 USD
Total No of Class : 26 Video Class
Class Duration : 31:30 Working Hours
Download Feature : Download Avalable
Technical Support : Call / Whatsapp : +91 8680961847
Working Hours : Monday to Firday 9 AM to 6 PM
Payment Mode : Credit Card / Debit Card / NetBanking / Wallet (Gpay/Phonepay/Paytm/WhatsApp Pay)

Brochure       Buy Now       Sample Demo

Fees Structure : 22500 INR / 270 USD
Class Duration : 30 Days
Class Recording : Live Class Recording available
Class Time : Monday to Firday 1.5 hours per day / Weekend 3 Hours per day
Technical Support : Call / Whatsapp : +91 8680961847
Working Hours : Monday to Firday 9 AM to 6 PM
Payment Mode : Credit Card / Debit Card / NetBanking / Wallet (Gpay/Phonepay/Paytm/WhatsApp Pay)

Download Brochure       Pay Online