[wpcol_1third id=”” class=”” style=””]

youtube

 

>>   SAP BODS

>>   SAP BI

>>   SAP FICO

>>   SAP CO

>>   SAP CRM

>>   SAP HR HCM

>>   SAP SD

>>   SAP PP

>>   SAP PS

>>   SAP PM

>>   SAP MM

>>  SAP WM

>>   SAP QM

[/wpcol_1third] [wpcol_2third_end id=”” class=”” style=””]

SAP PP  

SAP PP Online Training

Duration: 45 Hrs

TERADATA 12

Teradata Warehouse and Competitiveness

  • What is Teradata-RDBMS
  • Teradata 12 Vs Other versions
  • Teradata History
  • Teradata in the Enterprise
  • Teradata Users & Scalability
  • Teradata competitiveness with other RDBMS
    (Oracle, SqlServer etc)
  • Teradata Warehouse
  • Discussion on interview and certification questions 

Teradata Architecture and Components

  • PDE(Parallel Data Extension)
  • Vprocs(Virtual Processors)
  • 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 Architectures

  • Node Architecture(Shared Nothing)
  • SMP Architecture
  • MPP Architecture
  • Parallelism Architecture
  • Benefits and Types

Data Recovery and Protection

  • Object Locks
  • Various locks for simultaneous access
  • RAID 1
  • RAID 5
  • Disk Arrays
  • Fall Back
  • Clique
  • AMP Clustering
  • Journals
  • Recovery Journal
  • Trasient Journal
  • Permanent Journal
  • Before Journal
  • After Journal
  • Answering various recovery questions

Teradata Storage and Retrival Architectures

  • Request Processing
  • Syntaxer
  • Resolver
  • Security Module
  • Optimizer
  • Step Generator
  • GNC Apply
  • Dispatcher
  • Primary Index
  • Hash algorithm
  • Row Hash
  • DSW
  • Hash Map
  • Hash Bucket
  • Reaching V disk

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

  • Fundamentals
  • Data Types and Literals
  • Data Definition Statements
  • Data Manipulation Statements
  • 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

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

Introduction to

  • Answering AD-hoc queries and FAQs
  • Covering DBA Concepts

[/wpcol_2third_end]

Leave a comment

Your email address will not be published. Required fields are marked *