TERADATA Online Training
TERADATA Online Training
TERADATA Online Training Course Content :
Introduction
- What is Teradata?
- Teradatav12 & versions Other versions
- Overview OF Teradata
- Teradata warehouse
- Teradata in the Enterprise
- Teradata Users & Scalability
- interview Q&A and Certification queries
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
- Why for locks &how to release
- Various locks for simultaneous access
- RAID 1&RAID 5
- Disk Arrays
- Fall Back
- Clique
- AMP Clustering
- Types OF Journals
- Recovery Journal
- Trasient Journal
- Permanent Journal
- Before Journal
- After Journal
- How & where is used journals
- 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
Implicit Transaction
Explicit Transaction
- Performance Tuning and Explain Utility
- Explain Usage
- Collecting Statistics
- Tuning SQL Performance
- Usage of PMON
- Explaining various SQL statements
- Joins and Unions
- Inner Join
- Left Outer Join
- Right Outer Join
- Full Outer Join
- Detailed explanation
- Join Strategies
- Product Join
- Merge Join
- Hash Join
- Nested 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)
- Teradata Performance Monitor
- Teradata BTEQ
- Batch Scripts with samples
- Branching and Looping
- Importing data through scripts
- Exporting data through scripts
- Error handling
- Explanation with proper debugging
- Teradata Fast Load
- Various Phases of Fast Load
- Advantages and Process
- Limitations of Fast Load
- Sample Scripts
Real time Issues and resolving it
- Teradata Multi Load
- Various Phases of Multi Load
- Limitations of Multi Load
- Working with multiple tables
- Applying various operations
- Sample Scripts
Real time Issues and solving it
- Teradata Parallel Data Pump
- Limitations of TPump
- Overview of TPump
- Sample Scripts
- Teradata Fast Export
- Exporting Data
- Passing Parameters
- OUTMODS
- Sample Scripts
- Utility Vs Parallelism
Drop your query
Most Popular Courses
Achieve your career goal with industry recognised learning paths
What my Client's Say?
-
It was a great course over my expectations. I am eager to have another course wıth you as soon as possıble ~ R. Kamand
-
All in all, it was a very constructive and one in a lifetime experience. I'm so glad that I was part of it.~ T. Engin
-
It was the best decision I had ever made in my life. Although it was expensive for me, but I don't regret even for one second. ~ Maruti Malla
-
Thank you for this great course. I learned a lot of things, I met very nice people and I am happy that I had these 6 crazy weeks with you.".~ Najmul Shar A Baig
-
Very nice and friendly tutor and staff. The course was very fruitful, particularly the input sessions during the first half of it.~ Radha Nandyala
-
It was such great experience, though it was really intensive, it was worth doing it! Cant thank enough all team effort esp Mohan! .~ Rohan Kumar
-
The course was really good because it was a practical course.~ M.Radha patel
-
I liked this experience. Good tutor and nice mates. I will always remember it. ~ Jitu Bavaria
