Course Class: Government

This course covers the fundamentals of the Perl programming language.  Students are introduced to the basic language syntax with complex examples that will be understood by the end of the class.  Scalars and their different types are introduced with associated operators and built-in functions.  Lists and arrays are then covered with list manipulating functions and rules, followed by user-defined sub-routines.

The next component covered will be associative arrays (hashes) and hash functions.  An extensive coverage of regular expressions follows.  The course finishes with a study of additional control structures, file I/O, and file and directory manipulating functions.

Process Management, strings and sorting, database creation and access via the DBM hashes, and some advanced techniques for error-handling, using regular expression, and additional built-in functions.routines are also covered.

The course is best suited to a UNIX / Linux environment, but may also be run in a Windows environment with ActiveState Perl.

Students will be given ample time to work with these topics in a lab environment.

 

In this course students will clearly define the various methodologies one can use to tune an Oracle Database. The course covers the various components of an Oracle Database where potential performance bottlenecks could occur and how to monitor and tune them.

In addition, the course covers all Oracle 10g performance related features along tuning application code such as SQL or PL/SQL.

Throughout the course, students experience hands-on exercises in tuning a database.

Advanced topics include the study of Oracle’s database architecture, including schemas, objects, and the Data Dictionary. Students will demonstrate building and executing Stored Procedures and Functions while utilizing Oracle’s PL/SQL. Students will also learn about and practice creation of packages and triggers.

There are several hands-on labs in this course that will provide the student with the opportunity to practice and perfect the knowledge of Oracle that they will gain during these 2 days.

This course introduces students to advanced techniques used to develop fully functional, well‑performing business applications using the PowerBuilder Classic 12 IDE.  Upon successful completion of this course, the student should be able to:

• Create standard reports, including TreeViews, graphs, crosstabs, and multi-group reports.
• Create RichText, nested, and composite style reports.
• Manipulate the properties and behavior of the DataWindow control.
• Access and modify the properties of the DataWindow object.
• Describe the internal organization of the DataWindow buffers.
• Analyze issues involved in managing transactions and concurrency.
• Use DataWindow techniques to access, update, and validate data from the database.
• Create a DataWindow dynamically.
• Create and use DataStores.
• Use DataWindows to generate XML and PDF files.
• Create DataWindows that use a Web Service data source.
• Create and use standard, custom, and external user objects.
• Implement advanced elements of the graphical user interface, such as MonthCalendar, Animation, ListView, TreeView, and Tab controls.
• Use drag and drop for direct manipulation within the application.
• Use external functions in PowerBuilder Classic applications.
• Use a variety of techniques to test, debug, and analyze PowerBuilder Classic applications.

 

A series of written and lab exercises will be used to reinforce the classroom education.

 

This course introduces students to the PowerBuilder Classic 12 development environment. Each component of the PowerBuilder Classic 12 IDE is covered in the context of using PowerBuilder to develop GUI-based client/server business applications. Upon successful completion of this
course, the student should be able to:
• Use the System Tree to create workspaces and targets.
• Use the Application Painter to create application objects.
• Use the Window Painter to create windows.
• Use the PowerScript language to write scripts to perform required processing.
• Create user functions and user events.
• Use the DataWindow Painter to create Data Windows and select appropriate presentation
styles and data sources.
• Use the Query Painter to interactively construct and edit SQL statements.
• Use the Database Painter to define extended attributes and manage database tables.
• Use the Menu Painter to create traditional and contemporary menus.
• Debug PowerBuilder applications.
• Package a PowerBuilder application for distribution.
• Discuss the alternative deployment types, including pcode, machine code, and .NET WinForm applications.
A series of written and lab exercises will be used to reinforce the classroom education.

This course will introduce students to the skills necessary to code batch jobs using OS/390 MVS and z/OS Job Control Language (JCL).  The students will learn to code:

• JOB statements.
• EXEC statements.
• DD statements for disk data sets, tape data sets, and printed reports.

The structure of OS/390 and z/OS job output and system messages are reviewed, and common JCL errors examined.

Students will learn the skills necessary to define and use Generation Data Groups (GDGs), JCL procedures, and INCLUDE groups. Student will learn to:

• Define GDG indexes and model dataset control blocks.
• Code DD statements to use existing GDG generations and create new generations.
• Use ISPF and IDCAMS facilities to manage GDGs.
• Code in‑stream procedures, cataloged procedures, and INCLUDE groups.
• Use procedures and include members in batch jobs.
• Specify private JCL libraries to contain the procedures and INCLUDE groups.
• Customize procedures and INCLUDE groups with symbolic parameters.
• Code DD and EXEC procedure overrides.
• Perform condition checking via the COND JCL parameter and IF/ENDIF JCL statements.
• Code the OUTPUT JCL statement.

Students will also learn how to use such utility programs as DFSORT, IEBGENER, IEFBR14, and IDCAMS.

A series of written and lab exercises will be used to reinforce the classroom education.

This course covers MVS Job Control Language and contains many examples, self-assessment tests for each topic, and 38 programming exercises of increasing level of difficulty with solutions. You must have experience in programming to succeed in this course.

This course is a continuation of the AIX and Korn Shell Fundamentals class.  It begins by presenting some additional utilities that are useful in shell scripts.  Students are then taught basic programming concepts within the context of the Korn shell scripting language.  More advanced features of the Korn shell and its scripting capability are presented next.

The course then presents the basics of working with the Stream Editor.  Students are given additional material on regular expressions and taught how to use sed to edit files.  Techniques for integrating sed commands into Korn shell scripts are also presented.

Next, the course presents the awk programming language.  Students learn to write awk scripts to extract data from files and generate reports.  In addition, students are shown how they can integrate awk commands and programs into Korn shell scripts.

This course provides Java programmers with the skills needed to produce dynamic web applications using JSP and Servlets.  JSP and Servlets are part of the Java2 J2EE specification and provide a very capable alternative to Microsoft’s ASP.Net.  Additionally, the JSP will be presented using the MVC architecture provided by Struts. Using a developer’s prospective, and interesting hands-on labs, this course prepares Java programmers for JSP in just 3 days.

This advanced course is intended for experienced J2EE web developers that are interested in learning advanced topics related to J2EE web applications.
The course is modular and is essentially a collection of technologies and topics that are used to create more advanced and powerful web applications utilizing advanced features provided by J2EE that take web applications to the next step.
All topics are explained through real code examples and exercises. Participants learn about related technologies and about efficient ways to use the technologies covered.