Teradata basics and sql will be covered in this courses.Training will help students to appear for certification exams

Topics Covered

- Teradata Features - Relational Database Concepts - Teradata RDBMS Components and Architecture o features and benefits of Teradata technology (AMPs, PEs, BYNET) - Database Managed Storage o primary index (PI, NUPI, NoPI), data distribution, partitioned tables (PPI, MLPPI), space (perm,spool), storage optimization techniques - Data Access Methods o primary and secondary indexes (UPI, NUPI, NoPI, USI, NUSI), partitioned tables (PPI, Columnar), join indexes, full table scans, locking - Data and Performance Availability Features o fallback, journals, node failover, cliques, hot standby, RAID1 - Teradata Tools and Utilities o Load/Unload, query tools, , ARC - Basic sql concepts

Who should attend

People interested in knowing Teradata

Pre-requisites

Nothing

What you need to bring

Laptop"

Key Takeaways

Teradata knowledge