Haystack
← Back to Jobs
Other
ND

Trainer

nFolks Data SolutionsAtlanta, GA🇺🇸United StatesPosted 6 Aug 2026

Why This Role Stands Out

Leverage your expertise to shape the next generation of tech professionals in this dynamic hybrid Trainer role at nFolks Data Solutions. You'll thrive here if you're passionate about knowledge sharing and eager to contribute to a respected company while enjoying flexible work arrangements. Apply today to empower others and advance your own career!

Quick Overview

Seniority
Mid Senior
Work mode
Hybrid
Location
Atlanta, GA, United States
Posted
5 weeks ago
SQL

Job Description

Course Outline

Unit 1 - Db2 Relational database concepts

   Relational Database design

   Data access

   Interacting with Db2• Catalog and directory

 

 Unit 2 - SQL and SPUFI

     SQL SELECT statement review

   SQL INSERT, UPDATE, DELETE review

   SQL COMMIT and ROLLBACK review

   Joining tables

   Executing SQL using SPUFI

 

Unit 3 - Db2 objects (Storage groups, databases, and table spaces)

   Object concepts

   Storage Groups

   Databases

   Table Spaces

 

Unit 4 - Db2 Objects

   Tables

   Indexes

   Views

 

 Unit 5 - Utilities

   Utility Categories

   Load Utility

   Check Data Utility

   Unload Utility

   Runstats Utility

   Reorg Utility

 

 Unit 6 - Commands and program preparation

   Db2 Command Structure

   Display Command

   Archiving Logs

   Stop and Start Commands

   Executing Commands

   Program Preparation

 

 Unit 7 - The Db2 system

   System Parameters (zParms)

   Address Spaces

   System Databases

   Buffer Pools

   Logging

   Integrity

   Security

 

 Unit 8 - Db2 Shutdown, startup, and recovery

   Start and Stop Commands

   Db2 Shutdown Process

   Db2 Startup Phases

   System Recovery

   Object Recovery

   Copy Utility

   Recover Utility

Similar jobs

Browse related jobs

Apply now