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

Expertise in Online Training

★★★★☆
4 5 1
They have excellent faculty and support team that has given a real classroom learning experience. Anybody can upgrade their skills at their convenience! IQ Online Training has expertise in Online Training and they are providing opportunity to acquire these skills in a short time

erfect place to start with any IT Online Courses

★★★★★
5 5 1
It was very beneficial and motivational . I learned a lot,at the same time it was kind of eye opener for me that I know nothing and I have to study a lot. What I liked most was their performance and practical way of teaching rather than giving speech in a theoretical way.Thank you so much.

IQ ONLINE TRAININGS is good website to do training

★★★★☆
4 5 1
Very well structured course content and Learn very Easily from their trainers Thank you

8088763764

★★★★☆
4 5 1
Super

Great work IQ Online

★★★★★
5 5 1
Thank you so much for teaching me from the basics to advance level. I enjoyed this course from very first level.

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.