Tera Data

Course Requirements and Learning Objectives

Teradata

Teradata is a fully scalable relational database management system produced by Teradata Corp. It is widely used to manage large data warehousing operations.
The Teradata database system is based on off-the-shelf symmetric multiprocessing technology combined with communication networking, connecting symmetric multiprocessing systems to form large parallel processing systems.

Objectives:

What is Teradata?
Teradata architecture & it’s components
Recovery &protection of Data
Teradata indexes
How to storage & retrieval of data
Teradata SQL Functions & operations
Teradata join strategies & unions
Teradata basic commands,Objects

TERADATA V13 Developer

What is Teradata why for it is what for it is

What is Teradata?
Teradatav12 &versions
Teradata History
Teradata users scalability
Teradata &other RDBMS
Teradata warehouse
Teradata in the Enterprise
Interview Q&A and Certification queries
Real time Issues & resolving

Teradata architecture & it’s components

Node Architecture(Shared Architecture)
SMP Architecture
MPP Architecture
Parsing engine(PE) Architecture
AMP Architecture &uses
Bynet Benefits &types
Parallel data extension(PDE)
Teradata directory program(TDP)
Call level interface(CLI)
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
Locks & 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
Row 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 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

Types of tables
Set tables
Multi tables
Volatile tables.
Global temporary tables
Derived tables
Views
Macros
Stored procedures
Triggers

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

Our distinct services include :

Material and Documents: We provide real time working documents and materials to our students.
Free System Access : We have the latest and most up to date platforms deployed on high-end servers that are available remotely and in-class on a 24/7 basis.
Interview Preparation: We will prepare you for interviews in your specialized area by providing some real time interview questions. We also conduct mock interviews and assist you in preparing a professional resume.
Placement Assistance: Our placement service division provides job placement support by submitting your resumes to prospective clients and emails you any new job opportunities in the market. However, we do not provide false guarantees on securing any jobs for you. We have a history of several ex-students who have secured excellent jobs based on our WORLD class training approach, implementation of case study projects and post training support.
Initial Job Stabilization Support: We support our students to get stabilized in their job in the first TWO months. If our students come across any issues, we are there to help them. Students can send an email to us with their issues, our experts will reply back with possible solutions within 24 hours.
Free Class Room sessions recording: In addition to the e-class training, we will give you authorization to record all of your e-class room training sessions, so that you can go back and review.

Other Courses related

Course registration

Instructor Led Hands-on eClassroom Training.

Key Points of Training Program :

Teradata Courses, Learn with Online Practice, in-class Seminars, Training and Certification from the list of world-class education trainers. Macropus provides Class Material, Tutorial Curriculum, Demo Videos, Sample Questions, Recommended Books, Tips and Tricks. Get lectures and practical lessons on development and programming to improve technical skills and Students will benefit with Job Placements, Visa.