COURSES‎ > ‎

Teradata Certification level Online Training by Corporate Trainers



TeraData Training online course makes you an expert in using teradata and how to control database space, business analytics solutions, bigdata analytics, integrated data warehousing, advanced teradata sql concepts, etc. 
 


FOR FREE DEMO contact :

Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107  
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com


Teradata DBA Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided
  

TERADATA DBA COURSE OUTLINE / AGENDA
(the course content can be modified as per your requirements):



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