TRAINING

Enroll Now

Teradata DBA Training  

Teradata DBA Training gives detailed layout on how to Create, Modify and Drop Databases, Users, Tables, Profiles, Create Tables, Grant, Copy Table, View or Macro definitions to another database. Get Certified.

This Teradata Database Administration course is designed to provide the participants with in-depth knowledge of system administration for the Teradata database. The participants will learn how to run a Teradata warehouse on a daily basis from the ground up.

You will also learn how to use Teradata DBA from beginner to advanced level. This course has been designed in such a way that it is very easy for you to acquire and expand your Teradata DBA skills quickly. So, you can start working in this field once you complete the training successfully.

Teradata DBA Course Content

Teradata DBA Architecture

• Parsing Engine(PE)
• Request and Response Parcel
• Access Module Processors (AMPs)
• Bynet
• Data access Handling
• TD Config Utilities
• Config and Reconfig

Teradata DBA Database Space

• Permanent Space
• Spool Space
• Temp Space
• Indexes

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.

Access Rights, Roles, Profiles

• Access rights (Auto,implicit,Explicit Rights)
• Roles and Profiles
• Creating Roles and Profiles
• DBC.RoleInfo and DBC.ProfileInfo

MoniQuery analysis and Tools

• Database Query Log (DBQL)
• DBQL Tables and Views
• Access Logging

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

TD Manager

• TD Manager Apps
• TD Dashboard
• Priority Scheduler Admin
• TD Manager Service
• Starting TD Manager

Monitoring tools

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

TD Remote Console Utilities

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

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

Restoring data

• Restore
• COPY
• Copying Tables
• BUILD