TERADATA DBA ONLINE TRAINING

TERADATA DBA ONLINE TRAINING

TERADATA DBA  ONLINE TRAINING 

Course Duration:  30 Hours

Delivery type: Instructor-led online training

FOR FREE DEMO contact us at:

 

Phone: +91-868-622-2553

 

Email: info@apex-online-it-training.com

 

ABOUT THE TRAINER

  • 8 YEARS OF INDUSTRY EXPERIENCE
  • 5 YEARS OF EXPERIENCE IN ONLINE AND CLASSROOM TRAINING

 

 

TERADATA DBA Course ONLINE TRAINING COURSE CONTENT

 

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

·         Ø Priority Scheduler Admin

·         Ø TD Manager Service

·         Ø Starting TD Manager

 

Module 8: (Monitoring tools)

·         Ø Performance Monitor

·         Ø PMON Main window

·         Ø PMON sessions Screen

·         Ø TD Administrator

·         Ø TD manager Dynamic Utilization Charting

·         Ø Locking Logger

 

Module 9: (TD Remote Console Utilities)

·         Ø Starting DB Window

·         Ø QRYCONFIG

·         Ø QRYSESSN

·         Ø RCVMANAGER

·         Ø SHOWLOCKS

·         Ø VPROCMANAGER

·         Ø SHOWSPACE

·         Ø SHOWBLOCKS

·         Ø PACKDISK

·         Ø SCANDISK

 

Module 10: (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 11 (Restoring data)

·         Ø Restore

·         Ø COPY

·         Ø Copying Tables

·         Ø BUILD