BISPtrainings provides online Teradata classes And training Course details Admin Track, Developer Track video tutorial and Job Support.

Teradata Dev Track web based Online Training Curriculum

► History and Architecture

Introduction to TERADATA

OLTP
OLAP systems
Data warehouse and Data Marts
Dimension modeling
Schemas
What is Teradata?
Role of Teradata in DW
Evolution of Teradata DW
Advantages of Teradata over other RDBMS
Teradata Architecture

Understanding H/W and S/W components
Architecture of Teradata
V-disks
AMP
PE
V-procs
BYNET
Database structure

Data distribution
Understanding significance of Index in Teradata
UPI
NUPI
SI
NUSI
Partitioned index
Data Protection

Different levels of failures that could happen and fault tolerance of Teradata in that situations
CLIQUE
CLUSTER
RAID
LOCKS
JORNALS
Spaces and types of tables

Different levels of accessing the objects granting the Privileges and locking mechanism
SQL

ASNI SQL
Brief introduction of Relational concepts
Understanding users
Databases
Tables
Vies
Index
Macro
Sub query
Correlated query
Data types
Joins
Arithmetic functions
Teradata SQL

Explore Teradata specific SQL statements such as show, help, and explain
SET operations
Aggregate functions
String functions
Aliasing
FORMAT
Conversion of data types
Advanced Teradata SQL

Define and execution of Macros
Date calculations
Case
COALESCE
Sample
Ranking
Qualify
CSUM
MSUM
WITH
WITH BY
► Client utilities

SQL Assistant

Setup ODBC for connecting through SQL assistant
Options menu and EXPORT/IMPORT
BTEQ

Functionality
Operations
Execution
Limitations
Fast Load

Functionality
Different phases
Execution
Restart ability
Limitations
Fast Export

Functionality
Different phases
Execution
Restart ability
Limitations
Multi Load

Functionality
Different phases
Execution
Restart ability
Limitations
Performance tuning

Explain plan & Statistics
Understanding explain plan and recommendations
Significance of collecting statistics
Other techniques

Determine the proper join columns
Join index
Spars index
Aggregate index
SET / MULTSET with UPI and NUPI combinations
Compress
► Others (Optional)

UNIX

Role of UNIX in executing Teradata utility scripts and Basic commands used General Lifecycle of the projects
General phases of a Development project
Documents required in each phase
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

Teradata Dev Track online training