Teradata Online Training

Course Duration : 20Hrs
Learners : 1250
Reviews : 4.6

Become a master in developing data warehousing applications taught by real-time industry experts through hands-on exercises and use-cases and become a king of Data warehouse at Teradata Online Training Course.  

KITS Online Training Institute provides best teradata online training by well trained and certified trainers. Teradata is a leading provider of powerful, enterprise big data analytics and services that include Data warehousing, Data Driven Marketing, BI and CRM. Teradata is an open system, running on a UNIX MP-RAS or Windows server platform. Teradata is capable of supporting many concurrent users from various client platforms. We are delighted to be one of the best leading IT online training with best experienced IT professionals and skilled resources. We have been offering courses to consultants, companies so that they can meet all the challenges in their respective technologies. We also provide other technologies like Data Stage.

Sorting & Grouping
Aliases
Filtering and Quick Filters
Cross-Tabs (Pivot Tables)
Totals and Subtotals
Drilling and Drill Through
Aggregation and Disaggregation
Percent of Total
Working with Statistics and Trend lines
Ø What is Teradata?

Ø Teradatav12 &versions

Ø Teradata History

Ø Teradata users scalability

Ø Teradata &other RDBMS

Ø Teradata warehouse

Ø Teradata in the Enterprise

Ø Interview Q&A and Certification queries

Ø Real time Issues & resolving
Ø Node Architecture(Shared Architecture)

Ø SMP Architecture

Ø MPP Architecture

Ø Parsing engine(PE) Architecture

Ø AMP Architecture &uses

Ø Bynet Benefits &types

Ø Parallel data extension(PDE)

Ø Teradata directory program(TDP)

Ø Call level interface(CLI)

Ø Trusted parallel application(TPA)

Ø Virtual processors

Ø Bynet 0 &Bynet 1

Ø Parallism Architecture
Ø What is fall back &where it used

Ø Why for fall back

Ø What is Clique

Ø AMP Clustering

Ø Locks & types for simultaneous Access

Ø Why for locks &how to release

Ø RAID 1 &RAID 5

Ø Journals &types

Ø Virtual Disk Array

Ø How & where is used journals

Ø Q & A about data recovery
Ø Types of indexes in Teradata

Ø Hash index

Ø Join index

Ø Primary index(unique, non- unique)

Ø Secondary index(unique, non- unique)

Ø Skewness

Ø Keys & indexes (How & why these used)
Ø Hash algorithm

Ø Row hash

Ø Hash map

Ø Hash bucket

Ø Receiving VDisc
Ø SQL fundamentals

Ø Data types and literals

Ø DDL Statements

Ø DML Statements

Ø Teradata naming conversing
Ø String functions

Ø Format functions

Ø Cast functions

Ø Cast functions

Ø Group & Aggregation functions

Ø Logical operations

Ø Arithmetic operations

Ø set operations

Ø join operations

Ø conditional expressions
hash join

Ø merge join

Ø nested join

Ø product join

Ø inner join

Ø left & right outer join

Ø full outer join
Ø Help

Ø Show

Ø Explain

Ø Collect statistics
Ø Types of tables

Set tables
Multi tables
Volatile tables
o Global temporary tables

o Derived tables

Ø Views

Ø Macros

Ø Stored procedures

Ø Triggers
Ø Permanent spaces

Ø Temporary spaces

Ø Spool spaces

Ø Users spaces & PWD
Ø Batch mode

Ø BTET mode

Ø ANSI mode

Ø How Converted into others
Ø Usage of PMON

Ø Explain usage

Ø Collecting statistics

Ø SQL tuning

Ø Various SQL statements

Ø Real time Issues & resolving
Overview of BTeq
Looping stages
Batches scripts
Import &export scripts with Examples
Error handling
Real time scripts
Types of phages & how to find it
Advantages & its process
Limitations of fast load
Real time scripts
Types of phages in MultiLoad
Advantages & its process
Limitations of MultiLoad
Uses various types of operations
Overview of Tpump
Limitations of Tpump
Work on Multi tables
Real time scripts
Passing parameters

o IN/OUT Modes

o Work on Multi tables

Real time scripts
o Sample scripts
What is Teradata?

Ø Teradatav12 &versions

Ø Teradata History

Ø Teradata users scalability

Ø Teradata &other RDBMS

Ø Teradata warehouse

Ø Teradata in the Enterprise

Ø Interview Q&A and Certification queries

Ø Real time Issues & resolving
Node Architecture(Shared Architecture)

Ø SMP Architecture

Ø MPP Architecture

Ø Parsing engine(PE) Architecture

Ø AMP Architecture &uses

Ø Bynet Benefits &types

Ø Parallel data extension(PDE)

Ø Teradata directory program(TDP)

Ø Call level interface(CLI)

Ø Trusted parallel application(TPA)

Ø Virtual processors

Ø Bynet 0 &Bynet 1

Ø Parallism Architecture
What is fall back &where it used

Ø Why for fall back

Ø What is Clique

Ø AMP Clustering

Ø Locks & types for simultaneous Access

Ø Why for locks &how to release

Ø RAID 1 &RAID 5

Ø Journals &types

Ø Virtual Disk Array

Ø How & where is used journals

Ø Q & A about data recovery
Types of indexes in Teradata

Ø Hash index

Ø Join index

Ø Primary index(unique, non- unique)

Ø Secondary index(unique, non- unique)

Ø Skewness

Ø Keys & indexes (How & why these used)
Hash algorithm

Ø Row hash

Ø Hash map

Ø Hash bucket

Ø Receiving VDisc
SQL fundamentals

Ø Data types and literals

Ø DDL Statements

Ø DML Statements

Ø Teradata naming conversing
String functions

Ø Format functions

Ø Cast functions

Ø Cast functions

Ø Group & Aggregation functions

Ø Logical operations

Ø Arithmetic operations

Ø set operations

Ø join operations

Ø conditional expressions
hash join

Ø merge join

Ø nested join

Ø product join

Ø inner join

Ø left & right outer join

Ø full outer join
Ø Help

Ø Show

Ø Explain

Ø Collect statistics
Types of tables

Set tables
Multi tables
Volatile tables
o Global temporary tables

o Derived tables

Ø Views

Ø Macros

Ø Stored procedures

Ø Triggers
Permanent spaces

Ø Temporary spaces

Ø Spool spaces

Ø Users spaces & PWD
Ø Batch mode

Ø BTET mode

Ø ANSI mode

Ø How Converted into others
Usage of PMON

Ø Explain usage

Ø Collecting statistics

Ø SQL tuning

Ø Various SQL statements

Ø Real time Issues & resolving
Overview of BTeq
Looping stages
Batches scripts
Import &export scripts with Examples
Error handling
Real time scripts
Types of phages & how to find it
Advantages & its process
Limitations of fast load
Real time scripts
What is Teradata?
Teradatav12 &versions
Teradata History
Teradata users scalability
Teradata &other RDBMS
Teradata warehouse
Teradata in the Enterprise
Interview Q&A and Certification queries
Real time Issues & resolving
Teradata architecture & it’s
Node Architecture(Shared Architecture)
SMP Architecture
MPP Architecture
Parsing engine(PE) Architecture
AMP Architecture &uses
Bynet Benefits &types
Parallel data extension(PDE)
Teradata directory program(TDP)
Call level interface(CLI)
Trusted parallel application(TPA)
Virtual processors
Bynet 0 &Bynet 1
Parallism Architecture
What is fall back &where it used
Why for fall back
What is Clique
AMP Clustering
Locks & types for simultaneous Access
Why for locks &how to release
Types of indexes in Teradata
Hash index
Join index
Primary index(unique, non- unique)
Secondary index(unique, non- unique)
Skewness
Keys & indexes (How & why these used)
Hash algorithm
Row hash
Hash map
Hash bucket
Receiving VDisc
SQL fundamentals
Data types and literals
DDL Statements
DML Statements
Teradata naming conversing
String functions
Format functions
Cast functions
Cast functions
Group & Aggregation functions
Logical operations
Arithmetic operations
set operations
join operations
conditional expressions
hash join
merge join
nested join
product join
inner join
left & right outer join
full outer join
Help
Show
Explain
Collect statistics
Types of tables
Set tables
Multi tables
Volatile tables
o Global temporary tables
o Derived tables
Views
Macros
Stored procedures
Triggers
Permanent spaces
Temporary spaces
Spool spaces
Users spaces & PWD
Batch mode
BTET mode
ANSI mode
How Converted into others
Usage of PMON
Explain usage
Collecting statistics
SQL tuning
Various SQL statements
Real time Issues & resolving
Teradata BTeq scripts
Overview of BTeq
Looping stages
Batches scripts
Import &export scripts with Examples
Error handling
Real time scripts
Types of phages & how to find it
Advantages & its process
Limitations of fast load
Real time scripts
Overview of Multi load
Types of phages in MultiLoad
Advantages & its process
Limitations of MultiLoad
Uses various types of operations
o Work on Multi tables
Real time scripts
o Sample scripts
Overview of Tpump
Limitations of Tpump
Work on Multi tables
Real time scripts
o Sample scripts

Self-Paced

  • Learn at your convenient time and place
  • Grab the practical exposure of the course through high-quality videos
  • Learn from basic to advanced level of the course led by real-time instructors

Online

  • Get a live demonstration of every topic by our experienced faculty
  • Get LMS Access of every session after the completion of the course
  • Gain the stuff to get certified

Corporate

  • Can enroll for Self paced, Live (or) the class mode of training
  • Engage in online training lecture by an industry expert at your facility
  • Learn as a full day schedule with discussions, exercises, and practical use cases
  • Design your own syllabus based on the project requirements
The trainer is a real-time expert and has a significant amount of technology
Irrespective of your class attendance, every session will be recorded. Soon after the completion of the class, you can able to access the videos
During the course, the trainer will provide the environment to execute the practical's.
Once you contact us, our support team will offer you great discounts.
Yes! we do accept the fee in installments, depending on the mode of training you take.
We offer the best training on different modes like self-paced, one-one, batch as well as corporate training.
Yes! Our support team will take your resumes and forward to the firms for placement assistance
During the course, the trainer will provide the probable certification question to make you certified.

Click here to Login to add a review.

It is a recommended place to become a master in tera data from the ground. The docs delivered during the course, helped me a lot to clear the certification. Thank you KITS.
- David
I'm very happy to take the data analysis through KITS. All the sessions were completed on time with real-world examples. Thanks to the team
- Neha
Get hands-on experience in data analysis using Teradata and become a master in analyzing the data through Teradata Online Training offered by KITS
- Lavanya
I recommend it is the best place to acquire hands-on experience in Tera data from beginner to the advanced level and become a master in data analysis. Thanks to the team.
- Amar Kambam
I have recently taken the Tera data training through KITS. The trainer has good knowledge of Tera data and delivers the best content with real-world use-cases.
- Kiran Jami

100% Online Course

Flexible Schedule

Beginner Level To Advance Level

Real-Time Scenarios With Projects

LMS Access

Interview Questions & Resume Guidelines Access