Teradata Load Utilities Training Overview
Accelebrate's Teradata Load Utilities training course teaches attendees to use Teradata's wide array of efficient, scalable, and flexible features to seamlessly stream data from different sources into one central system.
Location and Pricing
Accelebrate offers instructor-led enterprise training for groups of 3 or more online or at your site. Most Accelebrate classes can be flexibly scheduled for your group, including delivery in half-day segments across a week or set of weeks. To receive a customized proposal and price quote for private corporate training on-site or online, please contact us.
In addition, some courses are available as live, instructor-led training from one of our partners.
Objectives
- Collect Statistics
- Table Create and Data Types
- Temporary Tables
- BTEQ – Batch Teradata Query
- FastLoad
- MultiLoad
- TPump
- FastExport
- Teradata Parallel Transport (TPT)
- The major keys to building TPT scripts
- TPT utility commands
- How to run a TPT script
- TPT operators and their equivalent load utility
- Teradata best practices
Prerequisites
No prior experience is required.
Outline
Introduction
Teradata Utilities Introduction
Collect Statistics
Table Create and Data Types
Temporary Tables
BTEQ – Batch Teradata Query
FastLoad
MultiLoad
TPump
FastExport
Teradata Parallel Transport (TPT)
Top SQL Commands Cheat Sheet
Conclusion
Training Materials
All Teradata training students receive comprehensive courseware.
Software Requirements
We have multiple options for setting up this course using a mix of local and/or cloud resources that we provide. Please ask us for details.
