Online Informatica Training organization is specialized in providing online classes for online Teradata training, Data Warehousing, Informatica and Teradata with much experienced and real Time experts in the industry. Online Informatica Training institute with committed specialized Computer courses, which has affluence of opportunities in present software industry and meanwhile always encourage the learners to adorn their ability and skills with up-to-date information. Online informatica Training offers training to the students in altered concepts and modes to be consistently basic in the accepted Job market, having faculty with superior & awfully skilled among current Industry. Highlights of our training includes training for complete project with absolute time and enhancing the trainees in all the areas especially at advanced concepts. Teradata is the No.1 Leader in DBMS.
- TERADATA
- What is Teradata?
- Teradata v13.10 & versions
- Teradata History
- Teradata user’s scalability
- Teradata & other RDBMS
- Teradata warehouse
- Teradata in the Enterprise
- Interview Q&A and Certification queries
- Real time Issues & resolving
- TERADATA ARCHITECTURE
- 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
- OBJECTS OF TERADATA
- Types of tables
- Set tables
- Multi tables
- Volatile tables
- Global temporary tables
- Derived tables
- Views
- Macros
- 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 are used journals?
- INDEXES OF TERADATA
- Types of indexes in Teradata
- Data Distribution and Data Retrieval
- Use of indexes
- Primary indexes (unique, non- unique, NO PI)
- Secondary indexes (unique, non- unique)
- Partition Primary Indexes (PPI)
- Multilevel portioning primary index (MLPPI)
- Join indexes
- Skew factor
- Keys & indexes (How & why these used)
- STORAGE & RETRIEVAL OF DATA
- SQL Request Processing
- SQL Syntax
- Resolver
- Security Mode
- Optimizer
- Step Generator
- GNC Apply
- Dispatcher
- Primary Index
- Hashing Algorithm
- Row Hash
- DSW
- Hash Map
- Hash Bucket
- Reaching V disk
- TERADATA SQL’s
- 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 OLAP Functions
- TERADATA JOIN STRATEGIES
- Hash join
- Merge join
- Nested join
- Product join
- Exclusion Merge
- Single window Merge Join
- TERADATA JOINS and SET OPERATORS
- Inner join
- Left outer join
- Right outer Join
- Full outer join
- Union
- Union All
- Intersect
- Minus
- TERADATA EXTENSIONS
- Help
- Show
- Macros
- Explain
- Collect statistics
- Teradata Performance Tuning
- 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 (IMPORT & EXPORT)
- BTEQ
- Teradata BTeq scripts
- Overview of BTeq
- Looping stages
- Batches scripts
- Import & export scripts with Examples
- Error handling
- Real time scripts
- FastLoad
- Teradata FastLoad
- Overview FastLoad
- Types of phases
- Advantages of FastLoad
- Limitations of fast load
- Real time scripts
- MultiLoad
- Teradata MultiLoad
- Overview of Multi load
- Types of phases in MultiLoad
- Advantages of MultiLoad
- Limitations of MultiLoad
- Uses various types of operations
- Work on Multi tables
- Real time scripts
- Sample scripts
- Tpump
- Teradata Tpump
- Overview of Tpump
- Limitations of Tpump
- Work on Multi tables
- Real time scripts
- Sample scripts
- Fast Export
- Teradata Fast Export
- How to export the data
- Passing parameters
- IN/OUTModes
- Work on Multi tables
- Real time scripts
- Sample scripts
- Teradata TPT
- Teradata performance tuning on scripts
- Explanation of explain plan
- Real Time Interview Questions
- Teradata Advanced Concepts
- BTEQ