Learn Teradata Course
Best Institute for Teradata Training in Chennai offers Job Oriented Hands-on Teradata Training, Oracle Data Integrator (ODI) training, Teradata 11g Certification Training, Business Intelligence Training with Placement by well experienced Oracle BI professionals having 12 years of Datawarehouse experience.
We provide Teradata 10g Training, Teradata 11g training, Oracle BI Applications (OBIA), Data Warehouse Administration Console (DAC) based on current industry standards. All our sessions are completely practical and interactive paired with Realtime Methodologies, Project Scenarios and Interview Guidance exclusively on OBIEE
Recommended as Best Teradata Training Institutes in Chennai!
About Our Trainer
As a Trainer, Mr.Ram work as a BI Consultant for a Leading MNC in Chennai with 12+ years experience in both software development and training and very keen in delivering the BEST Cognos Business Intelligence Trainings. The trainee can simply depend on Ram for his excellent Real Time examples on every part of the concept paired with in-depth discussions and Datawarehouse recommendations. All sessions are completely practical and very much interactive.
Specialties
ETL & Data Warehouse Consulting using Cognos and other ETL tools. 8+ years Cognos experience Including Version 10
Please Note: Trainer is a Realtime Expert and Currently working for one MNC. Hence all the Training Schedules (timings) are fixed. No One - One Trainings can be provided as of now.
Want a free career Advice or any career related queries? Reach him by
+91- 8939915572
Course Curriculum
Curriculum
Teradata Introduction
- Teradata Introduction
- Teradata Advantages
- RDBMS vs Data warehouse
- Teradata Tools & Utilities
- Teradata Installation
Teradata Architecture
- Teradata Components
- Storage & Retrieval architecture
- System architecture
- How parallelism works
Basic SQL
- Data types
- DDL statements(CREATE,DROP,ALTER)
- DML statements (SELECT, INSERT,UPDATE,DELETE)
- DCL statements (Grant, Revoke)
- SET Operators
- Logical & Conditional Operators
- String Manipulation
- Date & Time Manipulation
- Joins
- Built-in functions
- Aggregates
Indexes
- Primary Index
- Secondary Index
- Partition Primary Index
Teradata Objects
- Tables and its types
- Space concepts
- Views
- Macros
- Stored Procedures
- Join Index
Advanced SQL
- Sub queries
- Coalesce
- OLAP Functions
- Compression
- Collect Statistics
- DBC tables
- Explain plan
Utilities
- FastLoad
- MultiLoad
- BTEQ
- FastExport
- TPT
Data Protection
- Fallback
- Clusters
- Clique
- Permanent Journals
- Hot Standby Nodes
- RAID
Performance Optimization
- Join Strategies
- Confidence levels
- Statistics collection process
- Performance tuning techniques
Optional
- Real time projects
- Interview questions
