call +91-9347045052  /   09032803895
php new batch started
php training courses
seo Training Institute
php Training Institute
request for quote
request for quote for website
Joomla Training Hyderabad
Wordpress Training Hyderabad
Online Joomla Training
Online Wordpress Training
Online Web Designing Training
Online Drupal Training institute

Questions? Comments? Contact us.

Address Inquiries

Sai Datta apartment, 4th Floor
Dilsukhnagar , Near Vasan Eye Care Hospital
Beside Tirumala Music Center,Dilsukhngar, HYD

Call me at: +91-9347045052  /   09032803895 | 08500679873

Course Inquiries

New Batch Timing

PHP and CMS website Help??

professional Freelance web designer company hyderabad
 

teradata Training

teradata TRAINING ONLINE AND CLASSROOM

Teradata is an enterprise software company that develops and sells a relational database management system (RDBMS). Teradata is considered as a “Data ware house system”, which can manage data, store data & BAR (BACKUP, ARCHIVE &RESTORE) data.

Teradata online training shares the knowledge of gathering the data from multiple sources and makes it available for the analysis. Teradata training online in big classes deals with Teradata 13.10 & Teradata 14.

teradata Course Modules

WHAT IS TERADATA WHY FOR IT IS WHAT FOR IT IS

  • What is Teradata?
  • Teradatav12 & versions
  • Teradata History
  • Real time Issues & resolving

 

  • Teradata users scalability
  • Teradata &other RDBMS
  • Teradata warehouse

 

  • Teradata in the Enterprise
  • Interview Q&A and Certification queries

 

TERADATA ARCHITECTURE & IT’S COMPONENTS

  • Node Architecture(Shared Architecture)
  • SMP Architecture
  • MPP Architecture
  • Parsing engine(PE) Architecture
  • Bynet Benefits &types
  • Parallel data extension(PDE)
  • Teradata directory program(TDP)
  • Call level interface(CLI)
  • AMP Architecture &uses
  • Trusted parallel application(TPA)
  • Virtual processors
  • Bynet 0 &Bynet 1
  • Parallism Architecture

RECOVERY &PROTECTION OF DATA

  • What is fall back &where it used
  • Why for fall back
  • What is Clique
  • AMP Clustering
  • & types for simultaneous Access
  • Why for locks &how to release
  • RAID 1 &RAID 5
  • Journals &types
  • Virtual Disk Array
  • How & where is used journals
  • Q & A about data recovery

TERADATA INDEXES

  • Types of indexes in Teradata
  • Hash index
  • Join index

 

  • Primary index(unique, non- unique)
  • Secondary index(unique, non- unique)

 

  • Skewness
  • Keys & indexes (How & why these used)

 

HOW TO STORAGE & RETRIEVAL OF DATA

  • Hash algorithm
  • hash
  • Hash map
  • Hash bucket
  • Receiving VDisc

TERADATA SQL QUARRYMAN

  • SQL fundamentals
  • Data types and literals

 

  • DDL Statements
  • DML Statements

 

  • Teradata naming conversing

 

TERADATA SQL QUARRYMAN

  • SQL fundamentals
  • Data types and literals

 

  • DDL Statements
  • DML Statements
  • Teradata naming conversing

TERADATA SQL FUNCTIONS & OPERATIONS

  • String functions
  • Format functions
  • Cast functions
  • Cast functions
  • Group & Aggregation functions
  • Logical operations
  • Arithmetic operations

 

  • set operations
  • join operations
  • conditional expressions

 

TERADATA JOIN STRATEGIES & UNIONS

  • hash join
  • merge join
  • nested join
  • product join
  • inner join
  • left & right outer join
  • full outer join

TERADATA BASIC COMMANDS

  • Help
  • Show
  • Explain
  • Collect statistics

TERADATA OBJECTS

  • Set tables
  • Multi tables
  • Volatile tables
  • Global temporary tables
  • Views
  • Macros
  • Stored procedures
  • Triggers
  • TERADATA MEMORY SPACES
  • Permanent spaces
  • Temporary spaces
  • Spool spaces
  • Users spaces & PWD

Call on 9347045052 for complete details about the course
courseCourse Enquiry
CONTACT FOR COURSE FEE ENQUIRY
Name
Email
Phone
Course
Batch Timing?
Training Type?
Country ?
Message