Teradata Certified Professional TEO-141 and TEO-142 - Locus IT Services

Teradata Certified Professional TEO-141 and TEO-142

Locus IT ServicesCorporate TrainingTeradata Certified Professional TEO-141 and TEO-142

Teradata Certified Professional TEO-141 and TEO-142

Teradata Certified Professional TEO-141 And TEO-142 Training will help you become an expert in developing Data Warehousing applications using Teradata. Teradata Certified Professional TEO-141 And TEO-142 training will introduce the participants to work with Teradata.

The training course will cover the Architecture, Indexing mechanism and how data is stored and retrieved in detail. The course will cover the basic and the advanced SQL operations in Teradata and also the various utilities provided by Teradata to process, import and export the data.

Teradata Certified Professional TEO-141 and TEO-142 Modules

Module 1: Teradata Introduction
  • Introduction
  • Teradata Advantages
  • Tools & Utilities
  • Teradata Installation
  • Teradata Tools & Utilities Installation
Module 2: RDBMS/Data Warehousing Basics
  • RDBMS Basic Concepts (Tables/Rows/Columns/Primary Key/Foreign Key)
  • What is the data warehouse?
  • OLTP Vs Data warehouse
  • Data Warehouse Architecture
Module 3: Teradata Architecture
  • Teradata Components (Parsing Engine, BYNET, Access Module Processor)
  • How Teradata components interact with each other?
  • Storage & Retrieval architecture
  • System architecture
  • What is a Node?
Module 4: Basic SQL
  • Data types
  • DDL statements(CREATE,DROP,ALTER)
  • DML statements (SELECT, INSERT,UPDATE,DELETE)
  • SET Operators(UNION, UNION ALL, INTERSECT, MINUS)
  • Logical & Conditional Operators
  • Date & Time Manipulation
  • Joins
  • Built-in functions
  • Aggregates
  • Explain plan
Module 5: Indexes
  • Primary Index (UPI, NUPI)
  • Secondary Index (USI, NUSI)
  • Partition Primary Index
Module 6: Teradata Objects
  • SET vs MULTISET tables
  • Derived Tables
  • Volatile Tables
  • Global Temporary Tables
  • Views
  • Macros
  • Stored Procedures
  • Single Table Join Index
  • Multi-Table Join Index
  • Aggregate Join Index
  • Space concepts (Perm, Spool, Temp)
  • Triggers
Module 7: Advanced SQL
  • Subqueries in Teradata Certified Professional TEO-141 and TEO-142
  • Coalesce
  • OLAP Functions (Rank, Row_Number, Qualify, Partition by, Rows Unbounded preceding or following)
  • Compression
  • Collect Statistics
  • DBC tables
  • Teradata Transaction Modes
Module 8: Teradata Utilities
  • FastLoad
  • MultiLoad
  • BTEQ
  • FastExport
  • TPT
Module 9 : Data Protection
  • Fallback
  • Clusters
  • Clique
  • Permanent Journals
  • Hot Standby Nodes
  • RAID
Module 10 : Performance Optimization
  • Join Strategies
  • Confidence levels
  • Statistics collection process
  • Performance tuning techniques

Locus IT’s Teradata Certified Professional TEO-141 and TEO-142 offer certification tracks covering the features and functionality. Certifications are designed for all the audiences and offer a range of levels from the novice to those with extensive knowledge and expertise. For more information, please contact us.

Locus IT Project Management Office
What’s it?