EncartaLabs

DB2 UDB for System i Fundamentals

( Duration: 1 Day )

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.

COURSE AGENDA

1

Introduction to relational database management and DB2 UDB for iSeries

2

Introduction to SQL

3

Database creation considerations

4

iSeries SQL in action - database case study

5

Using SQL on the iSeries

6

Advanced database features

7

Database administration

8

Database integrity and security

9

Distributed data considerations

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top