Course Outline
Day 1 – Teradata Fundamentals & Core SQL
Welcome & Introduction
- Training objectives, agenda, expectations
- Overview of Teradata ecosystem in enterprise environments
Teradata Architecture Essentials
- Parallel architecture: AMPs, Parsing Engines, BYNET
- Data distribution and hashing
- Why architecture matters: skew and redistribution
Connecting to Teradata
- Tools overview: Teradata Studio, BTEQ
Core SQL in Teradata
- SELECT, WHERE, ORDER BY
- Data types, casting, aliases
- Case expressions and conditional logic
- Teradata-specific operators (QUALIFY, SAMPLE, TOP)
-Guided exercises
Data Definition & Management
- CREATE and DROP tables, views, and volatile tables
- INSERT, UPDATE, DELETE
- MERGE (UPSERT) and duplicate handling
- Transaction control and locking behavior
- Hands-on: creating and maintaining target tables
Joins & Subqueries (with Performance Awareness)
- INNER, LEFT, RIGHT, FULL OUTER JOIN
- Cartesian joins (and when to avoid them)
- Scalar vs. correlated subqueries
- Set operators: UNION, INTERSECT, MINUS
- Hands-on: data integration exercises
- Introduction to EXPLAIN plans and query performance
Applied Workshop: Business Reporting Scenario
- Building a sales report using joins and filters
- Analyzing query plans with EXPLAIN
- Identifying skew and redistribution
Day 2 – Analytics & Performance Optimization
Recap & Q&A from Day 1
Analytical & OLAP Functions
- Ranking functions: RANK, ROW_NUMBER, DENSE_RANK
- PARTITION BY and windowing with OVER()
- LAG, LEAD, FIRST_VALUE, cumulative sums
- Practical business use cases: KPIs, trends, moving averages
Performance Tuning & Best Practices
- Teradata Optimizer: how it chooses execution plans
- Using EXPLAIN and COLLECT STATISTICS effectively
- Common performance pitfalls: skew, spool space, redistribution
- Hands-on workshop: optimize inefficient queries
Final Integrated Lab
- Load sample dataset
- Transform and aggregate with joins and OLAP functions
- Optimize queries and validate with EXPLAIN
- Export final results to external file
Testimonials (1)
Flexibility in training allowed for asking questions at any moment if something was not understood.
Lukasz - POLKOMTEL SPOLKA Z OGRANICZONA ODPOWIEDZIALNOSCIA
Course - Teradata Fundamentals
Machine Translated
