Teradata Online Training

Key Features of Teradata

  • What is Teradata?
  • Teradatav12 & versions Other versions
  • Overview OF Teradata
  • Teradata warehouse

What you will learn Teradata

  • Certified and expert teachers
  • Extensive doumentation provided
  • Became an exepert few days

Course Details:

Introduction:
What is Teradata?
Teradatav12 & versions Other versions
Overview OF Teradata
Teradata warehouse
Teradata in the Enterprise
Teradata Users & Scalability
interview Q&A and Certification queries

Teradata Architecture and Components
Teradata Architecture
SMP Architecture
MPP Architecture
AMP(Access Module Processing)
TDP(Teradata Directory Program)
CLI(Call Level Interface)
TPA(Trusted Parallel Application)
Parallelism Architecture
Benefits and Types

Data Recovery and Security
Why for locks &how to release
Various locks for simultaneous access
RAID 1&RAID 5
Disk Arrays
Fall Back
Clique
AMP Clustering
Types OF Journals
Recovery Journal
Trasient Journal
Permanent Journal
Before Journal
After Journal
How & where is used journals
Answering various recovery questions

Teradata Indexes
Primary Index
Unique
Non unique
Partitioned
Secondary Index
Unique
NonUnique
Hash, Join, Value Ordered
Skewness
Secondary Index Sub table
Accessing Records via Primary Index
Accessing records via Secondary Index
Keys Vs Indexes
Full Real time scenarios and explaining

Teradata Sql Reference
SQL Fundamentals
Data Types and Literals
Data Definition Statements(DDL)
Data Manipulation Statements(DML)
Explaining with proper examples

Teradata Functions and Operators
String Functions
Format Function
Cast Functions
Group & Aggregate Functions
With & with by clauses
Practices of this section

Teradata Transactions
Implicit Transaction
Explicit Transaction
Performance Tuning and Explain Utility
Explain Usage
Collecting Statistics
Tuning SQL Performance
Usage of PMON
Explaining various SQL statements
Joins and Unions
Inner Join
Left Outer Join
Right Outer Join
Full Outer Join
Detailed explanation
Join Strategies
Product Join
Merge Join
Hash Join
Nested Join
Questions of this section

Teradata Basic Commands
HELP
SHOW
EXPLAIN
COLLECT STATISTICS

Teradata Objects
Tables
SET table
Multi Set table
Volatile tables
Global Temporary tables
Derived tables
Views
Macros
Stored Procedures
Triggers
Practices and FAQs of this session

Teradata spaces
PERM space
SPOOL space
TEMPORARY space
Teradata User and managing
Practical Examples

Teradata Transaction Modes
BTET
ANSI
Interactive
Batch

Teradata Sql Assistant(Queryman)
Teradata Performance Monitor
Teradata BTEQ
Batch Scripts with samples
Branching and Looping
Importing data through scripts
Exporting data through scripts
Error handling
Explanation with proper debugging
Teradata Fast Load
Various Phases of Fast Load
Advantages and Process
Limitations of Fast Load
Sample Scripts

Real time Issues and resolving it
Teradata Multi Load
Various Phases of Multi Load
Limitations of Multi Load
Working with multiple tables
Applying various operations
Sample Scripts

Real time Issues and solving it
Teradata Parallel Data Pump
Limitations of TPump
Overview of TPump
Sample Scripts
Teradata Fast Export
Exporting Data
Passing Parameters
OUTMODS
Sample Scripts
Utility Vs Parallelism

RIZE Trainings offers wide range of courses belonging to business, IT, students, developers, data and working professionals, freshers etc; We regulate training about your expected courses and help you to advance your career. RIZE come up with numerous courses and offer training throughout the world like France, United states, China, India, Singapore, Germany, Australia, Canada etc; by using interface like webex and GoToMeeting.

RIZE trainers assist in developing Real time experience of the required course and also improving interview skills, knowledge, communication, content of the course, innovative project ideas, future scope etc,. This makes our students are becoming future experts and working as professionals in top rated companies.

The course begins in a few days, and I still do not have my login information. What do I do?
Once your registration for a course is completed, we will send activation link to start your sessions.

What happens if I miss my training date, do I have any options?
In case you miss training date, we will send recorded sessions to you. Otherwise, we assign for next live batch.

How does the online training work?
All of our online courses are live instructor led online courses. You will have the ability to interact directly with the trainer. Once registered for a class you will receive detailed instructions on how to access your class.

How do I receive the course materials?
You receive a link to download the course materials when you register. Our trainers assist you in your assessments, case studies, sample projects, interview skills etc;

Will I be able to view the sessions again at a later time?
Yes, We provide recorded sessions.

Who are your trainers?
All our trainers are working professionals from the Industry and have at least 10-12 yrs of relevant experience in various domains. They are subject matter experts. So that participants get a great learning experience.

Can I get the same in-class experience at home or work?
Yes. You can attend courses anywhere that has an Internet connection. If you choose to participate from your home or workplace, you must validate your own equipment to ensure it meets the required specifications.

What should I bring to class?
You need to have your course materials, Internet, computer headset and the Link to your Rizetrainings classroom e-mail, which contains the link and LOGIN credentials you need to take your course.

Where can I get more information?
If you need more information, please call us at +91-970 39 767 53 or send mail to contact@rizetrainings.com . Rize Trainings Advisors will be happy to assist you.

Do you offer placements?
We help our customers for preparing their resumes, work on sample live projects and provide assistance for interview preparation. We don't offer any placements however if you go through the course diligently and complete the project you will have a very good hands on experience to work on a Live project.

What happens if I have technical problems during my class?
If you have technical difficulties, you call us at +91-970 39 767 53 . Our support team will resolve any issues you might encounter.

ENQUIRY FORM HERE :
Back to top