Teradata: From Zero to Advanced Training Course

Introduction to Teradata

Module 1: Fundamentals of Teradata and Its Architecture

• What is Teradata and what is it used for?
• Parallel architecture: AMPs, PEs, BYNET
• Data distribution and hashing
• Key concepts: sessions, spool, locks
• Connecting to the system: Teradata Studio / BTEQ / SQL Assistant

Module 2: Introduction to SQL in Teradata

• Basic SELECT, WHERE, ORDER BY
• Data types and casting
• Mathematical and date functions
• Use of ALIAS, CASE expressions
• Special Teradata operators (TOP, QUALIFY, SAMPLE)
• Guided practice: queries on real tables

Module 3: Joins, Subqueries, and Set Operators

• INNER, LEFT, RIGHT, FULL OUTER JOIN
• Joins without an ON clause (Cartesian product)
• Scalar and correlated subqueries
• UNION, INTERSECT, MINUS
• Data integration practical exercises

Module 4: Analytical Functions and OLAP

• RANK(), ROW_NUMBER(), DENSE_RANK()
• Data partitioning with PARTITION BY
• Windows with OVER() and ORDER BY
• LAG(), LEAD(), FIRST_VALUE()
• Use cases: KPIs, trends, accumulations

Module 5: Data and Table Management

• Types of tables: permanent, volatile, global temporary
• Creation and use of secondary indexes and join indexes
• Inserting, updating, and deleting records
• MERGE, UPSERT, and duplicate control
• Transactions and lock management

Module 6: Optimization and Performance Tuning

• The Teradata Optimizer: how it decides on plans
• Use of EXPLAIN and COLLECT STATISTICS
• Skew and how to avoid it
• Best practices for query design
• Bottleneck identification (spool, locks, redistribution)
• Practice: comparison between optimized and non-optimized queries

Module 7: Data Partitioning and Compression

• Types of partitioning: Range, Case, Multi-Level
• Benefits and practical use in large queries
• Block Level Compression (BLC) and Columnar Compression
• Advantages and limitations

Module 8: Data Loading and Extraction

• TPT (Teradata Parallel Transporter) vs. FastLoad / MultiLoad
• Bulk loading vs. batch insertion
• Error handling and retries
• Exporting results to files or external systems
• Basic automation with scripts and utilities

Module 9: Basic Administration for Technical Users

• Roles and permissions
• Resource control (Query Bands, Priority Scheduler)
• Monitoring with DBQLOGTBL, DBC.Tables, ResUsage
• Best practices for shared environments

Module 10: Final Integration Laboratory

• End-to-end practical case:
  • Data loading
  • Transformation and aggregation
  • Building indicators with OLAP functions
  • Optimization and explanation
  • Final export
• Discussion of best practices and common errors