Teradata Administration Online 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
- TD Manager Service
- Starting TD Manager
Module 8: (Monitoring tools)
- Performance Monitor
- PMON Main window
- PMON sessions Screen
- TD Administrator
- Locking Logger
Module 9: (TD Remote Console Utilities)
- Starting DB Window
- SHOWLOCKS
- SHOWSPACE
- SHOWBLOCKS
- PACKDISK
- SCANDISK
Module 10: (Archiving Data)
- Archive and Recovery Statements
- Recovery vs. FastLoad
- Invoking Archive
- Restart Log
- Archive
- Database DBC Archive
- Indexes option
- Database DBC Archive
- Archive and Recovery (ARC) Examples
Module 11 (Restoring data)
- Restore
- COPY
- Copying Tables
- BUILD
No comments:
Post a Comment