iBase Training

Official Website

Teradata Online Training Course Content 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 : info@ibasetraining.com

Phone/WhatsApp : +91-8106721223

USA Number : +1-650-993-1007

Gtalk : ibasetraining@gmail.com

WebSitehttp://www.ibasetraining.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

 

 

Student Registration

Name

Email Id

Country Code

Mobile No

Course Name

City