A2Z ONLINE TRAINING ( SINCE 2005 ) : Call US: +1 339 368 6489 (USA) | +91 88013 86489 (INDIA)

Pioneer In Online Training.
Online Training By Real Time Industry Experts with Professionalism and Commitment.

Teradata Online Training


Teradata Online Training Course Content:
TERADATA V13
WHAT IS TERADATA WHY FOR IT IS WHAT FOR IT IS What is Teradata? Teradatav12 & versions Teradata History Teradata users scalability Teradata &other RDBMS Teradata warehouse Teradata in the Enterprise Interview Q&A and Certification queries Real time Issues & resolving  TERADATA ARCHITECTURE & IT’S COMPONENTS Node Architecture(Shared Architecture) SMP Architecture MPP Architecture Parsing engine(PE) Architecture AMP Architecture &uses Bynet Benefits &types Parallel data extension(PDE) Teradata directory program(TDP) Call level interface(CLI) Trusted parallel application(TPA) Virtual processors Bynet 0 &Bynet 1 Parallism Architecture RECOVERY &PROTECTION OF DATA What is fall back &where it used Why for fall back What is Clique AMP Clustering & types for simultaneous Access Why for locks &how to release RAID 1 &RAID 5 Journals &types Virtual Disk Array How & where is used  journals Q & A about data recovery TERADATA INDEXES Types of indexes in Teradata Primary indexes(unique, non- unique, NO PI) Secondary indexes(unique, non- unique) Partition Primary Indexes Join indexes Skew factor Keys & indexes (How & why these used) HOW TO STORAGE & RETRIEVAL OF DATA Hash algorithm Rowhash Hash map Hash bucket Receiving VDisc TERADATA SQL QUERYMAN SQL  fundamentals Data types and literals DDL Statements DML Statements Teradata naming convesions TERADATA SQL FUNCTIONS & OPERATIONS String functions Format functions Cast functions Group & Aggregation functions Logical operations Arithmetic operations set operations join operations conditional expressions TERADATA JOIN STRATEGIES hash join merge join nested join product join Exclusion Merge TERADATA JOINS Inner join Left outer join Right outer Join Full outer join TERADATA EXTENSIONS Help Show Macros Explain Collect statistics Teradata Performance Tuning TERADATA OBJECTS Types of tables Set tables Multi tables Volatile tables Global temporary tables Derived tables Views Macros TERADATA MEMORY SPACES Permanent spaces Temporary spaces Spool spaces Users spaces & PWD TERADATA TRANSACTION MODES BTET mode ANSI mode How Convert into other modes Interactive and Batch mode TERADATA PERFORMANCE TUNING ON SQL ASSISTANCE Usage of  PMON Explain usage Collecting statistics SQL tuning Various SQL statements Real time Issues & resolving    TERADATA UTILITIES & TOOLS (IMPORT & EXPORT) Teradata BTeq scripts Overview of BTeq Looping stages Batches scripts Import &export scripts with Examples Error handling Real time scripts Teradata FastLoad Types of phages & how to find it Advantages & its process Limitations of fast load Real time scripts Teradata MultiLoad Overview of Multi load Types of phages in MultiLoad Advantages & its process Limitations of MultiLoad Uses various types of operations Work on Multi tables Real time scripts Sample scripts Teradata Tpump Overview of Tpump Limitations of Tpump Work on Multi tables Real time scripts Sample scripts Teradata Fast Export How to export the data Passing parameters IN/OUTModes Work on Multi tables Real time scripts Sample scripts Teradata SQL Assistant(Quarryman) Teradata performance tuning on scripts
Copyright © 2012 A2Z Online Training. All Rights Reserved