Welcome to Wings Academy

TERADATA DBA

TERADATA DBA

Teradata DBA Training in Mumbai
Learn at Home with Wings Academy

Classroom and Online Courses by Certified Experts

Our Classroom and Online Training Program insist you to become a specialist at Advanced Industrial Technologies in a Month. Hands-on Learning with Live Project sessions. We are One of the Best Classroom and Online Training Course Provider" in India with Placement Support.

About Teradata DBA Training Course in Mumbai

Gain in-depth knowledge of all the core concepts of Teradata DBA from industry experts with hands-on training sessions. You will learn how to build data warehousing applications using
Teradata DBA through real-life projects and use cases. This will help you successfully clear the Teradata DBA certification exam and advance your career. Enroll Now with us Wings academy Teradata DBA Classroom & Online Training Course.

Teradata is a popular Relational Database Management System (RDBMS) suitable for large data warehousing applications. It is capable of handling large volumes of data and is highly scalable.

Syllabus of Teradata DBA Course in Mumbai

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

About Experienced Teradata DBA Trainer

  •  Our Teradata DBA Training in Mumbai. Trainers are certified professionals with 7+ years of experience in their respective domain as well as they are currently working with Top MNCs.
  •  As all Trainers are Teradata DBA domain working professionals so they are having many live projects, trainers will use these projects during training sessions.
  •  All our Trainers are working with companies such as Cognizant, Dell, Infosys, IBM, L&T InfoTech, TCS, HCL Technologies, etc.
  •  Trainers are also help candidates to get placed in their respective company by Employee Referral / Internal Hiring process.
  •  Our trainers are industry-experts and subject specialists who have mastered on running applications providing Best Teradata DBA training to the students.