Radhika Technosoft head
Teradata Development
 Radhika Technosoft head

The Teradata product is referred to as a "data warehouse system" and stores and manages data. The data warehouses use a "shared nothing" architecture which means that each server node has its own memory and processing power. Adding more servers and nodes increases the amount of data that can be stored. The database software sits on top of the servers and spreads the workload among them. Teradata sells applications and software to process different types of data.

 

Introduction

  • What is Teradata?
  • Teradatav12 & versions Other versions
  • Overview OF Teradata
  • Teradata warehouse
  • Teradata in the Enterprise
  • Teradata Users & Scalability
  • Interview Q&A and Certification queries

Teradata Architecture and Components

  • Teradata Architecture
  • SMP Architecture
  • MPP Architecture
  • AMP(Access Module Processing)
  • TDP(Teradata Directory Program)
  • CLI(Call Level Interface)
  • TPA(Trusted Parallel Application)
  • Parallelism Architecture
  • Benefits and Types

Data Recovery and Security

  • Why for locks &how to release
  • Various locks for simultaneous access
  • RAID 1&RAID 5
  • Disk Arrays
  • Fall Back
  • Clique
  • AMP Clustering
  • Types OF Journals
  • Recovery Journal
  • Trasient Journal
  • Permanent Journal
  • Before Journal
  • After Journal
  • How & where is used journals
  • Answering various recovery questions

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
  • Full Real time scenarios and explaining

Teradata Sql Reference

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

Teradata Functions and Operators

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

Teradata Transactions, Implicit Transaction & Explicit Transaction

  • Performance Tuning and Explain Utility
  • Explain Usage
  • Collecting Statistics
  • Tuning SQL Performance
  • Usage of PMON
  • Explaining various SQL statements
  • Joins and Unions
  • Inner Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Detailed explanation
  • Join Strategies
  • Product Join
  • Merge Join
  • Hash Join
  • Nested Join
  • Questions of this section

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
  • Practices and FAQs of this session

Teradata spaces

  • PERM space
  • SPOOL space
  • TEMPORARY space
  • Teradata User and managing
  • Practical Examples

Teradata Transaction Modes

  • BTET
  • ANSI
  • Interactive
  • Batch

Teradata Sql Assistant (Queryman)

  • Teradata Performance Monitor
  • Teradata BTEQ
  • Batch Scripts with samples
  • Branching and Looping
  • Importing data through scripts
  • Exporting data through scripts
  • Error handling
  • Explanation with proper debugging
  • Teradata Fast Load
  • Various Phases of Fast Load
  • Advantages and Process
  • Limitations of Fast Load
  • Sample Scripts

Real time Issues and resolving it

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

Real time Issues and solving it

  • Teradata Parallel Data Pump
  • Limitations of TPump
  • Overview of TPump
  • Sample Scripts
  • Teradata Fast Export
  • Exporting Data
  • Passing Parameters
  • OUTMODS
  • Sample Scripts
  • Utility Vs Parallelism

our services Radhika Technosoft head RADHIKA Technosoft, a pioneer in software training has brought monumental changes in the methods and services offered. We're not an organization who puts across implausible claims. Since our inception, our services are exactly what we promised. On a given note, our service offerings are Online training, Corporate training, Certification, Web development and Job support.

our courses Radhika Technosoft head RADHIKA Technosoft is one of the trusted training institutes that offer online training for WEBSPHERE, SAP, ORACLE, PROFESSIONAL COURSES, works with a mission to make online software learning easier for all the students across the world.

Radhika Technosoft our courses websphere
Radhika Technosoft our courses sap
Radhika Technosoft our courses oracle
Radhika Technosoft our courses professional courses
Radhika Technosoft our courses java
Radhika Technosoft our courses microsoft
Radhika Technosoft our courses tibko
Radhika Technosoft our courses websphere
Radhika Technosoft our courses sap
Radhika Technosoft our courses oracle
Radhika Technosoft get in touch

Radhika Technosoft get in touch message get in touch
Feel free to get in touch with us.

contact us

Radhika Technosoft
No.1, 4th floor ideal home township,
Raja Rajeshwari Nagar,
Bangalore - 560098

social network
  • Facebook
    Radhika Technosoft Social icon
  • Linkedin
    Radhika Technosoft Social icon
  • Twitter
    Radhika Technosoft Social icon
  • Google Plus
    Radhika Technosoft Social icon

Copyrights @ All rights reserved | Privacy Policy | Sitemap Login

Scroll Up