Visão Geral

Este curso foi elaborado para permitir que os alunos desenvolvam o comando completo do Processo de Desenvolvimento de Aplicativos no que se refere ao Teradata. O curso fornece orientação abrangente sobre o desenvolvimento de aplicativos, incluindo CLI e Teradata Utilities.

Este curso pode ser ministrado usando a versão 12, 13 ou 14. Informe seu representante de vendas sobre a versão que você está usando no momento.

Objetivo

Após a conclusão do curso, os alunos serão capazes de:

• Desenvolva aplicativos para o ambiente Teradata
• Aproveite os utilitários e paralelismo de aplicativos disponíveis do Teradata
• Explicar o modelo de dados lógicos estendido
• Aplicar estratégias de junção

Publico Alvo

• Profissionais de TI
• Desenvolvedores,
• Gerente de projetos
• Analista de sistema
• DBA Junior,
• Analista de Banco de dados
• Analista de estrutura de TI

Informações Gerais

• Carga horaria, 24h
  
• Se de segunda-feira a sexta-feira das 19h às 23h, total de 6 noites,
• Se aos sábados o curso e ministrado das 09h às 18h, total de 3 sábados,

Formato de Entrega:

• On-line ao vivo em tempo real via Microsoft Teams, na presença de um instrutor,

Materiais

Conteúdo Programatico

The Rules of Data Warehousing

1. Teradata certification
2. A logical view of the teradata architecture
3. The Parsing Engine (PE)
4. The Access Module Processors (AMPs)
5. The BYNET
6. A visual for data layout
7. How Teradata handles data access
8. Teradata cabinets, nodes, Vprocs, and disks
9. Three types of parallelism with Teradata
10. Multi-step parallelism
11. Multi-statement parallelism
12. The active data warehouse
13. OLTP environments
14. The DSS environment
15. Teradata maximums
16. Teradata maximums per release

Data Layout: AutoMagically

1. Data distribution explained
2. Rows and columns
3. The primary index
4. The two types of primary indexes
5. Unique primary index (UPI)
6. Non-unique primary index
7. Data layout summary

Partition Primary Indexes

1. V2R5 partition primary indexes
2. V2R4 example
3. V2R5 partitioning
4. Partitioning doesn’t have to be part of the primary index
5. Partition elimination can avoid full table scans
6. The Bad NEWS about partitioning on a column that is not part of the Primary Index
7. Two ways to handle partitioning on a column that is not part of the Primary Index
8. Partitioning with CASE_N
9. Partitioning with RANGE_N
10. NO CASE, NO RANGE, or UNKNOWN

The Extended Logical Data Model

1. The application development life cycle
2. Asking the right questions
3. Logical data model
4. Primary keys
5. Foreign keys
6. Normalization
7. A normalized data warehouse
8. Dimensional modeling
9. Extended logical data model
10. The end goal of the ELDM is to build Table templates
11. Column ACCESS in the WHERE clause
12. Data demographics
13. Extended logical data model template
14. The physical data model
15. How to pick an excellent primary index
16. Denormalization
17. Derived data
18. Temporary tables
19. Derived tables
20. Volatile temporary tables
21. Global temporary tables

Secondary Indexes

1. Unique Secondary Index (USI)
2. USI subtable example
3. How Teradata retrieves an USI query
4. NUSI subtable example
5. How Teradata retrieves a NUSI query
6. Value-Ordered NUSI
7. Collecting statistics on NUSI Indexes
8. NUSI bitmapping
9. Prototyping indexes with EXPLAIN
10. Chart for primary and secondary access
11. Secondary index summary

Join Strategies

1. A join in simple terms
2. The key things to know about Teradata and joins
3. Merge join strategies
4. Joins need the joined rows to be on the same AMP
5. Another great join picture
6. Joining tables with matching rows on different AMPs
7. Redistributing a table for join purposes
8. Big table small table join strategy
9. Big table small table duplication
10. Nested join
11. Hash join
12. Exclusion join
13. Product joins
14. Cartesian product join
15. Outer joins
16. Inner and outer tables with residual conditions

Join and Hash Indexes

1. Description of join indexes
2. Join index fundamentals
3. Types of join indexes
4. Single-table join indexes
5. Multi-table join indexes
6. Aggregate join index
7. Partial-covering global join index
8. Partial-covering global join index picture
9. Multi-table join back
10. Sparse index
11. Sparse index picture
12. UPSERT ON indexed tables
13. Hash indexes
14. Hash indexes vs. secondary indexes
15. Hash indexes vs. single-table join indexes
16. Hash and join indexes vs. base tables

Explains

1. The Teradata Optimizer “knows” how to explain
2. Row estimate confidence levels
3. Explain terminology

Understanding Views, Macros and Triggers

1. All about views
2. View aggregation
3. All about macros
4. Creating a MACRO
5. Macros that use parameters
6. All about triggers

Locks

1. Teradata has 4 locks for 3 levels of locking
2. Locks and their compatibility
3. How Teradata locks objects
4. Teradata locks – first come first serve
5. Locking queue example 2
6. Locking queue example 3
7. Locking modifier
8. The NOWAIT option

Collect Statistics

1. How collect statistics works
2. Sample statistics
3. What you should collect statistics on

Tools

1. Database Query Log (DBQL)
2. DBQL collection options
3. DBQL tables and views
4. How to begin logging for DBQM
5. Performance Monitor - PM
6. Access logging
7. Statistics wizard
8. Index wizard
9. TSET

Loading the Data

1. Fastload
2. Multiload
3. Tpump
4. Fastexport
5. Insert/Select

MISC

1. Identity columns
2. Identity column example
3. Set manipulation
4. System calendar
5. Stored procedures
6. OLAP and analytical functions
7. ANSI OLAP syntax
8. Referential integrity
9. Soft referential integrity
10. Materialized views
11. Roles
12. Profiles
13. Compression
14. Implementing compression
15. How compression works
16. Teradata and ANSI mode
17. Teradata multi-statement request examples
18. PP2 –the Teradata preprocessor
19. Call Level Interface - CLI