All Forums Teradata Applications
21cssindia1 0 posts Joined 09/13
29 Sep 2013
Teradata DBA Online Training Teradata Developer Online Training Call Us +919000444287

Teradata  DBA Online Training

  Click Here For Enquiry

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

 

You must sign in to leave a comment.