Teradata Training in Pune

TERADATA training in Pune

Teradata is a scalable relational database management system which is used to store, retrieve and manipulate Big data. Today all databases ar failing for Big Data warehouse. Teradata is only database which sustain in market as a result of it speed and linear measurability. TeraData Classroom Training at ETLHIVE  makes you an expert in using teradata and how to control database space, bigdata analytics, business analytics solutions, advanced teradata sql concepts, integrated data warehousing, etc.

Intended Audience

Database administrators, developers, data analysts, and professionals contributing in areas of business intelligence will find this course useful.

Prerequisites

Participants are expected to have basic Knowledge in SQL, general relational database knowledge and basic Unix commands.

 


Course Features

 

 

One Stop Solution!

   Ability to attend missed sessions

    Complete documentation

   Resume preparation

   Certification preparation.

   Interview preparation

   Placement assistance

Syllabus

 

  Introduction to Teradata

  • Teradata Architecture Overview
  • Teradata Vs. Other RDBMS
  • Collecting Statistics
  • BYNET
  • The Parsing Engine
  • PEs
  • AMPs
  • Vprocs
  • Clique
  • Cluster
  • Scalable Architecture
  • Data Storage
  • Data Distribution
  • Data Access
  • Nodes and MPP
  • Teradata Space Management
  • Fault Tolerance
  • Data Protection
  • Teradata Client Tools and Utilities

 

  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 JOIN STRATEGIES & UNIONS

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

TERADATA PERFORMANCE TUNING ON SQL ASSISTANCE

 

  • Usage of PMON
  • Explain usage
  • Collecting statistics
  • SQL tuning
  • Various SQL statements
  • Real time Issues & resolving
  • Teradata Utilities & Tools (Import & Export)
  • Teradata BTeq scripts
  • Overview of BTeq
  • Looping stages
  • Batches scripts
  • Import &export scripts with Examples
  • Error handling
  • Real time scripts
  • Teradata FastLoad
  • Types of phages & how to find it
 

 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 Functions & Operations
  • String functions
  • Format functions
  • Cast functions
  • Cast functions
  • Group & Aggregation functions
  • Logical operations
  • Arithmetic operations
  • set operations
  • join operations
  • conditional expressions
 

TERADATA OBJECTS TYPES OF TABLES

  • Set tables
  • Multi tables
  • Volatile tables
  • Global temporary tables
  • Derived tables
  • Views
  • Macros
  • Stored procedures
  • Triggers

TERADATA PERFORMANCE TUNING ON SQL ASSISTANCE

  • Usage of PMON
  • Explain usage
  • Collecting statistics
  • SQL tuning
  • Various SQL statements
  • Real time Issues & resolving
  • Teradata Utilities & Tools (Import & Export)
  • Teradata BTeq scripts
  • Overview of BTeq
  • Looping stages
  • Batches scripts
  • Import &export scripts with Examples
  • Error handling
  • Real time scripts
  • Teradata FastLoad
  • Types of phages & how to find it
 

 Teradata indexes

  • Types of indexes in Teradata
  • Hash index
  • Join index
  • Primary index
  • Secondary index
  • Skewness
  • Keys & indexes

Gallery

More

 

top
ETLHIVE is a Trademark of Itelligence Infotech Pvt Ltd.   *PMP®, PMBOK, PMI, PgMP, CAPM, PMI-RMP, and PMI-ACP are registered trademarks of the Project Management Institute, Inc. *ITIL®, IT Infrastructure Library, Swirl Logo, Prince2 are registered trademarks of AXELOS Limited.
19th Oct 2019 – Pimple Saudagar – Data Science : 4pm | AI : 4pm | Python : 12pm | AWS : 9am | Informatica : 11am | Salesforce : 11am | Tableau : 6pm(sun) | Devops : 2pm | Baner – Blockchain : 3.30pm | AWS : 9.30am | Nal Stop – Data Science : 6.30pm/5.30pm(wed) | Salesforce : 1pm | AWS : 4pm | Kharadi – Python : 3pm | Vashi – Devops : 11am | Data Science : 5pm | Python : 4.30pm | AWS : 2pm | Informatica : 4pm |