TeraData - Data Warehousing Training

Training/Coaching/Tuition by Big Classes Hyderabad View Contact

Request Info

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

• & 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

• Types of tables

• 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

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

Key Service

• FAQS

• Covering DBA concepts

• Concentration on performance tuning

• Real time scenarios

• Certification guidance

• Resume preparation

• Sample resumes

• Interview & certification FAQS

• How to face the interview

• Class notes which is useful for who is trying for job

• Project preparation

Course Overview

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 13.10 stores and processes the data in an open parallel framework, whereas Teradata 14 is upgrade for Teradata 13 including column store analysis.
Teradata training masters the learners in using the tool for business analysis, storage of data in the offsite recovery center and its retrieval.

About Trainer

Trainer Information

• Real time work experience 7 Years in IT Industry

• Worked for 6 Years in Teradata Corporation

• Domain Experience: Datawarehousing

• 2 Years of Online Training Experience

• Batches: 45+ batches. Includes online and offline

Big Classes

BigClasses.com is been into the IT market since a decade. We have started our career 10 years back as a class room training provider. After 5 years in the classroom training, as a part of expansion in 2008, we have moved to online training. We are offering the services globally with local and international standards with real time exposure. Now, after 10 years of expertise in software training, we are one of the best online training service portals of the industry. This shows our standards and commitment towards the software learners.

Since inception of BigClasses.com, it has evolved into a cherished and most reliable retail and Corporate Training Company.

BigClasses.com Training is one training institute where online interactive training is a common experience and many students in the past have learnt, mastered, got certified and landed excellent jobs on their way to their careers. Our training takes place with well-prepared training materials. We provide documentation and the best interview preparation materials for learners.

BigClasses.com has access to a faculty of esteemed and highly qualified consultants to deliver the courses. These instructors are not in any way academics, but rather specialists actively involved in consulting to business in their particular fields. This gives the learners a fuller insight of the needs and as well as knowledge about actual and future trends in the market, and makes the courses extremely practical and relevant.

We don’t just give training and leave you on your own but support you even after you get into the job. We are providing web based online training in major IT Courses, where you can sit at home in front of the system and learn without travel or relocate during the training program. You can practice exercises and real-time projects which are given by our esteemed instructors.

Training is conducted by experienced and certified Instructors. Prestigious clients are included in our Clientele list and 100% Successful placement for excellent candidates.

BigClasses.com Institute is an online provider of IT technologies training products for individual and for corporate groups our training manuals and programs are designed to be used in a self-study or home based training environment. This allows any student the ability to learn at their own pace and on their own schedule.

Self-paced training is a very effective method of training and can be used with any schedule and with no previous experience. Effective results can be achieved in as little as 15 minute blocks of time not hours or days as is common with seminars and schedule courses.

All our materials are available with instant download which means you can get started on your training within minutes. The result is that you can show noticeable improvement in less than a day with our training Bigclasses.com.

Our materials are designed to be used in a self-study or home based environment so anyone can fit this training into any schedule no matter how busy it may be. Self-study also allows an individual the ability to train at their own pace and not have to worry about missing any concepts or being forced to proceed too slow like what might happen in a class or schedule group class.

We are dedicated to providing the very best in Bigclasses.com training while providing quality training at affordable prices. Our goal is to product training that is within the budget of anyone who desires to improve their IT skills.

Corporate Group Training: For companies or large groups who wish to provide quality Customer Service training for their employees, Bigclasses.com online training Institute is proud to announce their Corporate! Under our Corporate Training Program, we offer our Training package at group rates. This course encompassing 6 training modules covering both basic fundamentals and advanced techniques.

Bigclasses.com Training Certificate Program: A complete course in Bigclasses.com Training from Basic fundamentals through advanced skills, this complete course offers a single source for all your requirements and needs. Each module is designed as either a stand lone module or as part of a complete series so the student can target their most pressing needs first for maximum benefit. Upon successful completion of the program and the passing of a short test, a full color Certificate of Completion will be issued to the student.