Contact Us info@learnquest.com

??WelcomeName??
??WelcomeName??
photo

Thank you for your interest in LearnQuest.

Your request is being processed and LearnQuest or a LearnQuest-Authorized Training Provider will be in touch with you shortly.

photo

Thank you for your interest in Private Training.

We look forward to helping you develop the perfect training solution to help you meet your company's goals.

For immediate assistance, speak with one of our representatives using the chat module below. Otherwise, LearnQuest or a LearnQuest-Authorized Training Provider will be in touch with you shortly.

photo

Thank you for your interest in LearnQuest!

Now, you will be able to stay up-to-date on our latest course offerings, promotions, and training discounts. Watch your inbox for upcoming special offers.


IBM and LearnQuest Badge Program - DB2

LearnQuest is working together with IBM to offer IBM training courses and award digital badges upon successful completion and attainment of course objectives.

LearnQuest IBM DB2 Family Foundations

LearnQuest IBM DB2 Family Foundations

This badge holder has been provided with information about the functions of IBM's DB2, a relational database manager which may be installed under a variety of operating systems on many hardware platforms. The student was involved in discussions of how the DB2 products provide services. The badge holder now has the basic fundamentals to describe a relational database using IBM's DB2 database engine.

Click here for course objectives.

Badge Criteria and Activities
Badge earners have successfully achieved class objectives demonstrated by progress in lab exercises, attendance, participation in question & answer sessions, and/or assessments associated with:

  • Major components of DB2
  • Characteristics of a DB2 table; basic concepts of data modeling
  • SQL statements List; Embedded SQL statements
  • Functions performed by, and the responsibilities of, database and system administrators

Recommended next steps:

Evidence:



LearnQuest IBM Db2 Quickstart for Experienced Relational DBAs

LearnQuest IBM Db2 Quickstart for Experienced Relational DBAs

This badge holder has demonstrated experience using the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases & the selection of indexes to improve application performance & the use of SQL statements to track database performance and health. The recipient knows how to implement automatic archival for database logs & to plan a redirected database restore to relocate either selected table spaces or an entire database.

Click here for course objectives.

Badge Criteria and Activities
During a LearnQuest delivered course, badge earners have successfully achieved class objectives demonstrated by student progress in lab exercises, attendance, participation in question & answer sessions, and/or assessments associated with:

  • Performing database administrative tasks using Db2
  • Creating & populating databases
  • Implementing logical design
  • Examining access strategies using the DB2 Explain tools
  • Improving application performance & the use of SQL statements

Recommended next steps:

  1. CL485G DB2 10 for Linux, UNIX, and Windows Quickstart for Experienced Relational DBAs

Evidence:



LearnQuest IBM DB2 pureScale Implementation and Management

LearnQuest IBM DB2 pureScale Implementation and Management

This badge holder has demonstrated experience with planning, installing, managing and monitoring a DB2 pureScale database system. The recipient is able to use the features and functions of DB2 pureScale, including fixpacks.

Click here for course objectives.

Badge Criteria and Activities
During a LearnQuest delivered course, badge earners have successfully achieved class objectives demonstrated by student progress in lab exercises, attendance, participation in question & answer sessions, and/or assessments associated with:

  • Managing, Planning, & Installing a DB2 pureScale Database Cluster
  • Migrating a DB2 pureScale from a non-pureScale DB2 database
  • Using DB2 pureScale monitoring and performance management
  • Managing DB2 pureScale Client Availability and Workload Management

Recommended next steps:

  1. CV843G DB2 11 for zOS Database Administration Workshop Part 2
  2. CV852G DB2 11 for zOS System Administration

Evidence:



LearnQuest IBM DB2 Database Administration 1

LearnQuest IBM DB2 Database Administration 1

This badge holder has demonstrated experience with DB2 data management, DB2 catalog tables, the bind process, database utilities such as LOAD and REORG, and security considerations. The recipient has also demonstrated the ability to physically implement a logical databse design in DB2.

Click here for course objectives.

Badge Criteria and Activities
During a LearnQuest delivered course, badge earners have successfully achieved class objectives demonstrated by student progress in lab exercises, attendance, participation in question & answer sessions, and/or assessments associated with:

  • Setting up a DB2 database design
  • Setting database utilities to load and reorganize data
  • Defining & implementing a DB2 database recovery strategy
  • Using Security and Serialization

Recommended next steps:

  1. CV843G DB2 11 for zOS Database Administration Workshop Part 2
  2. CV852G DB2 11 for zOS System Administration

Evidence:



LearnQuest IBM DB2 11 Database Administration 2

LearnQuest IBM DB2 11 Database Administration 2

This badge holder has demonstrated experience with DB2 11 for z/OS Database Administration in terms of program preparation, online schema changes, user defined functions, archive-enabled and temporal tables, partition management, stored procedures, and triggers.

Click here for course objectives.

Badge Criteria and Activities
During a LearnQuest delivered course, badge earners have successfully achieved class objectives demonstrated by student progress in lab exercises, attendance, participation in question & answer sessions, and/or assessments associated with:

  • Executing programs in the DB2 environment using the TSO Attachment Facility
  • Utilizing UDFs, archive enabled & temporal tables, stored & native SQL procedures
  • Managing partitions & online schema changes; Working with Triggers & partition management

Recommended next steps:

  1. CL315G DB2 LUW 11.1 New Features and Database Migration
  2. CL810G Db2 11.1 HADR Workshop

Evidence:



LearnQuest IBM DB2 for zOS System Administration

LearnQuest IBM DB2 for zOS System Administration

This badge holder has demonstrated experience with DB2 System Administration, relating the z/OS IPL process to a DB2 subsystem, understanding the effects of stopping and starting DB2, using the catalog and DB2 utilities to determine data recovery requirements and DB2 program flow for all environments.

Click here for course objectives.

Badge Criteria and Activities
During a LearnQuest delivered course, badge earners have successfully achieved class objectives demonstrated by student progress in lab exercises, attendance, participation in question & answer sessions, and/or assessments associated with:

  • Using a Set SYSPARM command
  • Locating Command recognition characters
  • Querying the system log to gain knowledge about the IPL process
  • Understanding RACF for DB2 connection security & Implementing security procedures for a DB2 environment

Recommended next steps:

  1. CL315G DB2 LUW 11.1 New Features and Database Migration
  2. CV963G DB2 11 for z/OS Application Performance and Tuning

Evidence:



LearnQuest IBM DB2 for z/OS Implementation

LearnQuest IBM DB2 for z/OS Implementation

This badge holder has demonstrated experience with installing and/or migrating from DB2 10 to DB2 11 for z/OS using the Install CLIST. The recipient understands DB2 11 components and pointers, and the processes used to install or migrate from DB2 10 for z/OS.

Click here for course objectives.

Badge Criteria and Activities
During a LearnQuest delivered course, badge earners have successfully achieved class objectives demonstrated by student progress in lab exercises, attendance, participation in question & answer sessions, and/or assessments associated with:

  • Preparing TSO to run the Install CLIST & executing installation
  • Initializing system data sets & databases
  • Recording data to SMF; Establishing subsystem security
  • Verifying installation & migration
  • Creating a subsystem parameter module

Recommended next steps:

Evidence:



Db2 12 for zOS Advanced Database Administration

Db2 12 for zOS Advanced Database Administration

This credential earner has completed instructor-led learning to introduce advanced database administration skills, including program preparation and the use of packages, online schema changes, partition management, and stored procedures. This also includes performance and availability features of utilities (including LOAD, REBUILD INDEX, REORG, and UNLOAD).

Click here for course objectives.

Badge Criteria and Activities
Successfully complete the following IBM Instructor-Led course: Db2 12 for zOS Advanced Database Administration - Code: CV880G

Recommended next steps:

Evidence:



heres the new schedule
This website uses third-party profiling cookies to provide services in line with the preferences you reveal while browsing the Website. By continuing to browse this Website, you consent to the use of these cookies. If you wish to object such processing, please read the instructions described in our Privacy Policy.