Teradata online training

Teradata V13 course content

  • What is Teradata why for it is what for it is

  • What is Teradata?
  • Teradatav12 &versions
  • Teradata History
  • Teradata users scalability
  • Teradata &other RDBMS
  • Teradata warehouse
  • Teradata in the Enterprise
  • Interview Q&A and Certification queries
  • Real time Issues & resolving
  • Teradata architecture & it's components

  • 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
  • Recovery &protection of Data

  • What is fall back &where it used
  • Why for fall back
  • What is Clique
  • AMP Clustering
  • Locks & types for simultaneous Access
  • Why for locks &how to release
  • RAID 1 &RAID 5
  • Journals &types
  • Virtual Disk Array
  • How & where is used journals
  • Q & A about data recovery
  • Teradata indexes

  • Types of indexes in Teradata
  • Hash index
  • Join index
  • Primary index
  • Secondary index
  • Skewness
  • Keys & indexes
  • How to storage & retrieval of data

  • Hash algorithm
  • Row hash
  • Hash map
  • Hash bucket
  • Receiving VDisc
  • Teradata SQL Quarryman

  • SQL fundamentals
  • Data types and literals
  • DDL Statements
  • DML Statements
  • Teradata naming conversing
  • Teradata SQL Functions & operations

  • String functions
  • Format functions
  • Cast functions
  • Cast functions
  • Group & Aggregation functions
  • Logical operations
  • Arithmetic operations
  • set operations
  • join operations
  • conditional expressions
  • Teradata join strategies & unions

  • hash join
  • merge join
  • nested join
  • product join
  • inner join
  • left & right outer join
  • full outer join
  • Teradata basic commands

  • Help
  • Show
  • Explain
  • Collect statistics
  • Teradata objects

  • Types of tables
    • Set tables
    • Multi tables
    • Volatile tables
      • Global temporary tables
      • Derived tables
    >
  • Views
  • Macros
  • Stored procedures
  • Triggers
  • Teradata memory spaces

  • Permanent spaces
  • Temporary spaces
  • Spool spaces
  • Users spaces & PWD
  • Teradata transaction modes

  • Batch mode
  • BTET mode
  • ANSI mode
  • How Converted into others
  • Teradata performance tuning on SQL Assistance

  • Usage of PMON
  • Explain usage
  • Collecting statistics
  • SQL tuning
  • Various SQL statements
  • Real time Issues & resolving
  • Teradata Utilities & Tools (Import & Export)

    • Teradata BTeq scripts

    • Overview of BTeq
    • Looping stages
    • Batches scripts
    • Import &export scripts with Examples
    • Error handling
    • Real time scripts
    • Teradata FastLoad

    • Types of phages & how to find it
    • Advantages & its process
    • Limitations of fast load
    • Real time scripts
    • Teradata MultiLoad

    • Overview of Multi load
    • Types of phages in MultiLoad
    • Advantages & its process
    • Limitations of MultiLoad
    • Uses various types of operations
      • Work on Multi tables
      • Real time scripts
        • Sample scripts

      Teradata Tpump

    • Overview of Tpump
    • Limitations of Tpump
    • Work on Multi tables
    • Real time scripts
      • Sample scripts

      Teradata Fast Export

      • How to export the data
      • Passing parameters
      • IN/OUT Modes
      • Work on Multi tables
      • Real time scripts
        • Sample scripts
    • Teradata SQL Assistant
    • Teradata performance monitor
    • Teradata Administrator usage
    • Teradata performance tuning on scripts
    • Other Features:

    • FAQS
    • Covering DBA concepts
    • Concentration on performance tuning
    • Real time scenarios
    • Certification guidance
    • Resume preparation
    • Sample resumes
    • Interview & certification FAQS
    • How to face the interview
    • Class notes which is useful for who is trying for job
    • Project preparation

Contact Us

Tel: +91-8897400222
USA: +1-512-800-7568
EMAIL: info@mentorsinn.com

Testimonials

"The Teradata training was nice, and though I was the only one in the online session the class was very much interactive, it was a very good experience." - Kranthi (Teradata)