• India Flag
    Call Us:

    +91 769-409-5404

  • USA Flag
    Call Us:

    +1 786-629-6893

About Course:

BISPtrainings provides online Teradata classes And training Course details Admin Track, Developer Track video tutorial and Job Support.

Duration : 30 hours

Fee: 319

Job Trends

Who Should Learn?

This tutorial is designed for software professionals who are willing to learn Teradata concepts and become a Teradata developer.


You should have a basic understanding of Relational concepts and basic SQL. It will be good if you have worked with any other RDBMS product.

Delivery Methodology

We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course.

Class Delivery

Live Interactive classes with expert

Training Calender

Date Time Type Attend
19th October 2019 8:00 AM   IST Demo
22nd October 2019 8:00 AM   IST Regular
Contact Us

+91 769-409-5404

  • 24 hours on-demand video
  • Articles
  • Coding Exercises
  • Full lifetime access
  • Certificate of Completion


Teradata Dev Track

History and Architecture


Introduction to TERADATA - Watch Preview
OLTP, OLAP systems, Dataware house and Data Marts, Dimenssion modeling, Schemas, What is Teradata and role of Teradata in DW, Evolution of Teradata DW, Advantages of Teradata over other RDBMS
Teradata Architecture
Understanding H/W and S/W components, involved in Architecture of Terdata(vdisks, AMP, PE Vprocs, BYNET etc.

Database structure

Data distribution
Understanding significance of Index in teradata(UPI, NUPI, SI, NUSI, Partitioned index )
Data Protection
Different levels of failures that could happen and fault tolarance of Teradata in that situations.(CLIQUE, CLUSTER, RAID, LOCKS and JORNALS)
Spaces and types of tables
Different levels of accessing the objects granting the Privileges and locking mechanism


Brief introduction of Relational concepts, understanding users, databases, tables, vies, index, macro etc. Sub query, corelated query, Data types, Joins, Arthimatic functions
Teradata SQL
Explore teradata specifc SQL statements such as show, help,explain.
.SET operations, Aggregate functions, Sring functions, Aliasing,FORMAT, conversion of the
Advanced Teradata SQL
Define and execution of Macros, Date calculations, Case, COALESCE, sample, Ranking,

Client utilities

SQL Assistant
Settup ODBC for connecting through SQL assistant, options menu and EXPORT/IMPORT
Functinality,operations, exectuion and limitations
Functinality, Different phases, exectuion, restartability and limitations
Functinality, Different phases, exectuion, restartability and limitations
Functinality, Different phases, exectuion, restartability and limitations

Performance tuning

Explain plan & Statistics & Understanding Explain plan and recommandations. Significance of collecting statistics
Other techniques
Determine the proper join columns, Join index, Spars index, Aggregate index, SET / MULTSET with UPI and NUPI combinations, compress

Others (Optional)

Role of Unix in executing Teradata utility scripts and Basic commands used General Lifecycle of the projects
General phases of a Development project. Documents required in each phase

Use Case


Benefits of Certificate

Certification demonstrates your dedication, motivation and technical knowledge on a specific platform. Having a certification shows that you not only possess comprehensive knowledge of that technology but you also care enough about your own career to spend the time and money to get the certification.

We are welcoming our Students or professionals to participate in our professional online courses. We are offering great variety of online training programs and professional courses that you can always find as desired. After the completion of training program they will receive a certificate from BISP. As a Certified professional you can apply that knowledge in your future profession and enjoy with better salaries & career prospects.


Signup for free newsletter and
business tips

Any Questions?
Talk to our Course Co-ordinator

+91 769-409-5404
Want to see a live demo? We'll be in touch within 24 hours?