Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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
Testimonials (2)
The instructor explains very well.
Gerardo Hurtado
Course - Advanced Teradata
Machine Translated
Nice training, full of interesting topics. After each topic helpful examples were provided.
