Online Teradata Developer Track Training Classes And Courses  BISP 

60% Complete Courses » Teradata Dev Track
  • Course Content
  • Course Overview
  • Training Schedule
  • Demo Video
  • Learning Material
  • Register


History and Architecture
Introduction
OLTP, OLAP systems, Dataware house and Data Marts, Dimenssion modeling, Schemas, What is Teradata and role of Teradata in DW, Evolution of Teradata DW, Advantages of Teradata over other RDBMS
Teradata Architecture
Understanding H/W and S/W components, involved in Architecture of Terdata(vdisks, AMP, PE Vprocs, BYNET etc…).

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 tolarance of Teradata in that situations.(CLIQUE, CLUSTER, RAID, LOCKS and 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 etc. Sub query, corelated query, Data types, Joins, Arthimatic functions
Teradata SQL
Explore teradata specifc SQL statements such as show, help,explain.
.SET operations, Aggregate functions, Sring functions, Aliasing,FORMAT, conversion of the
datatypes.
Advanced Teradata SQL
Define and execution of Macros, Date calculations, Case, COALESCE, sample, Ranking,
Qualify, CSUM, MSUM, WITH, WITH BY.

Client utilities

SQL Assistant
Settup ODBC for connecting through SQL assistant, options menu and EXPORT/IMPORT
BTEQ
Functinality,operations, exectuion and limitations
FAST LOAD
Functinality, Different phases, exectuion, restartability and limitations
FAST EXPORT
Functinality, Different phases, exectuion, restartability and limitations
MULTI LOAD
Functinality, Different phases, exectuion, restartability and limitations

Performance tuning

Explain plan & Statistics & Understanding Explain plan and recommandations. 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

Course Id:
TD002 
Course Fees:
301 USD