IBM DB2 SQL Workshop for Experienced Users (CE131G)  Training Logo

IBM DB2 SQL Workshop for Experienced Users (CE131G) Training

Live Online & Classroom Enterprise Certification Training

Powered By

IBM Logo

The course teaches you how to make use of advanced SQL techniques to access DB2 databases in different environments.

ATP_Authorized Logo

Powered By

IBM Logo

Looking for a private batch ?

REQUEST A CALLBACK

Need help finding the right training?

Your Message

  • Certified Trainer

  • Authorized Courseware

  • Completion Certificate from ATP

  • Enterprise Reporting

  • Lifetime Access

  • CloudLabs

  • 24x7 Support

  • Real-time code analysis and feedback

What is IBM DB2 SQL Workshop for Experienced Users (CE131G) Certification Training about?

This course is appropriate for customers working in all DB2 environments, specifically for z/OS, Linux, UNIX, and Windows.

What are the objectives of IBM DB2 SQL Workshop for Experienced Users (CE131G) Certification Training ?

At the end of this course, you'll be able to: 


  • Discuss basic relational database concepts
  • Use some of the OLAP features of DB2, such as GROUPing and RANKing functions
  • Create tables, views and indexes
  • Use referential integrity, check constraints and triggers
  • Use outer joins, and join tables to themselves
  • Use CASE expressions, and the CAST function
  • Identify the impact of Summary Tables, Materialized Query Tables, and temporary tables
  • Use complex subqueries
  • Use a greater number of scalar SQL functions
  • Use advanced SQL constructs, such as recursive SQL and table expressions
  • Define User-Defined Distinct Types and User-Defined Functions
  • Avoid several of the most common causes for poorly-performing SQL

Who is IBM DB2 SQL Workshop for Experienced Users (CE131G) Certification Training for?

This intermediate course is for experienced SQL end users, application programmers, database administrators, and user support staff who need more advanced knowledge of SQL.

What are the prerequisites for IBM DB2 SQL Workshop for Experienced Users (CE131G) Certification Training?

You should have experience with:

  • Coding and executing basic SQL statements.


These skills can be developed by attending:

  • SQL Workshop (CE120), or equivalent experience.

Available Training Modes

Live Online Training

18 Hours

Classroom Training

3 Days

Who is the instructor for this training?

The Trainer is IBM certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.

Course Logo

IBM DB2 SQL Workshop for Experienced Users (CE131G) Certification Training - Certification & Exam

  • SpringPeople is the Authorized Training Partner of IBM through Tech Data
  • For any queries, feel free to reach us at ibm@springpeople.com

Reviews