1 / 17

Online Teradata Training | Online Teradata Certification Course in USA, UK, Canada, Australia, Dubai, France, India

A1Trainings provides Job Oriented Online Teradata Training Classes by Real Time Expert for India, USA, Canada, Australia, Dubai, France, India, Hyderabad, Bangalore with live projects, Job Placements 91 7680813158

PriyankaCH
Download Presentation

Online Teradata Training | Online Teradata Certification Course in USA, UK, Canada, Australia, Dubai, France, India

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. A1Trainings Online Teradata Training | Online Teradata Certification Course in USA, UK, Canada, Australia, Dubai, France, India

  2. TERA DATA TRAINING COURSE CONTENT

  3. INTRODUCTION • What is Teradata? • Teradatav12 & versions Other versions • Overview OF Teradata • Teradatawarehouse • Teradatain the Enterprise • TeradataUsers & Scalability • Interview Q&A and Certification queries

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

  5. 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

  6. 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

  7. TeradataSql Reference • SQL Fundamentals • Data Types and Literals • Data Definition Statements(DDL) • Data Manipulation Statements(DML) • Explaining with proper examples

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

  9. Teradata TransactionsImplicit TransactionExplicit 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

  10. Teradata Basic Commands • HELP • SHOW • EXPLAIN • COLLECT STATISTICS

  11. 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

  12. Teradata spaces • PERM space • SPOOL space • TEMPORARY space • TeradataUser and managing • Practical Examples

  13. Teradata Transaction Modes • BTET • ANSI • Interactive • Batch

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

  15. 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

  16. Real time Issues and solving it • Teradata Parallel Data Pump • Limitations of Tpump • Overview of Tpump • Sample Scripts • TeradataFast Export • Exporting Data • Passing Parameters • OUTMODS • Sample Scripts • Utility Vs Parallelism

  17. Contact Us Contact Info • Address: Madhapur, Hyderabad. • Email: contact@a1trainings.com • Call us: 7680813158 • Web: www.a1trainings.com

More Related