Teradata Development Online Training

Introduction

Teradata Development Training

Teradata is a database, which is planned to manage logical queries. Teradata is basically a relational database management system that means It is an open-system, operating on the UNIX MP-RAS or Windows machine platform. It is assisting several concurrent users from various customer systems capable. It 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 Development Training Course?

  • Learn the basic concepts of Teradata.
  • Know the Architecture and Indexing mechanism.
  • How to process the data using SQL in 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 Development Course?

  • Basic Knowledge of SQL is mandatory.

Course Curriculum

Download Course Content

MODULE 1: INTRODUCTION

  • Overview
  • Different versions
  • Warehouse
  • Users and Scalability
  • Enterprise Usage

MODULE 2: ARCHITECTURE AND COMPONENTS

  • 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: INDEXES

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

MODULE 5: 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: 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
  • 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
  • OUTMODS
  • Utility Vs Parallelism
Download Material

Write Review

Professional electronic learning at its best

★★★★★
5 5 1
Super professional training with big impact I got course due to their catalog of courses in no time. It was my first trial of electronic trading on a subject that I was good at, project management. And I felt relaxed to get the electronic training. Not only that, IQ Online Training provided class training in my country Saudi Arabia, too. Which was a surprise to have this capability to associate electronic and class training. But thy do that seamlessly Thanks IQ Online Training and its staff including the team of support(Rani especially) they have been wonderful

Excellent Customer Support

★★★★★
5 5 1
Knowledgeable Presenters, Professional Materials, Excellent Customer Support what else can a person ask for when acquiring a new skill or knowledge to enhance their career. IQ Online Training true to its name, is the place to gather,garner and garden the knowledge for all around the globe. My Best wishes to IQ Online Training's team for their upcoming bright future.

great service

★★★★☆
4 5 1
I am super excited to start the learning process with IQ Online Trainings, in preparing for my Pump and insure I will learn a lot! i also want to thank the customer service for their great contribution

Well paced and informative

★★★★★
5 5 1
It's one of the most decent options available for affordable professional courses which most of us look for improving our skill set in today's competitive world.The instructor was quiet knowledgeable and course was well paced and informative.

Support at IQ ONLINE TRAININGS

★★★★★
5 5 1
The support provided was terrific and straight to the point.Appreciate the prompt handling of the issue.

More reviews...

Summary
Review Date
Reviewed Item
Teradata Development Online Training - Nice
Author Rating
5
Please follow and like us:

Testimonials

Write a Review

No review posted.