Teradata Training Program

Total Training Duration: 3 PD ( 24 Hour)

-Basics (2Hours)

-Architecture (3 hours)

-SQL (4 Hours)

-ETL Utilities (3 Hours)

-Case Study (12 Hours)

Basics:

-Basic Architecture of Teradata

-The uniqueness of Teradata SQL and to know different functions available in Teradata.

-Different Utilities (FastLoad, FastExport, MultiLoad, Tpump,Teradata Warehouse Miner) in Teradata.

-How Teradata is ideal for Datawarehouse application.

Architecture:

Hardware components:

The hardware that supports Teradata RDBMS software is based on off the-shelf Symmetric Multiprocessing (SMP) technology. Hardware Components are:

• SMP Systems

• MPP Systems

BYNET

• VPROCS

-Parsing Engine (PE

)

-Access Module Processor (AMP)

Software Architecture:

•Parallel Database Extensions (PDE)

•Teradata File System

•Trusted Parallel Applications (TPA )

•Virtual Processors - PE and AMP

•PERM Space

•SPOOL Space

SQL:

-Teradata DDL(create, Drop, Alter)

-Teradata DML(Select, Insert,Update, Delete),

-Teradata DCL(Grant, Revoke).

-Teradata extensions to SQL like HELP, SHOW, EXPLAIN, CREATE MACRO, REPLACE MACRO.

-Primary index / Secondary Index

-SET operators(UNION,INTERSECT,EXCEPT, MINUS)

ETL Utilities:

Fload: This utility provides us with facility for loading new tables onto Teradata database

Fast export: This utility exports a large volume of data from Teradata to a host file or user-written application.

Multiload: This utility supports INSERT,UPDATE, DELETE and UPSERTS typically with batch inputs from a host file.

TPump: This utility allows the real time update from transactional systems into warehouse.

Case Study:

Administration:

-To create a user , database and understand the hierarchy of user and database.

-To create a table with columns having datatype integer, char, decimal, date and having one primary index.

-To drop a table in a database or a user.

SQL:

-To use SELECT statement with ORDERBY and GROUPBY clause.

-To use inner join, LEFT Outer Join, Right Outer Join and Full Outer Join on two tables.

-To use CASE, COALESCE, NULLIF, IFNULL

-To use set operators(UNION,INTERSECT,EXCEPT)

Fast Load:

-To create a empty table in TeraData and prepare a flat file containing data. Prepare a script for loading the data from flat file into the empty table.

Fast Export:

-To use the FastExport to create an export file that contains one record for each transaction . Columns from two different tables has to be joined inorder to create the export file.

MultiLoad:

-To use Multiload to delete rows from your three tables. An input file will be created which will contain a control letter(A-Accounts, C-customer, T-trans) followed by a primary index value for the appropriate table

TPUMP:

-Use FastExport to export the records into a flat file. Prepare Tpump script which performs UPSERT operation on another table.Validate your results.

Internal Use Only

TCS Internal