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

Amazing Experience from IQ Online Training Course Content

★★★★★
5 5 1
I have an amazing course experience from IQ Online Training as their course material is too good and very elaborative and also the customer support is also very helpful and prompt. I would surely try to take another course in future from IQ Online Training. This is my first time doing an online course of any kind. You have n number of instructors handling the same course you can learn from different instructor and get their expertise on that subject. The backend support staff are also amazing ready to help us anytime and provide quick solution.

Perfect CyberArk Institute in USA

★★★★★
5 5 1
I took the CyberArk online training course from IQ Online and it was a good experience for me. The trainer helped me to understand the intricacies of CyberArk within a short period and explained in-depth. Thanks IQ Online

Training was Structured well

★★★★☆
4 5 1
Thanks IQ Online! The trainer Mr. Vishnu has in depth knowledge in Dell Bhoomi. I like the way he explained with examples and i thoroughly enjoyed the sessions

IQONLINETRAINING

★★★★☆
4 5 1
whatever the course provided is more than enough for deploying a cloud environment of our own

Best training center in Hyderabad

★★★★★
5 5 1
Though the course was very long, the trainer Chenna Reddy covered all topics. BTW I took SAP Hybris online training here it is worth the fees.

More reviews...

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

Testimonials

Write a Review

No review posted.