Teradata DBA
- 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
- Permanent Space
- Spool Space
- Temp Space
- Indexes
- 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.
- Access rights (Auto,implicit,Explicit Rights)
- Roles and Profiles
- Creating Roles and Profiles
- DBC.RoleInfo and DBC.ProfileInfo
- Database Query Log (DBQL)
- DBQL Tables and Views
- Access Logging
- 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
- TD Manager Apps
- TD Dashboard
- Priority Scheduler Admin
- TD Manager Service
- Starting TD Manager
- Performance Monitor
- PMON Main window
- PMON sessions Screen
- TD Administrator
- TD manager Dynamic Utilization Charting
- Locking Logger
- Starting DB Window
- QRYCONFIG
- QRYSESSN
- RCVMANAGER
- SHOWLOCKS
- VPROCMANAGER
- SHOWSPACE
- SHOWBLOCKS
- PACKDISK
- SCANDISK
- 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
- Restore
- COPY
- Copying Tables
- BUILD
Module 2: TERADATA Database Space
Module 3: DBC Dictionary Tables
Module 4: Access Rights, Roles, Profiles
Module 5: Query analysis and Tools
Module 6: System Access Control Level
Module 7: TD Manager
Module 8: Monitoring tools
Module 9: TD Remote Console Utilities
Module 10: Archiving Data
Module 11: Restoring data