+91 – 88617 28680learning@flexmind.co

Teradata training

[vc_btn title=”On-Demand Course” color=”blue” size=”m” link=”url:http%3A%2F%2Fflexmind.co%2Fcontact%2F%23firstcontentcontainer|title:On-Demand%20Course|target:%20_blank”]

Teradata Training

Course Outline

Teradata is an enterprise software company that develops and sells a relational database management system(RDBMS). Teradata is considered as a “Data ware house system”, which can manage data, store data & BAR (BACKUP, ARCHIVE &RESTORE) data. This training will help students to master the tool for business analysis, storage of data in the offsite recovery center and its retrieval.

Module 1: Teradata Architecture and Components

  • PDE (Parallel Data Extension)
  • Vprocs (virtual processors)
  • PE (Parsing Engine)
  • AMP (Access Module processing)
  • BYNET
  • TDP (Teradata Directory Program)
  • CLI (Call Level Interface)
  • TPA (Trusted parallel Application)
  • Going in depth by explaining the process of SQL statement execution

Module 2: Various Architecture

  • Node Architecture (shared nothing)
  • SMP Architecture
  • MPP Architecture
  • Parallelism Architecture
  • Benefit & types

Module 3: Data Recovery and Protection

  • Object Locks-Various locks for simultaneous access
  • RAID
  • Disk Arrays
  • Fall Back
  • Clique
  • AMP Clustering
  • Permanent Journal
  • Transient Journal

Module 4: Teradata Indexes

  • Primary Index
  • Unique
  • Non unique
  • Partitioned
  • Secondary Index
  • Unique
  • Non unique
  • Skewness
  • Secondary Index Sub table
  • Accessing Records via primary index
  • Accessing records via Secondary index
  • Keys vs indexes

Module 5: Teradata Sql Reference

  • Fundamentals
  • Data Types and Literals
  • Data Definition Statements
  • Data manipulation statements

Module 6: Teradata Functions and Operators

  • String functions
  • Format functions
  • Cast functions
  • Group & Aggregate functions
  • With & with by clauses

Module 7: Performance Tuning and Explain Utility

  • Explain Usage
  • Collection Statistics
  • Tuning SQL Performance

Module 8: Joins & Unions

  • Inner Join
  • Left Outer Join
  • Right Outer join
  • Full Outer Join
  • Union
  • Union ALL

Module 9: Teradata Basic Commands

  • HELP
  • SHOW
  • EXPLAIN
  • COLLECT STATISTICS

Module 10: Teradata objects

  • Tables
  • SET table
  • Multi Set table
  • Volatile tables
  • Global Temporary tables
  • Derived tables
  • Views
  • Macros
  • Stored procedures
  • Triggers

Module 11: Teradata Locking

  • READ
  • WRITE
  • EXCLUSIVE
  • ACCESS

Module 12: Teradata spaces

  • PERM space
  • SPOOL space
  • TEMPORARY space
  • Teradata User

Module 13: Teradata OLAP Functions

  • Cumulative SUM
  • Difference SUM
  • Moving SUM
  • Moving AVG
  • Qualify
  • Row Number

Module 14: Teradata Built in Functions

  • DATE
  • TIME
  • CURRENT_DATE
  • CURRENT_TIMESTAP
  • LIKE
  • SUBSTRING
  • POSITION

Module 15: Teradata Transaction Modes

  • BTET
  • ANSI
  • Interactive
  • Batch

Module 16: Load and Unload Utilities & Tools

Teradata Sql Assistant (Queryman)

  • SQL Assistant Tool Hands On with all the features
  • Importing data SQL Assistant
  • Exporting data SQL Assistant

Teradata BTEQ

  • Batch Scripts with samples
  • Branching and Looping
  • Importing data through scripts
  • Exporting data through scripts

Teradata Fast load

  • Various Phases of Fast Load
  • Advantages and Process
  • Limitations of Fast Load
  • Sample scripts

Teradata Multi Load

  • Various Phases of Multi load
  • Limitations of Multi Load
  • Applying various operations
  • Sample Scripts

Teradata TPump

  • Various Phases of TPump
  • Limitations of TPump
  • Applying various operations
  • Sample Scripts

Teradata Fast Export

  • Fast Export with multiple tables
  • Sample Scripts