Close
Contact Us info@learnquest.com

??WelcomeName??
??WelcomeName??
« Important Announcement » Contact Us 877-206-0106 | USA Flag
Close
Close
Close
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.

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

title

Date: xxx

Location: xxx

Time: xxx

Price: xxx

Please take a moment to fill out this form. We will get back to you as soon as possible.

All fields marked with an asterisk (*) are mandatory.

Digital Badge Program DB2

A digital credential recognized and valued around the world.

2020 Top 20 Training Industry Company - IT Training

DB2 10 for z/OS Database Administration Part 2 - Code: CV842G

DB2 10 for z/OS Database Administration Part 2 - Code: CV842G

This credential earner has completed instructor-led learning for understanding how to perform database administration tasks.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: DB2 10 for z/OS Database Administration Part 2 - Code: CV842G

Db2 10 for z/OS System Administration - Code: CV851G

Db2 10 for z/OS System Administration - Code: CV851G

This credential earner has completed instructor-led learning for understanding of a view of the architecture and fundamental processes required to manage a Db2 10 for the z/OS subsystem.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: Db2 10 for z/OS System Administration - Code: CV851G

Db2 10 for z/OS Utilities for Database Administrators - Code: CV871G

Db2 10 for z/OS Utilities for Database Administrators - Code: CV871G

This credential earner completed instructor-led learning for understanding Db2 for z/OS utilities. Topics cover: using RUNSTATS to accelerate performance of a given SQL access; employing DSN1COPY, REPAIR & DIAGNOSE for DBA tasks which are not recovery-oriented; using parallel index build with the LOAD, REORG and REBUILD INDEX utilities; load partitions in parallel; LOAD options; concurrency & performance requirements; using options with REORG & UNLOAD; LISTDEF, TEMPLATE, and OPTIONS statements.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: Db2 10 for z/OS Utilities for Database Administrators - Code: CV871G.

DB2 11 for z/OS Application Programming Workshop - Code: CV722G

DB2 11 for z/OS Application Programming Workshop - Code: CV722G

This credential earner has completed instructor-led learning for DB2 11 for z/OS Application Programming Workshop (CV722G) course. They have acquired the skills necessary to produce application programs that manipulate DB2 databases.

Course Objectives

Badge Criteria and Activities

Attendance and successful completion of CV722G DB2 11 for z/OS Application Programming Workshop instructor-led training course

Db2 11 for z/OS Implementation Workshop - Code: CV862G

Db2 11 for z/OS Implementation Workshop - Code: CV862G

This credential earner has completed instructor-led learning for understanding Db2 11 components and pointers, and the processes used to install or migrate from Db2 10 for z/OS. Topics include hands-on experience installing Db2 10 for z/OS and migrating to Db2 11 for z/OS.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: Db2 11 for z/OS Implementation Workshop - Code: CV862G

Db2 11 for z/OS System Administration - Code: CV852G

Db2 11 for z/OS System Administration - Code: CV852G

This credential earner has completed instructor-led learning for understanding a view of the architecture and fundamental processes required to manage a Db2 11 for z/OS subsystem. Topics include: relating the z/OS IPL process to a Db2 subsystem; effects of stopping and starting Db2; Integrated Catalog Facility (ICF) catalog names; DSN command processor; using views; controlling access; catalog search; Internal Resource Lock Manager (IRLM); implementing Db2 and RACF security; and more.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: Db2 11 for z/OS System Administration - Code: CV852G

Db2 11.1 Administration Workshop for Linux - Code: CL207G

Db2 11.1 Administration Workshop for Linux - Code: CL207G

This credential earner has completed instructor-led learning for Db2 11.1 Administration Workshop for Linux (CL207G). They understand basic database administrative tasks using Db2 11.1.

Course Objectives

Badge Criteria and Activities

Attendance and successful completion of CL207G Db2 11.1 Administration Workshop for Linux instructor-led training course

Db2 11.1 Advanced Database Administration - Code: CL464G

Db2 11.1 Advanced Database Administration - Code: CL464G

This credential earner has completed instructor-led learning for understanding how to plan, implement and maintain Db2 11.1 databases. Topics covered include: Advanced Monitoring; Db2 Table Space Management; Db2 Database Memory Management; Database rebuild support; Db2 database and tablespace relocation; and Db2 Incremental Backup.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: Db2 11.1 Advanced Database Administration - Code: CL464G

Db2 11.1 HADR Workshop - Code: CL810G

Db2 11.1 HADR Workshop - Code: CL810G

This credential earner has completed instructor-led learning for understanding how to plan, implement and manage Db2 11.1 databases using the High Availability Disaster Recovery (HADR) feature. This includes: processing performed for a Db2 Primary and Standby Db2 database; Db2 database configuration options that define and control the HADR function; defining and operating multiple HADR standby databases; allowing read only access by applications to a HADR Standby database; Db2 commands and more.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: Db2 11.1 HADR Workshop - Code: CL810G

Db2 11.1 Quickstart for Experienced Relational DBAs - Code: CL487G

Db2 11.1 Quickstart for Experienced Relational DBAs - Code: CL487G

This credential earner has completed instructor-led learning for Db2 11.1 Quickstart for Experienced Relational DBAs (CL487G) course. The badge earner understands basic and advanced administrative tasks using Db2. 11.1.

Course Objectives

Badge Criteria and Activities

Attendance and successful completion of CL487G Db2 11.1 Quickstart for Experienced Relational DBAs instructor-led training course.

Db2 11.5 HADR Workshop - Code: CL910G

Db2 11.5 HADR Workshop - Code: CL910G

This credential earner has completed instructor-led learning for an understanding of how to plan, implement and manage Db2 11.5 databases using the High Availability Disaster Recovery (HADR) feature.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: Db2 11.5 HADR Workshop - Code: CL901G

Db2 11.5 Quickstart for Relational DBAs - Code: CL489G

Db2 11.5 Quickstart for Relational DBAs - Code: CL489G

This credential earner has completed instructor-led learning for understanding how to perform basic and advanced database administrative tasks using Db2 11.5. These tasks include creating and populating databases and implementing a logical design to support recovery requirements. Topics also cover: Db2 Optimizer; Db2 Explain tools; diagnostic methods; db2pd command options; automatic archival for database logs; redirected database restore; REBUILD and TRANSPORT options of RESTORE; plus labs.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: Db2 11.5 Quickstart for Relational DBAs - Code: CL489G

Db2 12 for z/OS Basic Database Administration - Code: CV844G

Db2 12 for z/OS Basic Database Administration - Code: CV844G

This credential earner has completed instructor-led learning for understanding fundamentals of Database Administration for a Db2 12 for z/OS. This includes how to physically implement a logical database design using DDL, and considerations of referentially related tables. Topics covered include the use of basic utilities, program preparation, serialization, and basic database security.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: Db2 12 for z/OS Basic Database Administration - Code: CV844G

Db2 12 for z/OS Introduction to System Administration - Code: CV853G

Db2 12 for z/OS Introduction to System Administration - Code: CV853G

This credential earner has completed instructor-led learning for understanding the skills and knowledge needed to administer a Db2 12 for z/OS system.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course:Db2 12 for z/OS Introduction to System Administration - Code: CV853G

Db2 12 for z/OS SQL Performance and Tuning - Code: CV964G

Db2 12 for z/OS SQL Performance and Tuning - Code: CV964G

This credential earner has completed instructor-led learning for understanding how to prevent SQL performance problems and how to improve the performance of existing SQL. Topics include: understanding and designing better indexes; determining how to work with the optimizer (avoid pitfalls, provide guidance); optimizing multi-table access; working with subqueries; avoiding locking problems; and using accounting traces and other tools to locate performance problems in existing SQL.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: Db2 12 for z/OS SQL Performance and Tuning - Code: CV964G

Db2 12 for zOS: Basics for DBA Beginners - Code: CV042G

Db2 12 for zOS: Basics for DBA Beginners - Code: CV042G

This credential earner has completed instructor-led learning for Db2 12 for zOS: Basics for DBA Beginners (CV042G) course. They have learned the fundamental skills required to administer a Db2 Database in a z/OS environment.

Course Objectives

Badge Criteria and Activities

Attendance and successful completion of CV042G Db2 12 for zOS: Basics for DBA Beginners instructor-led training course

Db2 13 for z/OS Utilities for Database Administrators - Code: CV972G

Db2 13 for z/OS Utilities for Database Administrators - Code: CV972G

This credential earner has completed instructor-led learning for Db2 13 for z/OS Utilities for Database Administrators. In this course, students have learned advanced topics about Db2 for z/OS utilities.

Course Objectives

Badge Criteria and Activities

Attendance and successful completion of CV972G Db2 13 for z/OS Utilities for Database Administrators instructor-led training course

Db2 Family Fundamentals - Code: CE031G

Db2 Family Fundamentals - Code: CE031G

This credential earner has completed instructor-led learning for understanding 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. Db2 runs under the z/OS, VM, Linux, UNIX, and Windows operating systems, to name a few. Topics covered include how the Db2 products provide services, with a focus on the services Db2 provides and how we work with Db2, not on its internal workings.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: DB2 Family Fundamentals - Code: CE031G

Db2 for LUW Performance Tuning and Monitoring Workshop - Code: CL413G

Db2 for LUW Performance Tuning and Monitoring Workshop - Code: CL413G

This credential earner has completed instructor-led learning for understanding how to tune for optimum performance the IBM Db2 10 for Linux, UNIX, & Windows relational database management system & associated applications written for this environment.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: Db2 for LUW Performance Tuning and Monitoring Workshop - Code: CL413G.

Db2 LUW Performance Tuning & Monitoring for Single or Multiple Partition DBs - Code: CL443G

Db2 LUW Performance Tuning & Monitoring for Single or Multiple Partition DBs - Code: CL443G

This credential earner has completed instructor-led learning for how to optimally tune the IBM DB2 10 for Linux, UNIX, and Windows relational database management system and associated applications written for this environment. Topics include: DB2 10 for Linux, UNIX, and Windows in support of single or multiple partition database environments; performance issues affecting the design of the database & applications using the database; major database performance parameters, and the different tools.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: DB2 LUW Performance Tuning & Monitoring for Single or Multiple Partition DBs - Code: CL443G

DB2 SQL Workshop - Code: CE121G

DB2 SQL Workshop - Code: CE121G

This credential earner has completed instructor-led learning for Db2 SQL Workshop (CE121G) course. They have introductory level knowledge on writing, supporting and understanding SQL queries.

Course Objectives

Badge Criteria and Activities

Attendance and successful completion of CE121G DB2 SQL Workshop instructor-led training course

Db2 SQL Workshop for Experienced Users - Code: CE131G

Db2 SQL Workshop for Experienced Users - Code: CE131G

This credential earner has completed instructor-led learning for understanding how to make use of advanced SQL techniques to access DB2 databases in different environments.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: DB2 SQL Workshop for Experienced Users - Code: CE131G

IBM Db2 LUW Family Fundamentals - Code: CE032G

IBM Db2 LUW Family Fundamentals - Code: CE032G

The credential earner has completed the instructor-led training for the IBM Db2 LUW Family Fundamentals course. They have learned about the functions of IBM's Db2 and how Db2 products provide services.

Course Objectives

Badge Criteria and Activities

Attendance and successful completion of CE032G IBM Db2 LUW Family Fundamentals instructor-led training course

Introduction to DB2 for zOS for Systems and Operations Personnel - Code: CV021G

Introduction to DB2 for zOS for Systems and Operations Personnel - Code: CV021G

This credential earner has completed instructor-led learning for Introduction to DB2 for zOS for Systems and Operations Personnel. The badge earner has demonstrated the basic skills required to administer a DB2 database in a z/OS environment.

Course Objectives

Badge Criteria and Activities

Attendance and successful completion of CV021G Introduction to DB2 for zOS for Systems and Operations Personnel instructor-led training course

z/OS and DB2 Basics for DB2 for z/OS DBA Beginners - Code: CV401G

z/OS and DB2 Basics for DB2 for z/OS DBA Beginners - Code: CV401G

This credential earner has completed instructor-led learning for understanding basic skills required to administer a DB2 database in a z/OS environment. Topics include: TSO/E and ISPF; Data sets; DB2 Objects; Structured Query Language; DB2 Commands; JCL and SDSF; DB2 Utilities; DB2 Logging; and DB2 Program Preparation.

Course Objectives

Badge Criteria and Activities

Successfully complete the following IBM Instructor-Led course: z/OS and DB2 Basics for DB2 for z/OS DBA Beginners - Code: CV401G.

Db2 12 for zOS Advanced Database Administration: CV880G

Db2 12 for zOS Advanced Database Administration: CV880G

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

Course Objectives

Badge Criteria and Activities

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

Need more Information?

Speak with our training specialists to continue your learning journey.

Talk to our team

Need more Information?

Speak with our training specialists to continue your learning journey.

 

Delivery Formats

Close

By submitting this form, I agree to LearnQuest's Terms and Conditions

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.
Your use of this LearnQuest site affirms your consent to our use of session and persistent cookies to track how you use our website.