DB2 Training Classes and Seminars In Des Moines, IA

Upon completion of this course, participants will learn: LSF installation Job submission and control Resource management Cluster query commands LSF architecture LSF configuration LSF batch system configuration LSF scheduling policies and fairshare policies Resource limits Cluster management Basic troubleshooting LSF debugging Platform LSF with EGO LSF application integration and deployment...

<div><p>After completing this course, students should be able to:</p> <ul> <li>Start and stop a Db2 subsystem</li> <li>Use the SET SYSPARM command</li> <li>Access the system log to gather information about the subsystem initialization, operation, or shutdown</li> <li>Describe the components and address space structure of a Db2 subsystem</li> <li>Explain the use of RACF (or another external security program) for Db2 connection security</li> <li>Explain the use of Roles and Trusted Contexts</li> <...

<div><ul> <li>Db2 Relational database concepts</li> <li>SQL and SPUFI</li> <li>Db2 objects (Storage groups, databases, and tablespaces)</li> <li>Db2 Objects (Tables, indexes, and views)</li> <li>Utilities</li> <li>Commands and program preparation</li> <li>The Db2 system</li> <li>Db2 Shutdown, startup, and recovery</li> </ul></div>...

<div><p>After completing this course, you will be able to:</p> <ul> <li>Understand and design better indexes</li> <li>Determine how to work with the optimizer (avoid pitfalls, provide guidance)</li> <li>Optimize multi-table access</li> <li>Work with subqueries</li> <li>Avoid locking problems</li> <li>Use accounting traces and other tools to locate performance problems in existing SQL</li> </ul></div>...

<div><ul> <li>Incorporate static SQL statements in an application program</li> <li>Prepare the program for execution</li> <li>Validate execution results are correct</li> <li>Produce code to support multiple rows being returned from the database manager using cursors</li> <li>Identify considerations regarding units of work, concurrency, and restart of programs</li> <li>Identify differences between static and dynamic SQL</li> <li>Provide test data for applications</li> <li>Discuss program and DB2 ...

<div><ul><li>Discuss basic relational database concepts </li><li>Use some of the OLAP features of DB2, such as GROUPing and RANKing functions </li><li>Create tables, views and indexes </li><li>Use referential integrity, check constraints and triggers </li><li>Use outer joins, and join tables to themselves </li><li>Use CASE expressions, and the CAST function </li><li>Identify the impact of Summary Tables, Materialized Query Tables, and temporary tables </li><li>Use complex subqueries </li><li>Use...

Red Hat System Administration III: Linux Automation (RH294) is designed for Linux® system administrators and developers who need to automate provisioning, configuration, application deployment, and orchestration....

The Linux Shell Scripting course is designed to provide the skills necessary to automate tasks on a Unix or Linux system. Systems Administrators and Developers alike can avoid errors, save time and money by replacing repetitive work patterns with shell scripts. Care has been taken to present the Linux Shell Scripting course in a format that benefits all students, with or without previous programming experience. The best way to learn shell scripting is writing shell scripts. For this reason, lab time is emphasized. Early labs present the scripting process step by step, while later labs are presented in a challenge format. While official solutions to each lab task are provided, you are encouraged to create your own before examining the solution. In this way, more experienced learners are challenged without overwhelming the less experienced....