Visão Geral

Este Curso Teradata Foundation, foi desenvolvido para ilustrar os fundamentos do banco de dados Teradata.

Os alunos aprendem sobre processamento paralelo, AMPs e PEPs, como o Teradata distribui os dados uniformemente, uso do índice primário, hashing, espaço permanente e spool e recursos de proteção.

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 Teradata Basics, os alunos serão capazes de:

• Descreva a arquitetura Teradata
• Explicar data warehouse e distribuição de dados
• Calcule o espaço Teradata
• Aplicar proteção de dados, incluindo Transient Journal, Fallback e RAID
• Explique o particionamento V2R5

Publico Alvo

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

Pre-Requisitos

Não se aplica!

Informações Gerais

• Carga horaria, 16h
• 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 2 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 Teradata Architecture

1. The Teradata Architecture
2. The Parsing Engine
3. The AMPs
4. Born to be parallel
5. The BYNET
6. Watch the Tera-Tom Video on Architecture
7. Collecting Statistics
8. Parsing Engine uses Statistics for the Plan
9. Columns and Indexes to Collect Statistics On
10. A Scalable Architecture
11. VProcs
12. Nodes and MPP
13. Watch the Tera-Tom Video on How AMPS store and process rows in Parallel

Logical Modeling

1. Logical Modeling – Primary and Foreign Keys
2. A Normalized Data Warehouse
3. Normalization
4. Dimensional Modeling also called Star Schema

The Primary Index

1. Physical Modeling - The Primary Index
2. Two Types of Primary Indexes (UPI or NUPI)
3. Unique Primary Index (UPI)
4. Non-Unique Primary Index (NUPI)
5. Multi-Column Primary Indexes
6. When do you define the Primary Index?
7. Watch the Tera-Tom Video on Primary Indexes

How Teradata Distributes and Retrieves Data

1. How Teradata Distributes and Retrieves Rows
2. Hashing the Primary Index Value
3. The Hash Map
4. Laying a Row onto the Proper AMP
5. Retrieving a Row by way of the Primary Index
6. Placing Non-Unique Primary Indexes (NUPI) Rows
7. Non-Unique Primary Indexes Continued
8. Placing (NUPI) Rows Continued
9. Retrieving (NUPI) Rows
10. Even Distribution with an UPI
11. Uneven Distribution with a NUPI
12. Unacceptable Distribution with a NUPI
13. Big Trouble – A Picture of a Full Table Scan
14. A Visual for Data Layout
15. Watch the Tera-Tom Video on Data Placement
16. Bonus Video - Tera-Tom Video on the Row-ID
17. Test your Teradata Primary Index Knowledge

Secondary Indexes

1. Secondary Indexes
2. The Secondary Index Subtable
3. USI – Always a Two-AMP Operation
4. USI Summary
5. Watch the Tera-Tom Video on Unique Secondary Indexes (USI)
6. NUSI Subtable is AMP-Local
7. NUSI Recap
8. Secondary Index Summary
9. Watch the Tera-Tom Video on Non-Unique Secondary Indexes (NUSI)

Partitioned Tables

1. A Table used for our Partitioning Example
2. Range Queries
3. Why we had to perform a Full Table Scan
4. A Partitioned Table
5. A Partitioned Table
6. One Year of Orders Partitioned
7. Fundamentals of Partitioning
8. Add the Partition to the Row-ID for the Row Key
9. Multi-Level Partitioning
10. Partitioning Rules
11. Watch the Tera-Tom Video on Partitioning

Space

1. The most Powerful USER
2. DBC owns all the Disk Space
3. DBC Example of 1000 GBs
4. DBC will first CREATE a USER or a DATABASE
5. Teradata is Hierarchical
6. Only two Objects can Receive PERM Space
7. PERM, SPOOL and TEMP Space
8. Spool is like a Speed Limit
9. All Space is calculated on a Per AMP Basis
10. Watch the Tera-Tom Video on Space

Join Indexes

1. Introduction to a Join Index
2. Join Index Fundamentals
3. A Multi-Table Join Index Example
4. Multi-Table Join Index Picture
5. Single-Table Join Index
6. Aggregate Join Index
7. Join Index Details to Remember
8. Watch the Tera-Tom Video on the Parody Teradata Query Search-Off

Data Protection

1. Data Protection
2. Transaction Concept
3. Transient Journal
4. RAID 1 - Mirroring
5. Cliques
6. VProcs Migrate when a Node Fails
7. Cliques – An 8-Node Example
8. Hot Standby Nodes
9. Hot Standby Nodes in Action
10. FALLBACK Protection
11. How Fallback Works
12. Fallback Clusters Exercise
13. Fallback Clusters
14. The Six Rules of Fallback
15. Down AMP Recovery Journal (DARJ)
16. Permanent Journal
17. Permanent Journal Rules

Locking

1. The Four Locks of Teradata
2. Teradata has 3 levels of Locking
3. Locking Modifiers – The Access Lock
4. Locks and their compatibility

The Steps to Active Data Warehousing

1. The Active Data Warehouse
2. Operational Data Stores Vs the Data Warehouse
3. How is all Started - OLTP, DSS, OLCP, and OLAP
4. Data Marts
5. Distributed Data Warehousing – The Future
6. Watch the Tera-Tom Video on the Nexus Nerds
7. Centralized Data Warehousing

Teradata Hardware, Software and Security

1. Teradata V12 Platforms
2. Teradata V12 Operating Systems
3. A Typical Cabinet and Node
4. LAN Connection for Network Attached Clients
5. Mainframe Connection to Teradata
6. LDAP
7. Access Rights
8. Automatic, Implicit, and Explicit Rights
9. Roles
10. Profiles
11. Views
12. Macros
13. Stored Procedures
14. User Defined Functions (UDF)

Teradata Tools

1. Teradata Analyst Pack
2. Teradata Visual Explain Utility
3. TSET
4. Index Wizard
5. Statistics Wizard
6. Three Levels of Workload Management
7. Teradata Dynamic Workload Manager
8. Priority Scheduler Fundamentals
9. Priority Scheduler with Additional Partitions
10. Database Query Log (DBQL)
11. Teradata Workload Analyzer
12. Performance Monitor

Load Utilities

1. Teradata Load Utilities
2. Teradata Load Utilities Continued
3. BTEQ
4. The Four Types of BTEQ Exports
5. BTEQ IMPORT Script
6. FastLoad
7. FastLoad has Two Phases
8. A Sample FastLoad Script
9. The SmartScript FastLoad Builder
10. MultiLoad
11. A Sample MultiLoad Script
12. The SmartScript MultiLoad Builder
13. TPump
14. Limitations of TPump
15. A Sample TPump Script
16. The SmartScript TPump Builder
17. FastExport
18. Teradata Parallel Transport
19. TPT Operators and their Functions
20. TPT Operator Types
21. TPT Operators and their Equivalent Load Utility
22. How to Run a TPT Script