mindquest-technologies
The training for the software engineers and the academic students is given by Industry certified Professionals, having 5 - 8 yrs of Experience. Students We adhere to quality education by continues feedback system, personal attention towards the students
Courses
DATASTAGE
HYPERION
TERADATA
JAVA
SAS
.NET
PHP
MULTI MEDIA
Training Enquiry Form
LIVE PROJECTS
Up Date News

Live projects for Btec , MCA  & Msc;

 
 

 TERADATA

   DATA WAREHOUSING CONCEPTS
   
 
  • About Data Warehouse & Data Warehousing
  • Active Warehouse & Passive Warehouse
  • Data Warehouse Usage Evolution
  • OLTP,DSS,OLAP & OLCP
  • SDLC ( DWD  Life cycle )
  • Schema Types ( Star, Snow etc....)
  • Characteristics of Dimension & Fact tables
  • ETL Process & Cleansing ( Parsing,Correcting,standardize,matching and Consolidate)
  • ER & Dimensional Model Overview
   
    INTRODUCTION TO TERADATA
   
 
  • Unique Features of  Teradata
  • Teradata System
  • Node Components
  • SMP & MPP
  • BYNET Hardware & Software
  • Communication Between Nodes
  • Teradata maximums
   
    TERADATA ARCHITECTURE
   
 
  • Architectural Flow
  • Shared Nothing Architecture
  • PE  with Explain
  • Visual Data Layout
   
    PRIMARY INDEX
   
 
  • Purpose of Primary Index
  • Non Unquie Primary Index   
  • Unique Primary Index
   
     SECONDARY  INDEX
   
 
  • Purpose of Secondary Index
  • Unquie Primary Index   
  • Non Unique Primary Index
   
   
    CREATING TABLES SYNTAX
   
 
  • Purpose of Primary Index
  • Non Unquie Primary Index   
  •  Non Unique  Secondary Index
   
    CREATING TABLES SYNTAX
   
 
  • General Create Table Syntax
  • Teradata Create Table Syntax
  • Create Set Tables
  • Create MultiSet Tables
  • Copy Table to Table
  • Partitio Primary Index Tables
  • Partition With CASE ,RANGE
   
    TERADATA SQL
   
 
  • SQL Basics
  • Teradata Punctuation
  • Help,Show,Explain
  • Working With Nulls
  • And,Or, Not,Between & Like
  • Aggregates
  • Sub Queries & Co-related Sub Queries
  • Aliasing,Title,Cast & Format
  • Interrogating Data 
   
    TYPES OF TABLES
   
 
  • Set and Multiset Tables
  • Volatile Tables
  • Derived Tables
  • Global Temporary Tables
   
    TERADATA SPACE
   
 
  • Perm Space
  • Spool Space
  • Temp Space
  • Performance Tuning  with Spaces
   
    JOINS
   
 
  • Join Types (Inner,Outer & self)
  • Join Strategies (Merge, Nested,Exclusion & Product Joins )
  • Join Index ( Single & Multi Table ) 
   
    SET OPERATORS
   
 
  • Union/Union  All
  • Intersect
  • Except or Minus  
   
    VIEWS
   
 
  • Purpose of  View  
  • Create View Syntax
  • Usage
   
    MACROS
   
 
  • Purpose of Macro 
  • Create Macro Syntax
   
    DATE AND TIMES
   
 
  • Teradata Key words 
  •  Storage of dates on Disk
  • DATEFORM
  • ADD_MONTHS Command
  • EXTRACT Command
  • System Calender
  • System Calender with Date Comparison
  • INTERVAL  Processing  with Date and Time
   
    RANK FUNCTION AND QULIFY USAGE
   
 
  • Rank  Functions
  • Qualify Usage
  • Rank  with OLAP functions
   
    OLAP  FUNCTIONS
   
 
  • CSUM 
  • MSUM
  • MAVG 
   
    TERADATA UTILITIES
   
 
  • MLOAD
  • FLOAD
  • FAST EXPORT
  • BTEQ
   
    LOCKS
   
 
  • Exclusive
  • Write
  • Read
  • Access 
   
    PROTECTION  FEATURES
   
 
  • Fallback
  • Raid
  • Clique
   
     STORED PROCEDURE
   
 

 

         PERFORMANCE TUNING

 

 

   
    PROJECT EXPLANATION
   
 
  • Spec's Overview
  • Working with All Utlities
  • SCD Implementations

 

Training Enquiry Form
Home|Careers |Privacy Policy | Terms& Conditions |Disclaimer| Accessibility|Contact Us
2005-2009 all rights reserved Mind Quest Technologies