Teradata DBA Training

Best Software Training Institute in Chennai

Teradata DBA Training in Chennai

Teradata DBA Training in Chennai

Learn how to use Teradata® DBA from beginner level to advanced techniques which is taught by experienced working professionals. With our Teradata DBA Training in Chennai you’ll learn concepts in expert level with practical manner.

Upcoming Batches

Starts Duration Days Time (IST)
05th June 4 Weeks Mon – Fri 08:00AM – 09:30AM
10th June 6 Weeks Sat & Sun 10:00AM – 01:00PM
12th June 4 Weeks Mon – Fri 06:30PM – 08:00PM
17th June 6 Weeks Sat & Sun 04:00PM – 07:00PM
19th June 4 Weeks Mon – Fri 06:30PM – 08:00PM
24th June 6 Weeks Sat & Sun 04:00PM – 07:00PM
26th June 4 Weeks Mon – Fri 06:30PM – 08:00PM
01st July 6 Weeks Sat & Sun 12:30PM – 03:30PM
03rd July 4 Weeks Mon – Fri 06:30PM – 08:00PM
Schedule does not suit you, contact us now! | Want to take one-on-one training, contact us now!

Teradata DBA Course Syllabus

TERADATA Architecture

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

TERADATA 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

Query analysis and Tools

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

System Access Control Level

  • 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

TeraData DBA Training Reviews

Besant Technologies Reviews given by our students already completed the training with us. Please give your feedback as well if you are a student.

Besant Technologies Velachery

No. 24, Nagendra Nagar,
Velachery Main Road,
Velachery, Chennai - 600 042
Tamil Nadu, India
Landmark - Opposite to Phoenix Market City

+91-996 252 8293 / 996 252 8294

Besant Technologies Tambaram

No. 31 / 11, Govindarajan Street,
West Tambaram,
Chennai - 600 045
Tamil Nadu, India
Landmark - Behind National Theatre

+91-996 250 4283

Besant Technologies OMR

No. 5/318, 2nd Floor, Sri Sowdeswari Nagar,
OMR, Okkiyam Thoraipakkam,
Chennai - 600 097
Tamil Nadu, India
Landmark - Behind Okkiyampet Bus Stop, Above IBACO Ice Cream

+91-887 038 4333

Besant Technologies Bangalore

No 2, Ground floor,
29th Main Road, Kuvempu Nagar,
BTM Layout 2nd Stage,
Bangalore - 560 076
Karnataka, India
Landmark - Next to OI Play School

+91-762 494 1772 / 762 494 1774

Quick Enquiry