+91 8142000093 info@tanviinfo.com

Teradata

TIS_Teradata

Teradata

Course Duration : 40 Hours
Course Delivery : Classroom, Online, Weekends

Course Content

INTRODUCTION TO TERADATA
• Architecture
• Comparative Study between Teradata an Other RDBMS
• Database Components and function
• Parallel Architecture and processing the table
• Factor affecting data storage and distribution
• RDBMS & Normalization { 1st – 3rd Normal form }
• Data-warehouse Concepts { Surrogate Keys , SCD etc}
• Administrative tools
TERADATA SQL
• Data Dictionary
• Primary keys, Foreign keys, Primary Indexes, and Secondary Indexes in a Teradata system
• Advance SQL
• SQL Performance Tuning
Teradata Application Utilities
• BTEQ (Export/Import), FastExport, FastLoad, MultiLoad and Tpump for batch processing
• Internal working of above utilities
• Using utilities – Choose above utilities when and why
• TPT and its advantage over traditional utilities like FastLoad, MultiLoad etc.