Teradata DBA Online Training

Duration: 25 Hours

Module 1: (TERADATA Architecture)Teradata DBA Online Training

  • 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

Teradata DBA Online Training by real time industry experts with hands on

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

Click here to register for the Teradata DBA online training.

Teradata DBA Online Training Video Tutorials

Click here to register for the Teradata DBA Video Tutorials.

About our Teradata DBA online training instructor:

  • Working in the top MNC in India
  • Very experienced got 8+ years of experience
  • Trained more than 300+ students online
  • Corporate trainer on Teradata DBA and Teradata V13
  • Teradata DBA Interview Questions.
  • Expertise in different Teradata DBA online training
  • Hands on Teradata DBA online training.

Click here to register for the Teradata DBA online training.