Teradata DBA Online Training

taradata dba

Teradata DBA Online Training

Duration: 25 Hours

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: (DBSize Control)

  • DBS Control record –General Fields
  • DBS Control record — File system Fields
  • DBS Control record — Performance Fields
  • DBS Control record — Performance Columns

Module 6:  (Query analysis and Tools)

  • Database Query Log (DBQL)
  • DBQL Tables and Views
  • Access Logging
  • Statistics Wizard
  • Index Wizard
  • TSET

Module 7:  (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 8:  (Priority Scheduler)

  • PS(Priority Scheduler) Partition Hierarchy
  • PSH Def
  • Resource Partition Examples
  • Multiple resource Partition Example
  • Scheduling Policies
  • Performance Periods

Module 9: (TD Manager)

  • TD Manager Apps
  • TD Dashboard
  • Priority Scheduler Admin
  • TD Manager Service
  • Starting TD Manager
  • Enable Data Collection

Module 10: (Monitoring tools)

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

Module 11:  (TD Remote Console Utilities)

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

Module 12: (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

Module 13 (Restoring data)

  • Restore
  • COPY
  • Copying Tables
  • BUILD
  • RELEASE LOCK

Other Features We provide:

  • FAQS
  • Concentration on performance tuning
  • Real time scenarios
  • Certification guidance
  • Resume preparation
  • Sample resumes
  • Interview & certification FAQS
  • How to face the interview
  • Class notes which is useful for who is trying for job
  • Project preparation

Fill up quick inquiry form to get more details on Teradata DBA online training