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