Course overview
About the Teradata Dev Track program.
BISPtrainings provides online Teradata classes And training Course details Admin Track, Developer Track video tutorial and Job Support.
Why learn with BISP
Trusted by professionals across 30+ countries.
👨🏫
Industry trainers
Certified consultants with 12+ years of real project experience.
🧪
Hands-on practice
Real-time scenarios & live project modules, not just slides.
💼
Placement support
Resume building, mock interviews & job referrals.
📜
Certification
BISP certificate + full guidance for official exams.
Course curriculum
Designed by real-time industry professionals around current job roles.
⬇ Download curriculum (PDF)
Teradata Dev Track web based Online Training Curriculum
â–º History and Architecture
Introduction to TERADATA
- OLTP
- OLAP systems
- Data warehouse and Data Marts
- Dimension modeling
- Schemas
- What is Teradata?
- Role of Teradata in DW
- Evolution of Teradata DW
- Advantages of Teradata over other RDBMS
Teradata Architecture
- Understanding H/W and S/W components
- Architecture of Teradata
- V-disks
- AMP
- PE
- V-procs
- BYNET
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 tolerance of Teradata in that situations
- CLIQUE
- CLUSTER
- RAID
- LOCKS
- JORNALS
Spaces and types of tables
- Different levels of accessing the objects granting the Privileges and locking mechanism
SQL
- ASNI SQL
- Brief introduction of Relational concepts
- Understanding users
- Databases
- Tables
- Vies
- Index
- Macro
- Sub query
- Correlated query
- Data types
- Joins
- Arithmetic functions
Teradata SQL
- Explore Teradata specific SQL statements such as show, help, and explain
- SET operations
- Aggregate functions
- String functions
- Aliasing
- FORMAT
- Conversion of data types
Advanced Teradata SQL
- Define and execution of Macros
- Date calculations
- Case
- COALESCE
- Sample
- Ranking
- Qualify
- CSUM
- MSUM
- WITH
- WITH BY
â–º Client utilities
SQL Assistant
- Setup ODBC for connecting through SQL assistant
- Options menu and EXPORT/IMPORT
BTEQ
- Functionality
- Operations
- Execution
- Limitations
Fast Load
- Functionality
- Different phases
- Execution
- Restart ability
- Limitations
Fast Export
- Functionality
- Different phases
- Execution
- Restart ability
- Limitations
Multi Load
- Functionality
- Different phases
- Execution
- Restart ability
- Limitations
Performance tuning
- Explain plan & Statistics
- Understanding explain plan and recommendations
- 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)
UNIX
- 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
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
Course details
Who it is for, what you need, and how it is delivered.
Who should learn Teradata Dev Track? ▼
This tutorial is designed for software professionals who are willing to learn Teradata concepts and become a Teradata developer.
Prerequisites ▼
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
Frequently asked questions
Everything you need before you enroll.
Can I attend a demo session before enrollment? ▼
Yes. You may attend a demo class before enrollment for training quality evaluation, and interact one-to-one with the trainer for any specific requirement.
Can you schedule training as per my availability? ▼
Yes. We discuss it with the trainer and schedule the training at a convenient time for you.
What if I miss a class? ▼
You get the recorded session. You may also retake the whole training multiple times within a 6-month period with the same trainer.
Is there live project training? ▼
Yes. The curriculum includes real-time scenarios and live project modules, with the trainer explaining every topic end-to-end.
How can I pay for the course? ▼
Enroll securely via the payment gateway on this page using card, UPI or net-banking. EMI options are available.
More queries? ▼
Call us at +91 769-409-5404 & +1 678-701-4914, or write to support@bisptrainings.com.
Case studies & learning PDFs
Free DWH ETL resources to explore.
Relevant courses
Learners who took this also explored these.
Not sure if this course is right for you?
Book a free 1-on-1 counselling call and get a personalised learning roadmap.
BISP
