Best Online Training

Teradata V14 training course

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(unique, non- unique) Secondary index(unique, non- unique) Skewness
  • Keys & indexes (How & why these used)

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

  • Overvie 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 Advance Topics

  • Teradata SQL Assistant(Quarryman) Teradata performance monitor
  • Database Move space
  • Teradata Administrator usage
  • Teradata performance tuning on scripts

Testimonials

Very well organized and conceived. By following the course, I was able to learn and build on the concepts with minimal questions or frustration. It taught me what I was looking to learn, was well organized, and well-paced. I’m already applying what I learned at work.

Priyanka

The practical exercises were useful in offering ‘hands on’ experience. The interactive atmosphere and live examples used for illustration were refreshing.

VENKATESH

Course Reviews

4

40 ratings
  • 1 stars0
  • 2 stars0
  • 3 stars0
  • 4 stars0
  • 5 stars0

No Reviews found for this course.

PRIVATE COURSE
  • PRIVATE
  • 40 Days

Instructors

92 STUDENTS ENROLLED
    •   Live Instructor Led Course
    •   Batch Flexibility
    •   Customized Course
    •   Live Projects
    •   Resume Preparation

      Drop Us A Query

    Contact Training Adviser?



    Register

    Free Demo

    Or
    Call Us @

    9502434001

    ©2016 4bssolutions. All rights Reserved.DISCLAIMER.

    Show Buttons
    Share On Facebook
    Share On Twitter
    Share On Google Plus
    Share On Linkdin
    Share On Youtube
    Hide Buttons