Teradata Tutorial

Teradata Basics

Teradata Utilities

Teradata Tips

Teradata Certification


No ping yet

  1. samir says:

    please send me teradata material to samirpanigrahi57@gmail.com
    both basics and advanced

  2. Prasad says:

    Please send the material to prasadreddy.09235@gmail.com

  3. venkata madan kumar s says:

    Hi Admin,

    please send me tera data material for beginner


  4. Nandini says:

    In the above query which I had sent originaldata is not equal to 0 and sampledata is not equal to 0, but it printed as originaldata0 and sampledata0, please consider this correction.

  5. Nandini says:


    select count(*) from sampletable where originaldata0 and originaldata is not null and sampledata0 and sampledata is not null and (originaldata/sampledata)>=1.

    In ‘sampletable’ I have these 2 columns where those column contains ‘Negative value,’ Null values’ and 0. I am getting divide by zero error.
    could you please help me out with this, how to replace or avoid this error so that I will get expected results and the datatype of those columns are ‘decimal’.

  6. Gopal says:

    Please send basic study material to this ID : gopalonrace@gmail.com , if you have any. Thanks in advance.

    1. Ashish says:

      Please share the teradata study material on ap.ashishpandey16@gmail.com if you have any…


    2. sumeet awalwar says:

      hi please share the teradata study material on sumeet.awalwar@inteliment.com
      If you have any.


  7. jaychandra says:

    Hai I am new to teradata, can you send any material to know about teradata? to jayachandra1805@gmail.com

  8. Shubhadip Ray says:

    why are you not answering?

  9. xian says:

    Hi, Admin,

    I am a new one in Teradata. I like it and I want to learn more.
    can you send the studying materials for beginners to



  10. Tanuj Shah says:

    Please send me teradata study material for beginner.


  11. Vinny says:

    Can we use VARCHAR2 data type in Teradata?

    1. admin says:

      Never heard of VARCHAR2 data type in Teradata, try creating a table with this data type to know the exact answer.

  12. Arun says:

    I am planning for first certification (TEO-141)exam. Please give me related material on below id.

  13. Abhishek says:

    please send me the teradata material for beginers.

    Thank You

  14. deepak mishra says:

    hi admin i am new to learn teradata. plz share the basic study material to my id-deepak091056@gmail.com.


  15. admin says:

    Hi All,

    We have started a new special online teradata training batch for developers and DBA profile. For those who are interested to learn teradata can register in this batch. Fees is quite less when you compare it with other batches and biggest advantage is that its a instructor led training batch so you can ask any doubt in the training itself. Also we’ll be covering latest version of Teradata i.e. Teradata 14.10

    Please check following link for more details about this batch –

    Limited Seats. So try to register ASAP.

    1. Nishant Srivastava says:

      Hello Admin,

      I am very new to Teradata world, would you be able to help me to get the basic study material.

      My email Id : kumarnishant1982@yahoo.co.in

      Truely appreciate all your contribution here.


  16. Priya says:

    Hello Admin
    I am new to Teradata..
    Can you please mail me the full tutorial…

  17. Gopala Vangari says:


    Can you give explanation on below items which will be very help full with such a spoon feeding explanation

    1. BTEQ – what ? why? how to create? execution? – show simple example

    2. Like Fast Load can you Explain MLOAD. also please tell HoW TPT works?

    3. Comparision of Different External Loaders in teradata?

    Thanks In Advance

    1. sai says:

      can u plz email me the explanations if u got it

  18. Tapas says:

    Hello admin!

    Could you please send some materials for newbies in Teradata

    My Mail id is tapas.mishra87@gmail.com

    thanks in Advance!

  19. chandra says:

    Hi Admin,

    I am new to tera data. I have interest to learn Teradata.

    Could you please provide the tutorial to me


  20. nikil says:

    hii admin

    am new to teradata

    if u dnt mind plz send me the teradata materials for beginners

    my mail id is nikil.indianrocks@gmail.com

  21. divya says:

    hi i am a beginner…just started learning TD…this site is super cool…finding it very easy to learn…can u pls put up article on how to install teradata in pc…i wanna try hands on as i keep learning…thanks in advance! πŸ™‚

  22. Alex says:

    HI Admin, I need a query for know all details tables, work with TD 14.02

  23. Naresh reddy says:

    Hi Admin
    If u don’t mind could u please explain about multiload utility that is very useful for me

    Naresh Reddy
    mail id :naresh0483@gmail.com

  24. Kumar says:

    Hi Admin,

    Could you please let me know the differences/comparision between version 12, 13 & 14 of teradata?

  25. Sweety says:

    Very useful for beginners like me…

  26. Naveen says:


    Please provide the Teradata 13 certification exam details…

    Thanks in Advance,

  27. Varun says:

    Hi can any one help to get the dumps for the TE0-127 EXAM. I’m planning to give this exam. Please help me, thanks in advance

    1. Dhana Ande says:

      Hi Please,

      Please Provide me the same, if you get it. Thanks in advance.

      Dhana Ande

  28. praveen kumar reddy says:

    Hi All,

    I am planning to write the teradata basics exam. Please send me materials and dumps to praveenkumarreddy.yanamala@gmail.com.


    Thanks for your posts which are helpfull for the beginners like me πŸ™‚ πŸ™‚


  29. nishant bhardwaj says:

    hi ,

    I have completed the Teradata 12 first exam and intrested in taking the second one. can you please send some good tutorials/material for this.?

  30. jyo says:


    Can someone explain what it means by NO BEFORE JOURNAL, NO AFTER JOURNAL and CHECKSUM = DEFAULT?

    1. admin says:

      NO BEFORE JOURNAL stands for – we are not defining any permanent journal( which is a data protection feature) for before images of data.
      NO AFTER JOURNAL stands for – we are not defining any permanent journal for after images of data.
      CHECKSUM = DEFAULT – it is a way of checking data integrity between DISK input and output, that whatever data was written in DISK drive, same data we are retrieving back. DEFAULT in CHECKSUM stands for default setting whatever is defined in DBCS control utility.

  31. Raja says:

    When answering multiple answer questions, if the answer is partially correct, will there be any partial marks or 0 marks?


    Awesome site for begineers.
    But need others topics details like BTEQ,MLOAD,TPUMP etc.
    Waiting for the tutorials of these consepts.

    1. admin says:

      just wait for some while … πŸ™‚



    I have completed Teradata V2R5 masters and i’m interested to write TD12 masters.
    where can i get that materials, please help.

    I know that i need to write below two exams….

    Teradata 12 Qualifying Exam for V2R5 Masters (TE0-12Q) and
    Teradata 12 Comprehensive Mastery Exam (TE0-127) .


  34. admin says:

    Please check this teradata tutorial for all articles which i posted on my blog.

  35. shukur says:

    Please provide the secondary index concepts.


    1. admin says:


  36. Aarti says:

    Fantastic site for beginners.

    1. admin says:

      Thanku πŸ™‚

    2. Vasu says:

      HI Aarthi,

      I am working as a Teradata DBA…Can you please share your mail id…vvdrmca@gmail.com ..this is my id…

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>