Teradata DBA Training

Teradata DBA Online Training

Teradata architecture

  • PE Component
  • BYNET Component
  • AMP Component
  • Important dictionary views/tables need to manage Database.

Managing Space

  • Spool
  • Permanent
  • Temporary
  • Skew factor
  • Space management
  • Hashing algorithm
  • Data retrieval
  • Storage in Teradata

Managing users and Database

  • Roles
  • Profiles
  • Hierarchy of user/DB (basic of designing part)
  • Access rights (Explicit/Implicit  AUTO)
  • Session related Views/Tables
  • Locking types
  • Query logging
  • Logon off tracking

Performance tuning

  • Join strategy in Teradata
  • Joins terms in Explain plan
  • Index types (PPI  SI  and JI)
  • Query tuning
  • DBQL logging
  • Reuse tables
  • DBQL
  • PDCR data
  • Workload management (TASM) Resource partitions
  • Priority scheduler
  • Workload classifications
  • Exceptions

BAR

  • ARCMAIN
  • Backup
  • Copy/Restore
  • Build
  • Net vault/Netback up

Teradata tools

  • Console utilities QRYCONFIG
  • QRYSESSN
  • RCVMANAGER
  • SHOWLOCKS
  • VPROCMANAGER
  • SHOWSPACE
  • SHOWBLOCKS
  • PACKDISK
  • SCANDISK
  • Viewpoint (TD 13)
  • Teradata Manager
  • PMON
  • SQL assistant
  • TD Administrator

Teradata loading utilities

  • Fast load
  • Multi load
  • Fast Export
  • TPUMP

Send Enquiry

Your Name (required)

Your Email (required)

Your Phone No. (required)

Subject

Your Message