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

Great learning Providers

★★★★★
5 5 1
IQ ONLINE TRAININGS learning strategy is very unique. They ensure as a student you know the subjects thoroughly. They provide all forms of media to ensure this. Am happy to be part of their family and happy to stay you have helped in my career growth. Thanks IQ ONLINE TRAININGS team

Great learning platform, highly recommend.

★★★★★
5 5 1
IQ Online Trainings is very easy to use.

Good course and good institute for learning

★★★★★
5 5 1
Arun was the ideal Guidewire course trainer…if you want to learn Guidewire online training I would suggest taking from this man from IQ.

good for java training

★★★★★
5 5 1
The course was really interesting and informative.Trainer has wonderful technical and teaching skills. He answered all my queries very politely. Thanks a lot for all the effort that you have put.

Amazing experience to get trained in Guidewire

★★★★★
5 5 1
I really appreciate the IQ online Training. The trainer is also very knowledgeable and experienced. If you are looking to learn something practically then choose IQ online training.

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.