|
||||||||
TERADATA V13 (Duration: 30 Hrs)
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
- Hash index
- Join index
- Primary index(unique, non- unique)
- Secondary index(unique, non- unique)
- Skewness
- Keys & indexes (How & why these used)
HOW TO STORAGE & RETRIEVAL OF DATA
- Hash algorithm
- hash
- Hash map
- Hash bucket
- Receiving VDisc
TERADATA SQL QUARRYMAN
- SQL fundamentals
- Data types and literals
- DDL Statements
- DML Statements
- Teradata naming conversing
TERADATA SQL QUARRYMAN
- SQL fundamentals
- Data types and literals
- DDL Statements
- DML Statements
- Teradata naming conversing
TERADATA SQL FUNCTIONS & OPERATIONS
- String functions
- Format functions
- Cast functions
- Cast functions
- Group & Aggregation functions
- Logical operations
- Arithmetic operations
- set operations
- join operations
- conditional expressions
TERADATA JOIN STRATEGIES & UNIONS
- hash join
- merge join
- nested join
- product join
- inner join
- left & right outer join
- full outer join
TERADATA BASIC COMMANDS
- Help
- Show
- Explain
- Collect statistics
TERADATA OBJECTS
- Types of tables o Set tables o Multi tables o Volatile tables ? Global temporary tables ? Derived tables
- Views
- Macros
- Stored procedures
- Triggers
- TERADATA MEMORY SPACES
- Permanent spaces
- Temporary spaces
- Spool spaces
- Users spaces & PWD
TERADATA MEMORY SPACES
- Permanent spaces
- Temporary spaces
- Spool spaces
- Users spaces & PWD
TERADATA TRANSACTION MODES
- Batch mode
- BTET mode
- ANSI mode
- How Converted into others
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 o Overview of BTeq o Looping stages o Batches scripts o Import &export scripts with Examples o Error handling o Real time scripts
- Teradata FastLoad o Types of phages & how to find it o Advantages & its process o Limitations of fast load o Real time scripts
- Teradata MultiLoad o Overview of Multi load o Types of phages in MultiLoad o Advantages & its process o Limitations of MultiLoad o Uses various types of operations o Work on Multi tables o Real time scripts o Sample scripts
- Teradata Tpump o Overview of Tpump o Limitations of Tpump o Work on Multi tables o Real time scripts o Sample scripts
- Teradata Fast Export o How to export the data o Passing parameters o IN/OUT Modes o Work on Multi tables o Real time scripts o Sample scripts
- Teradata SQL Assistant(Quarryman)
- Teradata performance monitor
- Teradata Administrator usage
- Teradata performance tuning on scripts
KEY SERVICE
- FAQS
- Covering DBA concepts
- Concentration on performance tuning
- Real time scenarios
- Certification guidance
- Resume preparation
- Sample resumes
- Interview & certification FAQS
- How to face the interview
- Class notes which is useful for who is trying for job
- Project preparation