お問い合わせを送信いただきありがとうございます！当社のスタッフがすぐにご連絡いたします。
予約を送信いただきありがとうございます！当社のスタッフがすぐにご連絡いたします。
コース概要
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
要求
- 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 時間
お客様の声 (1)
Nice training, full of interesting topics. After each topic helpful examples were provided.
