Teradata DBA Training

→ Module 1: (TERADATA Architecture)

  • Parsing Engine(PE)
  • Request and Response Parcel
  • Access Module Processors (AMPs)
  • Bynet
  • Data access Handling
  • TD Config Utilities
  • Config and Reconfig

→ Module 2: (TERADATA Database Space)

  • Permanent Space
  • Spool Space
  • Temp Space
  • Indexes

→ Module 3: (DBC Dictionary Tables)

  • Data dictionary
  • Parsing Engine
  • System Views
  • Database Views
  • DBC Users View
  • Indices View
  • All Temp Tables View
  • Using DBC AMP Usage
  • Using DBC Table Size
  • Logon and Logoff Tracking.

→ Module4: (Access Rights, Roles, Profiles)

  • Access rights (Auto,implicit,Explicit Rights)
  • Roles and Profiles
  • Creating Roles and Profiles
  • DBC.RoleInfo and DBC.ProfileInfo

→ Module 5: (Query analysis and Tools)

  • Database Query Log (DBQL)
  • DBQL Tables and Views
  • Access Logging

→ Module 6: (System Access Control Levels)

  • TD Password Encryption
  • Password Security Features
  • Host Logon Processing
  • GRANT/REVOKE LOGON
  • Session Related Views
  • DBC.sessionInfo Info View
  • Data Access Info Views
  • Access LogRules Views
  • Access Log Views

→ Module 7: (TD Manager)

  • TD Manager Apps
  • TD Dashboard
  • Priority Scheduler Admin
  • TD Manager Service
  • Starting TD Manager

→ Module 8: (Monitoring tools)

  • Ø Performance Monitor
  • Ø PMON Main window
  • Ø PMON sessions Screen
  • Ø TD Administrator
  • Ø TD manager Dynamic Utilization Charting
  • Ø Locking Logger

→ Module 9: (TD Remote Console Utilities)

  • Starting DB Window
  • QRYCONFIG
  • QRYSESSN
  • RCVMANAGER
  • SHOWLOCKS
  • VPROCMANAGER
  • SHOWSPACE
  • SHOWBLOCKS
  • PACKDISK
  • SCANDISK

→ Module 10: (Archiving Data)

  • Archive and Recovery Statements
  • Recovery vs. FastLoad
  • Invoking Archive
  • Restart Log
  • ANALYZE Statement
  • Archive
  • Database DBC Archive
  • Indexes option
  • Database DBC Archive
  • Archive and Recovery (ARC) Examples

→ Module 11 (Restoring data)

  • Restore
  • COPY
  • Copying Tables
  • BUILD
Online Courses Videos