Curso Teradata Foundation

Database

Curso Teradata Foundation

16 Horas
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
Português | Inglês
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
TENHO INTERESSE

Cursos Relacionados

Curso Oracle Database 12c Admin Install Upgrade

horas

Curso Oracle Database 12c Administração I

32 horas

Curso Oracle 12c Banco de Dados Introdução ao SQL

28 Horas

Curso Oracle Fundamentos de Big Data

32 horas

Curso Oracle Database 12c Performance Tuning

24 Horas

Curso Oracle 12c 10 Programa com PL/SQL

32 horas

Curso Oclacle 12c RAC – Administração de Banco de Dados

32 horas

Curso Oracle 12c Banco de Dados PL/SQL Advanced

24 horas

Curso Oracle 18c Database Backup and Recovery Workshop

32 horas