Teradata 13 Online Training Course

→ 1.TeradataWarehouseandCompetitiveness

  • What is Teradata-RDMBS?
    • Teradata 12 Vs other version.
    • Teradata History.
    • Teradata in the Enterprise.
    • Teradata users &scalability.
    • Teradata competitiveness' with other RDBMS
    • (Oracle, SqlServeretc…)
    • Teradata warehouse.
    • Discussion on interview and
    • Certification questions.

→ 2.Teradata Architecture And Components

  • PDE(Parallel Data Extension)
  • Vprocs(Virtual Processors)
  • PE(Parsing Engine)
  • Amp(Access Module Processing)
  • Board Less Bynet
  • TDT(Teradata Directory Program)
  • CLI(Call Level Interface)
  • Tap(Trusted Parallel Application)
  • Going In Depth By Explaining The Processor
  • SQL Statement Execution.

→ 3.Various Architectures

  • Node Architecture(Shared Nothing)
  • SMP Architecture
  • MPP Architecture
  • Parallelism Architecture
  • Benefit & Types

→ 4.Data Recovery And Protection

  • Object Locks
  • Various locks for simultaneous access
  • RAID1
  • RAID5
  • Disk Arrays
  • Fall Back
  • Clique
  • AMP Clustering
  • Journals
  • Recovery Journal
  • Transient Journal
  • Before Journal
  • After Journal
  • Answering Various Recovery Questions.

→ 5.Teradata Storage And Retrieval Architecture

  • Request Processing
    • Syntaxes
    • Resolver
    • Security Module
    • Optimizer
    • Step Generator
    • GNC Apply
    • Dispatcher
  • Primary Index
    • Hash Algorithm
    • Row Hash
    • DSW
    • Hash Map
    • Hash Bucket
    • Reaching Vdisk

→ 6.Teradat Indexes

  • Primary Index
    • Unique
    • Non Unique
    • Partitioned
  • Secondary Index
    • Unique
    • Non Unique
    • Hash,Join,Value Ordered
    • Skewness
    • Secondary Index Sub Table
    • Accessing Records Via Primary Index
    • Accessing Records Via Secondary

Index
Keys Vs Indexes
Full Real Time Scenarios And Explaining.

→ 7.Teradat a Sql Reference

  • Fundamentals
  • Data Types And Literals
  • Data Definition Statements
  • Data Manipulation Statement
  • Explaining With Proper Examples.

→ 8.Taradata Functions And Operators

  • String Function
  • Format Function
  • Cast Functions
  • Group & Aggregate Functions
  • With & With By Clauses

Practices Of This Section.

→ 9.Taradata Transactions

  • Implicit Transaction
  • Explicit Transaction

→ 10.Peformance Tuning And Explain Utility

  • Explain Usage
  • Collecting Statistics
  • Tuning SQL Performance
  • Usage Of PMON
  • Explaining Various SQLStatements.

→ 11.Joins & Unions

  • Inner Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Detailed Explanation.

→ 12.Join Strategies

  • Product Join
  • Merge Join
  • Hash Join
  • Nested Join
  • Questions Of Section.

→ 13.Teradata Basic Commands

  • HELP
  • SHOW
  • EXPLAIN
  • COLLECT STATISTICS

→ 14.Taradata Objects

  • Table
    • Se Table
    • Multi Set Table
    • Volatile Temporary Tables
    • Derived Tables
    • Views
    • Macros
    • Stored Procedures
    • Triggers

Practices And FAQs Of This Session.

→ 15.Teradata Spaces

  • Perm Space
  • Spool Space
  • Temporary Space
  • Teradata User And Managing.
  • Practical

→ 16.Teradata Transaction Modes

  • BETET
  • ANSI
  • INTERACTIVE
  • Batch

→ 17.Load And Unload Utilities & Tool

  • Tear Data Sql Assistant (Query man)
  • Teradata Performance Monitor
  • Teradata BTEQ
    • Batch Scripts With Samples.
    • Branching And Looping
    • Importing Data Through Scripts.
    • Exporting Data Though Scripts.
    • Session Control Command Set
    • Error Handling.

→ Explanation With Proper Debugging.

  • Teradata Fast Load
    • Various Phases Of Fast Load
    • Advantages And Process.
    • Limitations Of Fast Load
    • Sample Scripts.

→ Real Time Issues And Resolving It.

  • Teradata Multi Load
    • Various Phases Of Multi Load
    • Limitations Of Multi Load
    • Working With Multiple Tables
    • Appling Various Operations.
    • Sample Scripts

→ Real Time Issues And Solving It.

  • Teradata Parallel Data Pump
    • Limitations Of TPump
    • Overview Of TPump
    • Sample Scripts
    • Teradata Fast Export
    • Exporting Data
    • Passing Parameters
    • OUTMODS
    • Sample Scripts.
  • Utility Vs Parallelism.
Online Courses Videos