Mail : training@ecorptrainings.com
India : +91-8143-111-555
USA : +1-703-445-4802
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog

Workday HCM Demo New Batches Starting from Wednesday... 14-12-2016
Search Course Here




Live Chat
Support
Teradata online training

Teradata



overview


Teradata is a fully scalable relational database management system produced by Teradata Corp. It is widely used to manage large data warehousing operations.The Teradata database system is based on off-the-shelf symmetric multiprocessing technology combined with communication networking, connecting symmetric multiprocessing systems to form large parallel processing systems.

prerequisties

  • Any Programming Language Knowledge with OOPs concept.

Duration

Online
  • It is a 20 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

Corporate
  • It is a 5 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
Classroom
    Private Classroom arranged on request and minimum attendies for batch is 4.

course content

  • Introduction
    • What is Teradata?
    • Teradatav12 & versions Other versions
    • Overview OF Teradata
    • Teradata warehouse
    • Teradata in the Enterprise
    • Teradata Users & Scalability
  • 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
  • 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
  • Teradata Sql Reference
    • SQL Fundamentals
    • Data Types and Literals
    • Data Definition Statements(DDL)
    • Data Manipulation Statements(DML)
  • 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
  • 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
    • 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

Videos

Teradata Videos will be updated Soon
To Watch More Videos Click Here

Flash News


AngularJS New Batch Start From 09th DEC & 10th DEC.


Hadoop Dev New Batch Start From 10th DEC & 11th DEC.


IBM COGNOS TM New Batch Start From 11th DEC & 12th DEC.


Informatica Dev New Batch Start From 12th DEC & 13th DEC.


Mean Stack New Batch Start 13th DEC & 14th DEC.

SAP BODS new Batch Starting From 14th DEC & 15th DEC.

SAP S/4 HANA New Batch Start From 15th DEC & 16th DEC
.

Tableau New Batch Start From 16th DEC & 17th DEC

PUBLIC DEMO


(1) Workday Technical Demo Training

Demo Schedule : 09:30A.M EST / 08:30A.M CST / 6:30A.M PST on 13th DEC & 07:00A.M IST on 14th DEC

SOLVE YOUR QUERIES ONLINE
Email :
Rediff Bol :
ecorptrainings@rediffmail.com
Google Talk :
ecorptrainings@gmail.com
MSN Messenger :
ecorptrainings@hotmail.com
Yahoo Messenger :
ecorptrainings@yahoo.com
Skype Talk :
ecorptrainings