91 92907 22289 US No. 
205 267 5959 
Teradata
Teradata Training Program |
|||
| S.No. | Topics | Details | Duration (in hrs) |
History and Architecture |
|||
| 1 | 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 | 2 |
| 2 | Teradata Architecture | Understanding H/W and S/W components, involved in Architecture of Terdata(vdisks,AMP,PE Vprocs, BYNET…etc). | 2 |
Database structure |
|||
| 5 | Data distribution | Understanding significance of Index in teradata(UPI, NUPI, SI, NUSI, Partitioned index ) | 3 |
| 6 | Data Protection | Different levels of failures that could happen and fault tolarance of Teradata in that situations.(CLIQUE,CLUSTER,RAID,LOCKS and JORNALS) | 3 |
| 3 | Database objects and Access rights | Creating users, databases, tables,vies,index,macro...etc and understanding profiles | 2 |
| 4 | Spaces and types of tables | Different levels of accessing the objects granting the Privileges and locking mechanism | 1 |
SQL |
|||
| 6 | ASNI SQL | Brief introduction of Relational concepts, sub query, corelated query, Data types, Joins, Arthimatic functions | 3 |
| 7 | Teradata SQL | Explore teradata specifc SQL statements such as show, help,explain. .SET operations, Aggregate functions, Date functions, Aliasing,FORMAT, |
3 |
| 8 | Advanced Teradata SQL | Date calculations, string functions, Case,COALESCE,sample, Ranking, Qualify, CSUM, WITH,WITH BY, volatile, derived, global temporary tables | 3 |
Client utilites |
|||
| 9 | SQL Assistant | Settup ODBC for connecting through SQL assistant, options menu and EXPORT/IMPORT | 1 |
| 10 | BTEQ | Functinality,operations, exectuion and limitations | 3 |
| 11 | FAST LOAD | Functinality, Different phases, exectuion, restartability and limitations | 2 |
| 12 | FAST EXPORT | Functinality, Different phases, exectuion, restartability and limitations | 2 |
| 13 | MULTI LOAD | Functinality, Different phases, exectuion, restartability and limitations | 2 |
| 14 | TPUMP | Functinality, Different phases, exectuion, restartability and limitations | 2 |
Performance tuning |
|||
| 15 | Explain plan | Understanding Explain plan and recommandations | 1 |
| 16 | Statistics | Significance of collecting statistics | 1 |
| 17 | Other techniques | Determine the proper join columns, Join index, Spars index, Aggregate index, SET / MULTSET with UPI and NUPI combinations, compress | 1 |
Others (Optional) |
|||
| 18 | Unix | Role of Unix in executing Teradata utility scripts and Basic commands used | 2 |
| 19 | General Lifecycle of the projects | General phases of a Development project. Documents required in each phase | 1 |
| Total : | 40 | ||