Flexi is a Video Recording of Live Online + Official Courseware + Hands-on Labs

Live Online
+
On Demand
=
Flexi

Includes:

  1. 6 months access to recordings.
  2. Access via Laptop, Tab, Mobile, and Smart TV.
  3. Certificate of completion.
  4. Official Courseware
  5. Hands-on labs

We do not have a fresh Live Online Recording for the course. It can take 4-5 days to edit a recording. If your need is urgent, request for an un-edited version.


Teradata is a Rare course. Hence priced at $199. Other Flexis are for $99.
You can also purchase an annual plan for USD 999. For one year, all Flexi Videos will be free for you. Buy Annual Plan

Flexi Video

USD 199

Official Courseware

N/A

Hands-On-Labs

NA

Total

USD 199

100% Refund for Flexi Video (courseware is non-refundable) if user is not satisfied with the Video and seeks refund within 30 days of purchase.

Download Course Contents
Module 1: Introduction
  • What is Teradata
  • Overview of Teradata
  • Data warehouse concepts
  • Teradata Architecture
  • SMP Architecture
  • MPP Architecture
  • AMP(Access Module Processing)
  • TDP(Teradata Directory Program)
  • 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
  • Keys Vs Indexes
  • 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
  • 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
  • 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
  • How to use Sql Assistant
  • Query Processing
  • Importing and exporting
  • Teradata load and unload utilities
  • 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 Multi Load
  • Various Phases of Multi Load
  • Advantages and Process
  • Limitations of Multi Load
  • Working with multiple tables
  • Applying various operations
  • Sample Scripts
  • Teradata Fast Export
  • Advantages and Process
  • Limitations of Fast Export
  • Sample Scripts
  • 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 and Explain Utility
  • Explain Usage
  • Collecting Statistics
  • Tuning SQL Performance
  • Explaining various SQL statements
  • 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.

Learn more about Koenig. Download Presentation Buy Other Flexi

FAQ's

Yes, you can pay from this web page.
Yes, the site is secure by utilizing Secure Sockets Layer (SSL) Technology. SSL technology enables the encryption of sensitive information during online transactions. We use the highest assurance SSL/TLS certificate, which ensures that no unauthorized person can get to your sensitive payment data over the web.
We use the best standards in Internet security. Any data retained is not shared with third parties.
You will be provided access to LET ( Learning Enhancement Tool), where you will get the links to access all your purchases.
Flexi video for the new version will be provided free of cost.
6 months from the date of delivery.
Yes, you do. Flexi Videos do not include Courseware or Labs.
Yes, contact us for corporate packages.
Yes, c/w and Lab are not included in the annual plan. All Flexi videos are included.
It is only for one user.
Videos can only be streamed and not downloaded.
We do not track the pass rate of Flexi students. However, we trust it will be lower than for Live Online.
Presently, Flexi is only available in English.
It’s a unique subscription plan where customers can avail unlimited Flexi courses within a year.
The subscription plan is valid for 1 year from the date of purchase.
No, this is limited to one user and its non-transferable.

Feedbacks from Clients