Tera Data Course

Training/Coaching/Tuition by Pradhika Technology Hyderabad View Contact

Request Info

• 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 Rcovery 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

• NonUnique

• 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

Pradhika Technology

Pradhika Technology is one of the trusted training institutes that offer online training for Websphere courses & works with a mission to make online software learning easier for all the students across the world. We propose all the foremost software courses in a sole manner by instigate our own techniques, which are proven to be successful in the software learning. We are professionals & skilled enough to handle all the hottest techniques to offer online training in an astonishing manner.

Pradhika Technology works with an operation to be one of the finest online training centers that offers all the newest updated websphere courses in a various environment & maintains as a superior reports with the learners because we just don’t contribute the knowledge of the subject but we share the life of the software. We are passionate & famine to create more software connoisseurs who can serve the industry for long run.

Pradhika Technology software training Institute has all the qualities to be a Premier Websphere training Institute in Hyderabad (Andrapradesh) India with continuous improvement and achieve excellent Student satisfaction in providing high end skilled training and development on emerging technologies by Bridging the Gap between Academics and Industry in the fields of Information Technology. We have developed Software training Methods specifically designed for undergraduates, Graduates, postgraduates from engineering and non engineering background enabling them to discover and build, invent and innovate newer technologies. We also conduct special software training programs for Open University students.Pradhika technology always try to build a long-term relationship with all the Students who get trained in the institute by ensuring timely delivery of quality software Training and services using continuously improving processes.