Teradata DBA Online Training|Training|Support -3092003878

[edwardcruz]

Best Online Training Providers by Real Time Experts on Teradata DBA

Course Outline:

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 can reach us @   3092003878 or Email us: [email protected]