Top Teradata Course details that you need to learn

Teradata is most popular database among data warehousing projects. You will learn Teradata from any institute you want. My post intention is you just take a look on course contents you need to learn.

Course Contents You Need to Look Before You Start

Related: Top Data warehousing Interview Questions

Introduction to Teradata

• Data warehousing concepts and SCD’s
• OLTP & OLAP
• Teradata Architecture & Physical Design
• Teradata Vs. Other RDBMS
• BYNETPEs
• AMPs
• Vprocs
• Clique
• Cluster
• Data Storage
• Data Distribution
• Data Access
• Teradata Space Management

Fault Tolerance

• Data Protection

Teradata Indexes and Performance Tuning and Optimization

• UPI – Unique Primary Index
• NUPI – Non Unique Primary Index
• USI – Unique Secondary Index
• NUSI – Non Unique Secondary Index
• PPI – Partition Primary Index
• MLPPI – Multilevel Partition Primary Index
• STJI – Single Table Join Index
• MTJI – Multi Table Join Index
• AJI – Aggregate Join Index
• Global Temporary Tables and Volatile Temporary Tables
• Different Types of Tables in Teradata RDBMS
• Performance Tuning
• Explain Plan

Teradata Application Utilities

• Real-time hands-on Query Man / SQL Assistance

Teradata Application Utilities

• BTEQ
• FastExport
• FastLoad
• MultiLoad
• TPump
• Teradata Parallel Transporter (TPT)
• High Level Design of DWH Architecture from customer request to SDLC

Finally, the above list, trust me, it is complete list. I am sure if you do some project, it is good you will get job easily.