Vantage : Advanced SQL Engine Physical Implementation

Course Description

This course defines the processes and procedures to follow when implementing a Teradata Vantage Advanced SQL Engine system. It provides a technical and detailed description of Data Storage & Access as well as Optimization processes like Indexing, Row and Column partitioning, NoPI tables, collecting Statistics, understanding EXPLAIN plans, and Join Indexes.

Prerequisites

To get the most out of this training, you should have the following knowledge or experience.

  • Introduction to Teradata Database
  • Teradata SQL
  • Teradata Advanced SQL
  • Familiarity with Relational Database Modeling

Target Audience

This course is designed for:

  • Database Administrators
  • Data Architects / Engineers
  • ETLs / Application Developers

Learning Objectives

Upon accomplishment of this course, participants will be able to:

  • Explain the distinction between logical and physical data models
  • Discuss the features of Teradata's parallel architecture
  • Understand Teradata data distribution and hashing
  • Know how to analyze design criteria and choose indexes and partitioning
  • Create and populate tables with unique, non-unique, and no primary indexes
  • Create and populate tables with row partitioning and column partitioning
  • Create and populate Temporal tables
  • Create and populate Time Series tables
  • Understand and effectively use Multi-Value Compression
  • Apply database sizing criteria
  • Collect statistics
  • Use of the EXPLAIN facility

Content Outline

The course covers following topics in detail:

  •  Difference between logical and physical data models
  •  Teradata's parallel architecture
  •  Teradata data distribution and hashing
  •  Analyze design criteria and choose indexes and partitioning
  •  Create and populate tables with unique, non-unique, and no primary indexes
  •  Create and populate tables with row partitioning and column partitioning
  •  Create and populate Temporal tables
  •  Create and populate Time Series tables
  •  Understanding and effectively using Multi-Value Compression
  •  Apply database sizing criteria
  •  Collect statistics
  •  Use of the EXPLAIN facility

FAQs

To attend the training session you should have an operational Desktops or Laptops with required specification along with good internet connection to access the labs.

We would always recommend you to attend the live session to practice & clarify the doubts instantly and get more value from your investment. However, due to some contingency if you have to skip the class Radiant Techlearning would help you with the recorded session of that particular day.  However, those recorded sessions are not meant only for personal consumption and NOT for distribution or any commercial use.

 

Radiant Techlearning has a data center containing the Virtual Training environment for the purpose of participant’s hand-on-practice. 

Participants can easily access these labs over Cloud with the help of remote desktop connection. 

Radiant virtual labs provide you the flexibility to learn from anywhere in the world and in any time zone. 

 

The learners will be enthralled as we engage them in real world and industry Oriented projects during the training program. These projects will improve your skills and knowledge and you will gain better experience. These real time projects, they will help you a lot in your future tasks and assignments.

 

Send a Message.


  • Enroll
    • Learning Format: ILT
    • Duration: 80 Hours
    • Training Level : Beginner
    • Jan 29th : 8:00 - 10:00 AM (Weekend Batch)
    • Price : INR 25000
    • Learning Format: VILT
    • Duration: 50 Hours
    • Training Level : Beginner
    • Validity Period : 3 Months
    • Price : INR 6000
    • Learning Format: Blended Learning (Highly Interactive Self-Paced Courses +Practice Lab+VILT+Career Assistance)
    • Duration: 160 Hours 50 Hours Self-paced courses+80 Hours of Boot Camp+20 Hours of Interview Assisstance
    • Training Level : Beginner
    • Validity Period : 6 Months
    • Jan 29th : 8:00 - 10:00 AM (Weekend Batch)
    • Price : INR 6000

    This is id #d