In DB2 UDB for System i Fundamentals training course, attendees learn to examine how DB2 is implemented and integrated into the architecture of the iSeries and learn about its many functions and features.
By attending DB2 UDB for System i Fundamentals workshop, attendees will learn to:
- List four iSeries database objects
- Use both DB2 UDB SQL and native terminology to describe objects and operations
- Describe the use of referential integrity and triggers
- State four ways that SQL can be used in programs
- Describe the process to create DB2 UDB objects
- Use interactive SQL and Operations Navigator to create basic DB2 UDB objects
- List two performance tools that can be used to improve DB2 UDB performance
- Explain the role of the database administrator
- Explain the purpose of journaling and commitment control
- Explain the considerations of distributed data
General background in information processing and familiarity with database concepts. Broad experience in database products enhances the benefit of this course.
Database Administrators and Application Programmers who need to manage or implement an iSeries database. Individuals who have had experience with IBM's DB2 on another platform or another relational database.