TeraData Training

(3) 3 Ratings

Course Schedule

30

JUL

Mon - Sat

07:30 PM - 10:00 PM ( IST )

06

AUG

Mon - Fri

11:00 AM - 02:00 PM ( IST )

11

AUG

Sat - Sun

05:30 AM - 06:30 AM ( IST )


Total Learners

975 Learners


LMS Access

365 days

Course duration

30days


Support

24/7 support

Can't find convenient schedule?

Our experts can help you find a batch that meets your needs

The Instructor for this course is from one of the Big5 Companies in the world.

Drop us a Query

I agree to the Training T&C

Modes of Training

Corporate Training

Live, Classroom Or Self Paced Training

Online Classroom

Attend our Instructor Led Online Virtual Classroom

Self Paced Training

Comprehensive Recorded Videos by Experts to learn at your own pace

Course Features

Live Instructor-led Classes

This isn't canned learning. Its dynamic, its interactive, its effective

Expert Educators

Only the best or they're out. We are constantly evaluating our trainers

24&7 Support

We never sleep. Need something answered at 3 am? No Problem

Flexible Schedule

You don't learn as per our calendar. We work according to yours

☰ Details

Course Curriculum

Introduction to TeraData

  • 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 and Components

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

Recovery &protection of Data

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

Teradata indexes

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

Teradata SQL Quarryman

  • SQL fundamentals
  • Data types and literals
  • DDL Statements.

System Access Control Levels

  • TD (TeraData) Password Encryption
  • Password Security Features
  • Host Logon Processing
  • GRANT/REVOKE LOGON
  • Session Related Views
  • DBC.sessionInfo Info View
  • Data Access Info Views
  • Access LogRules Views
  • Access Log Views 

Monitoring Tools In TeraData

  • Performance Monitor
  • PMON Main window
  • PMON sessions Screen
  • TD Administrator
  • TD manager Dynamic Utilization Charting
  • Alert Facility and Viewer
  • Locking Logger.

Teradata Utilities & Tools (Import & Export)

  • Teradata BTeq scripts
  • Overview of BTeq
  • Looping stages
  • Batches scripts
  • Import &export scripts with Examples
  • Error handling
  • Real time scripts.

Teradata FastLoad

  • Types of phages & how to find it
  • Advantages & its process
  • Limitations of fast load
  • Real time scripts.

Course Description

What are Objectives of Course Training?

  • Understand Teradata's competitive advantage over other RDBMSs.
  • Understand Teradata Architecture and Indexing mechanism.
  • Use SQL to process data stored in Teradata tables.
  • Use Teradata application utilities to import/export data.
  • Apply various performance turning techniques to optimize the queries.

Who should go for this course?

The course is designed for all those who want to learn Teradata.

1. Developers/Designers who want to gain acceleration in their careers as an Teradata Developer/Designer.

2. Analytics Managers who are subject matter experts, leading a team of analysts.

3. Individual Contributors in the field of Enterprise Business Intelligence.


What are Pre-requisites for this Training Course?

  • Pre-requisites for this course include Basic Knowledge in SQL & General relational database along with basic unix commands. 

FAQ

Do you have self paced training?

Yes, we offer self paced training

How do you provide training?

We offer three different modes of training. Instructor Led Live Training, Self Paced Training and Corporate Training

Do you offer any discounts?

Yes we offer discounts for group of 3 plus people.

Can I choose timings that suits my schedule?

Yes we are the only company where we work with students and offer flexible timings which fits your schedule

Who are the Instructors?

All our instructors are from MNC companies who have real time experience of more than 10 years.

Can I attend a demo session before joining?

Yes we offer a free demo session with the instructors. The trainer will answer all your queries and share the course agenda.

Course Reviews

Sneha

Well, I took TeraData online training course from Live Trainings Bangalore and now I am an expert in TeraData. Industry expert trainers, great format, clear explanations, extremely well presented and overall completely satisfactory. Trust me guys, you will love this training. Highly recommended!

Murali

The course itself is very useful because it can be seen that the instructor has practical knowledge.The lessons are interesting, useful, clear, and well organized. Thank you LTB.

Venkat

I came across Live Trainings Bangalore while I was searching for Fast Track courses in TeraData. Their coordinators and instructors responded positively and I was able to get a good conceptual overview. Thank you LTB.