Teradata

Teradata introduction

Teradata Introduction

Teradata Advantages

Teradata Tools & Utilities

RDBMS/Data warehousing Basics

RDBMS Basic Concepts (Tables/Rows/Columns/Primary Key/Foreign Key)

What is data warehouse

OLTP Vs Data warehouse

Data warehouse Architecture

Teradata Architecture

Teradata Components (Parsing Engine, BYNET, Access Module Processor)

How Teradata components interact with each other

Storage & Retrieval architecture

System architecture

What is a Node

Basic SQL

Data types

DDL statements(CREATE,DROP,ALTER)

DML statements (SELECT, INSERT,UPDATE,DELETE)

SET Operators(UNION , UNION ALL, INTERSECT, MINUS)

Logical & Conditional Operators

String Manipulation

Date & Time Manipulation

Joins

Built-in functions

Aggregates

Indexes

Primary Index (UPI, NUPI)

Secondary Index (USI, NUSI)

Partition Primary Index

Teradata Objects

SET vs MULTISET tables

Derived Tables

Volatile Tables

Global Temporary Tables

Views

Macros

Stored Procedures

Single Table Join Index

Multi Table Join Index

Aggregate Join Index

Space concepts (Perm, Spool, Temp)

Triggers

Advanced SQL

Subqueries

Coalesce

OLAP Functions (Rank, Row_Number, Qualify, Partition by, Rows Unbounded preceding/following)

Compression

Collect Statistics

DBC tables

Teradata Transaction Modes

Utilities

FastLoad

MultiLoad

BTEQ

FastExport

TPT

Data Protection

Fallback

Clusters

Clique

Permanent Journals

Hot Standby Nodes

RAID

Performance Optimization

Explain Plan

Join Strategies

Confidence levels

Statistics collection process

Performance tuning techniques

Case-studies and Mock Project

Decoding common errors

Best Practices

Sample Mock Projects