Teradata Online Training

 30 Hours

 24/7 Digital Library Access
 2839 Total Learners
 30% Off

Instructor-led Online Training

Interactive Live training
Real Time, Certified, Expert Trainers
Job oriented & Industry ready curriculum
Free Course Access for 365 Days
Fast-track / Regular / Weekend

Recorded Video Training

Learn at your own convenience
Certified & Industry Experts Trainers
Email & Forum support for 365 days
Priority Certification support
Multi Instructor sessions

About Course

Learn Teradata

  • Training is provided in Teradata 15 versions
  • Training covers using Teradata within both Windows and Unix environment
  • In addition to live training, participants will get the recorded session
  • Participants will get Teradata installation document, SQL Assistant user guide, Teradata SQL document covering syntax and examples, Teradata utilities document covering Fastload, Multiload, FastExport, BTEQ and TPT with comprehensive examples.

Who can learn?

Whoever has the knowledge on SQL, can able to pick up Teradata easily. And also, anyone has background on database and data warehousing can able to learn it quickly.

Teradata Course Curriculum

Training Plan:

Duration: 30 Hours

  • Teradata Introduction
  • Teradata Advantages
  • Teradata Tools & Utilities
  • Teradata Installation
  • Teradata Tools & Utilities Installation
  • RDBMS Basic Concepts (Tables/Rows/Columns/Primary Key/Foreign Key)
  • What is data warehouse
  • OLTP Vs Data warehouse
  • Data warehouse Architecture
  • Teradata Components (Parsing Engine, BYNET, Access Module Processor)
  • How Teradata components interact with each other
  • Storage & Retrieval architecture
  • System architecture
  • What is a Node
  • Data types
  • DDL statements(CREATE,DROP,ALTER)
  • DML statements (SELECT, INSERT,UPDATE,DELETE)
  • SET Operators(UNION , UNION ALL, INTERSECT, MINUS)
  • Logical & Conditional Operators
  • String Manipulation
  • Date & Time Manipulation
  • Joins
  • Built-in functions
  • Aggregates
  • Explain plan
  • Primary Index (UPI, NUPI)
  • Secondary Index (USI, NUSI)
  • Partition Primary Index
  • SET vs MULTISET tables
  • Derived Tables
  • Volatile Tables
  • Global Temporary Tables
  • Views
  • Macros
  • Stored Procedures
  • Single Table Join Index
  • Multi Table Join Index
  • Aggregate Join Index
  • Space concepts (Perm, Spool, Temp)
  • Triggers
  • Subqueries
  • Coalesce
  • OLAP Functions (Rank, Row_Number, Qualify, Partition by, Rows Unbounded preceding/following)
  • Compression
  • Collect Statistics
  • DBC tables
  • Teradata Transaction Modes
  • FastLoad
  • MultiLoad
  • BTEQ
  • FastExport
  • TPT
  • Fallback
  • Clusters
  • Clique
  • Permanent Journals
  • Hot Standby Nodes
  • RAID
  • Join Strategies
  • Confidence levels
  • Statistics collection process
  • Performance tuning techniques

Trainer Information

  • Teradata Architect with 13+ Years of experience in information technology with exposure to Data warehousing, Mainframes, Unix and Big Data
  • 9 years of extensive experience in data warehousing with primary focus on Teradata
  • Have worked with Accenture and Wipro for clients from USA, Singapore, UK and Australia
  • Have worked in USA for 6 years and currently working for a major bank in Sydney, Australia

Job Trends

Request a Demo


Related Courses


Let us know your convenient schedule
Attend Live Demo
Suggest me a course for a better career
Donor Details
Donee Details
(Your Details)
(To whom you want to gift a course)
Request for sample video
Register For Free Digital Library
Quick Enquiry
We respond as soon as possible.
Register For Course Demo
Course Highlights:
Free Course Access for 365 Days.
Real Time, Certified, Expert Trainers.
Email & Forum support for 365 days.
Fast-track / Regular / Weekend.
Job oriented & Industry ready curriculum.
Thanks for your interest.
Our Senior Course Adviser will get back to you soon.
Follow us
Submit your details
PGlmcmFtZSB3aWR0aD0iMTAwJSIgaGVpZ2h0PSIxMDAlIiBzcmM9Imh0dHBzOi8vd3d3LnlvdXR1YmUuY29tL2VtYmVkL0Qyc2h6dFc4WWhFIiBmcmFtZWJvcmRlcj0iMCIgYWxsb3dmdWxsc2NyZWVuPjwvaWZyYW1lPg==
Attend Live Demo