About Course
TeraData Course Description
Sun Trainings Teradata Training online course makes you an expert in using teradata and how to control database space, business analytics solutions, bigdata analytics, integrated data warehousing, advanced teradata sql concepts, etc.
Course Name: TeraData Online Training
faculty:Real time Experience
Frequently Asked Questions
- You will never miss a class at Suntrainings! You can choose either of the two options:
- 1. You can go through the recorded session of the missed class and the class presentation that are available for online viewing through the LMS.
- 2. You can attend the missed session, in any other live batch. Please note, access to the course material will be available for lifetime once you have enrolled into the course.
- Sun Trainings is committed to provide you an awesome learning experience through world-class content and best-in-class instructors.
- We will create an ecosystem through this training, that will enable you to convert opportunities into job offers by presenting your skills at the time of an interview. We can assist you in resume building and also share important interview questions once you are done with the training. However, please understand that we are not into job placements.
- We have limited number of participants in a live session to maintain the Quality Standards. So, unfortunately participation in a live class without enrolment is not possible. However, you can go through the sample class recording and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in the class.
- All instructors at Sun Trainings are senior industry practitioners with minimum 10 - 12 years of relevant IT experience. They are subject matter experts who trained by Sun Trainings to provide impeccable learning experience to all our global users.
- You can Call us at +91 9642434362 OR Email us at contact@suntrainings.com. We shall be glad to assist you.
TeraData Course Curriculum
- 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
- 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
- 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
- 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
- SQL Fundamentals
- Data Types and Literals
- Data Definition Statements(DDL)
- Data Manipulation Statements(DML)
- Explaining with proper examples
- String Functions
- Format Function
- Cast Functions
- Group & Aggregate Functions
- With & with by clauses
- Practices of this section
- 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
- HELP
- SHOW
- EXPLAIN
- COLLECT STATISTICS
- Tables
- SET table
- Multi Set table
- Volatile tables
- Global Temporary tables
- Derived tables
- Views
- Macros
- Stored Procedures
- Triggers
- Practices and FAQs of this session
- PERM space
- SPOOL space
- TEMPORARY space
- Teradata User and managing
- Practical Examples
- BTET
- ANSI
- Interactive
- Batch
- 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
- 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
Trainer Information
- Trainer has 15+ years of experience in IT industry.
