TeraData Online Training

TeraData OverView

Teradata is a relational database like any other RDBMS but which is ideal for data ware housing applications. Teradata was famous because of its:

  • High parallelism (parallel processing) and it have utilities like fast load, multi load, T.pump, fast export.
  • Complex ad hoc query with up to 64 joins.
  • Parallel efficiency, such that the effort for creating 100 records is same as that for creating 100,000 records.
  • Scalability, so that increasing of the number of processors of an existing system linearly increases the performance. Performance thus does not deteriorate with an increased number of users.

The latest version of Teradata in the market is R 13.01

If the people with Oracle back ground, DB2, Sybase and ETL (Informatica, Ab initio, Datastage, Sybase) can be benefitted with Teradata.

About our Teradata Trainer

  • Our Trainer is Teradata certified master with 8 years of real time experience on the Teradata platform.
  • He is an expert in database designing.
  • At present he is working with CTS (Cognizant Technology Solutions). Previously he had worked with IBM.

He had worked for the largest clients of the world like Bank of America, Paypal and E-bay, DBS bank Sandhurst Bank, AT&T, T-mobile, Hartford, Walmart and the other financial telecom institutions

The major clients or users of Teradata are the largest clients in the world.  The users who are using Teradata are Bank of America, Paypal, Walmart, Vodafone, T-mobile, State Bank of India etc,.

This course is recommended for ETL developers, people working on any RDBMS like Oracle, SQL server, Sybase, DB2.

Combinations of Teradata

The carrier of the person will be boosted if the candidates have the following skills with Teradata.

  • Teradata + Informatica
  • Teradata + Datastage
  • Teradata + Ab-Initio
  • Teradata + BO
  • Teradata + Cognos

People with Teradata knowledge will be hired by the top most clients of the world. They will be paid high salaries when compared to all other technologies and can get a chance to work with the top most clients of the world.

Major domains of Teradata are: Banking and finance, Insurance and Tele communications

“The students will be given Insight and In-depth knowledge of Teradata physical database design.”

Teradata developers will be given an overview of database administration.

Highlights of Teradata

  • Tailor-made Course Curriculum
  • Online training is learner cantered.
  • Learner can combine education, work and family.
  • Real-time experts are our trainers
  • Most affordable Fee Structure
  • Industry-centric Approach
  • World-class teaching methodology
  • We Provide goal oriented, comprehensive training based on your specific educational needs.
  • We provide free 24/7 server access to help our trainees practice exercises and demos in real-time.
  • We offer Placement options to our learners if required.

People with Teradata  knowledge will be hired by the top most clients of the Industry. They will be paid high salaries when compared to all other technologies and can get a chance to work with the top most clients of the world.

Why MonsterClasses  for the Course

  • Training would be conducted by experienced and certified Instructors.
  • Online inter-active training is a common experience @MonsterClasses.com.
  • Many students in the past have learned, mastered, got certified and landed in excellent jobs.
  • Our course material is specially designed for online learning
  • Our trainers are technology specialists actively involved in their particular fields.
  • Support for real-time projects by our trainers.
  • 100% job support for desired and excellent candidates.

Teradata Course Content

TERADATA V13

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