Teradata

Teradata online training in hyderabad

Available Trainings

11th Apr, 2018 -  9th Aug, 2018     07:00  -  09:00     30 Hours
Online 
12641
Take Traning
11th Apr, 2018 -  9th Aug, 2018     07:00  -  09:00     30 Hours
Online 
12641
Take Traning
11th Apr, 2018 -  9th Aug, 2018     07:00  -  09:00     30 Hours
Online 
12641
Take Traning

Demo Videos

Course Syllabus

Teradata online training in hyderabad

Course Hours: 45 to 50 Hrs

Introduction:

  • What is Teradata and Overview of Teradata
  • Roles of Teradata
  • Data warehouse concepts
  • Relation between Teradata & with other ETL tools
  • Difference between Teradata & other RDBMS

Teradata Architecture and Components:

  • Teradata Architecture
  • SMP Architecture
  • MPP Architecture
  • AMP(Access Module Processing)

Teradata SQL Reference:

  • SQL Fundamentals
  • Data Definition Statements(DDL)
  • Data Manipulation Statements(DML)
  • Explaining with proper examples

Explicit Transaction:

  • Explaining various SQL statements
  • Joins and Unions
  • Inner Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Detailed explanation

Teradata Functions and Operators:

  • SQL Exercise
  • String Functions
  • Format Function
  • Cast Functions
  • Group & Aggregate Functions
  • With & with by clauses
  • Practices of this section

Teradata Index:

  • Primary Index
  • Unique Primary Index
  • Non unique Primary Index
  • Hashing Algorithm
  • Partitioned Primary Index
  • No Primary Index
  • Secondary Index
  • Unique Secondary index
  • Non Unique secondary index
  • Skew factor
  • Secondary Index Sub table
  • Accessing Records via Primary Index
  • Accessing records via Secondary Index

Data Recovery and Protection:

  • Various locks for simultaneous access
  • RAID 1&RAID 5
  • Fall Back
  • Clique
  • AMP Clustering
  • Types OF Journals

Teradata spaces:

  • PERM space
  • SPOOL space
  • TEMPORARY space

Teradata Objects:

  • Tables
  • SET table
  • Multi Set table
  • Volatile tables
  • Global Temporary tables
  • Derived tables
  • Views
  • Macros
  • Procedures
  • Functions

BTEQ:

  • Teradata BTEQ
  • Batch Scripts with samples
  • Branching and Looping
  • Importing data through scripts
  • Exporting data through scripts
  • Error handling

Teradata Fast Load:

  • Various Phases of Fast Load
  • Advantages and Process
  • Limitations of Fast Load
  • Sample Scripts

Teradata Multi Load:

  • Various Phases of Multi Load
  • Limitations of Multi Load
  • Working with multiple tables
  • Applying various operations
  • Sample Scripts

Teradata Tpump:

  • Teradata Parallel Data Pump
  • Limitations of Tpump
  • Overview of Tpump

Teradata Fast Export:

OLEDB:

Teradata Parallel Transporter:

Teradata New Features:

  • Temporal table
  • Columnar tables
  • Other features

Teradata Performance Tuning:

  • Tuning steps
  • Collect statistics
  • Join strategies
  • Other steps

Informatica Usage in your project:

UNIX Basics:

Teradata Project Explanation:

Teradata Interview questions:

Questions and Discussions:

teradata training videos online teradata training teradata training in hyderabad teradata training in bangalore teradata training in chennai teradata training bangalore

teradata training,teradata sql training,teradata,teradata online,learn teradata online,teradata training courses,teradata training online,teradata online training