[thim-heading title=”Teradata DBA Training” clone_title=”” line=””]

Teradata DBA Course Syllabus

TERADATA Architecture

  • Parsing Engine(PE)
  • Request and Response Parcel
  • Access Module Processors (AMPs)
  • Bynet
  • Data access Handling
  • TD Config Utilities
  • Config and Reconfig

TERADATA Database Space

  • Permanent Space
  • Spool Space
  • Temp Space
  • Indexes

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.

Access Rights, Roles, Profiles

  • Access rights (Auto,implicit,Explicit Rights)
  • Roles and Profiles
  • Creating Roles and Profiles
  • RoleInfo and DBC.ProfileInfo

Query analysis and Tools

  • Database Query Log (DBQL)
  • DBQL Tables and Views
  • Access Logging

System Access Control Level

  • TD Password Encryption
  • Password Security Features
  • Host Logon Processing
  • GRANT/REVOKE LOGON
  • Session Related Views
  • sessionInfo Info View
  • Data Access Info Views
  • Access LogRules Views
  • Access Log Views

TD Manager

  • TD Manager Apps
  • TD Dashboard
  • Priority Scheduler Admin
  • TD Manager Service
  • Starting TD Manager

Monitoring tools

  • Performance Monitor
  • PMON Main window
  • PMON sessions Screen
  • TD Administrator
  • TD manager Dynamic Utilization Charting
  • Locking Logger

TD Remote Console Utilities

  • Starting DB Window
  • QRYCONFIG
  • QRYSESSN
  • RCVMANAGER
  • SHOWLOCKS
  • VPROCMANAGER
  • SHOWSPACE
  • SHOWBLOCKS
  • PACKDISK
  • SCANDISK

Archiving Data

  • 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

Restoring data

  • Restore
  • COPY
  • Copying Tables
  • BUILD
QUICK ENQUIRY

We are glad that you preferred to contact us. Please fill our short form and one of our friendly team members will contact you back.

ExperiencedFresher

X
Quick Enquiry