Online Teradata training

Training
Enthusiast

Online Teradata training

Online teradata training offers a full suite of Teradata training courses, covering the basics to Advanced SQL and everything in between. All Teradata classes are available for private on-site instructor-led classes or online through our virtual Live Web-Based Training.

The Course cntains are

TERADATA V13.10
  • TERADATA
    • What is Teradata?
    • Teradata v13.10 & versions
    • Teradata History
    • Teradata user’s scalability
    • Teradata & other RDBMS
    • Teradata warehouse
    • Teradata in the Enterprise
    • Interview Q&A and Certification queries
    • Real time Issues & resolving
  • TERADATA ARCHITECTURE
    • Node Architecture (Shared Architecture)
    • SMP Architecture
    • MPP Architecture
    • Parsing engine (PE) Architecture
    • AMP Architecture & uses
    • Bynet Benefits & types
    • Parallel data extension (PDE)
    • Teradata directory program (TDP)
    • Call level interface (CLI)
    • Trusted parallel application (TPA)
    • Virtual processors
    • Bynet 0 & Bynet 1
    • Parallism Architecture
  • OBJECTS OF TERADATA
    • Types of tables
    • Set tables
    • Multi tables
    • Volatile tables
    • Global temporary tables
    • Derived tables
    • Views
    • Macros
  • RECOVERY & PROTECTION OF DATA
    • What is fall back & where it used
    • Why for fall back
    • What is Clique
    • AMP Clustering
    • & types for simultaneous Access
    • Why for locks & how to release
    • RAID 1 & RAID 5
    • Journals & types
    • Virtual Disk Array
    • How & where are used journals?
  • INDEXES OF TERADATA
    • Types of indexes in Teradata
    • Data Distribution and Data Retrieval
    • Use of indexes
    • Primary indexes (unique, non- unique, NO PI)
    • Secondary indexes (unique, non- unique)
    • Partition Primary Indexes (PPI)
    • Multilevel portioning primary index (MLPPI)
    • Join indexes
    • Skew factor
    • Keys & indexes (How & why these used)
  • STORAGE & RETRIEVAL OF DATA
    • SQL Request Processing
    • SQL Syntax
    • Resolver
    • Security Mode
    • Optimizer
    • Step Generator
    • GNC Apply
    • Dispatcher
    • Primary Index
    • Hashing Algorithm
    • Row Hash
    • DSW
    • Hash Map
    • Hash Bucket
    • Reaching V disk
  • TERADATA SQL’s
    • SQL fundamentals
    • Data types and literals
    • DDL Statements
    • DML Statements
    • Teradata naming convesions
  • TERADATA SQL FUNCTIONS & OPERATIONS
    • String functions
    • Format functions
    • Cast functions
    • Group & Aggregation functions
    • Logical operations
    • Arithmetic operations
    • Set operations
    • Join operations
    • Conditional expressions
    • Teradata OLAP Functions
  • TERADATA JOIN STRATEGIES
    • Hash join
    • Merge join
    • Nested join
    • Product join
    • Exclusion Merge
    • Single window Merge Join
  • TERADATA JOINS and SET OPERATORS
    • Inner join
    • Left outer join
    • Right outer Join
    • Full outer join
    • Union
    • Union All
    • Intersect
    • Minus

  • TERADATA EXTENSIONS
    • Help
    • Show
    • Macros
    • Explain
    • Collect statistics
    • Teradata Performance Tuning
  • TERADATA MEMORY SPACES
    • Permanent spaces
    • Temporary spaces
    • Spool spaces
    • Users spaces & PWD
  • TERADATA TRANSACTION MODES
    • BTET mode
    • ANSI mode
    • How convert into other modes
    • Interactive and Batch mode
  • TERADATA PERFORMANCE TUNING ON SQL ASSISTANCE
    • Usage of PMON
    • Explain usage
    • Collecting statistics
    • SQL tuning
    • Various SQL statements
    • Real time Issues & resolving
  • TERADATA UTILITIES (IMPORT & EXPORT)
    • BTEQ
      • Teradata BTeq scripts
      • Overview of BTeq
      • Looping stages
      • Batches scripts
      • Import & export scripts with Examples
      • Error handling
      • Real time scripts
    • FastLoad
      • Teradata FastLoad
      • Overview FastLoad
      • Types of phases
      • Advantages of FastLoad
      • Limitations of fast load
      • Real time scripts
    • MultiLoad
      • Teradata MultiLoad
      • Overview of Multi load
      • Types of phases in MultiLoad
      • Advantages of MultiLoad
      • Limitations of MultiLoad
      • Uses various types of operations
      • Work on Multi tables
      • Real time scripts
      • Sample scripts
    • Tpump
      • Teradata Tpump
      • Overview of Tpump
      • Limitations of Tpump
      • Work on Multi tables
      • Real time scripts
      • Sample scripts
    • Fast Export
      • Teradata Fast Export
      • How to export the data
      • Passing parameters
      • IN/OUTModes
      • Work on Multi tables
      • Real time scripts
      • Sample scripts
    • Teradata TPT
    • Teradata performance tuning on scripts
    • Explanation of explain plan
    • Real Time Interview Questions
    • Teradata Advanced Concepts


For More details Visit us : http://www.onlineinformaticatraining.com/online-teradata-training/