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 Training Connect Live
Corporate Training Contact Us
One to One Online Training Join Demo

COURSE SUMMARY

Course Name Teradata Development Online Training
Contents Fundamentals, Architecture, and Components of Teradata etc.
Duration 30 Hours with Flexible timings
Delivery Instructor Led-Live Online Training
Eligibility Any Graduate
Ideal For Freshers, aspirants seeking to learn the Teradata Development
Availability Regular/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

[RICH_REVIEWS_SHOW num="5"]

More reviews...

Summary
Review Date
Reviewed Item
Teradata Administration Online Training - Superb

Testimonials

Write a Review

No review posted.