Back to Jobs
Other

Trainer

nFolks Data SolutionsAtlanta, GA🇺🇸United StatesPosted Aug 6, 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

SeniorityMid Senior
Work modeHybrid
LocationAtlanta, GA, United States
Posted2 months 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