Teradata DBA

Course Overview

Xpertised Offers Advanced and Personalized Instructor Led Online Classroom training on Teradata DBA which gives you the opportunity to interact with a Teradata DBA instructor and help you enhance yourself to meet the demands of the industry.

Learn from our instructors from the convenience of your home or office. Interact and learn live with trainers and other participants.

Course Content

What is Teradata

What is Teradata?

Teradatav12 &versions

Teradata History

Teradata users scalability

Teradata &other RDBMS

Teradata warehouse

Teradata in the Enterprise

Interview Q&A and Certification queries

Real time Issues & resolving

Teradata architecture & it’s components

Node Architecture(Shared Architecture)

SMP Architecture

MPP Architecture

Parsing engine(PE) Architecture

AMP Architecture &uses

Bynet Benefits &types

Parallel data extension(PDE)

Teradata directory program(TDP)

Call level interface(CLI)

Trusted parallel application(TPA)

Virtual processors

Bynet 0 &Bynet 1

Parallism Architecture

Recovery &protection of Data

What is fall back &where it used

Why for fall back

What is Clique

AMP Clustering

Locks & types for simultaneous Access

Why for locks &how trelease

RAID 1 &RAID 5

Journals &types

Virtual Disk Array

How & where is used journals

Q & A about data recovery

Teradata indexes

Types of indexes in Teradata

Hash index

Join index

Primary index(unique, non- unique)

Secondary index(unique, non- unique)

Skewness

Keys & indexes (How & why these used)

How to storage & retrieval of data

Hash algorithm

Row hash

Hash map

Hash bucket

Receiving VDisc

Teradata SQL Quarryman

SQL fundamentals

Data types and literals

DDL Statements

DML Statements

Teradata naming conversing

Teradata SQL Functions & operations

String functions

Format functions

Cast functions

Cast functions

Group & Aggregation functions

Logical operations

Arithmetic operations

set operations

join operations

conditional expressions

Teradata join strategies & unions

hash join

merge join

nested join

product join

inner join

left & right outer join

full outer join

Teradata basic commands

Help

Show

Explain

Collect statistics

Teradata objects

Types of tables

Set tables

Multi tables

Volatile tables

Global temporary tables

Derived tables

Views

Macros

Stored procedures

Triggers

Teradata memory spaces

Permanent spaces

Temporary spaces

Spool spaces

Users spaces & PWD

Teradata transaction modes

Batch mode

BTET mode

ANSI mode

How Converted intothers

Teradata performance tuning on SQL Assistance

Usage of PMON

Explain usage

Collecting statistics

SQL tuning

Various SQL statements

Real time Issues & resolving

Teradata Utilities & Tools (Import & Export)

Teradata BTeq scripts

Overview of BTeq

Looping stages

Batches scripts

Import &export scripts with Examples

Error handling

Real time scripts

Teradata FastLoad

Types of phages & how tfind it

Advantages & its process

Limitations of fast load

Real time scripts

Teradata MultiLoad

Overview of Multi load

Types of phages in MultiLoad

Advantages & its process

Limitations of MultiLoad

Uses various types of operations

Work on Multi tables

Real time scripts

Sample scripts

Teradata Tpump

Overview of Tpump

Limitations of Tpump

Work on Multi tables

Real time scripts

Sample scripts

Teradata Fast Export

How texport the data

Passing parameters

IN/OUT Modes

Work on Multi tables

Real time scripts

Sample scripts

Teradata SQL Assistant(Quarryman)

Teradata performance monitor

Teradata Administrator usage

Teradata performance tuning on scripts

Customer Reviews

Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.

-Waseem

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional.
I am quite satisfied with the course.