Teradata Training - Canada

Teradata Training​ Course Outline

Teradata - An Overview

• Basic Relational Concepts
• Introduction to Teradata
• Competitive Benefits over Other RDBMS
• Teradata Architecture and Components
• How to Store and Retrieve Data
• Teradata How Components Interact with Each Other
• Connectivity with Mainframe and Network Applications
• Tools and Utilities
• Teradata Unified Data Architecture

Teradata SQL

• Data Types
• DML Statements (Insert, Delete, Update)
• DCL Statements (Grant, Revoke)
• DDL Statements (CREATE, ALTER, DROP)
• Order by, Group by, Distinct, SET Operators
• Logical & Conditional Operators
• String Functions
• HELP and Show Functions
• Cast & Format Functions
• Date and Built-In Functions
• Joins (INNER and OUTER)
• Aggregation

Teradata Indexes and Join Strategies

• Difference between Primary Key and Primary Index
• Primary Index and Types
• How Primary Index is used in Data Distribution and Retrieval
• Secondary Index
• Types of Secondary Index
• Data Retrieval using Secondary Index
• Partition Primary Index and its Types
• Advantage of PPI
• Join Strategies
• How Data is Redistributed for Join Processing

SQL Advanced

• Introduction to Subqueries
• Upsert, Case, Coalesce, Nullif, OLAP Functions
• Transaction Modes
• Rank & Row Number
• Temporary Tables (Derived, Volatile and Global Temporary)
• Explain and Collect Statistics

Data Protection

• Introduction to Transaction Locks
• Fallback Tables
• Clusters
• Permanent Journal
• Down AMP Recovery Journal
• Transient Journal
• Cliques
• Data Dictionary
• Hot Standby Nodes
• RAID 1 & RAID 5

Advanced Database Objects and Performance Optimisation

• Views and Macros
• Stored Procedure
• Join Index
• Performance Tuning tips

Teradata Utilities - FastLoad, MultiLoad, BTEQ

• What is FastLoad
• How FastLoad Loads Data
• How to Restart Failed FastLoad Jobs
• What is MultiLoad and how MultiLoad Works
• Using MultiLoad to insert/update/delete data from Teradata tables
• Using BTEQ to import/export data

Teradata Utilities - FastExport, TPT

• FastExport - Exporting Data from Teradata
• TPT Overview
• TPT Export
• TPT Load
• TPT Update Comparison of Load/Unload Utilities
• TPT SQL Selector