USA: +1-515-337-8778
India: +91-8008527566
info@sryitsolutions.com

Teradata

What is Teradata?

Teradata is a Relational Database Management System (RDBMS) for the world’s largest commercial databases.  Teradata can store data upto Teradata bytes in size. This makes the Teradata as a market leader in data warehousing applications.

Tera Data Online Training Contents

Teradata Online Training Details

Blog

Teradata Warehouse and Competitiveness

  • Introduction to Teradata
  • Teradata12 & Versions
  • Teradata Features
  • Teradata Vs Other Databses
  • Teradata warehouse
  • Interview Q&A and certification queries
  • Real Time Issues & resloving

Teradata Hardware/Software Architecture

  • Node Architecture
  • SMP architecture
  • MPP architecture
  • Parsing engine(PE) architecture
  • AMP Architecture
  • BYNET specility
  • Parallel data extension(PDE)
  • Teradata directory program(TDP)
  • Call level interface(CLI)
  • Trusted parallel Application(TPA)
  • Virtual processors

Teradata SQL Reference

  • SQL Fundamentals
  • ANSI support
  • Teradata specific SQL’s
  • HELP
  • SHOW
  • EXPLAIN
  • COLLECT STATISTICS
  • Data Dictionary tables
  • Data types and literals
  • Data definitions Statements
  • Data manipulation Statements
  • Sub Queries/Correlated Sub Queries
  • SET/MULTI SET tables
  • Volatile temp tables
  • Global Temp Tables
  • Derived Tables.
  • Data Compression
  • View
  • Macros
  • PL/SQL in Teradata
  • Advanced Aggregate Functions with/by
  • Advanced Analytical Functions
  • Type Conversions
  • Case support

JOINS

  • Types of Joins

a. Inner Join
b. Left outer Join
c. Right outer join
d. Full outer Join.

  • JOIN ALGORYTHMS

a. Product join
b. Merge join
c. Hash join
d. Nested join

  • UNION/UNION ALL

Recovery & Protection of data

  • Fallback Protection
  • Types of Journaling
  • Locks and types
  • RAID 1 & RAID 5
  • DBA role in data protection

Execution Plan

  • Request Processing
  • Syntax validation
  • Resolver
  • Security Module
  • Optimizer
  • Step Generetor
  • GNC Apply
  • Dispatcher
  • Row Hash
  • DSW
  • Hash Map
  • Hash Bucket
  • Explain Usage
  • Collecting Statistics
  • Tuning SQL performance
  • Using of PMON

Terada Indexes

  • Primary Index (unique, non-unique)
  • Secondary index (unique, non-unique)
  • HASH Index
  • JOIN Index
  • Skewness
  • Secondary Index Sub table
  • Accessing records via primary index
  • Accessing records via secondary
  • Primary key Vs Indexes
  • Rule for default PI creation

Teradata Transactions

  • Implicit Transaction
  • Explicit Transaction

Teradata Spaces

  • PERM Space
  • SPOOL space
  • TEMPORARY Spaces
  • Teradata User and managing

Teradata Transaction Modes

  • BTET
  • ANSI

Working With SQL Assistant

  • Configuring SQL Assistance
  • Best Practices on SQL Assistance
  • Teradata UTILITIES

BTEQ

  • Batch mode
  • Interactive mode
  • Creating scripts using BTEQ Data Control in BTEQ
  • Export
  • Import

FAST EXPORT

  • Exporting data using Fast Export

FAST LOAD

  • Importing Data from Delimited Files to Single Table
  • Importing Data from Fixed with Files to Single Table
  • Table
  • Input file formats
  • Error Handling
  • Restartability

MULTI LOAD

  • Importing Data from Delimited Files to Multiple Tables
  • Importing Data from Fixed with Files to Multiple Tables
  • Input file formats
  • INSERT/UPDATE/UPSERT using MULTI LOAD
  • Implementing SCD type-I using MULTI LOAD
  • Implementing SCD type-II using MULTI LOAD
  • Error Handling
  • Error/log tables
  • Restartability

TPUMP

  • Importing Data from Delimeted Files to Multiple Tables
  • Importing Data from Fixed with Files to Multiple Tables
  • Input file formats
  • INSERT/UPDATE/UPSERT using MULTI LOAD
  • Implementing SCD type-I using MULTI LOAD
  • Implementing SCD type-II using MULTI LOAD Error Handling
  • Error/log tables
  • Restartability

Comparisions

  • BTEQ vs SQL Assistances
  • BTEQ Export vs Fast Export
  • BTEQ import vs Fast Export vs Loads
  • Connecting to Teradata from infromatica
  • Connecting to Teradata from Datastage
  • Connecting to Teradata from OBIEE

Course Details:

Duration: 30-35 hours (Daily 1 hr to 1 hr 30 minutes)
System Access: 60 days
Session Timings: As per participant convenience
Payment Options: Paypal

Why SRY IT:

We are having ample of experience in Teradata Online Training. After every session recordings will be provided and soft copy of Teradata Online Training material will be provided. After the sessions od Teradata Online Training project support will be provided. CV preparation will be done with the ongoing clients. We are maintaining the Blogs for every course which will have the blogs related to new concepts of Teradata Online Training.

About the Trainer:

Teradata Online Training will be provided by real time certified consultant. Overall experience of trainer is 8 years. Trainer is having good experience in corporate training. Trainer is an expert in implementation projects and Teradata Online Training support projects. In the training real time scenarios will be covered which helps the job seeker to handle the projects easily.

 Who is Eligible:

Any Graduates/Post Graduates are eligible.
Anyone having knowledge in Data Warehousing technologies.
Any technical background consultants are eligible to learn Teradata Online Training.

 

To know more details about TERA DATA visit our blog

Open Popup
  • Book Your Demo.