Teradata online training c ourse content

Teradata DBA Course Training Outline :

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

http://www.monstercourses.com/teradata-dba