SUBSCRIBE | HOME | CONTACT US | ABOUT US

WebFacing Now!
RPG Web Skills Accelerator
 

Master iSeries Navigator and significantly shorten your learning curve for acquiring new skills

NEW!   iSeries Navigator for Programmers

iSeries Navigator is a powerful tool for programmers. It opens up new horizons and can help shorten the learning curve for new programming requirements, like the Integrated File System and SQL. iSeries Navigator for Programmers contains the descriptions, labs, how-tos and source code you need to make the most out of this tool in your shop.

iSeries Navigator for Programmers is self paced training that covers:

  • Basic Operations – This chapter introduces you to the basic mechanics of iSeries Navigator. It teaches you how to perform the GUI equivalent of WRKSPLF, DSPMSG, WRKUSRJOB, etc. It discusses when to use the GUI interface and when green screen is still best.

  • Integrated File System – This chapter discusses the Integrated File System (IFS). Learn how to access the IFS from Windows, how to manage the IFS with iSeries Navigator, and how to get the equivalent of Network Neighborhood on green screen.

  • Database Basics – This chapter shows how to use SQL’s Data Definition Language (DDL) without becoming an expert in SQL. Learn how iSeries Navigator simplifies the definition of tables, views, and indexes; the differences between DDL and DDS and how they affect RPG programs. Also learn some of the features introduced by DDL that are not possible in DDS.

  • Database Advanced – What about join logical and field reference files? This chapter shows you how to define them in iSeries Navigator. It also introduces the Run SQL Scripts feature, which can ease your introduction to SQL.

  • Referential Integrity – One of the powerful features of the database. Check constraints and referential constraints provide a means of ensuring the integrity of a database. This chapter teaches you how to use iSeries Navigator to define and manage constraints and how to handle them in RPG programs.

  • Triggers – Triggers are probably the most frequently used of the "new" database features. This chapter shows you how to use iSeries Navigator to manage triggers for a database. It also shows you how to define SQL triggers.

  • User Defined Functions – UDFs are probably the most powerful features that SQL brings to the database. This chapter shows you how to associate RPG code with columns in a table. Learn how to use existing RPG procedures directly on the database.

  • Database Navigator – Did you ever wonder how the components of your database fit together? Did you ever want to get the big picture – or even the little picture? This chapter shows you how to use Database Navigator to chart your database.

This course comes complete with a CD of all code used – a useful desk top reference you’ll turn to time and again.

 

100% Money-Back Guarantee: If you are not completely satisfied, return the training materials within 15 days for a prompt refund or credit.