Course Outline

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
  • Teradata special 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
  • Practical exercises for data integration

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, cumulative totals

Module 5: Data and Table Management
  • Types of tables: permanent, volatile, global temporary
  • Creation and use of secondary indexes and join indexes
  • Insertions, updates, and record deletions
  • MERGE, UPSERT, and duplicate control
  • Transactions and lock control

Module 6: Optimization and Performance Tuning
  • The Teradata Optimizer: how it decides plans
  • Use of EXPLAIN and COLLECT STATISTICS
  • Skew and how to avoid it
  • Best practices for query design
  • Identifying bottlenecks (spool, locks, redistribution)
  • Practice: comparing optimized vs. 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 Lab
  • 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

Requirements

  • Understanding of relational databases and SQL concepts
  • Experience querying large datasets or working in data environments
  • Familiarity with business intelligence or analytics objectives

Audience

  • Data analysts and business intelligence professionals
  • SQL developers and data engineers
  • Technical users who manage or optimize data in Teradata environments
 35 Hours

Delivery Options

Private Group Training

Our identity is rooted in delivering exactly what our clients need.

  • Pre-course call with your trainer
  • Customisation of the learning experience to achieve your goals -
    • Bespoke outlines
    • Practical hands-on exercises containing data / scenarios recognisable to the learners
  • Training scheduled on a date of your choice
  • Delivered online, onsite/classroom or hybrid by experts sharing real world experience

Private Group Prices RRP from €11400 online delivery, based on a group of 2 delegates, €3600 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.

Contact us for an exact quote and to hear our latest promotions


Public Training

Please see our public courses

Testimonials (1)

Provisional Upcoming Courses (Contact Us For More Information)

Related Categories