Teradata DBA Training & Certification Course Online

Key Highlights

+1 930 200 4823

30 Hrs Instructor Led Training

Self-paced Videos

20 Hrs Project & Exercises

Certification

Job Assistance

Flexible Schedule

Lifetime Free Upgrade

Mentor Support

Curriculum

A complete index of
job-ready skills curated
to meet the industrial need.
Explore.

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 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
TD Manager Service
Starting TD Manager

Monitoring Tools

Performance Monitor
PMON Main window
PMON sessions Screen
TD Administrator
Locking Logger

Teradata Database Utilities

Starting DB Window
SHOW LOCKS
SHOWSPACE
SHOW BLOCKS
PACKDISK
SCANDISK

Archiving Data

Archive and Recovery Statements
Recovery vs. FastLoad
Invoking Archive
Restart Log
Archive
Database DBC Archive
Indexes option
Archive and Recovery (ARC) Examples

Restoring Data

Restore
COPY
Copying Tables
BUILD

We have made a tailored curriculum covering the latest industry-ready concepts to serve every individual’s learning desires.

Teradata DBA Training Objectives

1. What are the Teradata DBA course objectives?

After the successful completion of Teradata DBA training at Tekslate, the participant will be able to

Get an overview of Teradata architecture and its key components.
Master different types of views, and track the logs(LOGON, LOGOFF) used in Teradata.
Understand the Access rights (Auto, implicit, Explicit Rights).
Learn about various monitoring tools used to track system, and performance issues.

2. Why should you learn Teradata DBA?

Teradata is the global leader in 2016 Gartner Magic Quadrant for Data Warehouse & Data Management Solutions for Analytics.
Top companies like Cisco, Dell, and other Fortune 500 companies are using Teradata in their deployments.
Certified Teradata Administrators are earning more salaries compared to other technology professionals.
The average pay of a skilled Teradata Administrators stands at 142,043 USD per annum.
The career opportunities for Teradata will increase even further, as many more organizations are moving towards Teradata DBA due to its increasing demand.

3. Who should attend Teradata DBA training?

The job roles who get primarily benefited from learning this course are listed below:

IT professionals
Analytics managers
Administrators
Professionals who want to enhance their skills in database management, and administration.

4. What are the prerequisites for learning Teradata DBA?

There are no specific prerequisites for learning Teradata DBA. Anyone who is interested in learning this course can join this training.

5. What projects are included in this Teradata DBA training course?

We will provide two real-time projects under the guidance of a professional trainer, who will explain you on how to acquire in-depth knowledge on all the concepts involved in these projects.

+1 930 200 4823

Training Options

Different individuals. Different upgrade goals. Different modes of learning.

We got solutions for everyone looking for an AWS Architect course. Opt in for your convenient upgrade option, and we will guide you through.

Duration

One-on-one Session

Support

Resources

Time

Fee

Live Online.

30 Hours

Yes

24x7

Additional tips from the trainer

24 Jan 2022, 07:00 AM IST

31 Jan 2022, 07:00 AM IST

Self-Paced

30 Hours

Weekdays & Working Hours

Accessible through LMS

At your convenience

Teradata DBA Training Upcoming Batches

Weekday

24 Jan, 2022 - 24 Feb, 2022

01:30 AM IST

Weekday

31 Jan, 2022 - 03 Mar, 2022

01:30 AM IST

Weekend

29 Jan, 2022 - 01 Mar, 2022

02:30 AM IST

Weekend

22 Jan, 2022 - 22 Feb, 2022

02:30 AM IST

Schedules Doesn't Suit You ?

Our Team can set up a batch at your convinient time.

Corporates Training

Experience and witness the express transformation of your workforce from the world-class tech upgrade platform.

Customized training options

Tailored curriculum to fit your project needs.

Practical exposure is assured.

We have got everything covered for any IT upgrade for your organization. We are one click away.

Success Stories from Future Digital Leaders

Teradata DBA trainer at Tekslate is a highly experienced professional and has vast knowledge on database management concepts, and explained sessions by taking real-time examples. Thank you Tekslate.

Darshika

Tekslate provides the best training for a Teradata DBA course. They provide content in accordance with the Teradata DBA certification exam which is very beneficial for aspirants career. Thank you Tekslate.

Santosh

Tekslate’s Teradata DBA trainer is highly knowledgeable in implementing projects with proper explanation.

Karthisha