Login

Register

Login

Register

Login

Register

Teradata Course

Hadoop is developed by Apache Software Foundation which is an open source framework used to process large sets of data such as Big Data and for distributed storage.

Teradata DBA Training

TERADATA ONLINE TRAINING

Teradata is a fully scalable relational database management process produced by Teradata Corp. It is mostly used to manage large data for warehousing operations.
The Teradata database process is based on off-the-shelf symmetric multiprocessing know-how combined with communication networking, connecting symmetric multiprocessing systems to form large parallel processing systems.
Teradata acts as a single data store that accepts a large number of concurrent request from multiple client applications.

TERADATA ONLINE TRAINING

Teradata is a fully scalable relational database management process produced by Teradata Corp. It is mostly used to manage large data for warehousing operations.
The Teradata database process is based on off-the-shelf symmetric multiprocessing know-how combined with communication networking, connecting symmetric multiprocessing systems to form large parallel processing systems.
Teradata acts as a single data store that accepts a large number of concurrent request from multiple client applications.

TERADATA ARCHITECTURE & IT’S COMPONENTS

• Node Architecture (Shared Architecture)
• SMP Architecture
• MPP Architecture
• Parsing engine(PE) Architecture
• AMP Architecture &usage
• Bynet Benefits and types
• Parallel data extension-(PDE)
• Teradata directory program(TDP)
• Call level interface-(CLI)
• Trusted parallel application-(TPA)
• Virtual processors
• Bynet 0 and 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 and RAID 5
• Journals and types
• Virtual Disk Array
• How & where is used journals
• Q and A about data recovery

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 and 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

• TERADATA MEMORY SPACES
• Permanent spaces
• Temporary spaces
• Spool spaces
• Users spaces & PWD

TERADATA TRANSACTION MODES

• Batch mode
• BTET mode
• ANSI mode
• How Converted into others
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
• Advantages & its process
• Limitations of fast load
• Real time scripts
• Teradata MultiLoad
• Overview of Multi load
• Types of phages in MultiLoad
• Advantages & its process
• Limitations of MultiLoad
• Uses various types of operations
• Work on Multi tables
• Real time scripts
• Sample scripts
• Teradata Tpump
• Overview of Tpump
• Limitations of Tpump
• Work on Multi tables
• Real time scripts
• Sample scripts
• Teradata Fast Export
• How to export the data
• Passing parameters
• IN and OUT Modes
• Work on Multi tables
• Real time scripts
• Sample scripts
• Teradata SQL Assistant(Quarryman)
• Teradata performance monitor
• Teradata Administrator usage
• Teradata performance tuning on scripts

Want to have a course urgently or on Fast track. We can arrange you for a specialised training aimed only for you. Please get in touch with us with your requirements by mail or just fill in the Batch Enquiry form. We will get in touch with you with the slot times and other details with in 24 hours

For Priority Training contact below
  • eITCafe: trainings@eitcafe.com
  • India: 040 6678 6677
  • US: 630-636-0198

Support services

We know how hard it can be to find and keep a job when there are so many other things to worry about. Our support team is here to help break down the barriers which are blocking your road to employment.
If you are a Working Chance candidate, please don’t hesitate to ask for advice or support on any issues which are affecting your chances of finding a job.
For further information, please email jobsupport@eitcafe.com our Support and Training Manager.

Job Preparation

• Assistance with learning job seeking skills
• Resume creation
• Master application completion
• Dressing for success
• Job interview preparation

Job Development

• Assistance with completing applications online or in person
• Job development online, on foot, networking events, job fairs and established employer relationships to locate available positions in your job goal
• Job leads and information on attending hiring events
• Follow-ups on applications placed to request interviews.

How do you define Teradata? Give some of the primary characteristics of the same

Teradata is basically an RDMS which is used to drive the Datamart, Datawarehouse, OLAP, OLTP, as well as DSS Appliances of the company. Some of the primary characteristics of Teradata are given below.

  • Is capable of running on Single-nodes, as well as multi-nodes.
  • Parallelism is built into the system.
  • Very much compatible with the standards of ANSI.
  • Tends to act in the same way as a server.

It is an Open System that basically executes for UNIX MR-RAS, Suse Linux ETC, WIN2K, etc

What are the newly developed features of Teradata?

Some of the newly developed features of Teradata are: –

  • Automated temporal analytics
  • Extension in the compression capabilities which allows flexible compression of data about 20 times more data than the previous version.
  • Customer associated innovation like tetradata viewpoint.

Highlight a few of the important components of Teradata.

Some of the important components of Teradata are: –

  • Bynet
  • Access Module Processor (AMP)
  • Parsing Engine (PE)
  • Virtual Disk (vDisk)
  • Virtual Storage System (VSS)

. Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

All you have to do is perform execution in UNIX in the way as mentioned below.

$Sh > BTEQ < [Script Path] > [Logfile Path]
or
$Sh > BTEQ < [Script Path] TEE [Logfile Path]

In Teradata, how do we Generate Sequence?

In Teradata, we Generate Sequence by making use of Identity Column

Key Features

metricsnew-75x75

Overview of Course and Learning analytic’s

teacher-75x75

Learn from Certified and Expert Trainers

Customized Course as per your requirement

24/7 online support for the course learners

High Quality E-learning Content for learning

videos

Access to the Recorded Sessions and classes

Flexible Course timing and Payment terms

Live Practical Oriented Approach for learners

Course Curriculam