Search for Training
Have Queries? Ask us +91 72592 22234

Course Overview


Xpertised Offers Advanced and Personalized Instructor Led Online Classroom training on Teradata which gives you the opportunity to interact with a Teradata instructor and help you enhance yourself to meet the demands of the industry.

Learn from our instructors from the convenience of your home or office. Interact and learn live with trainers and other participants.

Course Content


Teradata Architecture and Components

  • PDE(ParaIIe| Data Extension)
  • Vprocs (virtual processors)
  • PE (Parsing Engine)
  • AMP (Access Module processing)
  • Board less Bynet
  • TDP (Teradata Directory Program)
  • CLI (Call Level Interface)
  • TPA (Trusted parallel Application)
  • Going in depth by explaining the process of SQL statement execution

Various Architecture

  • Node Architecture (shared nothing)
  • SMP Architecture
  • MPP Architecture
  • Parallelism Architecture
  • Benefit & types

Data Recovery and Protection

  • Object Locks-Various locks for simultaneous access
  • RAIDI 
  • Disk Arrays
  • Fall Back
  • Clique
  • AMP Clustering
  • Journals

Teradata Storage and Retrieval Architecture

  • Request processing
  • Syntaxer
  • Resolver
  • Security Module
  • Optimizer
  • Step Generator
  • GNC Apply
  • Dispatcher

Primary index

  • Hash algorithm
  • Row hash
  • DSW
  • Hash Map
  • Hash Bucket
  • Reaching Vdisk

Teradata Indexes

  • Primary Index
  • Unique
  • Non unique
  • Partitioned
  • Secondary Index
  • Unique
  • Non unique
  • Hash, Join, Value Ordered
  • Skewness
  • Secondary Index Sub table
  • Accessing Records via primary index
  • Accessing records via Secondary index
  • Keys vs indexes

Teradata Sql Reference

  • Fundamentals
  • Data Types and Literals
  • Data Definition Statements
  • Data manipulation statements

Teradata Functions and Operators

  • String functions
  • Format functions
  • Cast functions
  • Group &Aggregate functions
  • With & with by clauses

Teradata Transactions

  • Implicit Transaction
  • Explicit Transaction

Performance Tuning and Explain Utility

  • Explain Usage
  • Collection Statistics
  • Tuning SQL Performance
  • Usage of PMON

Joints & Unions

  • Inner Join
  • Left Outer Join
  • Right Outerjoin
  • Full Outer Join

Teradata Basic Commands

  • HELP
  • SHOW
  • EXPLAIN
  • COLLECT STATISTICS

Teradata objects

  • Tables
    • SET table
    • Multi Set table
    • Volatile tables
    • Global Temporary tables
    • Derived tables
  • Views
  • Macros
  • Stored procedures
  • Triggers

Teradata spaces

  • PERM space
  • SPOOL space
  • TEMPORARY space
  • Teradata user and managing.

Teradata Transaction Modes

  • BTET
  • ANSI
  • Interactive
  • Batch

Load and Unload Utilities & Tools

  • Teradata Sql Assistant (Queryman)
  • Teradata Performance Monitor
  • Teradata BTEQ
    • Batch Scripts with samples
    • Branching and Looping
    • Importing data through scripts
    • Exporting data through scripts
    • Session Control Command Set
    • 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

Customer Reviews


Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.
-Waseem

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.
-Tanmoy

...more
Share:

For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

What is the sum of 5 + 1? (security question)

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234

Subscribe to our weekly newsletter