Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More DB2

Related Courses

DB2 UDB SQL Coding

Recommended Duration:
3 Days
 
Benefits
Students who complete this course will be able to code SQL statements to access DB2 UDB using both the Command-Line Processor (CLP) and Control Center graphical interface programs.
Audience
Persons who need to work with DB2 UDB Databases.
Prerequisites
The student should have familiarity with the environment used in the classroom (Windows, Unix, or Linux).
Major Topics
  • Relational Database Concepts
  • DB2 UDB Concepts
  • Command-Line Processor (CLP)
  • Interactive Tools and Control Center
  • SELECT
  • UPDATE/DELETE/INSERT
  • COMMIT/ROLLBACK
  • Joined and Nested Queries
  • SQL functions and analytics
  • Creating DB2 tables and Views
  • DB2 UDB Objects
  • Catalog Tables/Dictionary
  • Locking Mechanism
  • Security and Authorization
Exercises
There are seven hands-on exercises.