Teradata Online Training
OVERVIEW OF TERADATA
- What is Teradata…
- Teradata v12 & next versions
- Teradata History
- Teradata users scalability
- Teradata and other R-DBMS’s
- Teradata is a warehouse
- Teradata in the Enterprise level
- Interview Questations & Answers and Certification support
- Real time Scenarios & Problems – Solutions
TERADATA ARCHITECTURE & IT’S COMPONENTS
- Node Architecture (Shared Architecture)
- SMP Architecture
- MPP Architecture
- Parsing engine(PE) Architecture
- AMP Architecture &usage
- Bynet Benefits and types
- Parallel data extension-(PDE)
- Teradata directory program(TDP)
- Call level interface-(CLI)
- Trusted parallel application-(TPA)
- Virtual processors
- Bynet 0 and 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 and RAID 5
- Journals and types
- Virtual Disk Array
- How & where is used journals
- Q and 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 and 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
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
- 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 and OUT Modes
- Work on Multi tables
- Real time scripts
- Sample scripts
- Teradata SQL Assistant(Quarryman)
- Teradata performance monitor
- Teradata Administrator usage
- Teradata performance tuning on scripts