Teradata Vantage Training
Teradata Vantage training covers concepts from the Basic level to the advanced level. Whether you are an individual or corporate client we can customize training course content as per your requirement. And can arrange this Teradata Vantage training as per your pace.
Teradata Vantage is the latest analytics platform that integrates open source and commercial analytic technologies together to begin insights, solve complex business problems, and allow graphic, anticipating and prescriptive analytics, which escorts to autonomous decision-making. Teradata Vantage delivers analytic processing across workable deployment options, including public clouds, multi-cloud and hybrid-cloud environments. Teradata Vantage authorizes all sizes of enterprises to purchase software in more adaptable ways based on specified use cases through simplified pricing bundles, subscription-based licenses, as-a-service and elastic billing options. Teradata Vantage future-proofs buying decisions with the Teradata software license mobility that allows flexibility to move analytics across deployment options. Teradata Vantage marks the capabilities the modern data-driven enterprise demands. Teradata Vantage totally supports all the three data integration techniques such as Data Consolidation, Data Propagation and Data Federation. The most well-known Teradata assisted unquestionably is data consolidation technique. Teradata Vantage can also be deployed on the sending and receiving end when using the Data Propagation technique, but last but not the least is that Teradata Vantage also supports the Data Federation technique.
Complete Customization of Teradata Vantage training’s course content is possible for Individual students and for Corporate. Teradata Vantage online training is available for individuals and for corporate we may arrange the classroom as well. For more information on Teradata Vantage training do connect us.
Our Teradata Vantage certified expert consultant will teach on a real-time scenario-based case study and can provide study material and ppt. We will help you to clear your Teradata Vantage training certification by providing you with proper guidance. For more details kindly contact us.
When it comes to Teradata Vantage Corporate Training, we can say proudly that we have received excellent feedback and appreciation from our corporate clients across the globe. You can reach us for Teradata Vantage corporate training and we can even customize the training content as per your requirement.
Few of the clients we have served across industries are:
DHL | PWC | ATOS | TCS | KPMG | Momentive | Tech Mahindra | Kellogg's | Bestseller | ESSAR | Ashok Leyland | NTT Data | HP | SABIC | Lamprell | TSPL | Neovia | NISUM and many more.
MaxMunus has successfully conducted 1000+ corporate training in Bangalore / Bengaluru, India, Finland, Sweden, Germany, USA, UK, Netherlands, Ireland, Austria, Israel, Singapore, Australia, Canada, Denmark, Belgium, Poland, Hong Kong, Qatar, Saudi Arabia, Oman, Denmark, Bahrain, JAPAN, South Korea, UAE, Switzerland, Kuwait, Spain, United Kingdom, Russia, Czech Republic, China, Belarus, Luxembourg

INDIVIDUAL TRAINING BENEFIT
Customize Teradata Vantage Course Content as per Individual’s project requirement.
Our Individual Teradata Vantage Training program will help employees to start working on the project from day one after the Teradata Vantage training completion.
Industry-Specific Subject Matter Experts to provide corporate level Teradata Vantage online training to individuals.
Flexibility to choose a schedule for the individual’s to take Teradata Vantage online training courses.
Get the Flexibility to learn at your own pace. A Crash course option is also available for the Teradata Vantage course.
Flexibility to select a trainer and have a live video session with the trainer before Teradata Vantage training actually starts.
MaxMunus will provide Teradata Vantage Course Completion Certificate to the participants who are recognized by the industry. It will add value to the corporate workforce.
MaxMunus will help the participants understand the Teradata Vantage certification training exam process.
MaxMunus will provide a step-by-step progress assessment of yours.
Course Content
Module 1 - Physical Database Design Overview
~ Data Warehouse Usage Evolution
~ The Stages of Database Development
~ Customer Service Logical Model – ERA Methodology
Diagram
~ Different Models, Different Terms
~ Attributes
~ Entities and Relationships in the LDM
~ Normal Forms
~ Normalization
~ Database Design Components
~ Understanding Change Rating
~ Understanding Access
~ Extended Logical Data Model
~ Physical Data Model
~ The Principles of Index Selection
~ Review Questions
Module 2 - Building the Database Environment
~ The Teradata Hierarchy
~ Owners, Parents, and Children
~ Creating Objects
~ Permanent Space Terminology
~ Spool and Temp Space Terminology
~ Assigning Space Limits
~ Summary
~ Review Questions
~ Lab Exercises
Module 3 - Data Distribution and Hashing
~ Data Distribution
~ Hashing
~ Primary Index Hash Mapping
~ Hash Maps
~ Primary Hash Map
~ Hash Maps for Different Systems
~ Fallback Hash Map
~ Reconfiguration
~ MAPS TD 16.10 Reconfiguration
~ MAPS TD 16.10 Sparse Maps
~ Hash Related Expressions
~ Hashing – Numeric Data Types
~ Multi-Column Hashing
~ Additional Hash Examples
~ Using Hash Functions to View Distribution
~ Row Retrieval via PI Value – Overview
~ Names and Object IDs
~ Table ID
~ Row ID
~ AMP File System – Locating a Row via PI
~ Accessing the Row within the Data Block
~ General Row Layout
~ AMP Read I/O Summary
~ Review Questions
~ Lab Exercises
Module 4 - File System Writes
~ AMP Write I/O
~ New Row INSERT
~ Master Index Access
~ Cylinder Index Access
~ Use Free Space within Block
~ Expand the Block
~ Block and Row Terminology
~ Block Splits (INSERT and UPDATE)
~ Cylinder Full
~ Mini-Cylpack
~ Space Utilization
~ 1MB Data Blocks
~ 1MB Table Headers (TD14.10)
~ Summary
~ Review Questions
Module 5 - DBS Control Settings
~ System Level Defaults
~ DBS Control Record – General Fields
~ MaxDecimal
~ Date and Time Parameters
~ Primary Index Defaults
~ DBS Control Record – File System Fields
~ Free Space Percent
~ MiniCylPackLowCylProd
~ DefragLowCylProd
~ PermDBSize
~ PermDBAllocUnit
~ JournalDBSize
~ Cylinders Saved for Perm
~ Merge Datablocks
~ Teradata 14.10 – 1MB Spool Rows
~ DBS Control Record – Performance Fields
~ DisableSyncScan
~ ReDistBufSize
~ Support of Hash Joins
~ DBS Control Record – Compression
~ Enabling Compression
~ Controlling Compression Operations
TERADATA
PHYSICAL
DATABASE
DESIGN
~ Temperature Based Block Level Compression
~ Summary
Module 6 - Analyze Primary Index Criteria
~ Primary Index Choice Criteria
~ CREATE TABLE – Indexing Rules
~ Primary Index Characteristics
~ Multi-Column Primary Indexes
~ Primary Index Considerations
~ PKs and Duplicate Rows
~ Primary Index Demographics
~ Column Distribution Demographics for a PI Candidate
~ SQL to View Data Demographics
~ TableSize View
~ SQL to View Data Distribution
~ Summary
~ Review Questions
~ Lab Exercises
Module 7 - Tables without a Primary Index
~ What is a NoPI Table?
~ Reasons to Consider Using NoPI Tables
~ Creating a Table without a PI
~ Distribution of Rows (or Blocks) for a NoPI Table
~ The Row ID for a NoPI Table
~ Loading Data into a NoPI Table (SQL)
~ Loading Data into a NoPI Table (Utility)
~ Archive and Reconfig Issues
~ NoPI Table Options
~ Summary
~ Review Questions
Module 8 - Secondary Index Usage
~ Secondary Indexes
~ Choosing a Secondary Index
~ Secondary Index Subtables
~ USI Subtable General Row Layout
~ USI Hash Mapping
~ NUSI Subtable General Row Layout
~ NUSI Hash Mapping
~ Secondary Index Considerations
~ Single NUSI Access (Between, Less Than, or Greater
Than)
~ Dual NUSI Access
~ EXPLAIN of ORed NUSI’s
~ NUSI Bit Mapping
~ EXPLAIN of a SELECT (BMSMS)
~ Value-Ordered NUSIs
~ Hash-Ordered NUSIs
~ Hash-Ordered NUSI Example
~ Covering Indexes
~ NUSI vs. Full Table Scan (FTS)
~ Accessing Rows
~ Guidelines for Typical Behaviour
~ Secondary Index Considerations
~ Secondary Index Usage
~ Summary
~ Review Questions
Module 9 - Partitioned Primary Indexes
~ Partitioned Primary Indexes (PPI)
~ Logical Example of Row Partitioning
~ How is Partitioning Implemented?
~ PPI Details
~ Primary Index Access (Non-partitioned Table)
~ Primary Index Access (Row Partitioned Table)
~ Simple Partitioning Example
~ Partitioning with CASE_N and RANGE_N
~ Special Partitions with CASE_N and RANGE_N
~ NO CASE (NO RANGE) or UNKNOWN
~ TIMESTAMP PPI
~ SQL Use of PARTITION Key Word
~ SQL Use of CASE_N
~ Using ALTER TABLE
~ With Row Partitioned Tables
~ Populated Tables
~ NO RANGE is not Defined
~ NO RANGE is Defined
~ WITH DELETE
~ DROP/ADD
~ ADD Clause on Partitioning Expression
~ ALTER TABLE TO CURRENT
~ EXPLAIN Terminology for PPI Tables
~ Example 6 – Partition Elimination with a PPI Table
~ Multilevel Partitioning Concepts
~ How is the MLPPI Partition # Calculated?
~ Summary
~ Review Questions
~ Lab Exercises
TERADATA
PHYSICAL
DATABASE
DESIGN
Module 10 - Compression Forms
~ Teradata Data Types
~ Character Sets
~ Table Headers
~ Presence Bits
~ Multi-value Compression
~ Presence Bits and Compression
~ Implementing Multi-value Compression
~ ALTER TABLE and Compression
~ Multi-value Compression Considerations
~ Algorithmic Compression
~ Block Level Compression Options
~ Temperature-Based Block Level Compression
~ Defining Temperature Data
~ Advantages of Temperature-Based Compression
~ BLC Groups
~ DDL Compression Options
~ Compression Capabilities
~ SQL Interface for FERRET
~ DBC.CreateFsysInfotable – SHOWBLOCKS
~ SHOWBLOCKS (Short) Output Example
~ DBC MACROS with SHOWWHERE
~ DBC.PopulateFsysInfoTable Content Examples
~ Summary
~ Review Questions
~ Lab Exercises
Module 11 - Access Considerations and Constraints
~ Access Method Comparison
~ Optimizer Access Scenarios
~ Partial Value Searches
~ Storing Numeric Data
~ Data Conversions
~ Matching Data Types
~ Counting I/O Operations
~ Transient Journal I/O
~ Table Level Attributes
~ Column Level Constraints
~ Table Level Constraints
~ Altering Table Constraints
~ Summary
~ Review Questions
~ Lab Exercises
Module 12 - Referential Integrity
~ Referential Integrity Overview
~ Parent-Child Relationships
~ Three Types of Referential Constraints
~ Processing Cost of Referential Constraints
~ Fixing Referential Integrity Problems
~ Standard Referential Integrity
~ Batch Referential Integrity
~ Soft Referential Integrity
~ Referential Integrity
~ Join Optimization with RI
~ Summary
~ Review Questions
~ Lab Exercises
Module 13 - Optimizer and Collecting Statistics
~ Teradata Optimizer
~ Optimizer – Cost Based vs. Rule Based
~ Optimizer Statistics
~ Optimizer’s Search for Statistics
~ Optimizer – Dynamic AMP Samples
~ Optional Adjustments for Dynamic AMP Samples
~ Dynamic AMP Sampling – How it Works
~ Optimizer Estimate without Collected Statistics
~ Statistics
~ Statistics Data – What is Collected?
~ COLLECT STATISTICS Command
~ Collecting Statistics
~ Refresh or Re-Collect Statistics
~ COLLECT STATISTICS Command (Index Format
with 14.0 Options)
~ COLLECT STATISTICS on a Data Sample
~ Collecting Statistics – 14.0 Examples
~ Statistics
~ Optimizer’s Use of Statistics with Uneven NUSI
~ Collecting Statistics on PARTITION
~ Copying STATISTICS
~ Statistics Extrapolation
~ Additional Statistics Options
~ Teradata 14.0 Enhancements
~ Teradata 14.10 Enhancements
~ Teradata 14.10 Re-Collect Enhancements
~ COLLECT STATS Using THRESHOLD Options
~ Teradata 14.10 AutoStats
~ Stats Manager
~ Summary
~ Review Questions
~ Lab Exercises
TERADATA
PHYSICAL
DATABASE
DESIGN
Module 14 - Join Processing Analysis
~ Join Types vs. Join Strategies
~ Product Join
~ Product Join Explain
~ Product Joins
~ Merge Join with Duplication and Sorting
~ Merge Join Strategy
~ Merge Join with Row Redistribution
~ Merge Join with Redistribution Explain
~ Merge Join with Matching Primary Indexes
~ Merge Join on Matching Primary Indexes Explain
~ Alternative to Using OR Join Conditions
~ Exclusion Joins
~ Exclusion Merge Join Explain
~ Inclusion Merge Join Explain
~ Hash Joins
~ n-Table Joins
~ Three-Table Join Explain
~ Partial Redistribution and Partial Duplication (PRPD)
~ PRPD Join Steps Simplified
~ 14.10 EXPLAIN Terminology & Modifiers
~ Nested Joins
~ Nested Join Explain
~ Join Considerations with Partitioned Tables
~ NPPI to PPI Join – Many Partitions
~ NPPI to PPI Join – Sliding Window
~ NPPI to PPI Join – Hash Ordered Spool File Join
~ PPI to PPI Join – Rowkey-Based Join
~ PPI to PPI Join – Unmatched Partitions
~ Join Processing Observations
~ Index Choice Guidelines
~ Summary
~ Review Questions
~ Lab Exercises
CORPORATE TRAINING BENEFIT
Customization of Teradata Vantage Course Content as per Company’s project requirement.
Our Teradata Vantage Corporate Training program will help employees to start working on the project from day one after the training completion.
Industry-Specific Subject Matter Experts will provide Teradata Vantage corporate training.
Get Flexibility to choose Location, Mode and Schedule for Teradata Vantage corporate training courses.
Flexibility to select corporate the trainer and have a live video session with the trainer before Teradata Vantage training actually start.
MaxMunus will provide Course Completion Certificate to the participants which are recognized by the industry. It will add value to the corporate workforce.
MaxMunus will help the participants understand the Teradata Vantage certification course exam process.
MaxMunus will provide a step-by-step progress assessment of employees.
Course Duration
Course Duration:- 25-30 Hours.
Training Mode: Live Instructor-Led.
Trainer- Real-Time.
Training Time- Weekdays/ Weekend.
Connecting Tool- GoToMeeting/ Skype.
Video
Request For Demo
Training is going good till now, I can confidentially say I have gained immense knowledge on AWS. Trainer himself is certified and very knowledgeable
Trainer attends all the questions patiently and explains everything clear to the point regardless how many times you ask the same thing
Content of training also covers the relevant topic required in market; also the contents are explained clearly with practical knowledge.
Way to him, we feel satisfied for picking you up as our trainer.
Practical explanations and examples, hands-on approach, easy to follow and apply the concepts. Very much enjoyed the real world examples.
Simon Phil- Manhattan WMS
First of all I would like to thank to my friends who opted me Maxmunus to learn azure training, Its wonderful & helpful to taking this training which promote my technical knowledge and expand my carrier opportunities.
The instructor is extremely Excellent. He is more knowledgeable , trained with material oriented, willing to help any student at anytime, with any clarifications.
It should be helpful who is looking for taking up Azure Architect Certifications . Maxmunus's peoples are more acceptable in the way that timing and facilities.
I have attended AWS Solution Architect course. It was one of the best training i attended in my career. I got the practical 70% and theory 30% knowledge which i think best combination. I would really thankful to Maxmunus.Please keep up the good work. Thank you.
AWS course was truly wonderful and amazing Course for me and great experience with all of you. Especially the trainer who thought us each and thing regarding this course. He has vast experience and expertise in his field. I have learned so much. Above all, his obvious passion for training has been inspiring and extremely motivating. I have not experienced this level of passion and commitment with any other trainer.
Thank you so much.
The trainer offers quality AWS training that was the most in-depth and comprehensive. I am especially glad to note that he came with extensive experience, knowledge and has the patience to make each one of us grasp even the tough concepts. I am so much thrilled about the course. Thanks for the excellent support of Maxmunus Team.
And also please help me If I struck with Alfresco in Future.
Outstanding. I am very happy with the content and delivery of the training. The trainer was very experienced and covered everything in deep detail.
Mohan Nagaraju- TOGAF
The course is very well designed, well adapted and well delivered. The infrastructure to deliver the course is cuttung edge and latest. The style of delivering with reference to live projects is commendable. The trainer can connect to the audience and very helpful. I would recommend the course to all.
AWS Cloud faculty is an exceptional teacher at maxmunus solutions . He combines experience with knowledge. Other Training Institutes may offer just good training but maxmunus offers much more than just good training. It prepares you for the "Real World" and bridges the gap between the "Industry Expectations" and your own shortage of skills.. Any one looking for some real time , hands on training on Aws cloud just go and join maxmunus solutions.
Training was excellent.
The trainer is very knowledgeable, and it’s a great opportunity to improve our knowledge and way of working in real time .
The communication between the trainer and the students is very good; we will not stuck at any point when you are practicing the things.
The provided Documents , videos and ppts are very helpful to revise the topics .
Trainer provided Communication channels like whatsapp, slack are very useful to share the knowledge.
The trainer has very good knowledge on the subject. Most importantly throughout the session, he has been very energetic and delivered the best to explain. The best part is he was proactively clarifying the areas whenever he used to feel we are not clear.He was well versed with the subject, very patient in answering queries and good at sharing his own work experience.
I found the trainer to be very knowledgeable in the field of WMS. He explained each and every concept in detail and answered my questions with a lot of enthusiasm.
He brings a ton of experience from his current role and responsibility from operations which, I found very useful as part of the training.
He was punctual and never got frustrated by the questions asked. When he was not fully prepared, he took notes to go back and research. My queries were answered with the detailed demonstration.
He took a lot of effort in preparing solid documentation which, shows his strength in Operations and sustain.
I wish him the very best in his future endeavors.
Maxmunus provided a smooth online passage through Video conferencing for the duration of the training. Logistics worked well.
Maxmunus arranged a professional, punctual and very knowledgeable resource to conduct this training.
Maxmunus did not interfere in the overall scheduling and daily sessions and gave the trainer the flexibility to lead and drive the training.
Sincerely appreciate the trainer for conducting this course. Thanks a lot.
Windchill training was OUTSTANDING. I got what i was looking for, thanks to the trainer for every help.
Mayank T- Windchill PLM
The institute management is very supportive. They had arranged a demo online class before I choose to go for the registration. Really appreciate the way the trainer try to explain the things in a professional manner. Overall a very good institute and I would like to recommend this for Azure training.
This training is different from other online courses available in the market as it has extensive hands on session with practical example and also knowledge is shared how in Industry it is being used extensively . I recommend this training to anyone who wants to pursue his/her career in AWS Cloud journey.
This by far one of the best training i have taken i have taken in a long time. I appreciate the effort put by the trainer in completing the course. 10/10
Rohit P- Qliksense Training
I am 100% satisfied & Thanks for the wonderful training. I really appreciate all your efforts to straighten me up.
Once again thanks for answering all my questions each and every day thoroughly.
Hi Nitesh,
Thanks for introducing Kumar to me. I was my pleasure working with you both. Great service and support.
Babu Rajendaran-JDA WMS Training
I would give more than 5 star for AWS training by the trainer. He has excellent knowledge and teach very well. He goes everybody systems and resolves the issues during the training session. He provides different use cases for each topics during the training sessions and provides good theoretical knowledge. I liked his training very well.
Training was good with hands on over various modules of AWS. Trainer has good command over topics and explained clearly about various scenarios. Several topics were discussed and could have been little slower as I am from totally a different background without knowledge into much of the IT infrastructure. Access to training videos and slack of trainer is an added advantage for getting in touch with the other team and gaining continous knowledge.
With the help of this training, I achieved my goal in getting into a step head of my career and becoming strong in AWS. Maxmunus really helped me to grow, and had a good trainer who is advisable for choosing better career and has guided for completion of certification.
This review is a thank you note for the sincere effort put by the Liferay trainer in completing the course. I am very happy with the way he is explaining every concept with deep understanding of the subject. Very grateful.
Usman M- Liferay Training
I have joined as a trainee of Linux certification training course from MaxMunus. The classes went as per my scheduled time. And finished my Linux training last week and my overall experience was good. The training was perfect and the trainer had good knowledge about the subject. And covered all the related topics of Linux. Thanks to MaxMunus.
AWS training was outstanding and covered things in details. I am very happy with the outcome of the training. The trainer has very deep knowledge about the subject and training delivery was flawless. I would recommend this AWS training to everyone who wants to shift their career in AWS.
Rajiv S- AWS (Amazon Web Services)
I appreciate your patience answering all questions I asked during the class. You explained everything good.
I like the way you troubleshoot problems. Looks like what I do but you have a lot more experience. I found I am not alone in my troubles.
Now I have general idea what the main goals of the RP WMS are, and I have general guidelines what to look for when something goes wrong in the outbound process. I am not afraid of touching policies/rules because now I know more about the dependencies(especially when I have separate test instance :) ).
Thank you guys and I hope we'll keep in touch.
Very satisfied with overall IBM Curam training course. I am thankful to the trainer for giving extra support during my course. Appreciate.
Srikanth B- IBM Curam
I am getting trained in AWS infrastructure. I had a minimal knowledge of cloud computing. Trainer is so well versed I was able to grasp the cloud concepts easily. All the sessions so far are practical and I was able to setup my own website in AWS. Good to be part of this coaching academy.
I gained a lot of useful information on digital marketing. It is a great course and i am learning more than I imagined. OUTSTANDING.
Ketan Shah- Digital Marketing
I observed, that he is more technically sounds on everytopic he delivers and well versed with AWS concepts.
He ensures participants are activly engaged and making sure they've understood the concepts.
He keep-up the time, as he starts the class on time and ends it as per the interest of time.
All his classes are 90% pratical rather than running through the slides and explaining concepts theortically.
He never hestitate to clarify any questions/doubts being asked in the class, even if it is irrelevant to the topic being covered on that specific day.
He ensures everyone in the class have completed the lab excercise and in case of any clarification on completion, he helps us to fix the issue.
Overall the training is really good and the way trainer provided the insights on the concepts of AWS with respect to various real time examples really make me understand the concepts in a better way - I will certainly recommend my friends to join the course from Maxmunus.
Shailenkumar Mehta - AWS (Amazon Web Services)
Yes the training is complete and i am very much satisfied with the whole program. The trainer explained every concept quite clearly and didn't showed any discomfort in explaining the whole process in detail. The course was quite informative and if someone in my circle needs Manhattan training in the future i would definitely recommend your program.
Training was very good and it improved our AWS skills
1. Good course material and structured
2. Helpful Trainer even during the class / off-the class for completing the assignments
3. Good blend of business examples / technical content.
4. Quotes of good examples in the usage of technical concepts in a real-time scenario
5. Good real-time examples and work out in the class.
The trainer explains everything very thoroughly, and pays great attention to detail. I really do appreciate the time and effort you put into delivering such amazing training.
Sampat K- Alfresco Training
This is to update that the training provided by trainer was outstanding,it was very much descriptive,practical based & also our every query got answered. We also had some professional assistance from him which is much appreciated. Overall i am completely satisfied with the training & i have already recommended my friends & colleagues.
This is a great course and I've learned a lot from it! Truly appreciate your service.
Paul M- RedPrairie JDA
Training so far has been really good. The trainer has a very good knowledge on the subject and the way classes have been taken is very informative and practical. Looking forward to complete the ceritifcations and hoping that this training will help to find some good career oppurtunities.
Prasanth S Nair - AWS (Amazon Web Services)
