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

Very good institute for Online Trainings

★★★★★
5 5 1
Hi,thanks for quality sessions training. It really helped me in my projects. Trainer explained each and every doubt clearly which i have gone through.

Great Experience

★★★★★
5 5 1
I had a great experience learning online courses with Team IQ Online Training. The great support, light atmosphere and answering every question never made me miss blackboard, chalk and duster. Recorded sessions and 24*7 support are really good advantages and helps learning easy without any limitations on timings.

Training experience was really good

★★★★★
5 5 1
IQ online training enabled me to get trained in that course with my convenience timings and schedule. Trainer explained each module in a simple and understandable way. He gave assignments and also provided hands on practice. The experience was really good.

Wonderful Experience

★★★★☆
4 5 1
It has been a wonderful experience. All the staff members are really helpful.

System worked well

★★★★☆
4 5 1
The system worked well. The apps were a nice addition to make it usable everywhere

More reviews...

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

Testimonials

Write a Review

No review posted.