Teradata Training Course (3-4 days) 

Note: this outline is our proposal, but the training can be tailored to your specific requirements upon prior request ahead of the proposed course date.

Why Learn Teradata?

Teradata is a leading provider of powerful, enterprise big data analytics and services that include Data warehousing, Data Driven Marketing, BI and CRM. Teradata is an open system, running on a UNIX MP-RAS or Windows server platform. Teradata is capable of supporting many concurrent users from various client platforms. 

Requirements

  • Basic knowledge of SQL and Database Systems would be helpful for the beginners, and it's required for an advanced course.

 

Course details

The agenda covers both fundamentals and advanced topics, 

The final training outline will be designed depending on your particular requirements.

The practical exercises constitute a big part of the course time, besides demonstrations and theoretical presentations. Discussions and questions can be asked throughout the course.

 

Course Outline

 

Teradata Overview

  • What is Teradata,

  • Basic Relational Concepts, 

  • Competitive advantages over other RDBMS,

  • Teradata Components,

  • Components interaction 

  • Data storage and retrieval process 

  • Integration between Mainframe and Network Applications, 

  • Teradata Unified Data Architecture.

 

Teradata Indexing and Joining Strategies

  • Overview of Indexing 

  • Difference between Primary Key and Primary Index

  • The primary index for data retrieval and data distribution 

  • Secondary index and its types,

  • Data retrieval with secondary Index,

  • Partition Primary index types 

  • PPI advantages 

  • Join strategies and data redistribution for join process 

 

Teradata SQL

  • Data types,DML Statements (Insert, Remove, Update)

  • DDL Statements

  • DCL Statements (Grant, Revoke)

  • Group by, Order by, Distinct,

  • Logical & Conditional Operators, 

  • SET Operators and String functions,

  • Date Functions, Built-In Functions, HELP and Show Functions, 

  • Joins (INNER and OUTER).

  • Built-In Functions, Aggregation,

 

Data Protection

  • Transaction locks, Permanent Journal 

  • Fallback tables, Clusters, 

  • Transient Journal, Cliques,

  • Down AMP Recovery Journal 

  • Hot Standby nodes, and Cliques

  • Overview of RAID 1 & RAID 5,

  • Data Dictionary.

 

SQL advanced

  • Subqueries, Upsert,

  • Case,OLAP Functions, Nullify,

  • Transaction Modes,

  • Rank & Row Number, 

  • Temporary Tables 

  • Collect and Explain Statistics.

 

Database Advanced Concepts and Performance Optimization

  • Stored Procedure, Views, Macros

  • Performance Tuning tips

  • Join Index

 

Teradata Utilities: MultiLoad, FastLoad, BTEQ.

  • What is Fast

  • LoadThe process to restart failed FastLoad jobs

  • How FastLoad loads data

  • Introduction to MultiLoad and how it works 

  • Using MuliLoad to perform various data related functions Teradata tables.  

 

Teradata Utilities: TPT, FastExport

  • Exporting data from Teradata using FastExport

  • TPT Export, TPT SQL Selector.

  • TPT overviewTPT Load, TPT Update

  • Difference between Load/Unload Utilities

 europe@training-united.com

 +49 30 2218 0753

©TRAINING UNITED