Teradata Training in Ameerpet
Srihitha Technologies provides Teradata Training in Ameerpet by real time Experts. For more information about Teradata training in Ameerpet call 9394799566 / 9290641808.
Introduction:
- What is Teradata
- Overview Of Teradata
- Data warehouse concepts
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
- locks
- RAID 1&RAID 5
- Disk Arrays
- Fall Back
- Clique
- AMP Clustering
- Journaling
- Answering various recovery questions
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
- Full Real time scenarios and explaining
Teradata Sql Reference
- SQL Fundamentals
- Data Types and Literals
- Data Definition Statements(DDL)
- Data Manipulation Statements(DML)
- Explaining with proper examples
Teradata Functions and Operators
- String Functions
- Format Function
- Cast Functions
- Group & Aggregate Functions
- With & with by clauses
- Practices of this section
Teradata Transactions
- Joins and Unions
- Inner Join
- Left Outer Join
- Right Outer Join
- Full Outer Join
- Detailed explanation
- Join Strategies
- Product Join
- Merge Join
- Questions of this section
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
- Practices and FAQs of this session
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)
- How to use Sql Assistant
- Query Processing
- Importing and exporting
Teradata Utilities
BTEQ
- Teradata BTEQ
- Batch Scripts with samples
- Branching and Looping
- Importing data through scripts
- Exporting data through scripts
- Error handling
- Explanation with proper debugging
Fast Load
- Teradata Fast Load
- Various Phases of Fast Load
- Advantages and Process
- Limitations of Fast Load
- Sample Scripts
Multi Load
- Teradata Multi Load
- Various Phases of Multi Load
- Advantages and Process
- Limitations of Multi Load
- Working with multiple tables
- Applying various operations
- Sample Scripts
Fast Export
- Teradata Fast Export
- Advantages and Process
- Limitations of Fast Export
- Sample Scripts
T-Pump
- Advantages and Process
- Teradata Parallel Data Pump
- Limitations of TPump
- Overview of TPump
- Sample Scripts
- Utility Vs Parallelism
- Difference between Multi load and T pump
Performance Tuning
- Performance Tuning and Explain Utility
- Explain Usage
- Collecting Statistics
- Tuning SQL Performance
- Explaining various SQL statements
Real time scenarios and Project Architecture
- Retail or Banking or Health care Project Architecture
- Teradata relation with Informatica
- How to run Teradata scripts in Unix
- Sample Real time scripts walk thru.
- Interview guidance.
Teradata Training in Ameerpet