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
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.
0 Comments
Thanks for your message. We will get back you.