Teradata Tutorial

Teradata Basics –

Teradata Utilities–

Teradata Tips–

Teradata Certification–

72 comments

Skip to comment form

- Suprajhaa Mohan on April 23, 2019 at 10:51 am
- #
Hi Admin ,

Can u please share the study material to
Suprajasupri97@gmail.com
- shubhankit on March 17, 2019 at 1:16 pm
- #
Hello Admin

I am new to Teradata..

Can you please mail me the full tutorial to.. porwalshubhankit11@gmail.com
- astha agrawal on February 28, 2019 at 11:35 am
- #
Hello Admin

I am new to Teradata..

Can you please mail me the full tutorial to.. astha.agr21@gmail.com
- Ravindra Kumar on January 28, 2019 at 11:48 am
- #
I am new to teradata and want to learn basic as well as advanced

if u dnt mind plz send me the teradata materials

My Mail Id : ratha.ravindra@gmail.com
- Ravindra Kumar on January 28, 2019 at 11:48 am
- #
hii admin

am new to teradata

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

My Mail Id : ratha.ravindra@gmail.com
- Nirmal on December 7, 2018 at 9:11 am
- #
Hi,

Can you please post on rest of the utilities too as your explanations are so genuine and in detail.

Thanks & Regards,
Nithiya Nirmal
- Samart Jadhav on October 6, 2018 at 1:35 pm
- #
I am trying to create a table using a query,but that table is getting aborted due to spool space error.Then i created volatile table using the same query it worked.Please suggest as why there isnt spool issue with volatile tables and there is issue with actual table
1. - Rashmirekha Sutar on November 9, 2018 at 2:35 pm
  - #
  create table is the physical table remains in DB forever and takes space.
  
  Volatile table as its name indicates remains active only for that session and vanishes after you log out or disconnect. So it doesn’t take any space in Database.
- Radhika Trivedi on February 11, 2018 at 5:57 pm
- #
Hi admin,

I am a beginner in teradata.could you please send me beginner’s study material as well as material for TPT as well.

Thank you.
- Karan on February 8, 2018 at 8:57 am
- #
Hello Admin

I am new to Teradata..

Can you please mail me the full tutorial to..karan.arjun400@gmail.com
- Kartheek on October 10, 2017 at 8:39 pm
- #
Hello Admin,

Can you please send me the materials to below mail. Sivakartheek1993@gmail.com

Thanks,

Kartheek.
- Sudha on September 25, 2017 at 9:00 am
- #
Hi,
I’m sudha. I want to learn teradata. Can you please notify me when your course is started. And if you can could you please share your beginners materials which maybe very useful ofr me.
- Ankit on September 11, 2017 at 7:37 am
- #
Hello Admin,

I am new to teradata, Can you please send me the teradata materials for beginners

my mail id is ajankijain@gmail.com
- venkat on July 5, 2017 at 4:39 am
- #
Hi this venkat, I want to learn teradata. Could you please any one share teradata material to this email address .vyerramsetti123@gmail.com
- venkat on July 5, 2017 at 4:38 am
- #
Hi this venkat, I want to learn teradata. Could you please any one share teradata material .
- Ramya on May 6, 2017 at 10:32 am
- #
Hi admin,
I am learning Teradata. Could you please send me basic and advanced study material. My email ID is ramya.jank11@gmail.com. Please share some TPT material also. Thanks in Advance.
- prashant jha on February 22, 2017 at 3:42 pm
- #
Hi All,
I am new to teradata, and would like to learn it. can some one please send me the study material for basic and advance @ prashantjha434@gmail.com
- Gayatri Dhamal on December 22, 2016 at 6:33 am
- #
Hi admin,
I am learning teradata. Can U please send me basic and advanced material to Gayatri.dhamal@gmail.com. Please share some TPT material also. I have completed teradata basic level certification also. Please suggest me for advanced certification and material. Thank You in Advance.
- Gayatri Dhamal on December 22, 2016 at 6:28 am
- #
Hi,
I am new to teradata.Please send me teradata basic and advanced material and material of TPT also. I have done teradata basic level certification. Can U sugesset me material for next level please.
- Radhika on November 17, 2016 at 9:05 am
- #
Hi I have total 4 years of experience in teradata.I am planning to shift the company.But I am not able to find openings for it.Can you please help me on getting proper interview call if anyone knows.
- Nithin on November 7, 2016 at 6:22 am
- #
Hi,

I am new to Teradata, can someone please share me the Teradata Beginner’s guide to nithin.k302@gmail.com.

Thanks in Advance,
Nithin
- sivaprasad on October 15, 2016 at 10:21 am
- #
hi admin i am new to learn teradata. plz share the basic study material to my id-sivaprasad5811@gmail.com.

thanks
- venkata madan kumar s on October 4, 2016 at 5:52 am
- #
Hi All,
I am new to teradata, and would like to learn it. can some one please send me the study material for basic and advance at madans.494@gmail.com
- pranav on October 4, 2016 at 5:41 am
- #
hi,
I am new to teradata, and would like to learn it. can some one please send me the study material for basic and advance at spranav27@yahoo.com

Thank you
- samir on May 17, 2016 at 1:23 am
- #
please send me teradata material to samirpanigrahi57@gmail.com
both basics and advanced
- Prasad on May 10, 2016 at 9:17 am
- #
Please send the material to prasadreddy.09235@gmail.com
- venkata madan kumar s on April 29, 2016 at 12:43 pm
- #
Hi Admin,

please send me tera data material for beginner

Thanks
- Nandini on April 25, 2016 at 12:56 pm
- #
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.
- Nandini on April 25, 2016 at 12:52 pm
- #
Hi

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’.
- Gopal on November 27, 2015 at 6:34 am
- #
Please send basic study material to this ID : gopalonrace@gmail.com , if you have any. Thanks in advance.
1. - Ashish on December 22, 2015 at 8:46 am
  - #
  Please share the teradata study material on ap.ashishpandey16@gmail.com if you have any…
  
  Thanks
2. - sumeet awalwar on April 15, 2016 at 9:08 am
  - #
  hi please share the teradata study material on sumeet.awalwar@inteliment.com
  If you have any.
  
  Thanks
- jaychandra on November 9, 2015 at 9:36 am
- #
Hai I am new to teradata, can you send any material to know about teradata? to jayachandra1805@gmail.com
- Shubhadip Ray on September 19, 2015 at 2:54 pm
- #
why are you not answering?
- xian on August 4, 2015 at 7:40 pm
- #
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

xianmiao2009@gmail.com

Thanks
- Tanuj Shah on June 9, 2015 at 10:53 am
- #
Please send me teradata study material for beginner.

Thanks
- Vinny on March 13, 2015 at 10:21 am
- #
Hi,
Can we use VARCHAR2 data type in Teradata?
1. - admin on September 20, 2015 at 1:04 am
    Author
  - #
  Never heard of VARCHAR2 data type in Teradata, try creating a table with this data type to know the exact answer.
- Arun on February 27, 2015 at 2:36 pm
- #
I am planning for first certification (TEO-141)exam. Please give me related material on below id.
arunkhopade2010@gmail.com
- Abhishek on February 13, 2015 at 7:23 am
- #
please send me the teradata material for beginers.

Thank You
- deepak mishra on February 10, 2015 at 10:00 am
- #
hi admin i am new to learn teradata. plz share the basic study material to my id-deepak091056@gmail.com.

thanks
- admin on May 24, 2014 at 9:28 am
  Author
- #
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 –
http://www.onlineteradatatraining.com/?page_id=96

Limited Seats. So try to register ASAP.
1. - Nishant Srivastava on January 22, 2015 at 12:28 pm
  - #
  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.
  
  Cheers,
  Nishant
- Priya on April 28, 2014 at 1:14 pm
- #
Hello Admin
I am new to Teradata..
Can you please mail me the full tutorial…
- Gopala Vangari on April 26, 2014 at 6:46 pm
- #
Admin

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 on June 17, 2014 at 5:25 pm
  - #
  can u plz email me the explanations if u got it
- Tapas on April 15, 2014 at 7:36 am
- #
Hello admin!

Could you please send some materials for newbies in Teradata

My Mail id is tapas.mishra87@gmail.com

thanks in Advance!
- chandra on February 19, 2014 at 3:21 am
- #
Hi Admin,

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

Could you please provide the tutorial to me

chandrabond007@rediffmail.com
- nikil on January 9, 2014 at 6:05 am
- #
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
- divya on September 18, 2013 at 8:10 am
- #
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! 🙂
- Alex on August 26, 2013 at 3:06 pm
- #
HI Admin, I need a query for know all details tables, work with TD 14.02
- Naresh reddy on July 18, 2013 at 9:41 pm
- #
Hi Admin
If u don’t mind could u please explain about multiload utility that is very useful for me

regards
Naresh Reddy
mail id :naresh0483@gmail.com
- Kumar on June 20, 2013 at 6:12 pm
- #
Hi Admin,

Could you please let me know the differences/comparision between version 12, 13 & 14 of teradata?
- Sweety on February 24, 2013 at 2:15 am
- #
Very useful for beginners like me…
- Naveen on December 3, 2012 at 11:27 am
- #
Hi,

Please provide the Teradata 13 certification exam details…

Thanks in Advance,
Naveen.
- Varun on October 23, 2012 at 3:31 pm
- #
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 on May 12, 2013 at 3:47 am
  - #
  Hi Please,
  
  Please Provide me the same, if you get it. Thanks in advance.
  
  Regards,
  Dhana Ande
- praveen kumar reddy on October 2, 2012 at 9:02 am
- #
Hi All,

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

Admin,

Thanks for your posts which are helpfull for the beginners like me 🙂 🙂

Regards,
Praveen
- nishant bhardwaj on September 18, 2012 at 11:11 am
- #
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.?
1. - karthick on November 30, 2016 at 4:42 am
  - #
  Hi Nishant,
  
  Could you please forward the materials for 1st exam if you have to below mail ID.
  karthickbubendran@gmail.com
  
  Thanks
- jyo on September 18, 2012 at 5:55 am
- #
CREATE SET TABLE edwDB.abc ,FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT

Can someone explain what it means by NO BEFORE JOURNAL, NO AFTER JOURNAL and CHECKSUM = DEFAULT?
1. - admin on September 20, 2015 at 1:20 am
    Author
  - #
  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.
- Raja on September 9, 2012 at 4:38 pm
- #
When answering multiple answer questions, if the answer is partially correct, will there be any partial marks or 0 marks?
- JYOTI RANJAN JENA on August 20, 2012 at 5:10 am
- #
Awesome site for begineers.
But need others topics details like BTEQ,MLOAD,TPUMP etc.
Waiting for the tutorials of these consepts.
1. - admin on August 23, 2012 at 11:05 am
    Author
  - #
  just wait for some while … 🙂
- PRAVEEN KUMAR MYLAPILLI on May 24, 2012 at 5:25 am
- #
Hi

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) .

Thanks,
Praveen
- admin on May 22, 2012 at 11:33 am
  Author
- #
Please check this teradata tutorial for all articles which i posted on my blog.
- shukur on May 10, 2012 at 4:46 am
- #
Please provide the secondary index concepts.

Thanks
shukur
1. - admin on May 17, 2012 at 6:28 am
    Author
  - #
  http://www.teradatatech.com/?p=815
- Aarti on April 2, 2012 at 2:35 am
- #
Fantastic site for beginners.
1. - admin on April 21, 2012 at 4:44 pm
    Author
  - #
  Thanku 🙂
2. - Vasu on May 12, 2013 at 3:15 am
  - #
  HI Aarthi,
  
  I am working as a Teradata DBA…Can you please share your mail id…vvdrmca@gmail.com ..this is my id…