[vc_btn title=”On-Demand Course” color=”blue” size=”m” link=”url:http%3A%2F%2Fflexmind.co%2Fcontact%2F%23firstcontentcontainer|title:On-Demand%20Course|target:%20_blank”]

Teradata Training

Course Outline

Teradata is an enterprise software company that develops and sells a relational database management system(RDBMS). Teradata is considered as a “Data ware house system”, which can manage data, store data & BAR (BACKUP, ARCHIVE &RESTORE) data. This training will help students to master the tool for business analysis, storage of data in the offsite recovery center and its retrieval.

Module 1: Teradata Architecture and Components

PDE (Parallel Data Extension)
Vprocs (virtual processors)
PE (Parsing Engine)
AMP (Access Module processing)
BYNET
TDP (Teradata Directory Program)
CLI (Call Level Interface)
TPA (Trusted parallel Application)
Going in depth by explaining the process of SQL statement execution

Module 2: Various Architecture

Node Architecture (shared nothing)
SMP Architecture
MPP Architecture
Parallelism Architecture
Benefit & types

Module 3: Data Recovery and Protection

Object Locks-Various locks for simultaneous access
RAID
Disk Arrays
Fall Back
Clique
AMP Clustering
Permanent Journal
Transient Journal

Module 4: Teradata Indexes

Primary Index
Unique
Non unique
Partitioned
Secondary Index
Unique
Non unique
Skewness
Secondary Index Sub table
Accessing Records via primary index
Accessing records via Secondary index
Keys vs indexes

Module 5: Teradata Sql Reference

Fundamentals
Data Types and Literals
Data Definition Statements
Data manipulation statements

Module 6: Teradata Functions and Operators

String functions
Format functions
Cast functions
Group & Aggregate functions
With & with by clauses

Module 7: Performance Tuning and Explain Utility

Explain Usage
Collection Statistics
Tuning SQL Performance

Module 8: Joins & Unions

Inner Join
Left Outer Join
Right Outer join
Full Outer Join
Union
Union ALL

Module 9: Teradata Basic Commands

HELP
SHOW
EXPLAIN
COLLECT STATISTICS

Module 10: Teradata objects

Tables
SET table
Multi Set table
Volatile tables
Global Temporary tables
Derived tables
Views
Macros
Stored procedures
Triggers

Module 11: Teradata Locking

READ
WRITE
EXCLUSIVE
ACCESS

Module 12: Teradata spaces

PERM space
SPOOL space
TEMPORARY space
Teradata User

Module 13: Teradata OLAP Functions

Cumulative SUM
Difference SUM
Moving SUM
Moving AVG
Qualify
Row Number

Module 14: Teradata Built in Functions

DATE
TIME
CURRENT_DATE
CURRENT_TIMESTAP
LIKE
SUBSTRING
POSITION

Module 15: Teradata Transaction Modes

BTET
ANSI
Interactive
Batch

Module 16: Load and Unload Utilities & Tools

Teradata Sql Assistant (Queryman)

SQL Assistant Tool Hands On with all the features
Importing data SQL Assistant
Exporting data SQL Assistant

Teradata BTEQ

Batch Scripts with samples
Branching and Looping
Importing data through scripts
Exporting data through scripts

Teradata Fast load

Various Phases of Fast Load
Advantages and Process
Limitations of Fast Load
Sample scripts

Teradata Multi Load

Various Phases of Multi load
Limitations of Multi Load
Applying various operations
Sample Scripts

Teradata TPump

Various Phases of TPump
Limitations of TPump
Applying various operations
Sample Scripts

Teradata Fast Export

Fast Export with multiple tables
Sample Scripts

Sharing is Caring