Live online batches across IST, EST & GST — learners in 189+ countries
Home Courses DWH ETL Teradata Admin Track
DWH ETL Upskill with BISP Powered By AI

Teradata Admin Track

This training program is designed to prepare the students for Teradata Administrator. The Teradata DBA bootcamp training is practical oriented with real time scenarios, which helps you to gain knowledge on field experience. You learn in th…

4.8  ·  Rated by learners Certificate of completion
Duration
25 Hours
Mode
Live + Recorded
Level
Beginner → Pro
Language
English / Hindi

Course overview

About the Teradata Admin Track program.

This training program is designed to prepare the students for Teradata Administrator. The Teradata DBA bootcamp training is practical oriented with real time scenarios, which helps you to gain knowledge on field experience. You learn in this course how to replicate data across environments, monitor and manage databases, perform SQL tuning and analysis, provide capacity planning, grant data level access privileges, Implementing monitoring procedures to maximize system availability, Managing and tuning Teradata Workload Management designing and creating workload groups, priorities, throttles, and various day to day activities a DBA has to perform.

Why learn with BISP

Trusted by professionals across 30+ countries.

Industry trainers

Certified consultants with 12+ years of real project experience.

Hands-on practice

Real-time scenarios & live project modules, not just slides.

Placement support

Resume building, mock interviews & job referrals.

Certification

BISP certificate + full guidance for official exams.

Course curriculum

Designed by real-time industry professionals around current job roles.

Download curriculum (PDF)
23 modules 138 topics
01 Introduction and Getting Started 6 topics
  • What is Teradata?
  • Teradata Architecture
  • Role of Teradata in Data Ware housing industry
  • Evolution of Teradata DW
  • Significance and characteristics of Teradata
  • Advantages of Teradata over other RDBMS
02 Teradata Architecture 7 topics
  • Understanding H/W and S/W components
  • Involved in Architecture of Teradata
  • V-disks
  • AMP
  • PE
  • V procs
  • BYNET
03 Data distribution 7 topics
  • Understanding significance of Index in Teradata
  • UPI
  • NUPI
  • SI
  • Data distribution continues...
  • NUSI
  • Partitioned index
04 Data Protection 6 topics
  • Different levels of failures that could happen and fault tolerance of Teradata
  • CLIQUE
  • CLUSTER
  • RAID
  • LOCKS
  • JORNALS
05 Advanced Teradata SQL 17 topics
  • HELP
  • SHOW
  • EXPLAIN
  • Define and execution of Macros
  • Date calculations
  • Data type conversion
  • Case
  • COALESCE
  • Sample
  • Ranking
  • Qualify
  • CSUM
  • MSUM
  • MDIFF
  • MAVG
  • WITH
  • WITH BY
06 UNIX 1 topics
  • Role of Unix in executing Teradata utility scripts and Basic commands used
07 General Lifecycle of the projects 2 topics
  • General phases of a Development project
  • Documents required in each phase
08 DBA 7 topics
  • Teradata DBA basics and responsibilities
  • Initial Teradata Databases
  • Administrative User
  • Owners, Parents and Children
  • Creating New Users and Databases
  • Transfer of Ownership
  • DELETE/DROP Statements
09 User and Security Management 7 topics
  • Understand the Hierarchy
  • Teradata Administrator tool usage to perform creation of users
  • Databases
  • Identify spaces
  • Skew of databases
  • Moving spaces and accesses
  • Practical’s
10 The Data Dictionary 4 topics
  • Updating Data Dictionary Tables
  • Supplied Data Dictionary Views
  • Restricted Views
  • Suffix Options with Views
11 Selecting Information about Created Object 6 topics
  • Children View
  • Databases View
  • Users View
  • Tables View
  • Columns View
  • Indices View
12 Capacity management and planning 8 topics
  • Spaces and types of tables
  • PERM
  • SPOOL
  • TEMP space terminology
  • Derived
  • Volatile
  • Global temporary tables
  • Identify current space usage and estimate the space requirements for the applications
13 Users, Accounts, and Accounting 5 topics
  • Creating and Using Account IDs
  • Using Account IDs with Logon
  • Dynamically Changing an Account ID
  • Account Priorities
  • Account String Expansion
14 Access Rights 12 topics
  • Privileges and Access Rights
  • Implicit
  • Access Rights continues...
  • Automatic
  • Explicit Rights
  • Grand and Revoke accesses
  • Give command
  • System Views for Access Rights
  • Inheriting Access Rights
  • Transfer access rights
  • Delete or Drop
  • User or Database
15 Roles and Profiles 9 topics
  • What is a role?
  • Advantages of Roles
  • Access Rights Using a Role
  • Implementing Roles
  • Nesting of roles
  • Views for roles
  • Profiles
  • Implementing Profiles
  • Teradata password control
16 Work load management and Priority scheduler 2 topics
  • Levels of Workload Management
  • Priority Scheduler Architecture and concepts
17 Access logging and Query logging 10 topics
  • Setting up Access Logging
  • Acc Log Rules View
  • Query Logging (DBQL) Concepts and objects
  • Used in Defining Rules for DBQL
  • DBQL Rules View
  • Setting up Access Logging
  • Acc Log Rules View
  • Query Logging (DBQL) Concepts
  • Objects
  • Used in Defining Rules for DBQL and DBQL Rules View
18 Performance monitoring (PMON) 3 topics
  • Resource usage
  • Session Management User session Info
  • SQL & Explain Steps
19 Archive and Restore and copy 4 topics
  • Archive and restore data using ARCMAIN utility
  • Different levels of archiving and restoration
  • HUT locks
  • Revalidate references after restoration
20 View point 2 topics
  • Demo of view point portlets (which is new tool for DBAs having the features of PMON)
  • TDMANAGER and TASM
21 Performance tuning 11 topics
  • Explain plan
  • Statistics and Join strategies
  • Explain plan and recommendations
  • Significance of collecting and statistics
  • Other indexes and techniques
  • Determine proper join columns
  • Join index
  • Spars index
  • Aggregate index
  • SET / MULTSET with UPI and NUPI combinations
  • Compress
22 Delivery Methodology 1 topics
  • We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course
23 Class Delivery 1 topics
  • Live Interactive classes with expert

Course details

Who it is for, what you need, and how it is delivered.

Who should learn Teradata Admin Track?

IT professionals

Analytics managers

Administrators

Fresh Graduates

Professionals who want to enhance their skills in database management, and administration.

Prerequisites

Participants are expected to have basic knowledge of SQL

General relational database knowledge

Basic UNIX commands.

Delivery methodology

We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course.

Class delivery

Live Interactive classes with expert

Certificate of completion

Earn an industry-recognised BISP Trainings certificate when you finish the course.

BISP Trainings Certificate of Completion
  • Verifiable certificate with a unique ID
  • Shareable on LinkedIn & your resume
  • Recognised by our hiring partners

Frequently asked questions

Everything you need before you enroll.

Can I attend a demo session before enrollment?

Yes. You may attend a demo class before enrollment for training quality evaluation, and interact one-to-one with the trainer for any specific requirement.

Can you schedule training as per my availability?

Yes. We discuss it with the trainer and schedule the training at a convenient time for you.

What if I miss a class?

You get the recorded session. You may also retake the whole training multiple times within a 6-month period with the same trainer.

Is there live project training?

Yes. The curriculum includes real-time scenarios and live project modules, with the trainer explaining every topic end-to-end.

How can I pay for the course?

Enroll securely via the payment gateway on this page using card, UPI or net-banking. EMI options are available.

More queries?

Call us at +91 769-409-5404 & +1 678-701-4914, or write to support@bisptrainings.com.

Case studies & learning PDFs

Free DWH ETL resources to explore.

Relevant courses

Learners who took this also explored these.

Not sure if this course is right for you?

Book a free 1-on-1 counselling call and get a personalised learning roadmap.

Book free trial →