Teradata Administration Online Training

Introduction

Teradata Administration Training

Teradata is a database, which is planned to manage logical queries. Teradata is basically a relational database management system that is Teradata is an open-system, operating on the UNIX MP-RAS or Windows machine platform. Teradata is of assisting several concurrent users from various customer systems capable. Teradata is suitable for market specifications. Teradata is totally developed over a parallel architecture.

Instructor – Led Live Online TrainingConnect Live
Corporate TrainingContact Us
One to One Online TrainingJoin Demo

COURSE SUMMARY

Course NameTeradata Development Online Training
ContentsFundamentals, Architecture, and Components of Teradata etc.
Duration30 Hours with Flexible timings
DeliveryInstructor Led-Live Online Training
EligibilityAny Graduate
Ideal ForFreshers, aspirants seeking to learn the Teradata Development
AvailabilityRegular/Weekend Batches. 24×7 teaching assistance and support.

Course Objectives

What you’ll learn in Teradata Administration Training Course?

  • Learn the basic concepts of Teradata.
  • Know the Architecture and Indexing mechanism of Teradata.
  • How to process the data using SQL in Teradata tables.
  • How to import or export data using Teradata application utilities.
  • How to implement different performance turning methods.

What are the pre-requisites to learn Teradata Admintration Course?

  • Basic Knowledge of SQL is mandatory.

Course Curriculum

Download Course Content

MODULE 1: INTRODUCTION

  • Overview of Teradata
  • Teradata versions
  • Teradata warehouse
  • Teradata Users and Scalability
  • Teradata in the Enterprise

MODULE 2: ARCHITECTURE AND COMPONENTS OF TERADATA

  • Teradata Architecture
  • MPP Architecture
  • SMP Architecture
  • AMP, TDP, CLI, TPA
  • Parallelism Architecture

MODULE 3: DATA RECOVERY AND SECURITY

  • locks
  • Different locks
  • RAID 1 and RAID 5
  • Fall Back
  • Disk Arrays
  • Clique
  • Types of Journals
  • AMP Clustering

MODULE 4: TERADATA INDEXES

  • Unique
  • Primary Index
  • Non-unique
  • Secondary Index
  • Partitioned
  • Hash, Join, Value Ordered
  • Secondary Index Subtable
  • Skewness
  • Keys Vs Indexes

MODULE 5: TERADATA SQL REFERENCE

  • SQL Fundamentals
  • Data Definition Statements(DDL)
  • Data Types and Literals
  • Data Manipulation Statements(DML)

MODULE 6: TERADATA FUNCTIONS AND OPERATORS

  • Format Function
  • String Functions
  • Cast Functions
  • With & with by clauses
  • Group & Aggregate Functions

MODULE 7: TERADATA TRANSACTIONS

  • Explicit Transaction
  • Implicit Transaction
  • Collecting Statistics
  • Performance Tuning and Explain Utility
  • Tuning SQL Performance
  • Usage of PMON
  • Joins and Unions
  • Inner Join
  • Right Outer Join
  • Left Outer Join
  • Full Outer Join
  • Product Join
  • Join Strategies
  • Merge Join
  • Nested Join
  • Hash Join

MODULE 8: TERADATA BASIC COMMANDS

  • Show
  • Help
  • Collect Statistics
  • Explain

MODULE 9: TERADATA OBJECTS

  • Tables
  • Multi Settable
  • SET table
  • Global Temporary tables
  • Volatile tables
  • Views
  • Derived tables
  • Macros
  • Triggers
  • Stored Procedures

MODULE 10: TERADATA SQL ASSISTANT (QUERYMAN)

  • Teradata BTEQ
  • Teradata Performance Monitor
  • Branching and Looping
  • Batch Scripts with samples
  • Importing and Exporting data through scripts
  • Error handling
  • Teradata Fast Load
  • Advantages and Process
  • Sample Scripts
  • Limitations of Fast Load

MODULE 11: REAL TIME ISSUES

  • Teradata Multi-Load
  • Limitations of Multi-Load
  • Working with multiple tables
  • Sample Scripts
  • Limitations of TPump
  • Sample Scripts
  • Exporting Data
  • OUT MODS
  • Utility Vs Parallelism
Download Material

Write Review

Extremely satisfied with course

★★★★☆
4 5 1
I am extremely satisfied with course so far. The instructor, chenna, did a marvelous job. Trainer explained in depth way of teaching and by simplifying subject helps to learn and master very well. Support team is very responsive.

Simple & effective

★★★★☆
4 5 1
I had enrolled for my course with IQ ONLINE TRAININGS and found it to be simple and effective. There were exercises at the end of each session to review your learning and importantly it allows you to come up a learning plan. Also we get regular email notifications about the progress. Though I have not yet taken the actual certification I believe this course will help me towards that. My only suggestion would be make the exercises and the mock exam more difficult.

Great Flexible way of Learning

★★★★★
5 5 1
I like it for reason of choice of whenever I want learning and available contents, online training videos, content is great. I just completed ASM certification training and already feeling quite confident for my certification exam. I will definitely go for more online training courses for other relevant areas IQ Online Trainings provided a great platform for professional to gear up for future challenges and career growth as well as for people who would like to learn new things. I was little hesitant initially to go online courses however after completing my first training I realized that all my initial reservation about online training were wrong.

Awesome Explanation

★★★★☆
4 5 1
Awesome faculty. Awesome explanation on topics. I really appreciate IQ Online Training Support team. They are really doing a fantastic job. All my queries were answered in no time. I also approached your support team for a change in class and the instructor. They allowed me to choose an instructor of my choice and now my learning is much at its peak. Thanks to one and all sitting out there in the support team. They even provide a prompt response during weekends. That's a good feature. We professionals get time only during the weekend to focus on studies and when we do so we get stuck into problems; but no way have we had a good IQ Online Training support Team. Thanks once again.

Great Teaching

★★★★★
5 5 1
I completed my SAP HANA training in IQ Online Training.The trainer was well organized and he explained all the concepts very well. Got very good experience.

More reviews...

Summary
Review Date
Reviewed Item
Teradata Administration Online Training - Superb
Please follow and like us:

Testimonials

Write a Review

No review posted.